hehe, ok
i would write a script that reads the existing data from the table and
inserts it into a new one that has the same structure PLUS a primary key
something like:
original_table:name, description, whatever
new_table:id, name, description, whatever
where id is primary key and
Hi.
I don't know cPanel, but I expect it can run SQL directly, most panels
can. Use the ALTER TABLE ADD {INDEX|KEY} syntax to add indexes/primary
keys. You can use multiple columns, which together form a unique value
to create your primary key.
Niel
--
PHP Database Mailing List
Hello...
I'm the kind of PHP guy that people is scared of... i am Too curious :D.
So lately at the company i've been working for like 6 months, they are going
to migrate a OLAP program, to vb.net, since i think php could do a better
work... since it can be expanded... well i was looking for
Chris Carter wrote:
Hi,
I have a database, which was till now, not having any primary key defined. I
thought I would not need it but now I think I do (based on the suggestions
from my prior postings). I am now trying to insert the primary key in an
already existing database. There was not even
Christopher Blöcker wrote:
hehe, ok
i would write a script that reads the existing data from the table and
inserts it into a new one that has the same structure PLUS a primary key
something like:
original_table:name, description, whatever
new_table:id, name, description, whatever