php - mysql table field problem

I have a question. I have a table A and a table B. Table A is the main table and is used to store primary information. Table B is an additional table and is used to store secondary information. How can I add one of the fields of table B to the field? Copy the values ​​to the main table?

过去多啦不再A梦 2017-05-16 13:00:36 0  3  451

Given two tables risk_events (risk event table) and event_define (risk definition table)

Question: Given two tables risk_events (risk event table) and event_define (risk definition table). The table data is as follows: 1. risk_events field description: Event_code: event code Num: number of events Time: time when the event occurred 2. event_define field description: Code: event code Name...

A .配角 2021-05-12 11:32:14 0  0  964

How to get parent_id name of category table from post table

I have the following table in the "Category" table. id name parent_id1 student empty 2 teacher empty 3 math student 14 science student 1 I have the following table in the "Release" table. Post.php file in id name category_id1 Ajay 32 Mohan 3 model publicfunctioncategory(){return$...

P粉936568533 2023-09-12 22:21:06 0  2  657

mysql - database multi-table joint query inserting into other libraries

The table is almost the same as below Library A table 1 content {code...} Table 2 area {code...} Table 3 category {code...} Library B table z listid add catg title contents username z table and 1 table one How can I complete the table in library b correspondingly?

为情所困 2017-05-24 11:34:39 0  1  878

Implement table effect in web front-end page, this table is editable

A table is used on the page to display city defense data, but this table is editable. The content in the cells can be copied, pasted, and cut. The operation can also be undone and returned. Finally, the table can be frozen. Has anyone done this? Please give me some advice.

鸢尾花 2018-05-07 15:08:24 0  1  2587

About querying the picture of another table corresponding to the product table id based on the product table id

Teacher, based on the product table id, query the picture corresponding to the product table id in another table. Is there any other way to achieve this? Give me some ideas. I think all the methods are written in the public folder. If you re-assign another field in the volist loop, it doesn't seem t...

靖哥哥 2019-05-29 11:47:49 0  2  1397

How to use laravel multi-table query?

USER table, field id, nameACCOUNT table, field, id, name, account ORDER table, field, id, uid, aid, content There are 3 tables. How to use related query in laravel to query the order in the order table through the user id in the user table Detailed information, and then query acc through the aid in ...

phpcn_u1582 2017-05-16 16:47:53 0  1  576

Table height problem

Website data statistics table, why should the last row be higher?

三叶草 2018-12-19 19:18:27 0  1  1454

About the table table, download it as word from the web page

How to download table into word and set style

cxw 2018-08-30 15:48:47 0  1  1742

php - mysql connected table statistical query

Activity table rehearse id (self-incrementing id), name (activity name), send_time (start time), uid (user ID that created the activity)...statistics table status id (self-incrementing id), mtype (activity type 1, 2, 3 ; 1 represents the activity in the table rehearse), sid (source id, id of the act...

天蓬老师 2017-06-24 09:41:26 0  1  1269

php - mysql query to sort one table based on the number of fields in another table

Now there is a novel information table A (just summary information of the novel). The chapter information of the novel will be placed in the table B with the novel id%100 (for example, the novel id of table A is 1245, then its chapter data will be placed in Chapter_45 In this table, the novel inform...

滿天的星座 2017-05-16 12:58:36 0  2  546

How to write the code to update the relationship table?

The user table ID of table A can be related to the uid of table B. The problem now is that table A can be updated. The mon of table B is automatically added data, but the data of table A is not. Now once it is updated, all the data of table B will be updated. The values ​​of the MON field have all b...

An 2019-11-23 22:24:14 0  0  803

php - How should the title table and points rule table be designed?

For example, the first-level title ['Skilled Craftsman'] needs to reach the merit value XX, and the second-level title ['Skilled Worker'] needs to reach the merit value XX... After the fifth level, each time you advance to one level, you need 5 times the merit of the previous level [rules] Table] Ho...

迷茫 2017-05-19 10:07:32 0  1  771

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 user information, addresses, total prices, etc. The specific product information is stored in the DETAIL store, but now it is divided into two orders to be completed by different merchants. , h...

过去多啦不再A梦 2017-05-25 15:08:21 0  2  2363

Hello, export your data table there

Hello, export your data table there

享受人生 2017-07-12 10:43:37 0  2  1172

How to avoid pagination within table rows

I want to avoid pagination within table rows via wkhtmltopdf when converting HTML to PDF. I used page-break-inside:avoid with table and it worked, but not when there are many rows. If the display is set to block or other methods, the format of the table will be changed and double borders will be ins...

P粉529245050 2023-08-20 20:24:22 0  2  765

I want to insert the user_Id from one table into the parent_id of another table, but there are no common values ​​between the two tables.

I currently have three tables: users table, parent table and created_at table. Data is inserted at registration time. The users table contains user_id (primary key), user_fName, user_lName, user_Uid, email, user_Pwd and dateTime columns. The parent table contains mFname, mLname, mEmail, mPhone, fFna...

P粉323224129 2023-07-30 13:35:25 0  1  457

java - GreenDao creates association table problem.

1. greendao creates an association table. The above picture is the table creation method. The following is the error message. How to deal with this problem?

PHP中文网 2017-05-16 13:34:57 0  1  885

mysql - How to implement multi-table association query?

{Code...} The above are three tables in the database, related through UserID. Table A is a user login information table with LogID as the primary key; Table B stores user active status, and Table C stores user geographical location information. Now I want to get the cumulative sum of the number of o...

巴扎黑 2017-07-04 13:44:12 0  1  1180

php - mysql multi-table query

There are two tables, briefly describe them. Table 1: Relationship table between courses and students rsid cid1 ｜ 11 ｜ 2 The student with student number 1 chose the courses with cid 1 and 2. Table 2: The specific timetable of the course dcid day start end 1 ｜ 2 ｜ 14 ｜ 16 2 ｜ 2 ｜ 13 ｜ 15 Course cid.....

滿天的星座 2017-05-25 15:08:10 0  3  820