mysql 使用命令教程大全!

alter table login add hege int(2);

alter table login drop column last_area;

update login set hege = 1;

CREATE TABLE wall
(
id int not null  primary key auto_increment,
name varchar(25),
gender varchar(25),
city varchar(25),
height varchar(25),
occupation varchar(25),
mydesc text,
mydesc_demand text
);

更改数据库密码为123456

mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
点赞