Jump to content


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


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.