![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
城北徐公a
一个女孩冲进整容医院“我要整形变靓!!”医生在纸上默默写下 int a;
展开
-
mysql 多值 update INSERT delete
UPDATE tb_account_info SET passwd = CASE account WHEN '100002' THEN 'a' WHEN '100003' THEN 'b' END WHERE account IN('100002', '100003');INSERT INTO tb_account_info(account,passwd,level)values('1...原创 2020-01-16 17:56:17 · 182 阅读 · 0 评论 -
mysql通过my.cnf修改默认字符集为utf-8的方法以及注意事项
选项配置配置文件路径: /full/path/mysql/bin/my.cnf (默认为/etc/my.cnf )或者 /etc/mysql/mariadb.conf.d/50-server.cnf[client]default-character-set=utf8 [mysql]default-character-set=utf8 [mysqld]init_conne...转载 2018-07-30 14:58:28 · 6179 阅读 · 0 评论 -
MySQL 表字段唯一性约束设置方法unique
出处:https://blog.csdn.net/sinat_39308893/article/details/810691591. 建表时加上唯一性约束CREATE TABLE `t_user` ( `Id` int(11) NOT NULL AUTO_INCREMENT, -- 自增 `name` varchar(18) NOT NULL unique, ...转载 2018-12-20 14:25:04 · 204 阅读 · 0 评论 -
找不到mysqlclient.so文件处理方法
-lmysqlclient找不到mysqlclient.so文件处理方法# apt-cache search libmysqllibmysql++-dev - mysql C++ library bindings (development)libmysql++2c2a - mysql C++ library bindings (runtime)libmysql-java - Java ...转载 2019-07-25 19:04:22 · 1411 阅读 · 0 评论