FierceBlade Posted February 4, 2007 Share Posted February 4, 2007 Okay I'm using phpMyAdmin and you know when you create a table it shows the information such as $sql = "CREATE TABLE etc.. ( etc.. etc.. )"; I want to find that again but this is since it's created I want to view it now. Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/ Share on other sites More sharing options...
shoz Posted February 4, 2007 Share Posted February 4, 2007 Okay I'm using phpMyAdmin and you know when you create a table it shows the information such as $sql = "CREATE TABLE etc.. ( etc.. etc.. )"; I want to find that again but this is since it's created I want to view it now. SHOW CREATE TABLE tablename Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/#findComment-176451 Share on other sites More sharing options...
FierceBlade Posted February 4, 2007 Author Share Posted February 4, 2007 Sorry if I wasn't clear, but I mean I want the sql information shown in phpMyAdmin. I'm creating an automatic board creator where the users create their own board and I'm trying to make it write new tables down but anyway I'm trying to make it create them and It'll take forever to write out all the table information, is there any way to find the information of the tables and show them in phpMyAdmin like when you first create a table it shows you the query. Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/#findComment-176454 Share on other sites More sharing options...
shoz Posted February 4, 2007 Share Posted February 4, 2007 Sorry if I wasn't clear, but I mean I want the sql information shown in phpMyAdmin. I'm creating an automatic board creator where the users create their own board and I'm trying to make it write new tables down but anyway I'm trying to make it create them and It'll take forever to write out all the table information, is there any way to find the information of the tables and show them in phpMyAdmin like when you first create a table it shows you the query. I'm not very familiar with phpMyadmin's interface so I don't know of a specific option to do that. The query I posted should have shown the information for you to copy and paste however, but I may still not fully understand what you're looking for. Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/#findComment-176463 Share on other sites More sharing options...
artacus Posted February 4, 2007 Share Posted February 4, 2007 I think what you want to do is go to export if you only choose table structure, you'll have the sql to re-create the table. Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/#findComment-176543 Share on other sites More sharing options...
worldworld Posted February 4, 2007 Share Posted February 4, 2007 Please export the data onto a text file and see the CREATE table code out there... Quote Link to comment https://forums.phpfreaks.com/topic/36969-finding-the-query-of-mysql/#findComment-176921 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.