Author Archives: user

MySQLi – Sorting Results We have seen the SQL SELECT command to fetch data from a MySQL table. When you select rows, the MySQL server is free to return them in any order, unless you instruct it otherwise by saying how to sort the result. But, you sort a result set by adding an ORDER […]

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

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