Use excel_reader for import. It can be downloaded online. Code As follows:Require_once ('reader. php'); // contains the excel_reader file.$ DATA = new spreadsheet_excel_reader (); // create a reader object$ Data-> setoutputencoding ('utf8 ');$ Data->
First, view the current character set in MySQL.
Mysql> show variables like "% char % ";
+ -------------------------- + ---------------------------- +
| Variable_name | value |
+ -------------------------- + ---------------------------- +
|
We often need to back up the database. There are several schemas in the database, which is very troublesome. Write a script. Well, it's convenient.
The current user name, password, and host are all written in the script, which is more convenient.
I. InnoDB row lock ClassificationRecord lock: Record lock, that is, only a single row is locked.Gap lock: interval lock. Only one interval is locked. (Note that the interval here is an open interval, that is, the boundary value is not
Attribute: auto-increment ColumnNot Required: Unique, primary, positive number, bigint
Attribute: auto_increment is an optional attribute of MySQL In the table column definition. It conflicts with the default attribute.
Attribute: The index on
Miscellaneous Functions
Name
Description
Default ()
Return the default value for a table column
Get_lock ()
Get a named lock
Inet_aton ()
Return the numeric
MySQL supports a variety of system logs and provides comprehensive system errors, events, and business logic recording, tracking, diagnosis, and query functions!
Log Type
Information writtenLog
The Error
Encoding Problems:
There are four factors that affect MySQL encoding,
You can run the following command to View Details:
Mysql> Use db_name;
Mysql> statue;
We can see the following encoding:
Server characterset: utf8DB characterset:
I installed MySQL 5.1 and used MySQL connector net 6.1.3 as a management tool. However, when the statement was just executed, it was reported that "the requested. NET Framework data could not be found to provideProgram. It may not be installed.
Mysqldump-u user name-P password-P port number -- database name -- tables Table Name> C:/export file name. SQL
1. The parameter-P can be omitted unless your port number is not the default port number of MySQL.
2. If you do not write the -- tables
From http://bbs.taohost.net/thread-595-1-1.html
Mysql-uusername-pyourpassword yourdatabasename
Here, username is the MySQL user name, generally root;Databasename indicates the name of the target database for which you want to import data;Xxx.
ArticleDirectory
MySQL c api Programming Tutorial
MySQL c api programming tutorialabout this tutorial
This is a C Programming Tutorial for the MySQL database. It covers the basics of MySQL programming with the c API. You may also
I. Overview:
A MySQL cluster is an alternative. It is essentially a storage engine of a standard MySQL Server-named NDB or ndbcluster. This engine must be explicitly compiled into the mysqld server for use.
NDB supports a wide range of
Name
Description
Benchmark (cont, expr)
Repeatedly execute an expression is mainly used to test computation-intensive scalar expressions-similar to stress testing. For query, a single row and a single column are required.
Number
Extended: The display width only tells MySQL whether to fill the front blank when the number of numeric characters with a specified display width is less than the specified width. It does not affect the storage range and display of
Basic service settings
Basedir = OS _path-- Basic settings of everything
Plugin_dir = OS _path
Language = OS _path
Character_sets_dir = OS _path
Datadir = OS _path-- Extremely important! Data
The Character Sequence enclosed by backticks "'" is called a flag.
If the ansi_quotes mode is enabled, you can use the Character Sequence enclosed by double quotation marks "" to represent the flag.
The flag can contain any character,Of
RENAME TABLETbl_nameToNew_tbl_name[,Tbl_name2ToNew_tbl_name2]...
Alter {database | schema }[Db_name] {[Default] Character Set [=]Charset_name| [Default] collate [=]Collation_name}
Create {database | schema} [if not
MySQL needs to query the table where the field name is located based on a field name. This is mainly because, for example, you forget the table name, you only know that there is such a field name, and you want to find the table. The second case may
ArticleDirectory
Example-HTML form
Example:
Example:
AJAX can be used for interactive communication with databases. Ajax database instance
In the following Ajax example, we will demonstrate how to use Ajax technology to read
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