MySQL

Primary keys

Mar 14,16

A primary key is a column or a set of columns that uniquely identifies each record in a database table. …

Read More

Use logical operators

Mar 14,16

You can use the logical operators AND, OR, and NOT to filter records based on more than one condition and …

Read More

Sort results

Mar 14,16

You might have noticed that, when you use the SELECT statement to query data, the results are not sorted in …

Read More

Update the contents of a field

Mar 14,16

One of the most common tasks when working with MySQL databases is the data update. To update records in an …

Read More

LIMIT clause

Mar 14,16

Sometimes tables contain thousands of rows and if you run a SELECT statement to display all rows, you will impact …

Read More

Remove a row

Mar 14,16

You can use the DELETE command to remove a row from a table. The syntax: DELETE FROM table_name WHERE column_name …

Read More
Geek University 2022