创建数据表:地址簿
增删查改:
实例
新增数据到ls_addressbook表: inster into `ls_addressbook`('id,user_id,name,tel,province,city,county,address,createtime,is_receiver,is_default')values('1,2,王刚,13546264354,广东省,广州市,海珠区,广州大厦1121,0,0,0'); 删除数据: delete from 'ls_addressboo' where id =1; 查找: select * from 'ls_addressboo' where id =2; 更改: update 'ls_addressboo' set name= '李刚' where id =1;
运行实例 »
点击 "运行实例" 按钮查看在线实例
手写: