Tag: Mysql
-
How to get index column names of a table from MySQL
SELECT INDEX_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = ‘my_schema_name’ AND TABLE_NAME = ‘my_table_name’ See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names of a table from PostgreSQL How to get index column names of…
-
How to get primary key of a table from MySQL
select COLUMN_NAME,INDEX_NAME from INFORMATION_SCHEMA.STATISTICS where TABLE_SCHEMA = ‘my_schema_name’ and TABLE_NAME=’my_table_name’ and INDEX_NAME=’PRIMARY’ See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from SQLite How to get primary key of a table from SQL Server How to get primary key of a table from DB2…
-
Withdata Software Released MyLobEditor Version 2.1
Withdata software has announced mylobeditor 2.1, a tool that helps you edit MySQL lob (blob, text (clob)) data directly. Version 2.1 Add “Create sub folders by field name”. Add “turning off log” in command line. MyLobEditor – Edit MySQL LOB data directly MyLobEditor is convenient: 1. Edit LOB (BLOB, TEXT (CLOB)) data directly. 2. Easy…
-
Withdata Software Released MysqlToExcel Version 2.0
Withdata software has announced mysqltoexcel 2.0, a data conversion tool that export MySQL data to excel. Version 2.0 Add “turning off log” in command line. Add “SSH tunnel connect” to MySQL. Withdata MysqlToExcel – Tool for exporting Mysql data to Excel Withdata MysqlToExcel is convenient: 1. Easy visually config, just click on the mouse. 2.…
-
Withdata Software Released MyToTxt Version 2.3
Withdata software has announced mytotxt 2.3, a data conversion tool that export MySQL data to flat file (csv, tsv, xml, html, sql) and excel. Version 2.3 Add “turning off log” in command line. Add an option for “replace CRLF with space”. Add “SSH tunnel connect” to MySQL. MyToTxt – The better tool to export Mysql…
-
Withdata Software Released XlsToMy Version 2.2
Withdata software has announced xlstomy 2.2, a data conversion tool that import Excel data to MySQL database. Version 2.2 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command line” Add “SSH tunnel connect” to MySQL. XlsToMy – Better tool to…
-
Withdata Software Released TxtToMy Version 2.2
Withdata software has announced txttomy 2.2, a data conversion tool that import txt (csv, tsv) data to MySQL database. Version 2.2 Add “Bad File” to log failed import records. Add “Exception Report From”. Add “SSH tunnel connect” to MySQL. Improve import performance. TxtToMy – Better tool to import TXT (CSV, TSV) data to MySQL TxtToMy…
-
Withdata Software Released SqliteToMysql Version 1.0
Withdata software has announced sqlitetomysql 1.0, a data conversion tool that convert SQLite data to MySQL database. Version 1.0 is the first release. SqliteToMysql – Convert SQLite data to MySQL SqliteToMysql is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving and loading session parameters, let you…
-
Withdata Software Released PostgresToMysql Version 1.0
Withdata software has announced postgrestomysql 1.0, a data conversion tool that convert PostgreSQL data to MySQL database. Version 1.0 is the first release. PostgresToMysql – Convert PostgreSQL data to MySQL PostgresToMysql is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving and loading session parameters, let you…
-
Withdata Software Released MysqlToSqlite Version 1.0
Withdata software has announced mysqltosqlite 1.0, a data conversion tool that convert MySQL data to SQLite database. Version 1.0 is the first release. MysqlToSqlite – Convert MySQL data to SQLite MysqlToSqlite is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving and loading session parameters, let you…