csv

From CSV to MySQL in less than 20 seconds. How to create a new MySQL table ( populated and with automatic data type detection), from CSV source file in less than 20 seconds. Prerequisites: Web browser. MySQL database. Link MySQL database management tool. e.g. PhpMyAdmin CSV file with data. You can find a small sample file here. ( csv_with_headers.csv ) Steps to follow: Open file2sql ( http://file2sql.com ) url in web browser. Select CSV file type to convert and data file. Select desired options. Click on “Convert File” button. Click on “Copy to clipboard” button. Open your database management tool url. e.g.PhpMyAdmin ( http://localhost/phpmyadmin ) Select ( or create ) database… Read More