Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 导入数据，以前数据不见了，怎么处理

导入数据，以前数据不见了，怎么处理

WBOY
Release： 2016-06-13 13:49:39
Original
1404 people have browsed it

导入数据，以前数据不见了，怎么办
一个表的数据 因一些原因 以ID

1-20000分成一个SQL文本
以20000-40000分成一个SQL文本


现在我不管怎么导入，，都只能得到最后一次导入的数据。

我想要的效果是
数据表里的ID以
1-40000的记录

------解决方案--------------------
SQL文本里，有
DROP TABLE……
CREATE TABLE……吧？
------解决方案--------------------
你先试着分批把数据导出，看看数据有没有和错误，再把数据批量插入到数据库。这是最简单的办法。

Related labels：
create sql table
source：php.cn
Previous article： 字段中文名写在表里还是文件里？解决办法 Next article： 公认最好的SQL注入扫描工具是哪个？该怎么解决
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
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
sql groupby not working, I want to group by code_branch ->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameas...
From 2024-04-06 19:24:49
0
2
488
Record query under partial value conditions - SQL skill sharing I have a table called zipcode which has a column called code. The Code column contains the...
From 2024-04-06 16:01:26
0
1
395
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
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