Jump to content

Archived

This topic is now archived and is closed to further replies.

Fission

field properties on create table

Recommended Posts

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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.