Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
L
L
lolo_to2021-02-28 17:41:53
MySQL
lolo_to, 2021-02-28 17:41:53

How to substitute NULL in the id field when exporting a table?

How in phpmyadmin, when exporting a table, in the latter, replace all id fields with NULL?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
R
Ruslan Fedoseev, 2021-02-28
@martin74ua

export with a query like
select null, then_list_of_fields_except_id from tablename

Similar questions
T
tessariman2016-06-14 15:28:48
How to implement shooting from the object's camera with subsequent saving of these pictures in a separate folder? 2Reply
A
Anton2021-03-27 12:39:53
Getting the selected radio item and passing it to the email body, how to display the selected item? 2Reply
M
maks2807952015-12-30 08:20:29
How to translate PHP date format to MySql, PGSql format? 2Reply
V
Valery Khizhevsky2018-05-10 12:20:59
How to round up time to a smaller value? 2Reply
N
nikolau2018-05-10 12:55:38
Do I need to add index if there is already unique? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question