Shulou(Shulou.com)06/01 Report--

The following brings you about the operation of the sql sentence under MySQL. I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I believe you will gain something after reading the relevant operations of the sql sentence under MySQL.

1. Insert several fields from Table T2 into table T1:

Insert into T1 (t1.c1, … , t1.c5) select t2.c1,... , t2.c5 from t2

Time function in 2.MySQL:

Curdate () 2017-04-13

Now () 2017-04-13 09:09:09

3. Replace:

The name of the update table set the field name to be replaced by this table = REPLACE (the field name to be replaced by this table, 'original content', 'new content')

4. Intercept the string:

SUBSTR (field name, the nth bit starts to be intercepted, and the m bit is intercepted)

5. Delete:

Delete the record in the table: delete from table tablename where condition.

Delete table: drop table tablename

6. Positioning:

LOCATE (string, field name)-- locates the position of the string in the data

7. Look for data with the same field 1 and different field 2 in tables 1 and 2.

SELECT T1 * FROM person_lnfo T1 JOIN person_lnfo T2 ON t1.houseid=t2.houseid AND t1.unitidt2.unitid

For the above operation on the sql statement under MySQL, do you think it is what you want? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.