Desc table name;
Show columns from table name;
Describe table name;
Show create table table name;
Use information_schemaSelect * from columns where table_name = 'table name ';
By the way:Show databases;You can also
Use information_schema
Baidu consulted some materials and combined with some of its own experience, adopted the following solutions:
CopyCodeThe Code is as follows: $ idlist = '';
For ($ I = 1; $ I If ($ I = 1 ){
$ Idlist = mt_rand (3,25216 );
}
Else {
$ Idlist = $
CopyCodeThe Code is as follows: alter table 'database name'. 'table name' add column 'procid' varchar (6) default ''after 'ppidchanged ';
-- In MySQL, if the table name, database name, and column name are used, you must use the accent symbol on the
1. Use the MSSQL Enterprise Manager to open the table structure (design table). locally, use phpMyAdmin to create one table based on the structure, optimize the table data fields, and create the table.
2. Use the Enterprise Manager to export a
MySQL cannot be started because the hard disk is full.
Log on to the system and check the cause.
Delete the MySQL Log File and restart mysql. the following error is found: Starting mysql. Manager of PID-file quit without updating file. [failed]
For operations on the string position, the first position is marked as 1.
ASCII (STR)
Returns a string.StrASCII of the leftmost characterCodeValue.If
StrIs a null string and returns
0. If
StrYes
Null,
Myisam_max _ [Extra] _ sort_file_size is large enough
Delay_key_write reduces Io and improves Write Performance
Bulk_insert_buffer_size
Set concurrent_insert to 2.
Read_rnd_buffer_size random Scan
Read_buffer_size sequential table Scan
Three
At the same time, the online access volume continues to increase. For servers with 1 GB of memory, the server even crashes every day or gets stuck from time to time. This problem has plagued me for using MySQL for more than half a month. scalable
Differences between char and varchar
Char (13) is fixed in length. For example, the storage space of 'www .jb51.net' must be 12 characters long.
Varchar (13) Variable Length: for example, 'www .jb51.net' requires a bucket of 13 characters,
There are three common methods for MySQL database backup:
1. Directly copy (CP, tar, Gzip, cpio)
2. mysqldump
3. mysqlhotcopy
1. Use Direct Copy Database Backup Typical applications such as CP, tar, or cpio Program .When using the direct backup
CopyCode The Code is as follows: select...
Union [All | distinct]
Select...
[Union [All | distinct]
Select...]
Select... Union [All | distinct] Select... [Union [All | distinct] Select...]
Union is used to combine the results from many select
Yesterday it was configured for a day, its configuration is Jena 2.4.0, MySQL database version is 5.1.42-community, JDK version is 1.6.0, mysqldriver is mysql-connector-java-3.1.14;
An example is written based on the resources on the network, and
CopyCode The Code is as follows:
/*--------------------------------System: Pt book-Pt novel thiefCode: James pakey-----------------------------------*/
$ Pt_mysql = new dbquery;
/*** MySQL Query Class**/
Class dbquery {/*** Total number of
Date_add (Date, IntervalExpr Type) Date_sub (Date, IntervalExpr Type)
These functions perform date operations.DateIs a datetime or date value, used to specify the start time.ExprIs an expression used to specify the time interval value added or
Operating System: WINDOWS-XP System
Database Version: MySQL 5.x
Tip:Access denied for user 'root' @ 'localhost' Using password yes/no
It turned out to be good. The above error was prompted when I started the system today. It is still not
The followingArticleI am mainly introducing the five configuration parameters that closely affect MySQL performance. I saw the five configuration parameters that closely affect MySQL performance on the relevant website a few days ago, let's share it
Use execl to convert TimestampThe formula is:
Code :
= (Xxxxxxxxxx + 8*3600)/86400 + 70*365 + 19
Use a MySQL statement to explain the timestampSyntax example:
Code:
Select from_unixtime (1234567890, '% Y-% m-% d % H: % I: % s ')
Drop procedure if exists pro_rep_shadow_rs;
Delimiter |
----------------------------------
-- Rep_shadow_rs
-- Used to process information addition, update, and deletion
-- Only data that has not been updated since the last time is updated each time.
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