@mysql基础sql语句
DB DBMS SQL
连接数据库
mysql-> mysql -h ip -uuser -ppassword
use leaseback
创建表
CREATE TABLE test1 (
id int(11) PRIMARY KEY,
city VARCHAR(20) not null,
count_person int(50)
);
复制表 字段结构和索引
CREATE TABLE test2 LIKE test1;
复制表 不会复制索引 可以选择字段
CREATE table test3 as SELECT id,city FROM test1;
增加列
ALTER TABLE test1 add COLUMN color VARCHAR(20);
删除主键
ALTER TABLE test1 DROP PRIMARY KEY;
添加主键
alter TABLE test1 add PRIMARY KEY(id);
存储过程添加数据
DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=3 DO
insert into t_user (
userId,
userName,
password,
phone)
values (i,'ww','123456','135786&