1.启动mysql:mysqld
2.链接mysql:mysql -u username -p password
3.查询数据库:show databases
4.删除数据库:drop database test
5.创建数据库:create database test
6.使用数据库:use test
7.查询表:show tables
8.创建表:create table person(id varchar(32) not null primary key,
name varchar(20) not null,
password varchar(20)
);
9.显示表结构:desc person
10.插入记录:insert into person values('1','username','password');
11.在mysql控制台中执行sql脚本:source d:/person.sql
12.删除表:drop table person
13.删除表中所有记录:delete from person
14.更新表:update person set password='0';
15.查看mysql版本:select version();
16.查看当前时间:select current_date;
17.查看用户:select user();
18.注释:--
19.统计行数:select count(*) from person;
20.修改mysql root密码
use mysql;
update user set password=pasword('新密码') where user='root';
flush privileges;
2.链接mysql:mysql -u username -p password
3.查询数据库:show databases
4.删除数据库:drop database test
5.创建数据库:create database test
6.使用数据库:use test
7.查询表:show tables
8.创建表:create table person(id varchar(32) not null primary key,
name varchar(20) not null,
password varchar(20)
);
9.显示表结构:desc person
10.插入记录:insert into person values('1','username','password');
11.在mysql控制台中执行sql脚本:source d:/person.sql
12.删除表:drop table person
13.删除表中所有记录:delete from person
14.更新表:update person set password='0';
15.查看mysql版本:select version();
16.查看当前时间:select current_date;
17.查看用户:select user();
18.注释:--
19.统计行数:select count(*) from person;
20.修改mysql root密码
use mysql;
update user set password=pasword('新密码') where user='root';
flush privileges;