1. delete a table: Drop table name;
2. Insert record: insert into user (ID, name) values (1, 'zhang san ');
3. Delete record: delete from user where id = 1;
4. Modify the record: update user set name = 'lily' where id = 1;
5. query record:
LinuxLowerMySQLInstallation and configuration
MySQL
Installation
MySQLInstallation is relatively simple becauseSambaSo you can directly put the content to be installed in the system,
Use it directly. (The files
MySQL automatic number field
When creating a table:Create Table 'mydatabase'. 'mytable '('Id' integer unsigned not null auto_increment,......Primary Key ('id '))If the table already exists, modify it.Alter table 'mydatabase'.
To start the mysqld server, you should start an msdos window and type: C:/MySQL/bin/mysqldThis will start mysqld in a blank background. In this way, you can kill the MySQL server and execute: C:/MySQL/bin/mysqladmin-u root Shutdown Open command
The JSP page uses the following three statements to ensure GBK encoding.
Use the following statement to connect to a database:String sconnstr = "JDBC: mysql: // localhost: 3306/test? User = Michael & Password = 123456 & useunicode = true &
1. Determine the default encoding of the database. For example, if the encoding is utf8, set the reading path encoding to utf8 and set the command to set names utf8;2. Source D:/20080613. SQL import data. Check whether garbled data exists in the
I have no intention of learning too much database knowledge. This article is just a Summary of the miscellaneous articles on the Internet. It will only be used for MySQL installation in the future.
I. Installation Process:
1. Preparations
Download
The following articles mainly describe the actual operation steps of MySQL Delete syntax and the actual application code of MySQL Delete syntax. The following describes the specific content, I hope it will help you learn this syntax.
Single Table
Use of delayedUse delayed insert operationsThe delayed modifier is applied to insert and replace statements. When the delayed insert operation arrives,The server puts data rows in a queue and immediately returns a status message to the client.You
Install Ruby, rails, and MySQL in Windows
1. Download and install Ruby:
Http://rubyinstaller.org/downloads/ download the latest Ruby 1.9.3 and install it.
After the installation is complete, view the version number.
Ruby is
0. Environment Introduction
The cluster nodes are master1, master2, and slave1. Master-slave replication from master2 to slave1 has been completed. Now you need to configure the mutual replication between master1 and master2.
1. Modify the master2
I found a lot of information about using MySQL C APIs and examples on the Internet. It's not for VC, it's for BCB, or for Linux, and I 've always wanted to use standard C ++ for something in WIN (the nickname is portability ). So I want to use MySQL
1.Character set (character set) is the ing from binary encoding to the specified symbol set;
Collation is a set of Character Set sorting principles;
2.If you run show variables like "% character %" on the mysql client, the character set setting in
In response to the multi-thread concurrent operation of the system, a simple Python script is written today to insert and retrieve data to and from MySQL, And the mysqldb and threading modules are used.
Among them, the threading module is an
1. Install mysql5.1Open the downloaded installation file and the following page is displayed: Start the MySQL Installation Wizard and click "Next" to continue Select the installation type, which has three options: "typical (default)", "complete
When inserting data into a table, you often encounter this situation: 1. First, determine whether the data exists; 2. If the data does not exist, insert the data; 3. If the data exists, update the data.
In SQL Server, you can perform the following
MySQL character set support has two aspects:Character Set and collation ).The support for character sets is refined to four layers:Server, database, table, and connection ).
1. Default MySQL Character Set
MySQL can refine the character set
This article describes a situation where this error occurs!Myeclipse throws an exception:
Check the manual that corresponds to your MySQL Server version for the right syntax to use near 'read, create, update, delete, execute) values ('sap ', 4,
Saw the netizen Wang open source "A Chinese it thinking -- Evaluation of the United States took the lead to cast ooxml yes vote" (http://blog.csdn.net/arthur5933/archive/2008/03/19/2197087.aspx) article, coupled with a little recent sentiment, to
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