INSERT INTO
表名(字段一,字段二, 字段三) SELECT 字段一, 字段二,字段三 FROM 表名
WHERE
条件
--------------------------------------------------------------------------
例:
Field Type Null Key Default Extra
id int(11) unsigned NO PRI NULL auto_increment
name varchar(50) NO NULL
pass varchar(50) NO NULL
INSERT INTO
users(name,pass) SELECT users.name, users.pass
FROM
users
WHERE
users.id =1
修改某字段值
INSERT INTO
表名(字段一,字段二, 字段三) SELECT 值, 字段二,字段三 FROM 表名
WHERE
条件
例:
INSERT INTO
orderdetails(orderid,drawingid,number,carnumber,remark ) SELECT 100 , drawingid,number,carnumber,remark
FROM
orderdetails
WHERE
orderid = 92
分享到:
相关推荐
mysql-connector-net-0.1.0.msi mysql-connector-net-6.3.6.msi mysql-connector-net-6.3.7.msi mysql-connector-net-6.3.8.msi mysql-connector-net-6.3.9.msi mysql-connector-net-6.4.0.msi mysql-connector-...
开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin...
mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-...
mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community...
amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gzamoeba-mysql-binary-2.2.0.tar.gz amoeba-mysql-binary-2.2.0.tar.gz ...
JavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector...
java连接mysql数据库的驱动,里边包含两个版本:5.1.47、8.0.28 也可从以下两个地址免费下载: ...3. https://cdn.mysql.com//archives/mysql-connector-java-5.1/mysql-connector-java-5.1.47.zip
赠送jar包:mysql-binlog-connector-java-0.21.0.jar; 赠送原API文档:mysql-binlog-connector-java-0.21.0-javadoc.jar; 赠送源代码:mysql-binlog-connector-java-0.21.0-sources.jar; 赠送Maven依赖信息文件:...
mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 ...
包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-...
mysql-connector-net-6.8.3.msi mysql-connector-net-6.9.9.msi mysql-for-visualstudio-1.2.6.msi mysql-for-visualstudio-1.2.7.msi
mysql-connector-java-5.0.5.jar mysql-connector-java-5.1.6.jar mysql-connector-java-5.1.18.jar mysql-connector-java-5.1.21.jar mysql-connector-java-5.1.35.jar mysql-connector-java-5.1.39.jar mysql-...
centos 下hive连接mysql驱动 ,mysql-connector-java-8.0.26-1.el7....4.按你的实际需求,将此mysql-connector-java.jar文件复制到你需要的地方,一班是在大数据组件的conf目录,比如hive是/usr/software/hive312/lib/
mysql-connector-net-6.9.9.msi mysql-connector-net-6.10.7.msi mysql-for-visualstudio-1.2.8.msi Win64OpenSSL-1_1_0i.exe
mysql-8.0.20下载,此为mysql-8.0.20 压缩安装包(文件全称:mysql-8.0.20-el7-x86_64.tar.gz)
mysql-connector-java mysql-connector-java-5.1.5 mysql-connector-java-5.1.40
开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 mysql-5.5.40-win32开发工具 ...
mysql-community-client(x86-64) >= 5.7.9 被 mysql-community-server-5.7.18-1.el7.x86_64 需要 mysql-community-common(x86-64) = 5.7.18-1.el7 被 mysql-community-server-5.7.18-1.el7.x86_64 需要 有人说...
mysql-connector-net-6.10.8.msi + mysql-for-visualstudio-1.2.8.msi ef 连接mysql 工具类
mysql-connector-java-5.1.40.zip和mysql-connector-java-5.1.10.jar