Talk:Delete (SQL)

From Wikipedia, the free encyclopedia
Jump to: navigation, search
WikiProject Computing (Rated Start-class)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Databases / Computer science  (Rated Start-class, Mid-importance)
WikiProject icon This article is within the scope of WikiProject Databases, a collaborative effort to improve the coverage of database related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 Mid  This article has been rated as Mid-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computer science (marked as Mid-importance).
 

Difference[edit]

difference between truncate ane delete The preceding unsigned comment was added by 202.63.114.20 (talk • contribs) .

Truncate is not a SQL statement (just a proprietary extension of some DBMS) --Stolze 14:33, 15 February 2007 (UTC)

Merge[edit]

Recommend merging UPDATE, INSERT, DELETE, MERGE and SELECT statements into DML article and redirecting these statements there. Comments? SqlPac 05:19, 17 May 2007 (UTC)

These articles appear to be specific to SQL, not DML generally. 64.236.208.25 14:36, 20 July 2007 (UTC)

POLICY DEBATE: Use of source code and other examples in articles[edit]

Someone started a policy debate concerning the use of source code in articles, that seems to directly impact this (and possibly other Database articles). See below for details:

I have opened a debate on the use of source code and other examples in Wikipedia articles. It seems that many pieces of example source code etc. currently in Wikipedia violate Wikipedia policy, so we need to either clarify or change the situation. Depending on the result of the discussion, this may result in a number of source code examples being summarily removed from computing articles!

Please reply there, not here, if you wish to contribute.—greenrd 10:50, 18 May 2007 (UTC)

Thanks.SqlPac 15:08, 18 May 2007 (UTC)

Multiple-table syntax[edit]

Should Multiple-table syntax be included or it is not SQL standard? http://dev.mysql.com/doc/refman/5.1/en/delete.html —Preceding unsigned comment added by 195.235.227.10 (talk) 16:39, 15 April 2010 (UTC)

It seems to be a standard by adoption at least, I was disappointed not to find an example like:

delete [alias]

 from [table] [alias]
   inner join [table] [alias] on [table].[field] = [table].[field]  — Preceding unsigned comment added by 65.51.190.48 (talk) 12:37, 11 September 2013 (UTC)