Hello.
Use something like: create table user( UserID int primary key, Password varchar (20), User_stats int); See: http://dev.mysql.com/doc/mysql/en/create-table.html Aji Andri <[EMAIL PROTECTED]> wrote: > hi seniors, > > I'm trying to create a table, here my table > properties, > > create table user ( > UserID int primary, > Password varchar (20), > User_stats int multi > ); > > i'm still confuse in User_stats properti's that is > multi, > what really use 'multi' is ? > and what the conection between primary key and index > > Thx before the guide, > > Aji > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]