Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
LemonWiki共筆
Search
Search
Appearance
Log in
Personal tools
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
Database management tools
(section)
Page
Discussion
English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Special pages
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
=== 32 bit OS architecture === [https://www.toadworld.com/products/toad-for-mysql Toad for MySQL] v. 8.0.0.296 for {{Win}} * Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table<ref>[https://www.toadworld.com/products/toad-extension-for-eclipse/b/weblog/archive/2014/08/15/export-and-import-your-database-data Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World]</ref> * Export format: Export query result set as CSV, '''Excel''', HTML/XML, SQL script * Specify Field and Row Terminators: * Engine supported: MySQL * Software licenses: Proprietary * Data type of cell value: * Comments: [http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query] Free v. 3.5.6.3 (32bit) for {{Win}} * Import format: N/A * Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.<ref>[http://www.activedbsoft.com/features-querytool.html FlySpeed SQL Query - all essential tools to work with data]</ref> * Specify Field and Row Terminators: * Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite" * Software licenses: Proprietary * Data type of cell value: * Comments: [http://www.mysqlfront.de/ MySQL-Front] v. 6.0 (Build 2.20) (32bit) for {{Win}} * Import format: Import CSV, Excel file (XLS), MS Access file & ODBC data source into table * Export format: Export query result set as CSV, Excel file (XLS), XML, HTML, PDF file * Specify Field and Row Terminators: * Engine supported: MySQL * Software licenses: Proprietary * Data type of cell value: * Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit! ''$'' [https://www.sqlwave.com/ SQLWave] v. 6.12.2 (32 bit) for {{Win}} 15 days trial * Import format: N/A * Export format: Export query result set as SQL file * Specify Field and Row Terminators: * Engine supported: MySQL * Software licenses: Proprietary * Data type of cell value: * Comments: ''$'' [http://www.mydb-studio.com/ MyDB Studio] v. 1.3 (32bit) for {{Win}} 30 days trial * Import format: CSV * Export format: Export query result set as SQL file * Specify Field and Row Terminators: * Engine supported: MySQL * Software licenses: Proprietary * Data type of cell value: * Comments: {{exclaim}} I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.
Summary:
Please note that all contributions to LemonWiki共筆 are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see
LemonWiki共筆:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)