删除两个表中的数据 如何删除不了
删除两个表中的数据 怎么删除不了
SELECT * FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body='' 是有数据出来的
我写了下面的两条语句 都不行。 该怎么改的呢？
delete FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body=''
delete from (SELECT * FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body='')
------解决方案--------------------
- SQL code
DELETE `liao_addonarticle`,`liao_archives` FROM `liao_addonarticle` LEFT JOIN `liao_archives` ON liao_addonarticle.aid=liao_archives.id WHERE liao_addonarticle.body='' <div class="clear">
</div>
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
A Practical Guide to the Where Method in Laravel Collections
Mar 10, 2024 pm 04:36 PM
Practical Guide to Where Method in Laravel Collections During the development of the Laravel framework, collections are a very useful data structure that provide rich methods to manipulate data. Among them, the Where method is a commonly used filtering method that can filter elements in a collection based on specified conditions. This article will introduce the use of the Where method in Laravel collections and demonstrate its usage through specific code examples. 1. Basic usage of Where method
How to use the Where method in Laravel collections
Mar 10, 2024 pm 10:21 PM
How to use the Where method in Laravel collection Laravel is a popular PHP framework that provides a wealth of functions and tools to facilitate developers to quickly build applications. Among them, Collection is a very practical and powerful data structure in Laravel. Developers can use collections to perform various operations on data, such as filtering, mapping, sorting, etc. In collections, the Where method is a commonly used method for filtering the collection based on specified conditions.
From beginner to proficient: Master the skills of using is and where selectors
Sep 08, 2023 am 09:15 AM
From beginner to proficient: Master the skills of using is and where selectors Introduction: In the process of data processing and analysis, the selector is a very important tool. Through selectors, we can extract the required data from the data set according to specific conditions. This article will introduce the usage skills of is and where selectors to help readers quickly master the powerful functions of these two selectors. 1. Use of the is selector The is selector is a basic selector that allows us to select the data set based on given conditions.
You can't specify target table 'table_name' for update in FROM clause - How to solve MySQL error: Unable to update target table in FROM clause
Oct 05, 2023 am 10:25 AM
Hello, the following is an article within 1500 words, titled: Youcan'tspecifytargettable'table_name'forupdateinFROMclause-How to solve the MySQL error: Unable to update the target table in the FROM clause, specific code examples are needed. During the development of MySQL database, we sometimes encounter the following error message: Youcan'tspecify
The basic usage of mysql left join and the difference between on and where
Jun 02, 2023 pm 11:54 PM
Preface When we write SQL statements, we cannot avoid using connection keywords, such as inner connections and outer connections. There are many types. I will post here a picture I found elsewhere: I think this picture is very detailed. It shows the common link types in SQL statements. Take leftjoin in this article as an example. It is available online. As defined: the LEFTJOIN keyword will return all rows from the left table, even if there are no matching rows in the right table. In fact, literally speaking, leftjoin is relatively easy to understand, but there are still some problems during use. For example, if the condition is after on and after where, their results are completely different. Let's go from shallow to deep
Usage analysis of Where method in Laravel collection
Mar 09, 2024 pm 06:51 PM
Laravel is a popular PHP development framework that provides rich and convenient functions. Collection is one of the very important data structures in Laravel. The collection class provides many powerful methods, one of which is the where method. This article will use specific code examples to analyze the usage of the where method in Laravel collections. 1. Create a collection First, we need to create a collection that contains some data. Can
Detailed explanation of Where method of Laravel collection
Mar 10, 2024 pm 01:33 PM
Laravel is a popular PHP framework, and its Collections class provides powerful data processing functions. Among them, the Where method is one of the commonly used methods in collection classes, used to filter data that meets conditions. This article will introduce the Where method of Laravel collection in detail, including usage methods, parameter meanings, and specific code examples. 1. Overview of the Where method The Where method is used to filter elements in the collection that meet specified conditions and return a
How to use the WHERE clause in SQL to specify selection criteria
Jun 03, 2023 pm 04:31 PM
SQLWHERE clause The WHERE clause is used to specify the selection criteria. To conditionally select data from a table, add a WHERE clause to the SELECT statement. The syntax is as follows: SELECT column name FROM table name WHERE column operator value The following operators can be used in the WHERE clause: =: equal to: not equal to >: greater than =: greater than or equal to 1965
