Taku Posted February 13, 2013 Share Posted February 13, 2013 (edited) After using inner join and getting ur desired values.. how to enter this values to a new table? tnx for replies :B Edited February 13, 2013 by Taku Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 13, 2013 Share Posted February 13, 2013 No. Bad. Bad dog. Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Barand Posted February 13, 2013 Share Posted February 13, 2013 (edited) 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. Edited February 13, 2013 by Barand 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.