Category Archives: mysqli

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, […]

MySQLi – Update Query There may be a requirement where the existing data in a MySQL table needs to be modified. You can do so by using the SQL UPDATE command. This will modify any field value of any MySQL table. Syntax The following code block has a generic SQL syntax of the UPDATE command […]