newbie question create table

2005-04-01 Thread Aji Andri 
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  




__ 
Yahoo! Messenger 
Show us what our next emoticon should look like. Join the fun. 
http://www.advision.webevents.yahoo.com/emoticontest

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie question: Create table from query or export query

2002-04-15 Thread Renger van Nieuwkoop 

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
Economic Research and Policy Consultancy
Thunstrasse 22 / CH-3005 Berne (Switzerland)
Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60
mailto:[EMAIL PROTECTED]  / http://www.ecoplan.ch


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

2002-04-15 Thread Craig Ostrander 

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 existingtablename;

There are many variations on these themes, but this should get you pointed 
in the right direction.
Hope it helps.

Craig Ostrander

At 06:38 AM 4/15/2002, you wrote:
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
Economic Research and Policy Consultancy
Thunstrasse 22 / CH-3005 Berne (Switzerland)
Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60
mailto:[EMAIL PROTECTED]  / http://www.ecoplan.ch


-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

===
Craig Ostrander
Blue Forest Software and Development Inc
Database Design Consultants Worldwide
MySQL  //  SAP DB // Oracle //  Microsoft  SQL Server  // Microsoft Access
Need help now?  [EMAIL PROTECTED] or +1 530 326 5680
===

spam filter:
sql,query



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php