PHP MySql Tutorial

PHP MySql Tutorial Links: PHP Tutorial Introduction PHP Tutorial Installation Variables PHP Tutorial Operators Decisions Making PHP Tutorial Arrays PHP Tutorial Loops PHP Tutorial Functions PHP Tutorial Forms Input and Methods PHP Tutorial File Handling PHP Tutorial Sending Mails PHP MySql Tutorial  Introduction PHP MySql Tutorial Create and Insert PHP MySql Tutorial  Select Data PHP MySql Tutorial Update and Delete ...

Read More

SQL Tutorials

Index of SQL Tutorials 1) Introduction 2) MySQL Workbench 3) Database Designing 4) Normalization 5) ER Modeling 6) Creating a Database 7) SELECT Statement 8) WHERE Clause 9) INSERT INTO 10) DELETE & UPDATE 11) ORDER BY, ASC, DESC 12) GROUP BY 13) Wildcards 14) Regular Expressions 15) Functions 16) Aggregate Functions 17) Null 18) Auto Increment 19) Alter Drop Rename 20) Limit 21) Sub Queries 22) Unions 23) JOINS 24) Views 25) Indexes 26) PHP MySQL Exampl...

Read More

Your First Application using MySQL and PHP

Now that Myflixdb, what's next? Congratulations for your successful completion of the SQL tutorial series. We looked at how we can design a database from scratch, the relational database management system model among others, MySQL as a database management system and how it implements the SQL language, what tools are available for us to use in the database design phase, SQL development and MySQL server administration such as MySQL workbench...

Read More

MySQL Index Tutorial - Create, Add & Drop

What are Index? Nobody likes slow systems. High system performance is of prime importance in almost all database systems . Most businesses invest heavily in hardware so that data retrievals and manipulations can be faster. But there is limit to hardware investments a business can make.  Optimizing your database is a cheaper and better solution. Towards this end we can use INDEXES. The slowness in the response time is usually due...

Read More

Views in MySQL Tutorial: Create, Join & Drop with Examples

What are views? Simply put, VIEWS are virtual tables .By virtual, we mean, the tables do not store any data of their own but display data stored in other tables. In other words, VIEWS are nothing but SELECT Queries. Views syntax Let's now look at the basic syntax used to create a view in MySQL. CREATE VIEW `view_name` AS SELECT statement; WHERE "CREATE VIEW `view_name`" tells MySQL server to create a view object in the database...

Read More

MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS

What are JOINS? Joins help retrieving data from two or more database tables.  The tables are mutually related using primary and foreign keys. Note: JOIN is the most misunderstood topic amongst SQL leaners. For sake of simplicity and ease of understanding , we will be using a new Database to practice sample.  As shown below idfirst_namelast_namemovie_id 1AdamSmith1 2RaviKumar2 3SusanDavidson5 4JennyAdrianna8 6LeePong10 idtitlecategory 1ASSASSIN'S...

Read More