简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mysql中复制表结构的方法小结_MySQL

WBOY
Release： 2016-05-31 08:47:52
Original
1039 people have browsed it

mysql中用命令行复制表结构的方法主要有一下几种: 

1.只复制表结构到新表

CREATE TABLE 新表 SELECT * FROM 旧表 WHERE 1=2
Copy after login

或者

CREATE TABLE 新表 LIKE 旧表
Copy after login

2.复制表结构及数据到新表 

CREATE TABLE 新表 SELECT * FROM 旧表
Copy after login

3.复制旧表的数据到新表(假设两个表结构一样) 

INSERT INTO 新表 SELECT * FROM 旧表
Copy after login

4.复制旧表的数据到新表(假设两个表结构不一样)

INSERT INTO 新表(字段1,字段2,.......) SELECT 字段1,字段2,...... FROM 旧表
Copy after login

source：php.cn
Previous article：关于php中使用IP和localhost连接问题 Next article：《MySQL必知必会》读书笔记_2
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1479
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
1644
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1400
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1328
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1377
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！