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 ... Read more
Tag Archives: Mysql
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 ... Read more
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 ... Read more
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 ... Read more
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 ... Read more
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” ... Read more
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 ... Read more
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 ... Read more
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 ... Read more
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 ... Read more