MySQL

1.show databases; Show all databases2.create database name [other options]; New DatabaseExample: Create database example_db character Set GBK; A database named example_db is created and the database character encoding is specified as GBK for easy

Take the example of creating a database with a character set of UTF8:CREATE DATABASE db_name DEFAULT CHARACTER SETUTF8 COLLATE utf8_general_ci;CREATE DATABASEThe syntax:CREATE{DATABASE | SCHEMA}[IF not EXISTS] db_name[create_specification [,

Create a database CREATE DATABASE IF not EXISTS $database DEFAULT CHARSET UTF8 COLLATE utf8_general_ci; CREATE DATABASE $database DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci; Create a user and add permissions # just create

Create a test table: MySQL> Create TableBigdata (IDint, nameChar(2) ; Create stored procedure: MySQL>Delimiter//MySQL> Create procedureRand_data (inchNumint) - begin - Declare Str Char( +)default 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0

To count the number of connections to a database, we typically count the totals without subdividing each IP. Now to monitor the number of connections per IP, the implementation is as follows:Method One:Select Substring_index (Host, ': ', 1) as IP,

The downloaded MySQL has two versions: one is. msi, can be installed directly, and then start the service in Services.msc;The other is to be configured with the following steps:1. Place the files where you want them, similar to the program

1. Read all the fields of a table using C # SQL statements2. Execute the following SQLString strSQL = String. Format ("Select column_name from Information_schema.columns where table_name= '" + the table name that needs to be queried + "' and

Scheduled BACKUP Database/usr/sbin/backupmysqltimestamp= ' date + '%y-%m-%d-%h-%m-%s 'Mysqldump-uroot-p ' 123456 databasename>/db$timestamp.sqlchmod +x BackupmysqlInstall Crontab:[email protected] ~]# Yum install Vixie-cron[email protected] ~]# Yum

mysql> #查询每个栏目最贵的商品mysql > select goods_id,shop_price,cat_id from (select goods_id,shop_price,cat_id from goods ORDER BY shop_price DESC) as temp GROUP by cat_id;+----------+------------+--------+| goods_id | Shop_price | cat_id |+----------+--

A friend was asked at the interview: the difference between Mycat and MySQL. We can think of the upper layer as an abstraction of the underlying, such as an abstraction of various kinds of computer hardware by the operating system. So when do we

I'm having a problem today. Unable to remotely link MySQLHost ' XXX ' is not allowed to connect to this MySQL server solution/How to turn on MYSQSolve the first prompt question firstIt turns out that no Telnet user was created in MySQLLog in to

Method One: Solve garbled problem by adding parameter--default-character-set = UTF8Method One: Solve garbled problem by adding parameter--default-character-set = UTF8Mysql-u root-p Password Method Two: Import garbled address in command lineUse

First, start/Shut down the database service:1. Open cmd Command Prompt window2, enter the command net start MySQL , enter, then started the MySQL service3. After entering the command net stop MySQL , enter, then turn off the MySQL serviceSecond, the

Create a database{} Required | Select from front and back [] optionalCreate {database | schema} [if not EXISTS] db_name [default] Character Set [=] Charset_nameCreate a database T1Create DATABASE T1;View all databasesShow database;If not exists (if

Left (outer) Join: The table is the main, which contains all the rows of the left table, and the right table satisfies the recorded data listRight (outer) join: The table that is the main, contains all the rows of the right table, and the left table

Detects if the machine has MySQL installed| grep mysqlAfter executing the above command, you see that the MYSQ socket is in the listening state, indicating that the installation was successful.Install MySQLsudo apt-get install mysql-server

Int (m) This m represents the width of the displayFunction: In the front-end to display an integer type of data, the database set the corresponding data type int (4), but the data written less than 4 bits, then the left padding space (if Zerofill is

In MySQL's master-slave environment, we can view some of slave's state information by executing the show slave status on Slave, which has a more important parameter seconds_behind_master. So do you understand what it really means and how it's

There are two main types of optimizations for massive data:the way of large table splitting table; optimization of SQL statements Partitioning Technology:similar to horizontal segmentation, but it is a horizontal table at the logical level, which is

MySQL can be used to change the root password.Zookeeper Method 1: use the set password command Mysql-u root Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass '); Method 2: Use mysqladmin Mysqladmin-u root password "newpass"