Re: MySQL export to csv

Oh it's easy. Select database, export, select table, select csv, check save as file, go. I'm using an older version but I'd bet it hasn't changed much. You'll figure it out. D. Eric Chadbourne My play site: http://www.NewMAG.org/ **

Re: Max size and row numbers

Olaf, That's a very broad question depending upon your exact requirements to be honest. So long as you've considered file size limitations and you've opted for a decent RAID system there's not too much more to worry about, try and buy the fastest disks possible obviously i.e. 15,000 RPM one

[patch] Typo in the french translation

Hi, Here is a patch correcting a translation error: the french word for "connection" is "connexion". I dont want open a bugzilla account just for this, so i post it on this ml. This patch is a diff from the file mysql-5.1.14-beta/sql/share/errmsg.txt. Cheers, -- Vincent http://www.magicninja.or

JSP/JSTL problem

Hi I have created a table with the following specs: create table `cust` ( `ssn` int(9) NOT NULL PRIMARY KEY, `submitdate` date, `submitto` int(3), `first` varchar(30), `last` varchar(30), `loanAmt` decimal(10,2), `company` int(3),

Re: Count the number of specific rows

Servers24, Hi Philip, Thank you very much for your help. Can you please tell me the differemce between COUNT(*) and COUNT(id) ? Thanks again. Actually sorry I was a bit misleading there. MySQL is optimized to calculate... SELECT COUNT(*) FROM aTable; ...but given the fact you've got a whe

RE: MySQL export to csv

Hi Alf, "SELECT INTO OUTFILE 'file_name' [export_options] FROM yourtable" could of agreat help in your situation Regards, Mikhail Berman -Original Message- From: Alf Stockton [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 11:34 AM To: mysql@lists.mysql.com Subject: Re: MyS

Re: MySQL export to csv

Dwight E Chadbourne wrote: If there's only a couple of tables you could just export to CSV per table (phpmyadmin makes this easy). Simple for the Access user to import. Great. In fact there is only one table but I cannot see where in phpmyadmin the export is done..? -- Regards, Alf Stoc

Re: Max size and row numbers

Olaf, Thanks for the detailed answer. So basically the limitations come from the OS and the file system used. What is the best file system to use for mysql (not considering the filesize limitations)? Thanks Olaf The "best" is probably ZFS if you really are intent on make things huge, http:/

Re: MySQL export to csv

If there's only a couple of tables you could just export to CSV per table (phpmyadmin makes this easy). Simple for the Access user to import. Select... into outfile... is fine. See: http://dev.mysql.com/doc/refman/5.1/en/select.html

MySQL export to csv

Can anyone tell me how to export a mysql db to a csv file suitable for my client to import into his windows access program. -- Regards, Alf Stocktonwww.stockton.co.za The abuse of greatness is when it disjoins remorse from power. -- William Shakespeare, "Julius Caesa

Re: Max size and row numbers

Thanks for the detailed answer. So basically the limitations come from the OS and the file system used. What is the best file system to use for mysql (not considering the filesize limitations)? Thanks Olaf On 12/29/06 2:25 AM, "ViSolve DB Team" <[EMAIL PROTECTED]> wrote: > Hi, > > The maxim

Re: Count the number of specific rows

>I can simply use this : >SELECT id FROM sent WHERE member_id= ... >and the use count($result) to count the number, but I want a faster way, if >possible. SELECT COUNT(id) FROM sent WHERE member_id= ... PB Servers24 Network wrote: Hi, Well this question may seem funny, but I really need to

Re: Count the number of specific rows

Servers24, Well this question may seem funny... No, a funny question would start something like "Why did the nun cross the road?". ;^) The problem is with counting a user's contribution in my site. Suppose that each user that send an email will be stored in DB. Now I want to count number of

Re: Count the number of specific rows

On Friday 29 December 2006 14:02, Servers24 Network wrote: > Hi, > > Well this question may seem funny, but I really need to know! > The problem is with counting a user's contribution in my site. Suppose that > each user that send an email will be stored in DB. Now I want to count > number of times

Count the number of specific rows

Hi, Well this question may seem funny, but I really need to know! The problem is with counting a user's contribution in my site. Suppose that each user that send an email will be stored in DB. Now I want to count number of times that a user has sent an email. I can simply use this : SELECT id FRO

Re: SQL syntax

Hi Scott, all, Scott Yamahata wrote: Hi, I'm getting the following error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' enabled = '1'' at line 3INSERT INTO clf_cities SET cityname = 'Santa Barba

mysqlbinlog problem

Hello, I have hab problem with mysqlbinlog. I'm testing point in time recovery. The Server Version of MySQL is 5.0.22. Statement: ./mysqlbinlog --stop-date="2006-12-29 08:40:00" | mysql -u -p The error: ERROR at line 12: Unknown command '\C'. By piping the output in a file line 12 looks like