MySQL

Linux under MySQL ERROR 1045:access denied for user: '[email protected]' (Using password:no)This problem occurs every time MySQL is enabled and then I type the command # Mysql-penter password:welcome to the MySQL monitor. Commands Endwith; or

1, serializable2. Repeatble Read3. Read Commit4. Read UncommitSerializableMultiple transactions are queued for execution, and subsequent transactions await the previous transaction submissionRepeatble read:Repeatable read, other transaction

BackupExport Database all table structuremysqldump -uroot -ppassword -d dbname > db.sqlExport a table structure for a databasemysqldump -uroot -ppassword -d dbname tablename > db.sqlExport database all table structure and datamysqldump -uroot

1 Single-Table queryQuerying all fieldsSELECT * FROM table_nameQuerying a specified recordAnd not like DESC ASCORDER BYIn keyword in (1,2,3,4)Between keyword between 1 and 2Like% or _ query for fuzzy matching_ Stands for 1% stands for 1 or

Goal: Connect MySQL find data into a new Excel tableImplementation process:1. Connect to the databaseFirst, go to the MySQL website to download an ODBC data source.After installation, you can see the MySQL driver name in the Control Panel-Admin tool-

First, INNODB support affairs, MyISAM not support, this is very important. Transactions are an advanced way of handling, such as in some column additions and deletions, as long as the error can be rolled back to restore, and MyISAM will not

Depend on:GCC,gcc-c++GUN Compiler KitNcurses-develNcurses provides a character terminal processing libraryKernel-develOperating system kernelBisonbelong to a parser generator for the GNU projectCMakeCMake is a cross-platform installation

GBK, gb2312: For Chinese people who use ChineseUtf-8: Equivalent to compatibility mode, the disadvantage is that the space is largeThe difference between Utf8_unicode_ci and utf8_general_ci: Utf8_general_ci does not support extensions, it is only

1. Optimize data typeThere are several types of data in MySQL, and if you are a DBA, you are rigorously checking the data types according to the principles of optimization, but developers may choose what they think is the simplest scenario to speed

GROUP byThe group BY keyword is used in MySQL to group one or some field queries and returns the first of the duplicate records.Grammar:SELECT column,... From Tb_name GROUP by column1,column2 ...The user table is logged as follows: UID

There are a lot of options here, and here's a quick look:1. Into outfile1 SELECT * frommytable2 intoOUTFILE'/tmp/mytable.csv' 3Fields TERMINATED by ',' 4Optionally enclosed by '"' 5LINES TERMINATED by '\ n';In my use of the process found a

MySQL is case-insensitive under Windows, and the table name is automatically converted to lowercase when the script file is imported into MySQL, resulting in an error when you want to put the database export into use on a Linux server. Because the

Test.javaImport Java.sql.drivermanager;import java.sql.resultset;import java.sql.sqlexception;import java.sql.Connection; Import Java.sql.statement;public class Test {static Connection con;//Declare Connection object static Statement SQL;//DECLARE

In MySQL to go heavy, is actually a very simple thing, to see the following example:mysql> DROP TABLE test;Query OK, 0 rows affected (0.01 sec)mysql> CREATE TABLE Test(ID INT,NAME VARCHAR (10));Query OK, 0 rows affected (0.01 sec)mysql> INSERT into

　　Run the MySQL Instance configuration Wizard as an administrator when configuredWhen you log in to the MySQL database: Error 1045 errors (such as), it indicates that you entered the user name or password error is denied access, the simplest

at work, we will encounter the need to change the database storage location, such as: the original database where the disk space is insufficient, and so on. compiling the installed Mysql[[Email protected] ~]# service mysqld status # First see MySQL

1. Configure the backup directory on the serverMkdir/data/mysqlbackup2. Write backup script codeVI dbbackup.shPaste the following code, and make sure to change the Username,password and dbname.Here's an example of backing up the entire databaseCode:#

1. Fully preparedMysqldump-u root-padmin--single-transaction--events--triggers--routines--all-databases > all-databases-' Date +% F '. sql2. Full-Backup RestoreSOURCE all-databases-' Date +%f '. sql3. Sub-Library PreparationMysqldump-u

MySQL environment to build online posts have been more, I have to write because just want to record their own installation of the process points, cut off the commonplace content 1. Need to download 2 things, Microsoft.NET.exe and mysql-5.6.24 2.

MySQL time and date function learningIn order to facilitate the use of the more Intelligent MySQL Client tool MYCLI, the introduction of this tool can be in another article (http://watchman110.blog.51cto.com/9194028/1687953) to understand!1,now ()