Jump to content


Photo

field properties on create table


  • Please log in to reply
No replies to this topic

#1 Fission

Fission
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 28 January 2003 - 11:03 PM

I have a user interface to create tables, but when I pull info out of the database to display on the web I don\'t want all the fields in the table displayed. I need someway to pull \"visible\" fields out of a table. So far my program builds this query:

CREATE TABLE testtest (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,feild1 varchar (13),feild2 date,field3 float,field4 int,field5 text,field6 char (14),fulltext(feild1, field5));

Is there some way to create an index of fields at the end of the query like:
visible(field1, field2, field4)

if so, what is the proper syntax, and if not then is there another, better way?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users