mysql - What should you pay attention to when connecting large tables and small tables? Performance

Does a small table drive a big table?

From [MySQLdiscussion group] 2017-05-27 17:39:11 0  1  1002

trigger - MySQL defines a trigger to return an auto-incrementing ID

Define a trigger in MySQL to return the self-increasing id value. The code is as follows: {code...} An error o...

From [MySQLdiscussion group] 2017-05-27 17:39:10 0  1  1242

mysql - Update problem of related data table

UPDATE a,b SET a.v_publishyear = b.v_publishyear WHERE a.v_id = b.v_e I want to update the data in table a. Th...

From [MySQLdiscussion group] 2017-05-27 17:39:06 0  2  729

mysql - About database table structure design

I want to make a test system, but I am currently encountering the problem of not knowing how to design the tab...

From [MySQLdiscussion group] 2017-05-27 17:39:05 0  2  744

Problem with mysql getting time function unix_timestamp?

Use mysql to obtain the milliseconds of the current date. If the date is too large, it will not be obtained. S...

From [MySQLdiscussion group] 2017-05-27 17:39:04 0  2  855

mysql - How to generate this sql table?

As shown in the figure, to generate this SQL table, from 5 o'clock to 23 o'clock, the interval is 15 minutes. ...

From [MySQLdiscussion group] 2017-05-27 17:39:01 0  2  630

mysql optimization - the situation behind mysql update, delete and insert operations on multiple pieces of data

1.Update, delete and insert operate multiple pieces of data, adding, modifying and deleting one by one. Is thi...

From [MySQLdiscussion group] 2017-05-27 17:39:00 0  1  851

How does jdbc return automatically defined beans

{code...}

From [MySQLdiscussion group] 2017-05-27 17:38:59 0  1  597

php - In a production environment, how can we add indexes to MySQL and modify the table structure so that our online business is not affected?

In a production environment, how can we add indexes to MySQL and modify the table structure so that our online...

From [MySQLdiscussion group] 2017-05-27 17:38:57 0  1  761

php - mysql fuzzy search problem

Please tell me how to match the following keywords. For example, the database storage characters are: sfsdf4-1...

From [MySQLdiscussion group] 2017-05-27 17:38:56 0  6  816

mysql - Use PHPEXCEL to import 5000+ items of data from an excel file into the database. The local database is normal, but only 15 items are imported online. No errors are reported. What is the problem?

Use PHPEXCEL to import 5000+ items of data from the excel file into the database. The local database is normal...

From [MySQLdiscussion group] 2017-05-27 17:38:55 0  2  1041

php - The third-party payment platform notifies multiple times asynchronously in a short period of time, and the order is confirmed and collected multiple times.

The third-party payment asynchronous notification notifies the callback address multiple times. The previous n...

From [MySQLdiscussion group] 2017-05-25 15:08:25 0  4  1049

javascript - Baidu coordinates, returns the coordinates near the target

Now there is a table recording user coordinates (using Baidu API), with two field records, such as coordinates...

From [MySQLdiscussion group] 2017-05-25 15:08:24 0  1  925

Back-end development - How to write sql statements for mysql statistics by time segment?

My database table structure is as follows: The fields are ID, NUM1, NUM2, TIME1, TIME2, MONEY. I want to count...

From [MySQLdiscussion group] 2017-05-25 15:08:22 0  3  1050

php - Taobao order splitting table design

Our mall currently uses two tables, the ORDER table and the ORDER_DETAIL table. The ORDER table only saves use...

From [MySQLdiscussion group] 2017-05-25 15:08:21 0  2  2309