Re: Is query possible? (Newbie)

archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with count(*)

select count(distinct(user)) from results; Cheers, Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ Sometime recently Daniel Rossi said: > what ever happend to a unique primary key like userID ? > > >>> &

Re: datetime column dummy question

gt; 2 rows in set (0.02 sec) > > mysql> select version(); > ++ > | version() | > ++ > | 4.0.13-log | > ++ > 1 row in set (0.00 sec) > > > -- > If you cc me or remove the list(s) completely I'll most likely ignore > your message.see http://www.eyrie.org./~eagle/faqs/questions.html > -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: datetime column dummy question

alter table p_asset add mydate datetime default 'now()'; - you need the '' around now(); apparently http://www.mysql.com/doc/en/DATETIME.html and scroll down to the comment made by Lazy Soul on Tuesday May 27 2003, @8:15am Jan Janice Wright Ingenta plc [E

Re: mysqld question

;ve got some more specific questions, we'll be happy to help :) Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select * into outfile;mysql-delphi

MySQL won't write data to a file if the file already exists. Make sure you've deleted the old file or given MySQL a new filename to write to. Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] http://www.ingentaselect.com/ Sometime recently Rahmat Hidayat said: > hello my fri

Re: Export xml, import into filemakerpro 6.0

ilar, any > advice would be very appreciated. > Is there any particular reason you want to export as XML? Does filemaker pro 6.0 not accept a csv (comma seperated variable) file for input? J. -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.inge