MySQL

Use the online general method to read and upload the contents of the CSV file into the MySQL database, the Chinese display garbled, even if the data with Iconv function transcoding still garbled, then you can use the setlocale () function:This

All along, the understanding of the database's transaction isolation mechanism always stays on the surface, and its contents are also looked over and forgotten. These two days decided to understand it in principle and to sort out their own knowledge.

MySQL Root Password Reset1 Login failed, mysqladmin change password failed[Email protected] var]# mysqladmin-u root password ' 123456 'Mysqladmin:connect to server at ' localhost ' failedError: ' Access denied for user ' root ' @ ' localhost '

MySQL Database optimization techniques:The optimization of the database is a comprehensive technology, which mainly includes: 1. The design of the table is reasonable (in accordance with the three paradigms, 3NF) 2. Add an appropriate index

Objectiversyslog System Log, called the syslog on the CentOS5, and on the CentOS6 called Rsyslog, called the enhanced version of the SYSLOG,CENTOS5 on the configuration file under/etc/syslog.conf, and CentOS6 under/etc/rsyslog.conf.The syslog

Prior to the Linux direct copy under the data of the entire database folder, in phpMyAdmin to re-give new users the appropriate permissions, Drupal successfully connected to the database. But there are more than N line error hints, all the

This foot is an upgrade to the script written in the morning (previous address http://www.sql8.net/a/course/shujuku/Mysql/2014/0815/30340.html)For colleagues multiple databases and data accounts, passwords, the host may not be the same situation

share the value range of tinyint in MySQL, some basic content. In the MySQL data type, the value range of tinyint is: The signed range is 128 to 127. The unsigned range is 0 to 255 (see the official MySQL 5.1 reference Manual,

When we design the database table structure, we need to pay attention to the performance of the data operation when we operate the database, especially the SQL statements when we look at the table. Here, we're not going to talk too much about

First, the basic conceptThe mysql5.1 version begins with the introduction of the event concept. Event is not only a "time trigger", unlike the events triggered by the triggers, the event is similar to a Linux crontab scheduled task for time

1. mysql--Create a databaseCreate database logs;--UsingUse logs;--Create a tableCREATE TABLE Weblogs (MD5 varchar (32),URL varchar (64),Request_date date,Request_time time,IP varchar (15));--loading data from an external text fileLoad data infile

1. Select Data SheetThe statements are as follows: UseMySQL;2. Add a connection user account to the users table in MySQL:Instead of adding a user record directly using the INSERT statement, using Insert may appear:Error 1364 (HY000): Field '

Mysql> #接下来学习触发器的概念Mysql> #触发器是由事件来触发某个操作的, including insert update DELETE statementMysql> #触发器的基本形式:Mysql> #create trigger Trigger name Before|after trigger event on table name for each row execution statementMysql> #如果需要执行多条语句则使用 begin ... end

MySQL Data directory/data/mysql is located in the upper directory/data disk space is not enough to cause MySQL boot failure, so clean up the/data directory in addition to the MySQL subdirectory of the other useless directory. Restart discovery or

Goal: Configure a keepalived dual-machine hot standby architecture and configure master-slave replicationPlanning:Master1 zlm177 192.168.17.177Master2 zlm188 192.168.17.188VIP 192.168.17.166Environment: Red Hat Enterprise Linux 6.4Percona Server 5.6.

Http://anothermysqldba.blogspot.com/2013/06/mariadb-1003-alpha-install-on-fedora-17.htmlMariaDB 10.0.3 Alpha Install on Fedora x86_64MariaDB 10.0.3 Alpha was just released.So for those of the recall my previous MariaDB 5.5 install post, I decided to

Mysql cannot be connected, logon, shutdown, and other problemsNow there is a problem with mysql: 1: Client Connection: Can't connect to MySQL server on '10. 14.39.220 '2. log on to the local server. mysql-uroot-phqnERROR 1045 (28000): Access denied

SQL database de-duplication and SQL database For SQL deduplication, I would like to briefly introduce myself. If you have any suggestions or do not understand it, please give it a little more. There are two common ways to remove SQL deduplication:

MySQL startup error: File./mysql-bin.index not found (Errcode: 13), mysqlbin. index After installing and initializing the MySQL database in Linux, use mysqld_safe to start the mysql database. [Root @ SVNServer bin] #./mysqld_safe-user = mysql

SQL subquery instance SQL subquery instance introduction: A subquery is a query within a query. The results of the subquery are used by the DBMS to determine the results of the advanced query that contains the subquery. In the simplest form of a