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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.