MySQL Common commands

2. Create Database test_db; Create a database named test_db

4. Use test_db; Enter the TEST_DB database

6. Show tables; See how many tables are in the database

8. Drop database test_db; Deleting a database

10. drop table test01; Delete a table

12. Delete from test01; Clear Table Contents

14. Show variables like '%char% '; View the database character set

16. INSERT into test01 values ("001", "JF1"); Inserts data into the table.

18. SELECT * from test01; View test01 table data content.

20. CREATE TABLE test01 (ID varchar (), name varchar (20));

22. Grant all privileges the test_db.* to [e-mail protected] identified by ' 123456 ';

24. Grant all on test_db.* to [e-mail protected] identified by ' 123456 ';

26. Grant Select,insert,update,delete on * * to [e-mail protected] "%" identified by ' 123456 '; authorize MySQL database.

28. Flush privileges; Refresh Permissions

30. mysqldump–uroot–p123456 test_db >/tmp/test.db.sql; MySQL Backup or export

32. mysql–uroot–p123456 test_db </tmp/test.db.sql; MySQL Import

34. mysqladmin–uroot–p123456 password NewPassword; Modify the MySQL root password

36. Drop database test_db; Deleting a database

38. drop table test01; Delete a table

40. Delete from test01; Clear Table Contents

42. Show variables like '%char% '; View the database character set

44. INSERT into test01 values ("001", "WUGK1"); Inserts data into the table.

46. SELECT * from test01; View test01 table data content.

48. CREATE TABLE test01 (ID varchar (), name varchar (20));

50. ALTER TABLE Ip_can drop ID; Delete a field
    ALTER TABLE Ip_can Add ID varchar (20); Add a field
    ALTER TABLE Ip_can Add ID varchar (a) first;

In subsequent continuous updates

This article is from the "Fluffy Duck" blog, please be sure to keep this source http://woshitieren.blog.51cto.com/2466034/1681211

MySQL Common commands