Withdata software has announced mysqltomssql 1.2, a data conversion tool that convert MySQL data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToMsSql – convert Mysql data to ... Read more
Tag Archives: Mysql
Withdata Software Released MysqlToDB2 Version 1.2
Withdata software has announced mysqltodb2 1.2, a data conversion tool that convert MySQL data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToDB2 – convert Mysql data to ... Read more
Withdata Software Released MysqlToAccess Version 2.1
Withdata software has announced mysqltoaccess 2.1, a data conversion tool that export MySQL data to access. MysqlToAccess 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToAccess – Better tool for export MySQL ... Read more
Withdata Software Released MsSqlToMysql Version 1.2
Withdata software has announced mssqltomysql 1.2, a data conversion tool that convert SQL Server data to MySQL database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToMysql – Convert SQL Server data ... Read more
Withdata Software Released DB2ToMysql Version 1.2
Withdata software has announced db2tomysql 1.2, a data conversion tool that convert DB2 data to MySQL database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToMysql – Convert DB2 data to ... Read more
Withdata Software Released AccessToMysql Version 2.1
Withdata software has announced accesstomysql 2.1, a data conversion tool that import Access data to mysql. AccessToMysql 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToMysql – Better tool for importing ... Read more
Remove duplicate rows in MySQL
The primary key: id, the unique columns: col_1, col_2, col_3 . You can use a temporary table, like: create temporary table temp_table (id int); insert temp_table (id) select id from your_table t1 where exists ( select * from your_table t2 ... Read more
How to get column names from Mysql table
We can use information_schema.columns for getting column information SELECT column_name FROM information_schema.columns WHERE table_schema = ‘My_Schema_Name’ AND table_name = ‘My_Table_Name’ See also: How to get column names from Sql Server table How to get column names ... Read more
Edit Mysql LOB data
MyLobEditor is a database tool that can edit Mysql LOB data directly. Use MyLobEditor, you can edit Mysql LOB visually. And you can save LOB data to file and edit also. Easy to use Edit LOB (LOB, CLOB) data directly. Edit multiple formats LOB data(text, RTF, image, hex, html, ... Read more