MySQL

One, 1 CREATE TABLE name (name VARCHAR (10));For this table, by default, the results of the following two queries are the same:SELECT * from TABLE NAME WHERE name= ' clip ';SELECT * from TABLE NAME WHERE name= ' Clip ';The MySQL default query is

Memory table:1, through the MY.CNF in the max_heap_table_size designation, support dynamic designation2, the table definition is stored on the disk, the extension is. frm, the restart is not lost, the data is stored in memory, so the restart will

1. First check whether the profiling function is turned on like ' %pro% 'OrSELECT @ @profiling2. Open ProfilingSET Profiling=13. Execute SQL statementsFor example:SELECTTable_schema as 'Db Name', ROUND(SUM(Data_length+Index_length)/ 1024x768 / 102

MSSQL Differential Backup Usage tipsAPR 2013The so-called differential backup is to back up only the portion of data that has been added to the backup since the last backup. For example, my first nth backup after the database is the content of ABCD,

How MySQL temporarily disables triggersCause?? The MySQL trigger, on trigger control, can only trigger control according to the operation mode of the data (Insert,update,delete) and before and after (Before,after) operation. But what if you

Fundamentals of the ten-year OPS series-MySQLZeng LinContact: [Email protected]Website: www.jplatformx.comCopyright: Please do not reprint the article without permission First, IntroductionPay special attention to the differences between MySQL and

8. Calculated fieldsConcat () Splicing stringMysql> SelectConcat (Name,'-', msg) fromPw_luck;+-----------------------+|Concat (Name,'-', msg)|+-----------------------+|Wilson- - ||Zhangsan- - ||Lisi-1001 ||Wang5-1001

Environment:CentOS6.6 hadoop1.2.1 mysql5.1.73 1. Download[Email protected] ~]$ wget http://mirrors.cnnic.cn/apache/hive/hive-1.0.0/apache-hive-1.0.0-bin.tar.gz 2. Decompression[Email protected] ~]$ TAR-ZXF apache-hive-1.0.0-bin.tar.gz 3. Setting

9. Data processing functionsText Processing: Upper uppercaseMysql> SelectUid,name,msg,Upper(name) asUppername fromPw_luck;+-----+-----------+------+-----------+|Uid|Name|Msg|Uppername|+-----+-----------+------+-----------+| 0 |Wilson| - |WILSON||

Create a libraryCreate DATABASE xxx; View Library Nameshow databases; Enter LibraryUse XXX; View TableShow tables; Create a tableCreate tables xxx; Clear tableDelete from xxx; View table Structuredescribe xxx; CREATE table name written

MySQL Connection string Summary1. Local Database connection2. Remote Data connectionserver=myserveraddress;option=131072; stmt=;D atabase=mydatabase; User=myusername; Password=mypassword;>3. Special TCP/IP port connectionserver=myserveraddress; port=

1. Check that MySQL backup command has no effectCreate a backup directory under the Var directory and create a MySQL directory in the backup directory for MySQL backup filesCD to/var/backup directorymysqldump-uroot-pwh5268925 Zhaochao >

PHP embedded in HTML, placed in?>Tag insideGeneral php file extension. phpBefore the Body settlement labelFor remote servers, you can use the FTP tool to pass programsPrint StatementsEcho ' Hello world! ';print "Hello World";PHP is case-insensitive

#!/bin/bash# name:bakmysql.sh# a shellscript for Auto DB backup and Delete old backup# backup address Backupdir=/home/mysqlbac kup# backup file suffix time time=_ ' date +%y_%m_%d_%h_%m_%s ' #需要备份的数据库名称db_name =test#mysql user name

How to reset the root password:Under Windows system:1, stop the MySQL service;2, the new file Init-root.txt, write the following content:Update mysql.user Set password = password (' newpwd ') where user = ' root ';Flush privileges;Save3. Open the

The weird sync problem with MySQLRecently encountered a strange MySQL synchronization problem, after multi-analysis and location found incredibly due to backup caused, very wonderful, hereby record the whole problem analysis and positioning

#!/bin/bash#数据库配置信息#db_user = root#db_password = Wdmima#db_host = localhost#备份目录Backup_dir =/root/database/#获取当前时间Timestr = ' Date +%y%m%d '#mysql command#MYSQL = "/usr/local/mysql/bin/mysql"#MYSQLDUMP =

When inserting data into a database today, Chinese characters appear garbled in the database. There are various statements on the Internet, but for me, the ultimate solution to my problem is the following one! When creating a database, be

Install Mysql MMM On Redhat 6.3   MMM official introduction:MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication deployments (with only one

Mysql. frm. myd. myi File When I saw a program in the library management system yesterday, I found that the database files are MYI, frm, and myi files, which are not commonly used. SQL files, which have never been used before, have not been noticed