MySql Basics
With well over ten million installations, MySQL is probably the most popular database management system […]
Introduction to MySQL
Syntax MySql
After you successfully logged in to the MySql Database, enter your first command as : […]
MySQL Commands
You’ve already seen the SHOW command, which lists tables, databases, and many other items. The […]
Creating database and Users
For creating a database table in Mysql, use the following command as : After verifying […]
Creating a table
At this point, you should now be logged into MySQL with ALL privileges granted for […]
Data Types
In previous examples, you may have noticed that three of the table’s fields were given […]
DATE and TIME
The main remaining data types supported by MySQL relate to the date and time and […]
The AUTO_INCREMENT data type
Sometimes you need to ensure that every row in your database is guaranteed to be […]
Adding data to a table
To add data to a table, use the INSERT command. Let’s see this in action […]
Renaming a table
Renaming a table, like any other change to the structure or meta-information about a table, […]
Changing the data type of a column
Changing a column’s data type also makes use of the ALTER command, this time in […]
Adding a new column
Let’s suppose that you have created a table and populated it with plenty of data, […]
Renaming a column
If you may decide that having a column named type can be confusing, because that […]
Removing a column
Actually, upon reflection, maybe the page count column pages isn’t actually all that useful for […]
Deleting a table
Deleting a table is very easy indeed. But, because I don’t want you to have […]
Indexes in mysql
As things stand, the table classics works and can be searched without problem by MySQL—until […]
- 1
- 2