`
sunwch
  • 浏览: 165650 次
  • 性别: Icon_minigender_1
  • 来自: free-town
社区版块
存档分类
最新评论

mysql delete syntax

MySQLJava 
阅读更多 
Single-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

Multiple-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]
Or:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    FROM tbl_name[.*] [, tbl_name[.*]] ...
    USING table_references
    [WHERE where_condition]
分享到：
| mysql grant revoke
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    Devart dbForge Studio for MySQL Professional Edition v7.1.13

    Code navigation, obtaining quick object information, and syntax check are performed instantly. More on SQL coding Database Compare and Sync When modifying MySQL database structure, transferring...

    MySQL and JSON A Practical Programming Guide 2018

    Throughout, real-world examples and sample code guide you through the syntax and application of each method. You will get in-depth coverage of programming with the MySQL Document Store. •See how...

    MySQL自动备份

    /bin/bash##this is mysql data backup sample script############################################# judge syntax,here must be one syntax at least,or else quit#if [ $# -eq 0 ];then echo "no database ...

    SQL: A BEGINNER'S GUIDE 3/E

    Paperback: 534 pages Publisher: McGraw-Hill Osborne Media; 3 edition (August 8, 2008) ...Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

    ZeosDBO

    The following compilers are supported: Delphi 5 - 7C++ Builder 5 - 6Kylix 2 - 3ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface: MySQL 3.20 ...

    飙升：SQL Optimizer和Rewriter

    支持复杂查询的多列索引优化（UPDATE，INSERT，DELETE，SELECT） 支持EXPLAIN信息丰富解读 支持SQL指纹，压缩和美化 支持同一张表多条ALTER请求合并 支持自定义规则SQL改写 快速入门 交流与反馈 欢迎通过Github Is

    UE（官方下载）

    A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...

    sqlmap (懂的入)

    | Delete_priv | enum | | Drop_priv | enum | | Execute_priv | enum | | File_priv | enum | | Grant_priv | enum | | Host | char | | Index_priv | enum | | Insert_priv | enum | | Lock_tables_priv |...

    Delphi7.1 Update

    Index Open Tools API (IOTA)=d7iota.hlp Save the d7.ohi file and delete any hidden *.GID files in your Delphi7/Help folder before restarting the Help. This modification reduces the number of index ...

    Doctrine ORM for PHP.pdf

    Table of Contents Introduction....................................................................................................13 Code Examples.........................................................

Magicbox
Global site tag (gtag.js) - Google Analytics