mysql-Study Notes 1

1. A convenient use of the while loop is to loop through the rows of data in a SQL query result.

2, Mysqli_fetch_array (), this built-in PHP function gets a data row from the result of a database query, which can be paired with while repeatedly calling this function to read data row by line.

3. Drop table tableName, this SQL statement deletes the entire table from the database, and all data stored in the table is deleted together.

4, DESCRIBE tableName, this SQL statement is used to understand the structure of a table, it does not expose any data, but can display the column name and the data type of each column.

5, delete from tableName, this SQL statement can delete data rows from a table, you can delete a single row, or you can delete multiple rows.

6. WHERE, this SQL clause is used in conjunction with other SQL commands to establish SQL statements for specific rows of data in the table.

7. Select * FROM TableName, select a data row from one table, and when using *, returns all columns of the data row in the table.

mysql-Study Notes 1