mysql import data to table with constraints

Chris P. answered on December 29, 2022 Popularity 1/10 Helpfulness 1/10

answer mysql import data to table with constraints

Comment

SET FOREIGN_KEY_CHECKS = 0;
LOAD DATA INFILE '/path/to/mytable.txt' INTO TABLE mytable;
SET FOREIGN_KEY_CHECKS = 1;

Popularity 1/10 Helpfulness 1/10 Language sql

Tags: constraints import mysql sql

Link to this answer
Share Copy Link

Contributed on Dec 29 2022

Chris P.

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.