Creating a table from a query in MySQL/PHP

Question

I'm not sure this is possible, but the code I tried using first is:

mysql_query ("CREATE TABLE My_table as ( SELECT * FROM CPE LEFT JOIN Greenwich_j20 ON CPE.cust_index = Greenwich_j20.cust_index LEFT JOIN Liverpool_j20 ON CPE.cust_index = Liverpool_j20.cust_index)")
 or die ("this certainly didn't work\n");

The query itself works fine, and the syntax for the table works fine, but the combination is what it really doesn't like. Does it have a problem creating a table from a left join query?

Hi Tomalak, I don't seem to get any error, just the "this certainly didn't work" when it dies — Soop
– Soop, Commented Apr 13, 2011 at 8:37

Shakti Singh · Accepted Answer · 2011-04-12 16:35:27Z

2

If there is any auto increment column in your existing tables that will be not remain auto_increment in the table to be created.

You could try by selecting columns instead of * there should be an error of column Ambiguous.

edited Apr 12, 2011 at 16:35

answered Apr 12, 2011 at 16:30

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Lightness Races in Orbit Over a year ago

Should this have been a comment?

Shakti Singh Over a year ago

@Tomalak: I think should not you should give some reaction time.

Lightness Races in Orbit Over a year ago

@Shakti: Huh? I can't understand what you said. If you're implying that I should have waited for you to complete compiling your answer, then my response is that perhaps you shouldn't post your answer until it is an answer. It's not a race.

Shakti Singh Over a year ago

@Tomalak: That was not. I mean to say At the first sight what I thought I posted but another sight I take one another thing I posted that as well. I am not taking it like race. By the way in real life everything is race.

Lightness Races in Orbit Over a year ago

@Shakti: Sorry, I can't understand you. I think it's a language barrier between us.

|

Collectives™ on Stack Overflow

Creating a table from a query in MySQL/PHP

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related