Add, query, modify, and delete MySQL table operations

Add, query, modify, and delete MySQL table operations

 

01 INSERT data

Insert into 'table _ name' ('column01 _ name', 'column02 _ name',...) VALUES (value01, value02 ,...)

02 query data SELECT

SELECT * FROM 'table _ name' WHERE 'column01' = value01 and 'column02' = value02 and...

03 modify data UPDATE

UPDATE 'table _ name' SET 'column01 _ name' = new_value01, 'column02 _ name' = new_value02 ,...

04 DELETE data

Delete from 'table _ name' WHERE 'column01 _ name' = value01, 'column02 _ name' = value02 ,...

 

14:47:07 on BIT/#10/315

Help php to operate mysql. Combined with forms, js can add, delete, query, and modify data.

I advise you not to write it.

You can use others, but you cannot master them completely if you write different words.

My QQ747024605 indicates Baidu, you write a program, and I will fix it for you.

Root users cannot remotely log on to mysql to operate on permissions. They can only add, delete, modify, and query tables or databases. Why? Guidance

The -- skip-grant-table can be used to ignore the permission.
#./Mysqld start -- skip-grant-table
# Mysql-uroot-S/home/mysqlData/mysqld. sock
Mysql> show databases;