MySQL

Select the appropriate data type:Char and varchar:+---------+------------+| char (6) | varchar (6) |+---------+------------+| | | | str | str | | str123 | str123 | | str123 | str123 |+---------+------------+4

1.error Log   Error log, log the problem that occurs when the MySQL service starts, text file[Mysqld_safe] #注意是写在这里Log-error=/var/log/mysqld/mysql-error.log --mysqld folder to be present and chown mysql The log cannot be turned off2.access

For example:There is a Type field in the article table, he stores the article type, there are 1 headlines, 2 recommended, 3 hot, 4 graphics ..... 11,12,13, wait.Now there is an article he is a headline, but also hot, or graphic,The type is stored in

I. Conditions of preparationTwo MySQL servers:MASTERSERVER:REDHAT6.3-64-bit system, ip:192.168.136.11SLAVESERVER:REDHAT6.3-64-bit system, ip:192.168.136.12Second, configure the Masterserver server1, log in to master server, edit the/etc/my.cnf file,

1. Master receives write operation, writes Binlog2. Slave on Io_thread Connection master, request the change log3. Io_thread received log request after writing to Relay-log4. Slave on Sql_thread read Relay-log, execute the SQL inside, synchronize

Hello everyone, I am 乄God epilepsy buckle:929777981, today to bring php+mysql manual Blind Tutorial, Although the injection is not God horse new technology, but there are many pots of friends will not, many pots of friends are with the help of

Today, the developers asked me, does MySQL have a limit on capitalization? I don't think so, say no limit. After a while, the developers told me that there was a limit to Linux. I suddenly had the feeling of beating my face. For their own uncertain

[Email protected] Oct 14:48:10 14:48:10 [(none)]>[email protected] @global. tx_isolation,@ @tx_isolation;+-----------------------+----------------+|@ @global. Tx_isolation | @ @tx_isolation |+-----------------------+----------------+| read-committed

MySQL to export to Excel file is very simple, execute a command like this: select * from a table into outfile   ' d:/file name. xls ';  the above command you perform on the server, on the server D: disk, if the client command line execution, on the

Fault:At about 7 o'clock in the evening, received the Broadcast center complaint, said the video playback is slow, loading for a long time not come out. At first, brother thought it was Tomcat service and hung up. So see the next Catalina.out output

1. Check from libraryshow slave status \g;Slave_io_running:yesSlave_sql_running:no2. An error similar to the following appears:Last_sql_error:error ' Duplicate entry ' 1001-164761-0 ' for key ' PRIMARY ' on query. Default database: ' Bugs '. Query: '

MySQL master-slave synchronization is currently using a relatively broad database architecture, technology is relatively mature, configuration is not complex, especially for the load of large sites, master-slave synchronization can effectively

1.1 Development stage of database management technologyHuman Management phase, file system phase, database system phase.1.2 Concepts involved in the database system phaseDatabase DB: A collection of data that can be shared by a variety of users or

The full set of installation packages required to install

Ubuntu install MySQLGirlfriend to do Linux level three project, but did not install a good night MySQL, I know she does not want to disturb me, do not want to trouble me. For her this kind of kindness sincerely feel happy, she must be able to enter

DROP DATABASE IF EXISTS databaseweb; --delete the mode if it exists databasewebCreate DATABASE databaseweb CHARACTER SET utf8;--creation mode Databaseweb. Using UTF8 encodingUse databaseweb;--switch to mode Databaseweb, the following operations are

Once secretly interviewed two units, all mentioned the optimization of MySQL problem, so after a lot of learning database optimization knowledge. The optimization of the construction database is probably mainly the optimization of the index, because

Working PowerDesigner Select File-new Create a new table from the tool iconIn the Properties window of the tableSelect Physical Options tab Select Type= (ISAM) from the list on the leftClick >> to select it to the right-hand side of the

Installing databases in Linux the first version of the preferred Mysql,mysql database is distributed on Linux systems, and other options can be postgresql,oracle, etc.To install MySQL database on Linux, we can download the MySQL database rpm package

Reference URL: http://www.111cn.net/database/mysql/51146.htmThe original page ads too much, I copied the next.1. Delete from T1 where condition2. Delete t1 from T1 where condition3. Delete T1 from T1,t2 where condition4. Delete t1,t2 from t1,t2