thinkPHP的JOIN中表名要不要加前缀,该怎么解决
thinkPHP的JOIN中表名要不要加前缀
如果表名是think_work
那么在JOIN里改怎样写
是
$Model->join('RIGHT JOIN work ON artist.id = work.artist_id')->select();
还是
$Model->join('RIGHT JOIN think_work ON think_artist.id = work.artist_id')->select(
手册上没有写
两种方法试了貌似都不成功
哎，，，怎么tp的问题这么多呢 把我折磨了一天了 各种各样的问题
------解决方案--------------------
'RIGHT JOIN think_work ON think_artist.id = think_work.artist_id'
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use JOIN in MySql
Jun 04, 2023 am 08:02 AM
The meaning of JOIN is just like the English word "join". It joins two tables and can be roughly divided into inner join, outer join, right join, left join and natural join. First create two tables, the following is used as an example CREATETABLEt_blog(idINTPRIMARYKEYAUTO_INCREMENT,titleVARCHAR(50),typeIdINT);SELECT*FROMt_blog;+----+------+--------+| id|title|typeId|+----+-------+--------+|1|aaa|1||2|bbb|2||3|ccc|3|
What is the usage principle of MySQL Join?
May 26, 2023 am 10:07 AM
Join type leftjoin uses the left table as the driving table and the left table as the basis of the result set. The data from the right table is connected to the result set. rightjoin uses the right table as the driving table and the right table as the basis of the result set to connect the left table. The data is added to the result set innerjoin. The result set takes the intersection of the two tables fulljoin. The result set takes the union of the two tables. MySQL does not have a fulljoin. The difference between union and unionall is that union will deduplicate the crossjoin Cartesian product. If the where condition is not used, the result set will be the product and of the two associated table rows. The difference is that when crossjoin creates the result set, it will be passed according to the on condition.
What are mysql's join query and multiple query methods?
Jun 02, 2023 pm 04:29 PM
Compared with join query and multiple queries, which one is more efficient, MySQL multi-table related query or multiple single-table query? When the amount of data is not large enough, there is no problem using join, but it is usually done on the service layer. First: the computing resources of a stand-alone database are very expensive, and the database needs to serve both writing and reading at the same time, which requires CPU consumption. In order to make the database The throughput becomes higher, and the business does not care about the delay gap of hundreds of microseconds to milliseconds. The business will put more calculations into the service layer. After all, computing resources can be easily expanded horizontally, and databases are difficult, so most The business will put pure computing operations into the service layer, and use the database as a kv system with transaction capabilities. This is a heavy business.
How to use JOIN in MySQL
Jun 03, 2023 am 09:30 AM
Introduction A's unique + AB's public B's unique + AB's public AB's public A's unique B's unique A's unique + B's unique + AB's public A's unique + B's unique Practice creating table department tables DROPTABLEIFEXISTS`dept`;CREATETABLE`dept`(`dept_id`int(11)NOTNULLAUTO_INCREMENT,`dept_name`varchar(30)DEFAULTNULL,`dept_number`int(11)DEFAULTNULL,PRIMARYKEY(`dept_id`))ENGINE =InnoDBAUT
Use MySQL's JOIN function to join tables
Jul 26, 2023 am 08:37 AM
Use MySQL's JOIN function to join tables. In MySQL, JOIN is a very common operation that allows us to join two or more tables based on the associated fields between them. This makes it easy to query and obtain relevant data from multiple tables, improving query efficiency and flexibility. This article will use code examples to demonstrate how to use MySQL's JOIN function to join tables. First create two sample tables: students and scores. The students table contains students
Interpretation of CSS positioning properties: position and top/left/right/bottom
Oct 21, 2023 am 09:58 AM
Interpretation of CSS positioning properties: position and top/left/right/bottom In front-end development, CSS positioning properties are very important. With the positioning attribute, we can control the position of the element on the page. The most commonly used positioning attribute is position, whose values can be static, relative, absolute, and fixed. In addition to these basic positioning attributes, we can also use top, left, r
How to optimize the join statement in MySQL
Jun 03, 2023 am 09:31 AM
SimpleNested-LoopJoin Let's take a look at how mysql works when performing join operations. What are the common join methods? As shown in the figure, when we perform a connection operation, the table on the left is the driving table, and the table on the right is the driven table. SimpleNested-LoopJoin This connection operation is to take a record from the driving table and then match the records of the driven table one by one. If the condition If there is a match, the result is returned. Then the next record in the driver table is taken for matching until all the data in the driver table is matched. Because it is time-consuming to retrieve data from the driver table each time, MySQL does not use this algorithm to perform the connection operation BlockNested-LoopJ
How to improve performance through JOIN optimization in MySQL
May 11, 2023 am 08:48 AM
In most web applications, database operations are the most basic and important part. As the most commonly used relational database management system at present, MySQL hosts countless websites and applications and is also facing increasing pressure on large-scale data processing and query access. In this context, performance optimization has become an important part of MySQL database management, and JOIN operation is a key point. JOIN connection is one of the most commonly used data query statements in MySQL. exist
