MySQL

Recently began to learn MySQL, mainly through books, and see Yan 18 teacher's video, and then through the blog to record their learning process.Log in to DatabaseView all current databasesMysql> show databases, #查看当前所有数据库 +--------------------+|

1. LoginMySQLDatabaseMySQL-U root-p#查看数据库mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema ||MySQL|+--------------------+2 rows in Set (0.00 sec)#查看user表Mysql> useMySQL;Database changedMysql> select

Reference: Http://imysql.cn/2008_07_10_innodb_tx_isolation_and_lock_modeThis article is only for " SELECT ... LOCK in SHARE MODE"and"select ... for UPDATE "in transaction lock and RR isolation level testing, for the table structure, index

1. Unzip the downloaded MySQL archive into a custom directory (D:\Program Files (x86) \mysql-5.6.16-winx64). 2. registering MySQL as a Windows system serviceThe operation is as follows:1) Create a new My.ini file and put the My.ini file under

The problem solved:Installing MySQL server and MySQL client 5.5Create a new remote accountRemote access PermissionsMySQL default character set modified to UTF8Check the firewallFirst, installationBTW: You can use the Find command to view the

Get the DataSource resource from the server container through Jndi (managed by the container, do not close it, the container will handle it itself) the previous article we used is DBCP, which uses Jndi:To connect data using Jndi:In Spring commentUse:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/29/FA/wKioL1OAQ53iojoBAAGdYP7VEHc107.jpg "title=" 46cad483-420b-4e86-b5db-6425929b28b8.png "alt=" Wkiol1oaq53iojobaagdyp7vehc107.jpg "/>0. http://soft.macx.cn/2068.htm1. Installing mysql-5.6.

First, common operation1. Duplicate table structure CREATE table t2 like T1Copy table data INSERT INTO t2 SELECT * from t12. mysql IndexALTER TABLE is used to create a normal index, a unique index, or a primary key indexALTER TABLE T add index index_

First, the development environmentMac OS X 10.9.2 64-bit, Xcode5.1, MySQL5.5.37 64-bitThe MySQL installation directory is:/usr/local/mysqlSecond, configure Xcode to connect MySQL's compilation option1> Add the MySQL header file directory to the

In the page tour, most of the development patterns are: Client (AS3) + server Side (Java) + database (MySQL).In these 3 sections there will be an identical part of the data structure. such as a user data, in the client using Class Uservo (AS3) to

When installing MySQL on a Linux system, thethe Mysql-5.6.17-1.el6.x86_64.rpm-bundle.tar package opens with 7 rpm files, as

Delete multiple table data in MySQLDelete deletes multiple table data, how can you delete data from multiple associated tables at the same time? Here's an in-depth explanation:1. Delete from T1 where condition2. Delete t1 from T1 where condition3.

Required Software:Httpd-2.2.22-win32-x86-no_ssl.msiPhp-5.4.5-win32-vc9-x86.zipMysql-5.5.27-win32.msi 1. Install Apache, modify httpd.confModify the httpd.conf file, the file is located under \apache2.2\confFind #loadmodule vhost_alias_module modules/

backing up the database1. Use the mysqldump command to back up Back up a database: Mysqldump-u user name-p password database name [table name 1, table Name 2 ...] > backup file path and name. sql If there is no table name, back up the

Download a new mysql.5.6.17 from mysql.com after installation, because the original machine installed MySQL, start always error650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/28/5F/wKioL1N4Rx7QBz_AAAAykPCF0ck190.png "title=" Mysql_ Error_2

# vim:tabstop=4 shiftwidth=4 softtabstop=4# Copyright states government as represented by the# Administrator of the National Aeronautics and Space administration.# Copyright, Justin Santa barbara# All rights reserved.# Copyrigh T (c) Citrix Systems,

The problem is that mysql cannot log on.[Plain] view plaincopy [Root @ slave1mysql] # mysql ERROR2002 (HY000): Can 'tconnecttolocalmysqlserverthroughsocket '/Var/lib/mysql. sock' (111) First, check whether mysqld is started: service mysql

Take notes on inserting Chinese characters into MySQL 1. Script statement Charset gbk is used before import. Modify the table field encoding: Note: If you use the import method to insert data, the console reports an error. If you run the

I. PreparationTest with two servers:Master Server: 192.0.0.1/Linux/MYSQL 4.1.12Slave Server: 192.0.0.2/Linux/MYSQL 4.1.18 The principle of master slave server is that the MYSQL version must be the same. If not, the MYSQL version of the slave server

Various load file methods and time for MySQL and PostgreSQL are evaluated on virtual machines. Because it is the evaluation on the virtual machine, so the time is only for reference, don't be too real, just look at it.MySQL tool:PostgreSQL tool:Test