When designing some datasheets, we often encounter situations where one field in a table needs to grow from another field, for example, when storing a player's weapon information in a data table, it is necessary to store the player's weapon
The wildcard characters in the like statement for MySQL: percent, underscore, and escape% represent random multiple characters SQL code Http://blog.csdn.net/yc7369/select * from user where username like '% Huxiao '; SELECT * from user where username
Usually because of the database study is not deep, so in the interview asked some of the usual encountered problems incredibly can not be very sure to answer, really let oneself very angry!One of the things that impressed me this time is:when using
1. Download and install MySQL1) to http://dev.mysql.com/downloads/download MySQL Community Edition Server, and the connector for JDBC. All the way to the default installation, it is important to remember the MySQL database username and password.2)
The following article mainly describes the PHP (PHP training PHP tutorial) + mysql (MySQL certified MySQL training) transaction operation of the actual application code demonstration, we all know in the actual lamp application, PHP is generally used
The 1.centos5.8 x86_64 is minimized, and the system has undergone a basic optimization2.nginx version: nginx-1.4.73. Source Package storage Location:/home/oldboy/tools4. Source Package Compilation Installation Location:/application/5. A
Must be a coding problem (UTF8 or GBK), but it is not necessarily the SQL file data, SQL file encoding problem, it may be the Import tool (encoding) problemThere are several ways to import MySQL1234SSC Prestige Platform "q:737888396" honor Platform "
Installation and service start-up:
sudo apt-get update [remember update source every time]
sudo apt-get install mysql-server [command line installed, middle to enter root account password]
After the installation is successful, MySQL is
After MySQL created the local link, sometimes after rebooting the link will not open, reported the following error:Can not connect to MySQL server on localhost.Workaround: Go to Task Manager to see if the MySQL service has started (my is this reason)
There are two ways to combine Apahce and PHP1 PHP as a module combined with Apache2 PHP combined as a standalone process with Apache, this way you need to handle PHP scripts in reverse proxy modeThe separation of MySQL in lamp, the general use is
Today, the integration of phpMyAdmin under CentOS Error, error prompts as follows:Error during session start; Please check your PHP and/or webserver log file and configure your PHP installation properly. Also Ensure that cookie is enabled in your
If you need reprint, please specify the source http://blog.csdn.net/slimboy123/archive/2009/07/30/4394782.aspxToday, my colleague, when using MySQL, needs to intercept the specified content in a string.such as the existing string
For bulk inserts:1, in the case of establishing a unique index, from the trip, if you encounter an index repeat error will stop the insertion (the previous insert succeeds), the error after the correct even if it is not insertedThe 1:insert method
Method 1,Curdate (), Curtime (), now ()Method 2,Utc_date (), Utc_time (), Utc_datetime ();You can see that UTC time is 8 hours smaller than the eight area.AttentionFunctions that return their current date or time are evaluated once at the beginning
MySql processes databases and tables
View Database
It is usually useful to obtain the Database List on the server. Run the show databases command.
Mysql> show databases;
Create a database
Mysql> create database db_test;Query OK, 1 row affected (
Mysql modifies the database storage engine (InnoDB)The current example is to change the engine MyISAM to innodb.View the supported database engines and default database engines of the current databaseDatabase-supported engines and default database
Mysql learning, mysql
1. log on to mysql and enter the mysql bin directory:
mysql -u root -p
Enter the password after you press Enter. After the database is created, the root password is blank and you can directly press enter to log on. You can
MySql adopts GROUP_CONCAT to merge multiple data display methods, mysqlgroup_concat
This article describes how MySql uses GROUP_CONCAT to merge multiple data display methods. The specific implementation method is as follows:
Assume that you have the
MySQL Common commands
I am a newbie
Learning how to manage and navigate to MySQL Databases and tables is one of the first tasks to be mastered. The following content summarizes some common commands of MySQL Databases and tables, some commands that
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