MySQL

View the currently supported storage engines Mysql> show engines;+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| engine              | Support | Comment      

MySQL method to delete all tables in the database:--  switch to the database where you want to delete the table use replace_with_database_name_you_want_to_delete;--  Delete all tables Set foreign_key_ checks = 0; set group_concat_max_len=32768; set 

This article explains the C language method of invoking the stored procedure of MySQL databaseThe following assumes that there is a SC table, save the student selection record, there is a course number, school number, peacetime points, scaled points,

Today added a database automatic backup module, MySQL data backup method has many, can be a single database backup, can be multiple database backup, or a table can be backed up, you can only back up the databaseThe structure does not back up the

SQL:Structured Query Language (Structured Query language)Classification:1. Data manipulation (Management) language: manipulate data directly; (DML: Data Management Language)Query the data and get the data. (DQL)Manage data, add, delete, modify data.

Index and manage IndexesA database object in the schemaFunction: Used in the database to speed up the query of the tableCreate: Automatically create indexes on primary key and unique keyReduces disk I/O by quickly locating data by using fast path

The current session can be modified directly with prompt mysql> prompt \[email protected]\h \d \r:\m:\s>PROMPT set to ' \[email protected]\h \d \r:\m:\s> '[email protected] MySQL 02:06:38>Also in the my.cnf configuration file [MySQL] Add ( Note

DELIMITER is actually defining a statement to execute the TerminatorDelimiter in MySQL:Http://blog.sina.com.cn/s/blog_4c197d420101d3oa.html1: Define Stored Procedure drop PROCEDURE test_insert;D elimiter $$//define Terminator Create PROCEDURE

Each table in MySQL has a clustered index (clustered index), except that each nonclustered index on the table is a level two index, also known as a secondary index (secondary indexes).For InnoDB, each InnoDB table has a special index called a

Date_format (Date,format)Formats the date value according to the format string.The following specifiers is used in the format string. As of MySQL 3.23, the "%" character is required before format specifier characters. In earlier versions of MySQL, "%

Mysql> select Tbl_id,create_time,last_access_time,tbl_name,tbl_type from TBLs;+--------+-------------+------------------+----------------------+---------------+| tbl_id | Create_time | Last_access_time | Tbl_name | Tbl_type |+--------+-------------+-

1. Account numberConnection data: mysql-h host-u root-p PasswordChange Password: mysqladmin-u root-p old_password Password New_passwordAdd Users: Create user ' user1 ' @ '% ' identified by ' password 'User authorization: Grant

website Description: Normally, a slave does not Log toits ownbinary Log anyUpdates that is received froma master server. ThisoptionTells the slave to LogThe updates performed byIts SQL thread toits ownbinary Log. forThisoption toHave anyeffect,

1. Create and edit the file/usr/sbin/bakmysql, command:Vi/usr/sbin/bakmysqlThe contents are as follows: 1 db_ user= "root" 2 db_passwd= "root" Span style= "color: #008080;" >3 db_name= "Db_test" 4 # the directory for stories your backup

1. Install MySQL Database2. Three files required after MySQL installation mysql.h libmysql.lib libmysql.dll.#include #include/*#include */#includeintMain () {MYSQL*con = Mysql_init (MySQL *)0); Mysql_res*Res; Mysql_row ROW; Chartmp[ -];

Reference: http://www.cnblogs.com/fly1988happy/archive/2011/11/21/2257682.htmlHttp://www.cnblogs.com/xiongpq/p/3384681.htmlFirst, install CMake (mysql5.5.0 after the version with CMake installation )Download:Cd/usr/local/src/wget

MySQL describes two problems in 15.2.10.5, and gives the solution separately.1. Write the data to the child table, but before writing, make sure that its corresponding information exists in the parent table.It may appear that the data in the parent

Stored Procedures and functions:To create the sample code:DELIMITER $ $CREATE PROCEDURE proc (in c_id int, in C_name VARCHAR (a), out Count INT) READS SQL databegin SELECT * F ROM course WHERE cou_no = c_id OR cou_name = c_name;

sql--structured querying language (structured query Language)The 1> SQL language is case-insensitive, and it is recommended that keywords be capitalized, but string constants are case-sensitive2> SQL Comment:/**/multi-line Comment--Single line

. Add primary key (primary key index)Mysql>alter TABLE ' table_name ' ADD PRIMARY KEY (' column ')2. Add unique (unique index)Mysql>alter TABLE ' table_name ' ADD UNIQUE (' Column ')3. Add index (normal index)Mysql>alter TABLE ' table_name ' ADD