MySQL SELECT all but Primary key column?

[Mermogoat]

Is there a way to SELECT all data from all columns, and exclude the entire primary key column? I have searched the documentation, but cannot find anything. Thanks

 

[r937]

no

 

[obadare]

select <field1>,<field2> from tablename;
you need to explicitly specify the columns leaving out the primary key field

 

[Mermogoat]

Well, I'm making a generic insert_row function for my web application, and I'm dynamically creating the fields to enter data, however, I don't want them to enter a value for the id field since's it is an auto-increment primary key.

 

[r937]

i believe in mysql you can insert NULL into an auto_increment field and it will get the next number the same as if you had omitted it from the INSERT statement

test it first before relying on this info, eh


rudy

 

[hvass]

What about submitting an explain or desc query like this

explain unknowntable;

then read the results which are a description of all of the fileds inculding whether they are a primary key

 

[hos2]

If you use form elements that bring the values you want to insert then you can look at

thread436-681336 I have automated my inserts and update statements

 

[hos2]

and otherwise look at the

http://nl2.php.net/manual/en/function.mysql-fetch-field.php

section. perhaps you can combine that with above link and make a string of the fieldnames you want exept the primary key

 

[tshot]

u can insert implicit NULL i.e if table tst2 has 2 cols no (integer, primry, Auto_increment) and
form (integer)then

insert into tst2 (form) values(1)

would add insert value in filed &quot;no&quot;





----------------
ur feedback is a very welcome desire