1. Delete all matching records with ID values in Table T2.
Delete T1 from T1, T2 where t1.id = t2.id or delete from T1 using T1, T2 where t1.id = t2.id
2. From Mysql Data Table T1, no matching records in data table T2 are found and deleted.
The default encoding of MySQL is Latin1, which does not support Chinese characters. You need to change the default encoding of the database to GBK or utf8 at noon.
1. You need to log in as the root user to view the database encoding method (the
1. Use the MySQL built-in command mysqldump
Usage:Mysqldump [Options] database [Tables]Mysqldump [Options] -- databases [Options] db1 [DB2 DB3. ..]Mysqldump [Options] -- all-databases [Options]
You can see that you can back up all the databases,
Author: heiyelurenBlog:Http://blog.csdn.net/heiyeshuwuTime: 2006-10-14
It is fast enough to run a common MySQL with a small amount of data and traffic. However, when the data volume and traffic volume increase sharply, it is obvious that MySQL is
If you want to use the time limit when operating the database, store the time in the format of year-month-day hour: minute: Second. For a storage method in Linux: void * gettime (char name []) {struct TM * P; // char name [512]; char C [5]; time_t;
Query records of the current day
Select * From hb_article_view where to_days (hb_addtime) = to_days (now ())
Query data for the current weekSelect name, submittime from enterprise where yearweek (date_format (submittime, '% Y-% m-% D') = yearweek
XP system,
Download the mysql5.6.12 decompressed version some time ago. It can be used, but it can be used remotely
Mysql-H *. *-u root-P
*. * Indicates the IP address of the server, which cannot be logged on.
Error 1045 (28000): Access denied for
When MySQL 5.1 is upgraded to MySQL, the database must be backed up as an SQL file, and then data must be imported. Copying database files may cause some strange problems, such as Chinese garbled characters, table Corruption and other mysqldump
Rights and privileges
Privilege
Description
All
All privileges tGrant Option
Alter
UseALTER TABLE
Alter routine
UseAlter procedureAndDrop procedure
Create
UseCreate Table
1. After the service is installed and started, MySQL commands cannot be identified under the command line.Solution: MySQL is installed in/usr/local/MySQL/bin/MySQL by default, the solution is to enter/usr/local/MySQL/bin/MySQL-u root-P in the
Article from: http://blog.csdn.net/jccz_zys/archive/2007/07/08/1682810.aspx
Mysql5.0 and later support stored procedures. At present, MySQL's Alpha alpha version has also been released. 6.0 not only supports the vast majority of Functions of large
Chinese garbled characters -- question mark ??
1: The default Character Set of eclipse is utf8;
2: The default Character Set of mysql6 database is also utf8;
3: The table creation statement also indicates:
Engine = MyISAM Character Set = utf8;
4
Document directory
6.1.1. syntax for creating a table
6.1.2 set the table's primary key
6.1.3 set the foreign key of the table
6.1.4. Set non-empty table Constraints
6.1.5. Set table uniqueness constraints
6.1.6. Set the attribute value of
Document directory
2.1.1 Installation
2.1.2 uninstall
2.2.1 Installation
2.2.2 uninstall
2.3.1. MySQL
2.3.2. mysqladmin
2.1 install the MSI installation package 2.1.1
Note that you must delete the original my. you can change the name of INI
System Requirements:The hardware can start the operating system.Win2k, WINXP, or win2003 Operating System
Preparations:List of required software: (this configuration includes the following software versions)1. APACHE_2.0.47-win32-x86-no_ssl (Apache
This article from: http://johnnyhg.javaeye.com/blog/245544
1. Download MySQL
Http://www.mysql.org/downloads I download is mysql-noinstall-5.0.67-win32.zip
Ii. Installation Process1. Extract the mysql-noinstall-5.0.67-win32.zip to a C disk and
This article synced to: http://www.waylau.com/mysql-5-6-13-windows-platform-installation-use-graphic/
1. First, the computer must have a. NET Framework 4 or above EnvironmentIi. MySQL download, installation, and execution1. Download http://cdn.mysql.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service