MySql

MySql

使用工具Navicat pemium

连接

mysql -u root -p
然后输入密码

创建

CREATE TABLE runoob_tbl

增加

insert into user_code (index_id,identification,residue) values ('0','192.168.1.1','5')

删除

删除表：DROP TABLE test_tb1
删除具体行：DELETE FROM my_test where id = '1'

修改

UPDATE my_test set number = '666' where number = '444'

查询

select residue FROM user_code where index_id = '5'