To add data tables in MySQL, I learned how to add tables today. I wrote a blog to summarize it. PS: after all the annotations are completed on my computer, copy it to the notepad. You can add comments as needed during execution. Select
Shang ke: delete the history operation file of MYSQL security to find out where the mysql data file is installed:
Enter mysql and perform fuzzy search:
Mysql> show variables like '% data %'; // fuzzy search
Mysql> show variables like 'datadir ';
Mysql Learning Series: Error: 1005 Error errno: 105 mysql Learning Series: Error: 1005 Error errno: 105
1. SQL script:
(Red indicates the modified script)
Create database if not exists insurance;Use insurance;Create table if not exists person
The unix_timestamp function of mysql time comparison can accept a parameter or not use a parameter. The return value is an unsigned integer. If the parameter is not used, it returns the number of seconds that have elapsed since 00:00:00, January 1,
To view the current mysql connection in linux, you must first log on to mysql.
There are a total of three commands:1. status
mysql> status--------------mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1Connection id: 96
MySQL 5.5.x compilation and installation MySQL 5.5.x compilation and installation
I recently started to learn MySQL-related knowledge again. I used to study it in a scattered manner. now I want to repeat it again. I will take my own notes.
PHP uses the PDO method to convert Mysql data to a function in the SQLite form. Recently, a function is used to convert mysql data to sqlite data, because we want to save the image data in blob binary format, I will write a class myself. from the
MySQL can be connected using localhost, but cannot be connected using IP addresses.
Problems frequently encountered during java web Development: mysql can only be connected using localhost or 127.0.0.1
Solution: After mysql is installed, it is the
Mysql viewing table types Mysql viewing table types InnoDB
Problem description:
MySQL data tables support six types: BDB, HEAP, ISAM, MERGE, MYISAM, and InnoBDB.
These six types are divided into two categories: transaction-safe, including BDB
Before getting tokudb, run echo never>/sys/kernel/mm/redhat_transparent_hugepage/enabled on centos 6 to disable Transparent Huge Pages, I did not go into it at that time. now I will try again.
Before talking about Transparent Huge Pages, let's
Mysql random query records
Test the efficiency of using rand random query records in mysql
I always thought that mysql would randomly query several pieces of data.
SELECT * FROM 'table' order by rand () LIMIT 5
You can.
However,
Paging SQL statements for ORACLE and mysql
Oracle:
1. minute by ROWIDSelect * from t_xiaoxi where rowid in (select rid from (select rownum rn, rid from (select rowid rid, cid from t_xiaoxi order by cid desc) where rownum 9980) order by cid desc;
MySQL Query processing of NULL
There is a field blist. if you query where blist <> 'B', why cannot the records whose blist is NULL be found? How can I find a NULL value record?
Answer:
Null values cannot be compared using common arithmetic
The mysql view is used to export tables from one or more basic tables (or views. Unlike the basic table, it is a virtual table. The database only stores View definitions, but does not store view data. The data is still stored in the original basic
Usage of mysql cursor loop
Create procedure 'test '. 'New _ procedure '() BEGINDECLARE done int default false; -- you need to define the variable DECLARE a CHAR (16); -- the cursor declare cur cursor for select I FROM test. t; -- DECLARE done int
Mysql groups by day, month, week, and quarter by day: select DATE_FORMAT (o. orderDate, '% Y % m % d') weeks, count (*) count from orders o group by weeks;
Grouping by month: select DATE_FORMAT (o. OrderDate, '% Y % M') weeks, count (*) count from
How to use regular expressions in mysql to query regular expressions
Basic form
Property name regexp 'matching method'
Regular expression pattern character
^ Starting from matching characters
Eg1: query records starting with L from the name
MySQL stored procedure learning (1) 1. creation of stored procedure
CREATE PROCEDURE proc_demo()BEGINSELECT username FROM t_user;END
Create a stored procedure named proc_demo. Note that the brackets after the stored procedure name must exist,
Fix the stored procedure of the AUTO_INCREMENT start value of the auto-increment field of the mysql database
Delimiter $ create procedure catalog (IN db varchar (10) begindeclare tmp_name char (30) default ""; declare tmp_cursor cursor forselect
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