Csv Import mysql

mysql imports a csv,csv format that is the character set of the utf8, table and utf8,. After importing, everything in select from an on the terminal is empty, but on phpmyadmin using select from a, there is data. If select * from a where name = "xx", it cannot be found as empty set.

Apr.05,2021

use the program to import, php python and write a script

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3886e-2c106.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3886e-2c106.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?