环境部署
基本常识
insert into persons
(id_p, lastname , firstName, city )
values
(200,'haha' , 'deng' , 'shenzhen'),
(201,'haha2' , 'deng' , 'GD'),
(202,'haha3' , 'deng' , 'Beijing');
-
alter table test add column birth date; -
ALTER TABLE table_name RENAME TO new_table_name
Debug
-
update user set authentication_string=password('123456') where user='root';