1:使用SHOW语句找出在服务器上当前存在什么数据库:
mysql>use database;
mysql> SHOW DATABASES;
mysql> CREATE DATABASE MYSQLDATA;
mysql> USE MYSQLDATA; (按回车键出现Database changed 时说明操作成功!)
mysql> SHOW TABLES;
mysql> CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));
6:显示表的结构:
mysql> DESCRIBE MYTABLE;
mysql> insert into MYTABLE values (”hyq”,”M”);
mysql> LOAD DATA LOCAL INFILE “D:/mysql.txt” INTO TABLE MYTABLE;
mysql>use database;
mysql>source d:/mysql.sql;
mysql>drop TABLE MYTABLE;
mysql>delete from MYTABLE;
mysql>update MYTABLE set sex=”f” where name=’hyq’;