MySQL

Describe table_name; this command is used to display the structure of a table + ---------- + --------- + ------ + ----- + --------- + ------- + | FIELD | type | null | key | default | extra | + ---------- + ----------- + ------ + ----- + --------- +

The operation method described in this article is only usedNonMsi InstallationProgramWhen the installed MySQL program or MySQL program is copied from another PC to the local machine; Download or copy the latest MySQL program file to the local

Concat functions in MySQLUsage: Concat (str1, str2 ,...) Returns the string generated by the connection parameter. If any parameter is null, the return value is null. Note:If all parameters are non-binary strings, the result is a non-binary

To support Chinese characters and unified character sets, we use the utf8 character set. First, modify my. ini (MySQL configuration file) and add the following content in the following configuration block:   1. [client] # Client Connected to

Use Mysql-eWhen the generated result is imported to a specified file:● To display the statement itself at the same time:-V● To increase the number of rows in the query result:-VV● To increase the execution time:-Vvv  Some monitoring scripts can

Original http://www.cnblogs.com/daimage/archive/2012/02/25/2367534.html 1. MySQL workbench MySQL workbench is the database administrator,ProgramDevelopers and system planners provide visual SQL development, database modeling, and database

I started to try MySQL today. I encountered some common problems when installing mysql. I hope it will be helpful to myself and friends: Error 1: Step 2 of configuration execution: System prompt: "configuration file tmeplate E: \ website \ mysql \

MySQL basic commands Favorites First, start and stop the MySQL Service Net stop MySQL Net start MySQL Second, log on to MySQL Syntax: mysql-u user name-P User Password Enter the mysql-uroot-p command, press enter and prompt you to enter the

 MySQL create table statement application and syntax   The following articles mainly introduce the actual usage of the MySQL create table statement and the basic syntax of the MySQL create table statement. If you are interested in the specific

I. Basic Database Operations 1. Create a databaseCreate database is used to create a database. The basic syntax is as follows:   CREATE DATABASE database_name The following is an example:   We want to create a database named "test_db. We use the

// Convert data when writing data to the databasePublic String gb2312_iso8859 (string write){// Declare the character setSystem. Text. Encoding iso8859, gb2312;// Iso8859Iso8859 = system. Text. encoding. getencoding ("iso8859-1 ");// 2312 GBGb2312 =

Install mysql5.0 in Linux   In the installation and configuration process of mysql5.0 under suse9, because the source code package is used for installation, this process should also apply to other versions of Linux. 1. Install MySQL1. Download the

This article is some of the scattered notes in the first chapter of MySQL technology insider. mysql> Create Table member (member_id int unsigned not null auto_increment, primary key (member_id), last_name varchar (20) not null, first_name varchar (20

========================================================== ====================================================== Excerpted from hellodba The single-host and multi-instance MySQL solution is to run multiple MySQL database instances on a physical PC

1. Modify the table creation engine Mysql> Create Table test_2 (-> name varchar (10),-> year int (10)-> engine = InnoDB; --> specify the default Engine Query OK when creating a table, 0 rows affected( 0.10 Sec) mysql> show create table test_2 \ G ***

[Intrinsic column flags] (basic field type identifier)-PK: Primary Key (column is part of a PK) primary key-NN: not null (column is nullable) not empty-Uq: Unique (column is part of a unique key) unique-AI: auto increment (the column is auto

There are four database isolation levels, as described in the high-performance MySQL book:   Then let's talk about how to modify the transaction isolation level: 1. Modify the global settings, modify the mysql. ini configuration file, and add 1 #

When I was learning new technologies, it was really depressing to configure the environment. But fortunately, many of my friends on the Internet are very helpful to me. 1. install and configure APACHE (install it to D: \ phpapache \ Apache2.2)1. It

1. ########## how to obtain the total number of rows obtained from the last query ######## Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Mysql> select SQL _CALC_FOUND_ROWS * from _ table _ limit 0,

Java Chapter 2 Today, I mainly talked about thread synchronous communication and Timer: Timer and TimerTask, and some examples are given.To avoid deadlocks, let the thread release its locked resources as much as possible when it enters the blocking