Taku Posted February 13, 2013 Share Posted February 13, 2013 After using inner join and getting ur desired values.. how to enter this values to a new table? tnx for replies :B Link to comment https://forums.phpfreaks.com/topic/274451-question/ Share on other sites More sharing options...
Jessica Posted February 13, 2013 Share Posted February 13, 2013 Do you need to create the new table right then, or does it already exist? You could use INSERT INTO tlb [your join here] http://dev.mysql.com/doc/refman/5.5/en/insert-select.html Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412282 Share on other sites More sharing options...
Taku Posted February 13, 2013 Author Share Posted February 13, 2013 ohh tnx so much :3.. I will read it and yea I need to create the table... btw is creating a table name using date possible? Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412283 Share on other sites More sharing options...
shlumph Posted February 13, 2013 Share Posted February 13, 2013 Are you using MySQL? You can probably do it all in a single statement. INSERT INTO table (colA, colB) SELECT ... http://dev.mysql.com/doc/refman/5.1/en/insert-select.html Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412284 Share on other sites More sharing options...
Jessica Posted February 13, 2013 Share Posted February 13, 2013 If you're going to have a bunch of tables for a bunch of dates, that is a bad idea. Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412285 Share on other sites More sharing options...
shlumph Posted February 13, 2013 Share Posted February 13, 2013 btw is creating a table name using date possible? Assuming you're using MySQL- yes, it is. But you need the ticks ` when creating and referencing the name. So it's kind of discouraged. Reason being, is date is a keyword in MySQL. Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412286 Share on other sites More sharing options...
Taku Posted February 13, 2013 Author Share Posted February 13, 2013 Are you using MySQL? You can probably do it all in a single statement. INSERT INTO table (colA, colB) SELECT ... I see tnx for this :3 If you're going to have a bunch of tables for a bunch of dates, that is a bad idea. I see... if I will not use date.. what is a good way to make a new table for each day? :B what I want to do is... it will create a new table everyday Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412287 Share on other sites More sharing options...
Jessica Posted February 13, 2013 Share Posted February 13, 2013 No. Bad. Bad dog. Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412289 Share on other sites More sharing options...
Taku Posted February 13, 2013 Author Share Posted February 13, 2013 guess I will think of a way and post here if it is right xDD Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412293 Share on other sites More sharing options...
Jessica Posted February 13, 2013 Share Posted February 13, 2013 You should not be creating a new table every day. What are you trying to do? Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412294 Share on other sites More sharing options...
shlumph Posted February 13, 2013 Share Posted February 13, 2013 I see... if I will not use date.. what is a good way to make a new table for each day? :B what I want to do is... it will create a new table everyday That's what rows in a table are for. I had originally thought you were asking if you could create a table named date. Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412295 Share on other sites More sharing options...
Barand Posted February 13, 2013 Share Posted February 13, 2013 what is a good way to make a new table for each day? There is no good way to create a table foreach date You create one table and put the date in the records. Link to comment https://forums.phpfreaks.com/topic/274451-question/#findComment-1412340 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.