Primary keys
Mar 14,16A primary key is a column or a set of columns that uniquely identifies each record in a database table. …
Read MoreUse logical operators
Mar 14,16You can use the logical operators AND, OR, and NOT to filter records based on more than one condition and …
Read MoreSort results
Mar 14,16You might have noticed that, when you use the SELECT statement to query data, the results are not sorted in …
Read MoreUpdate the contents of a field
Mar 14,16One of the most common tasks when working with MySQL databases is the data update. To update records in an …
Read MoreLIMIT clause
Mar 14,16Sometimes tables contain thousands of rows and if you run a SELECT statement to display all rows, you will impact …
Read MoreRemove a row
Mar 14,16You can use the DELETE command to remove a row from a table. The syntax: DELETE FROM table_name WHERE column_name …
Read More