mysql常用命令

mysql> SHOW databases;mysql> CREATE DATABASE mydb;mysql> USE mydb;mysql> SHOW tables;mysql> CREATE TABLE tbTest (name VARCHAR(20), sex CHAR(1));mysql> DESC tbTest;mysql> insert into tbTest values (”hyq”,”M”);mysql> LOAD DATA LOCAL INFILE “D:/mysql.txt” INTO TABLE tbTest;mysql> source d:/mysql.sql;mysql> drop TABLE tbTest;mysql> delete from tbTest;mysql> update tbTest set sex=”f” where name=’hyq’;