Let's take a look at some simple database commands commonly used by QT, which are complicated and not usable.

Show databases: displays databases on the current server

Database specified by use databasename

Create Table tablename (...)
Example:
Create table Information (ID int, Name text, address text, age INT );
Insert into information values (1, "huitailang", "China Shanghai", 15 );

View table data:

Select * From tablename;

Set password:

Use MySQL;
Update user set passord = PASSWORD ("123321") where user = 'root ';

Refresh the current database:

Flush privileges;

Exit Database

Quit

 

Log on to MySQL:

Mysql-u root-P

Password required

 

Delete A Database

Drop database databasename;