mysql
来源:互联网 发布:使命召唤11 知乎 编辑:程序博客网 时间:2024/05/24 01:44
1.命令行创建 PROCEDURE
mysql> delimiter //mysql> CREATE PROCEDURE simpleproc (OUT param1 INT) -> BEGIN -> SELECT COUNT(*) INTO param1 FROM t; -> END -> //Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;
2. 中文字符显示
显示字符编码
mysql> show variables like "%char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
设置字符编码,例如
mysql> set character_set_database=utf8;
mysql>set character_set_server=utf8;
通过网页存取时,造成数据库乱码:
new String(request.getParameter("cdAlbum").getBytes("iso-8859-1"),"utf-8")
- Mysql
- MySql
- MYSQL
- MySQL
- mysql
- mysql
- mysql
- mysql
- Mysql
- Mysql
- mysql
- MySQL
- mysql
- Mysql
- mysql
- mysql
- mysql
- mySQL
- box-shadow
- ADB无法启动
- iOS开发_iphone 实现剪贴板操作_iphone 复制粘贴功能
- Android ListView记录上次滑动时位置状态
- wampserver启动中mysql启动异常解决
- mysql
- uva 537
- iOS开发之企业发布无线安装APP
- ExtJs学习笔记(1)ItemSelector (用户关系左右选择组件)
- Data Pump导入导出实例
- Google code android开源项目
- vs2008+Qt+MySql环境搭建及提示"Driver not load"的原因分析
- 并查集--学习详解
- 开张