newbie question create table

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 ? Thx before the guide, Aji

Re: Newbie question: Create table from query or export query

Yes. Assuming you are comfortable using the mysql client program you could use: CREATE TABLE newtablename SELECT * FROM existingtablename; In addition, if you have an existing table and need to load data from a text file you could use: LOAD DATA INFILE 'textfilename.txt' INTO TABLE existingt

Newbie question: Create table from query or export query

Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger _ ECOPLAN Forschung und Beratung in Wirtschaft und Politik Econom