启动mysql sudo ./mysql start
1.1 登陆
>mysql [-h 主机名] [-u 用户名] [-p(密码)]
屏蔽提示声音 mysql --no-beep
屏蔽提示声音 mysql --no-beep
1.2 了解mysql 的环境
>select now();
>select user(),version(),now();
1.3 中止服务器的连接
>quit
1.4 修改密码
mysqladmin -u用户名 -p旧密码 password 新密码
1.5 创建用户
grant select on 数据库.* to 用户名@登录主机 identified by "密码"
1.4 修改密码
mysqladmin -u用户名 -p旧密码 password 新密码
1.5 创建用户
grant select on 数据库.* to 用户名@登录主机 identified by "密码"
二 数据库,表和数据类型
2.1 数据库
查看已有的数据库
>SHOW DATABASES;
创建数据库
>CREATE DATABASE db_name;
查看当前所使用的数据库
>SELECT DATABASE();
使用数据库
>USE db_name[;]
删除数据库
>DROP DATABASE db_name;
2.2 表
创建表
>CREATE [TEMPORARY] TABLE [IF NOT EXITSTS] table_name
(create_defination,...)
[table_options]
[[IGNORE|REPLACE] select_statment];
>insert into product
>insert into product (no,name,place)
可以通过选择一个表的其中一部分或全部内容拷贝一个新表
>create table new_tb_name
select * from tb_name
[where conditions];
三 添加,修改,删除记录
3.1 添加记录
>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
table_name [(column_list)]
VALUES(col_1_value [,col_2_value]...)[,(...)]...;
或者
>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
table_name
SET col_1=col_1_value[,col_2=col_2_value]...;
或者
>INSERT [LOW_PRIOTIRY | DELAYED] [IGNORE] [INTO]
table_name [(COLUMN_LIST)]
SELECT select_statements;
例子:
(1)指定所有的列值:
>insert into product
values("00101","钢笔","支",25.60,"香港");
>insert into product
values("00102","钢笔","支",0.00,NULL);
values
("00101","钢笔","支",25.60,"香港"),
("00102","钢笔","支",0.00,NULL);
values("00102","钢笔",NULL);
(2)使用 SET 赋值
>insert into product
set no="00101",name="钢笔",place="香港";
(3)通过 SELECT 添加记录
>create table product_1
select * from product
where 1=0;
>insert into product_1
values
("00110","音像",200,"深圳"),
("00111","主板",900,"东莞");
>insert into product
select * from product_1;