kezhen的专栏

一、导出数据库用mysqldump命令（注意mysql的安装路径，即此命令的路径）：1、导出数据和表结构：mysqldump -u用户名 -p密码 数据库名 > 数据库名.sql#/usr/local/mysql/bin/   mysqldump -uroot -p abc > abc.sql敲回车后会提示输入密码2、只导出表结构mysqldump -u用户名 -p密码 -

转自：http://www.cnblogs.com/yuejin/archive/2013/11/12/3419467.html 1、打开mysql.exe(MySQL Command Line Client)，输入密码2、输入：use mysql;3、查询host输入： select user,host from user;4、创建host（如

http://www.ha97.com/5359.html一、登录MySQL查看用SHOW VARIABLES LIKE ‘character%’;下字符集，显示如下：+--------------------------+----------------------------+| Variable_name | Value |+---------------------

转自：http://www.devshed.com/c/a/python/database-programming-in-python-accessing-mysql/While data storage for applications is no longer considered complex, it is now simplified to the point that flex

https://www.youtube.com/watch?v=oXjJRrbKjp0修复方法：查看/var/run/mysqld 文件夹是否存在？ls -lart /var/run/my*如不存在，创建mkdir /var/run/mysqld创建mysqld.sock文件touch /var/run/mysqld/mysqld.sock修改权限chown -

转自：http://opensourcedbms.com/dbms/installing-mysql-5-6-on-cent-os-6-3-redhat-el6-fedora/

Summary: in this tutorial, you will learn about variables in stored procedure, how to declare, and use variables. In addition, you will learn about the scopes of variables.A variable is a named da

http://jwcooney.com/2012/08/13/asp-net-error-adding-the-specified-count-to-the-semaphore-would-cause-it-to-exceed-its-maximum-count/

Summary: in this tutorial, we will show you how to write MySQL stored procedures with parameters. We will also give you a couple of stored procedure examples to help you understand how to use differ

http://www.mysqltutorial.org/introduction-to-sql-stored-procedures.aspx

Summary: in this tutorial, we will show you step by step how to develop the first MySQL stored procedure by using CREATE PROCEDURE statement. In addition, we will show you how to call the stored p

转自：http://blog.hsdn.net/1433.html我在五年前(好久遠…)寫過一篇關於C# 連接 MySQL的文章，由於年代久遠MySQL也更新了相關的DLL，所以舊的程式會發生一些錯誤，因此我更新了這段程式，希望對於有使用C#連接到MySQL的朋友有所幫助。安裝MySQL Connector1. 首先請先到MySQL官方網站下載新的Connector：Conne

转自：http://www.isstudy.com/mysql/436.html创建数据表可以使用CREATE TABLE语句，其语法格式如下：CREATE [TEMPORARY] TABEL [IF NOT EXISTS] table_name[(create_definition,…)][table_options] [select_statement]TEMPORARY关

mysql根据配置文件会限制server接受的数据包大小。有时候大的插入和更新会受max_allowed_packet 参数限制，导致写入或者更新失败。查看目前配置show VARIABLES like '%max_allowed_packet%';显示的结果为：+--------------------+---------+| Variab

搜了挺长时间，都说mysqldump只能导出全部字段，可根据条件导出部分数据的全部字段，网搜了下发现一个导出部分字段的方法，使用select concat('insert into table_name(column1,column2...) values(\"',column_1,'\",\"',column_2,'\"') into outfile 'file_name' from table