常忘记,记录随时参考!
mac电脑,终端进入mysql:
cd /usr/local/bin/
sudo ln -fs /usr/local/mysql/bin/mysql mysql
mysql -u root -p (输入密码 root)未修改的默认密码都为root
查看所有数据库: show databases;
创建数据库: create databases (名);
进入某数据库中:use (名);
创建一个表:(例如用户登录注册)
create table if not exists `user`(`id` INT UNSIGNED AUTO_INCREMENT,`username` VARCHAR(100) NOT NULL,`password` CHAR(32) NOT NULL,PRIMARY KEY ( `id` )) ENGINE=MyISAM DEFAULT CHARSET=utf8;
进入user表:desc user;
查看user表的所有数据:select * from user;
创建业务表:
create table if not exists `business`(`id` INT UNSIGNED AUTO_INCREMENT,`userid` INT NOT NULL,`article` VARCHAR(100) NOT NULL,PRIMARY KEY ( `id` )) ENGINE=MyISAM DEFAULT CHARSET=utf8;
设置这个表的userid为外键:
alter table business add constraint FK_ID foreign key(user_id) REFERENCES user(id);
如果表已经创建,设置某字段(id)为主键:
ALTER TABLE file ADD PRIMARY KEY( id );
如果表已经创建,设置某字段(id)自增:
alter table file modify id int AUTO_INCREMENT;