Question 321901 in Mysql Question posted in
The official MySQL documentation can be found here.

phpMyAdmin MySQL CSV importing – get a warning if value is not in structure

When importing a CSV file into a MySQL database through phpMyAdmin, is there a way to get a warning if a value is not listed in the "values" list of a ENUM or SET field in the table’s structure?

Right now, the value is dropped without a notification.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    It took me hours of trying various things, but I finally found the bizarre way that phpMyAdmin does warnings while importing csv data:

    • For tables with up to 49 rows, phpMyAdmin reports warnings when data are truncated
    • For tables with more rows, it does not

    So, to see the warnings, I have to import the data piecemeal in chunks of 49 rows.


  2. 0

    some time mysql not support CSV.
    So for data types then your need. SQL file import because sql file in sql data command

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search