You'll have to issue two separate queries:
"select * from table where lang=1 limit 10" and "select * from table where
lang=2 limit 10"
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 11:46 AM
To: Mysql maillist
Subject: select 10
Mysqldump will write out all the SQL needed to build the table (in plain
text form).
Connecting with the client and doing a select * from table will also "write
out the table in plain text form"
Finally doing a select into outfile (see manual for syntax details) will
also "write out the table in
included below a dump of variables.
Thanks in advance for your insight,
Brett Error
back_log: 50
basedir: C:\mysql\
binlog_cache_size: 32768
character_set: latin1
character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8
dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
