zoran Posted November 5, 2009 Share Posted November 5, 2009 I am using wamp and I would like to check the structure of mysql tables with cmd, i.e. to see if they have unique index in a column and the sql command that was used to create the table etc. I am having intermittent problems with my tables. Values are sometimes inserted and updated and are not other times without apparent reason. and the code looks ok. so I need to check everything regarding table structure. I can not see all that in phpmyadmin because it is not all visible. Link to comment https://forums.phpfreaks.com/topic/180418-how-to-check-mysql-tables-using-cmd/ Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 Cllick on WampServer icon in Windows tray, select MySQL > MySQL Console. Link to comment https://forums.phpfreaks.com/topic/180418-how-to-check-mysql-tables-using-cmd/#findComment-951835 Share on other sites More sharing options...
zoran Posted November 5, 2009 Author Share Posted November 5, 2009 thanks, what should I type to get info on structure of tables in my databases. I would like to also get an sql command that has created the table, e.g. create table customers, primary key ID (int) 25, if that can be found in the mysql console. ect. Link to comment https://forums.phpfreaks.com/topic/180418-how-to-check-mysql-tables-using-cmd/#findComment-951860 Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 http://dev.mysql.com/doc/refman/5.0/en/show.html Link to comment https://forums.phpfreaks.com/topic/180418-how-to-check-mysql-tables-using-cmd/#findComment-951884 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.