Author Archives: user

MySQLi – Using Joins In the previous chapters, we were getting data from one table at a time. This is good enough for simple takes, but in most of the real world MySQL usages, you will often need to get data from multiple tables in a single query. You can use multiple tables in your […]

MySQLi – Insert Query To insert data into a MySQL table, you would need to use the SQL INSERT INTO command. You can insert data into the MySQL table by using the mysql> prompt or by using any script like PHP. Syntax Here is a generic SQL syntax of INSERT INTO command to insert data […]

MySQLi – Create Table To begin with, the table creation command requires the following details − Name of the table Name of the fields Definitions for each field Syntax Here is a generic SQL syntax to create a MySQL table − CREATE TABLE table_name (column_name column_type); Now, we will create the following table in the […]