Ask a Question related to PHP Development, Design and Development.
-
Jeremy #1
Build MySQL table with a query
Hello,
I am looking for a function that will build a mysql table with the
results of a query.
If you could help that would be great,
Thanks,
Jeremy Ross
Jeremy Guest
-
Deletion based on the result of a 3 table right joins select query (MySQL 3.23)
I am using MySQL 3.23 I have a relatively complex database with a number of Many to Many relationships (using link tables). I want to delete... -
Dynamic Table Build Using DataRowView
All I'm trying to build a table dynamically from a DataView using IEnumerator. It will be read only data for printing on Avery 5160 label... -
insert mysql query into a history table... ?
hi guys, i have created a 'history' table and would like to insert the 'bare' sql query into that table just to check who did what on the... -
Query build
I am having trouble with structuring my query for searching using "LIKE". I return no records with my current SQL statement. Any suggestions would... -
Result of Mysql Query in a PHP table
Hi, I've a problem: I want to have the result of my Mysql Query in a Table in my php file. Now I've this: <? -
Brommer #2 Re: Build MySQL table with a query
Jeremy Ross wrote:
Not sure if this is what you need, but you can do it directly in SQL:
CREATE TABLE newtable AS
SELECT * FROM oldtable;
Brommer Guest
-
Jeremy #3 Re: Build MySQL table with a query
Thank you that was just what I needed.
Brommer wrote:
>
>
> Not sure if this is what you need, but you can do it directly in SQL:
>
> CREATE TABLE newtable AS
> SELECT * FROM oldtable;[/ref]
Jeremy Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
