Amoeba is a middle layer developed by one of Alibaba's colleagues Based on the mysql client and server. It has some common features such as read/write splitting, data splitting, and filtering in distributed databases.
Functions of amoeba
A
How can we view the MySQL storage engine accurately? Here are two correct methods. 1) Correct Method 1: Show table status from database name where name = 'table name' 2) mysqlshow-u database Logon account-P
Sometimes, we want to see the
You can obtain an alias for the table and field during query. This alias can replace the specified table and field.
Alias for table
MySQL > Select * From Department d -> Where D. d_id = 1001 ; + -- ---- + ----------- + ------------
Address: http://www.start4e.cn/tabid/62/forumid/-1/postid/57/scope/posts/Default.aspx
1, install MySQL database ODBC driver, mysql-connector-odbc-3.51.19-win64.msi, http://www.mysql.com/find the corresponding windows under the
After installing MySQL 5.1 and playing for a while, the server is broken and the service cannot be started. The error 1067 is displayed.
I have been reading it online for a long time for many reasons, but it is hard to do so. After half a day, I
Modify MySQL engine to InnoDB. You can use foreign keys, transactions, and other functions with high performance.
Modify my. ini and add
Default-storage-engine =InnoDB
The red font indicates the engine name to be specified.
Use SQL
I checked the information online. The following two sentences are backup and restoration.
Mysqldump.exe-H 152.152.152.32-u root-p123456 tsingtest> C: \ 123. SQL Database Export
Mysqldump.exe-H 152.152.152.32-u root-p123456 tsingtest
However,
Today, I helped my friend configure the MySQL server and couldn't start the service. The error 1067 in the old version was very depressing!
At this time, the search engine plays a role, but the search results are the same. What is the content of
Original article: http://www.blogjava.net/etlan/archive/2007/07/12/129794.html
MySQL Command for viewing table Structures
Run the following command to view the table structure in MySQL:
Desc table name;Show columns from table name;Describe
In. NET and MySQL databases, Chinese characters cannot be displayed!
The solution is to add a character set charset = utf8 to the connection character;
Code
Code highlighting produced by Actipro CodeHighlighter
Data is very important. I want to know this with my toes. To ensure data security, we need to regularly back up data.
Here are some notes about data backup and restoration.
Data backup use the mysqldump command to back up a database
Mysqldump-
Recently, for performance problems, I used the MyISAM engine to create tables and found that the difference between the two is still a little big in auto_increment. The following describes the differences.
1. InnoDB:
Only one column in the table
Add subsonic. dll references to the project;
Add
Then subsonic Dal, refer to http://hi.baidu.com/beloving/blog/item/472d17ce1ed17e3ab600c8a9.html
NOTE: If there are multiple databases or even multiple types of databases in the same
This article is original. If you need to reprint it, please indicate the author and the source. Thank you!
This article has been published in Skynet: http://dev.yesky.com/353/2679353.shtml
With the popularization of networks, more and more
. Net connection MySQL database driver package MySQL. Data. dll
It encapsulates the ADO. Net operations of all MySQL Databases in almost the same way as SQL Server (for example, sqlcommand in SQL Server is called mysqlcommand in MySQL ).
Use
In this system, each module has its own function distribution and code design.
The Hiberate plug-in was used at the data layer, but the interaction between jdbc and mysql was first reviewed.
Platform: Eclipse3.6 mysql5.0
This is an introduction to
Linux (Ubuntu platform)JSPConnect to the MySQL database through JDBC, which is similar to that on the Windows platform. The procedure is as follows:
Download jdbc: mysql-connector-java-5.1.18.tar.gz
Unzip jdbc: tar-zxvf
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