Advanced SELECT statements
Mar 14,16We can use many different clauses to change the behaviour of the SELECT statement. In this chapter we will describe …
Read MoreQuery a database
Mar 14,16We’ve learned that a table consists of rows and columns. Often, you want to see a subset rows, a subset …
Read MoreModify a table
Mar 14,16The ALTER TABLE statement is used to change the existing table structure. It can be used to add or remove …
Read MoreInsert new records
Mar 14,16To insert new records in an MySQL table, the INSERT INTO command is used. INSERT INTO allows you to insert …
Read MoreData types
Mar 14,16A data type defines what kind of value a column in a database table can contain. This parameter tells MySQL …
Read MoreCreate a table
Mar 14,16Tables are subcontainers within a database that store the actual data. The database is created without any tables. To create …
Read More