StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This topic has been covered already, in its parts.</p> <ol> <li>to import a CSV you can check this <a href="https://stackoverflow.com/questions/2978864/csv-to-mysql-conversion-and-import">question</a>, which will lead you to use:</li> </ol> <p><code>LOAD DATA INFILE yourfile.csv</code></p> <p>or if you need to update some data that is already on the database you can relate to a <a href="https://stackoverflow.com/questions/7727923/csv-to-mysql-import-script-to-match-fields/7729046#7729046">question</a> I answered not long ago (and possibly other answers on stackoverflow).</p> <p>You may execute this statement in the mysql prompt with <code>mysql -u user -p -h localhost -D database</code> (learn how to find the path to mysql.exe in your XAMMP <a href="https://stackoverflow.com/questions/698914/how-can-i-access-the-mysql-command-line-with-xampp-for-windows">using this question</a>) or using some other way, such as your scripting/programming language of choice together with mysql connectors/libraries.</p> <p>You may also use the mysqlimport.exe command (it'll be in the same folder as your mysql binary).</p> <ol start="2"> <li>To import a sql file you can take a look at <a href="https://stackoverflow.com/questions/859313/import-sql-dump-into-mysql">this question</a>. You will essentially just copy the file contents into the mysql prompt, which is usually done with input redirection on the console:</li> </ol> <p><code>C:>mysql -u user -p -h localhost -D database -o < yoursqlfile.sql</code></p> <p>I hope that besides answering your question i might also have introduced you to the fact that with thousands(?) of questions in stackoverflow you are very likely to find the answers to your doubts by searching the questions database, possibly faster than asking your own new question.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload