MySQL Forums
Forum List  »  MySQL Workbench

Re: I want Null not 0
Posted by: Peter Brawley
Date: April 17, 2022 05:00PM

Let's see a line of data with "blanks" in it in the .csv file you're inputting, the result of Show Create Table for the table you're importing to, and the Load Data Infile command you're using.



Edited 1 time(s). Last edit at 04/18/2022 11:41AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
535
April 17, 2022 03:51PM
Re: I want Null not 0
266
April 17, 2022 05:00PM
287
April 18, 2022 12:56AM
292
April 18, 2022 12:12PM
280
April 18, 2022 03:32PM
251
April 18, 2022 04:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.