How to Import a .csv file into MySQL using SQuirreL

mysql squirrel-sql
kratika gupta picture kratika gupta · Oct 7, 2014 · Viewed 17.1k times · Source

I m using SQuirreL SQL and I want to import a .csv file into MySQL. Please tell how to do that.

Answer

sqlab picture sqlab · Oct 7, 2014

According importing-data-from-a-file-like-csv you should right-click on the table, where you want to import into, and in the context menu you should see a menu-item called "Import file", where you choose your csv-file.

With F1 -> Help -> Data Import Plugin you should get some help about that.

Related questions

Cannot connect to MySQL db using SQuirreL

I have trouble connecting to MySQL using the client Squirrel SQL. I managed to connect to Oracle and Derby previously, but this time, I do not know what I am doing wrong. I have installed MySQL on my Mac, following …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More