Category Archives: mysqli

MySQLi – Data Types Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don”t define a field as 10 characters wide if you know you”re only going to use 2 characters. These types […]

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 – Delete Query If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well as in any script like PHP. Syntax The following code block has a generic SQL syntax of the DELETE command […]