All posts by Tuna Peyo

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

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

We can use many different clauses to change the behaviour of the SELECT statement. In this chapter we will describe …

We’ve learned that a table consists of rows and columns. Often, you want to see a subset rows, a subset …

The ALTER TABLE statement is used to change the existing table structure. It can be used to add or remove …

To insert new records in an MySQL table, the INSERT INTO command is used. INSERT INTO allows you to insert …