开发者

create table like new table individually numbered

开发者 https://www.devze.com 2023-03-22 06:09 出处:网络
I\'m new to all of this but decided to create an online system for our company but now stuck! What I\'m trying to do is copy a mysql table but each table 开发者_Python百科have a unique number when ev

I'm new to all of this but decided to create an online system for our company but now stuck!

What I'm trying to do is copy a mysql table but each table 开发者_Python百科have a unique number when ever the script is ran i.e. autoquoteS1, autoquoteS2 etc.

I've searched a lot for this and this is the best I can find.

mysql_select_db("sdbdb", $con);
$sql = "CREATE TABLE IF NOT EXISTS autoquoteS1 LIKE autoquoteS";

Any help is very much appreciated


this sounds like a problem.

you should not be creating many many copies of the same table, instead, you should be entering many many rows into a single table. (assuming the same structure)

maybe you can post your table design, and we can help you with normalization.

edit:

you may be looking for something like this:

quote
--------
quote_id
customer_id
total
status

quote_line_item
----------------
quote_id
line_num
quantity
amount
item_id

item
--------
item_id
description
0

精彩评论

暂无评论...
验证码 换一张
取 消