MySQL

If/case when to judge Select Case 1 if 1 then "one" while 2 then "one" and "more" END; "One" Select Case when 1>0 and "true" ELSE "false" END; "true" Select Case BINARY "B" when "a" N 1 when the "B" then 2 END; and NULL (1) Case VALUE

10.29 to 10.31th new registered user orders over $600 gift coupon in October#3天内订单满600元且10月注册的用户订单明细SELECTA. City, a. User id,b. User name, date (b. Registration time) asRegistration date, B. User address, B. Contact number, A. Salesperson, A. Order

such as the next two table update statementsUPDATE hzxm201610 a,xmhzylb1201610 b SET a.gk07_1_6=b.gk04_11,a.gk07_2_6=b.f06_1,a.gk07_3_6=b.f07_1,a.gk07_4_6= B.f08_1 where substring (a.gk01,1,4) in (' 5323 ') and a.gk01=b.gk01 and dqdm= ' 532300 'What

Some simple searches can be implemented by MySQL's own full-text index and MATCH against query statement. The experimental steps are as follows.1. Build a tableDROP table IF exists con_video_file_des_test;CREATE TABLE ' con_video_file_des_test ' ('

/*Create a table*/CREATE TABLEtb_test (IDint( One) unsigned not NULLAuto_increment COMMENT'self-increment primary key', namevarchar( -) not NULL DEFAULT "'COMMENT'name',user_id int( One) unsigned not NULL DEFAULT '0'COMMENT'User ID', Update_timeint(

--MYSQL Gets the current node and recursively all ancestor nodes--parameter description: Resultfield: Query return field, IDD to query the resource ID value, idfieldname ID field name, parentidfieldname ancestor ID field name, TableName table name,

[Mysqld]Port= 3306Socket=/tmp/mysql.sockDatadir=/data/mysql/dataServer-id= 1Skip-name-resolveExpire_logs_days=15Log-bin=mysql-binBinlog_format=mixedReplicate-do-db=allin_platformReplicate-do-db=allin_platform_logSlow_query_log = OnLong_query_time = 2

1. Learn from http://blog.chinaunix.net/uid-7374279-id-4255927.htmlField name blob with four types of Tinyblob (255B), blob (65k), Mediumblob (16M), Longblob (4G)Example:CREATE TABLE Test (ID int Auto_increment primary KEY,Photo blob);2. Read the

SummaryFirst, MySQL ReplicationIntroducing the basic concept of MySQL replication, from the MySQL websiteSecond, Replication Configuration2.1 Basic Steps in Configuration　　　　　　First, MySQL Replication1. What is Replicaiton?For the purposes of this

1. Create a function firstBEGINDECLARE stemp VARCHAR (4000);DECLARE stempchd VARCHAR (4000);SET stemp = ' $ ';SET stempchd = cast (PID as Char);While stempchd are not NULL doesSET stemp = CONCAT (stemp, ', ', stempchd);SELECT Group_concat (cmnt_id)

Database Links:Mysql-uroot-p Mysql-h10.0.0.100-ustaging-pn3ktxgShow Databases INSERT into ' user ' (Select id+3333504, ' user_name ', ' password ',' Birthday ', ' mobile ', ' email ', ' province ', ' City ', ' region ', ' create_at ', ' update_at ','

Reference: http://blog.chinaunix.net/uid-23215128-id-2951624.html1. Log in as root account2.grant all privileges in discuz.* to [e-mail protected] ' 10.110.1.100 ' identified by ' 123456 ';All privileges means giving all permissions to the specified

In MySQL, sometimes the columns that need to be indexed are very long, and if you apply the index directly it can cause problems with indexing too large. So we can take some of the fields to do the indexing, for example:Add index: ALTER TABLE * Add

1. Standard process for working with MySQLImportPymysqlconn= Pymysql.connect (host ="127.0.0.1", port = 3306,user ="Root", passwd ="*******", db ="Homework", CharSet ="UTF8") Cursor=conn.cursor () R= Cursor.execute ("Show Tables") Conn.commit ()

Truncate Table NameDeleting all the data in the table directly, unlike Delete, this method cannot use the where selection and can only be deleted.TRUNCATE table users;Java Connection database:Package Com.edu.gkh;Import java.sql.Connection;Import

Note: Multi-table queries and connection queries (left JOIN, etc.) function Similarly, without much difference.Create DATABASE Test charset UTF8 collate utf8_bin;Use test;CREATE TABLE Tb_chengji (Xuesheng varchar () NOT NULL default ' primary

Show data table structure1, DESC (describe) tablename;2, show columns from TableName;3, use INFORMATION_SCHEMA;SELECT * from columns where table_name= ' tablename ';4, show create TABLE tabelname;Modify character encoding1, ALTER DATABASE mydb

Detailed steps for accessing a database using php mysql: accessing data using mysql Steps for accessing the mysql database using php The official saying is that mysql_query () has been discarded since 5.5. Of course, you can read the manual for a

Mysql implements a simple example of two data columns in the exchange table and two mysql Columns Because of the recent project, there is a need to swap the two columns of data in the database. It takes a long time to complete the problem. Here we

Calculate the nearest store based on the longitude and latitude, and calculate the distance from the store. Currently, services need to display the Service Outlet information closest to the coordinate point on the map. Premise: the positioning