Category Archives: mysqli

MySQLi – Temporary Tables The temporary tables could be very useful in some cases to keep temporary data. The most important thing that should be known for temporary tables is that they will be deleted when the current client session terminates. As stated earlier, temporary tables will only last as long as the session is […]

MySQLi – Like Clause We have seen the SQL SELECT command to fetch data from the MySQL table. We can also use a conditional clause called as the WHERE clause to select the required records. A WHERE clause with the ‘equal to’ sign (=) works fine where we want to do an exact match. Like […]

MySQLi – Select Query The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP. Syntax Here is generic SQL syntax of SELECT command to fetch data from the MySQL table − SELECT field1, field2,…fieldN FROM table_name1, […]