Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

The devil finds work for idle glands.


devel / comp.databases.mysql / another load data infile issue

SubjectAuthor
o another load data infile issueDFS

1
another load data infile issue

<57SSI.4$Qp7.3@fx46.iad>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=28&group=comp.databases.mysql#28

 copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!aioe.org!feeder1.feed.usenet.farm!feed.usenet.farm!newsfeed.xs4all.nl!newsfeed9.news.xs4all.nl!news-out.netnews.com!news.alt.net!fdc3.netnews.com!peer02.ams1!peer.ams1.xlned.com!news.xlned.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!fx46.iad.POSTED!not-for-mail
Newsgroups: comp.databases.mysql
X-Mozilla-News-Host: news://usnews.blocknews.net:119
From: nos...@dfs.com (DFS)
Subject: another load data infile issue
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.13.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Lines: 13
Message-ID: <57SSI.4$Qp7.3@fx46.iad>
X-Complaints-To: abuse@blocknews.net
NNTP-Posting-Date: Tue, 17 Aug 2021 17:13:37 UTC
Organization: blocknews - www.blocknews.net
Date: Tue, 17 Aug 2021 13:13:36 -0400
X-Received-Bytes: 1189
 by: DFS - Tue, 17 Aug 2021 17:13 UTC

MariaDB allows NULLs in a FK field, but 'load data infile' insists on
NOT NULL

load data infile:
"ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`db`.`table`, CONSTRAINT `ibfk_1` FOREIGN KEY
(`fkcol`) REFERENCES `parenttable` (`parentcolumn`))

MariaDB [db]> insert into tbl values (999999,'test',null);
Query OK, 1 row affected (0.161 sec)

(the third column is the FK column)

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor