SQL--MYSQL query statement Daquan, sqlmysql statement

SQL--MYSQL query statement Daquan, sqlmysql statement

1: Use the SHOW statement to find out the current database on the server:

Mysql> show databases;

2. Create a database named MYSQLDATA

Mysql> create database mysqldata;

3: select the database you created

Mysql> use mysqldata; (when you press the Enter key to see Database changed, the operation is successful !)

4: view the tables in the current database

Mysql> show tables;

5. Create a database table

Mysql> create table mytable (name VARCHAR (20), sexCHAR (1 ));

6: display the table structure:

Mysql> describe mytable;

7. Add records to the table

Mysql> insert into MYTABLE values ("hyq", "M ");

8: load data into database tables in text mode (for example, D:/mysql.txt)

Mysql> load data local infile "D:/mysql.txt" into Table MYTABLE;

9: import the. SQL FILE command (for example, D:/mysql. SQL)

Mysql> use database;

Mysql> source d:/mysql. SQL;

10: delete a table

Mysql> drop table mytable;

11: Clear the table

Mysql> delete from MYTABLE;

12: Update table data

Mysql> update MYTABLE set sex = "f" where name = 'hyq ';

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.