1.show databases; //顯示所有數(shù)據(jù)庫
2.mysql> use mysql; //切換當(dāng)前數(shù)據(jù)庫
3.mysql> show tables; //顯示當(dāng)前數(shù)據(jù)庫所有表
4.mysql> desc user; //顯示當(dāng)前表的所有字段
- mysql> select Host,User from user; //查詢表記錄
6.mysql -h IP地址 -u test -p //登錄數(shù)據(jù)庫
7.GRANT all privileges ON . TO ‘test’@’%’ IDENTIFIED BY ‘123456’;
創(chuàng)建一個訪問mysql數(shù)據(jù)庫賬號
8.mysql> create database //創(chuàng)建數(shù)據(jù)庫
9.DROP DATABASE 數(shù)據(jù)庫名;刪除數(shù)據(jù)庫 - 創(chuàng)建學(xué)生表 student
CREATE TABLE student( number int()
name varchar()
age int()
);
11.1刪除表
mysql> DROP TABLE coures;
12.插入一條記錄
mysql> INSERT INTO student (number,name,age)VALUES(1001,'小明',23);
13.查詢語句
SELECT * FROM student;
14.修改記錄
mysql> UPDATE student SET name='張三' WHERE number=1001;
15.刪除記錄
mysql> DELETE FROM student WHERE name='李四';
