MySQL Error#: 2002

at to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com "Everything will be alright in the end, so if it is not alright, it is not yet the end." - Quote from movie: The Best Exotic Marigold Hotel -- MySQL General Mailin

Re: List archive?

On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) see

List archive?

I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL Gener

Re: Not to show until a certain date

On 9/28/10 8:33 PM, Chris W wrote: SELECT * FROM announcements WHERE announcements_expiredate > CURDATE() AND announcements_postdate <= CURDATE() ORDER BY announcements_expiredate ASC Thank you! -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list ar

Re: Not to show until a certain date

On 9/28/10 10:52 AM, Patrice Olivier-Wilson wrote: Hi... beginner here. Working on a php page and using this $query_announcements = "SELECT * FROM announcements WHERE announcements.announcements_expiredate >CURDATE() ORDER BY announcements_expiredate ASC "; Client now wants the

Not to show until a certain date

e. I have an announcements_postdate in the table. Just not sure what the WHERE should be to not show until that date. Thanks much, -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: newbie question database tables

Thanks all... I got this to work! Much appreciated.. And thanks for patience with a newbie! -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: newbie question database tables

On 9/10/10 12:31 PM, Jerry Schwartz wrote: Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Thank you! -- Patrice Olivier-Wilson http://biz-comm.com

newbie question database tables

, but then I couldn't expand later. Reverse is true if I add user_ID to the Topics. So, need an idea how to solve this so it doesn't matter how many new users I keep adding, I can still see who is using the topics. As I said, a newbie question. Thanks much. -- Patrice Olivier-Wi

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: Gave it a try got this: MySQL said: #1062 - Duplicate entry '1' for key 1 Yeah, that's what I was saying about in my previous mail. It looks like you've got a primary key on one of your columns, and you're attempting to

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: I have data I need to keep in both db just trying to merge. There's two ways around this: First is to not export the structure (uncheck structure). The second is to export with "if not exists". This should (IIRC) do a creat

Re: Importing table contents

Gary Smith wrote: Patrice Olivier-Wilson wrote: I have 2 databases, different domains. Both have a table named 'tips'... both have different contents in the table. Using phpMyAdmin for GUI. I want to export databaseA tips as sql (done) then import content into databaseB tips. But

Importing table contents

there is already a table named tips in databaseB. Yep, know that... I want to bring in the contents...not make a new table. Any help, most appreciated Thanks as always -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists

Re: inserting csv - solved, but more to the puzzle

s use CRLF (chr(13)chr(10)). andy Patrice Olivier-Wilson wrote: In case anyone might find this of the least interest, probably not, but I always hope to add to discussion just as part of the thank you for help. Further work with same issues found that a file received from a PC based client, if o

inserting csv - solved, but more to the puzzle

ust a thought. If anyone has any insight, most appreciated. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

insertng csv - solved

ed to import and it stopped at line 17 (again). BUT progress! So, went back to the converter and entered into SQL on phpmyadmn interface... viola! success. Thank you both so much for your help. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list arc

Inserting csv

, '', '', '', '', '', '', '', '' ); MySQL said: #1054 - Unknown column '20' in 'field list' Actually the first time, it was column 21, so to trouble shoot, I removed that column from cs

csv import issues - good solution found

table) -- viola! :-) Just thought I'd share in case anyone else might need it... -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Newbie question: importing cvs settings - followup

wrong.) posted by . February 14, 2007 ) -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Newbie question: importing cvs settings

d patience. (above represents an empty portfolio_ID, a filled in sort_ID, title, empty bodycopy, image, empty before) Thank you. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: Newbie question: importing cvs settings

Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? Patrice Olivier-Wilson wrote: Yep, typo ...:-( I

Re: Newbie question: importing cvs settings

Telephone +44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message----- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: 26 September 2009 17:08 To: mysql Subject: Newbie question: importing cvs settings Greetings: I have a project for which need to import cvs file

Newbie question: importing cvs settings

iated. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

unicode and C API

ble to get in MYSQL_ROW an unicode string after performing a select for example using : swprintf(w_out, _T("%s\n"), row[1]); ? If not is MySQL 5.x will allow this ? when ? Thanks in advance Patrice Serrand

Primary key question

Hi, Does MySQL automatically create index on primary key ? If not how can I create an index on a primary key ? Thanks for any help. Patrice Serrand - Before posting, please check: http://www.mysql.com/manual.php (the

bug report with functions

parser does not like this space... The same problem occurs with all the functions. Thanks, Patrice Khawam. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ ---

2008 Mysql client run out of memory !?!

Hello, I use PHP 4.0.6 with mySQL 3.23.40 and I have the error 2008 (client run out of memory) performing this query : select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f, items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id = i2f.item_id and f.id =

improving indexes

hi, I have pretty bad performance on the following query. Could someone help me to define the indexes I need on the tables to improve this. Thanks in advance. select a.field_1,a.date,b.field_1,b.field_2,sum(a.subtotal) as total from table_a as a, table_b as b group by b.field_2,a.field_1 ha

Re: SV: [PHP-DB] Empty error ? (HELP ME)

PhpMyAdmin writes : 3.23.40-log Why -log, don't know ?... Le jeu, 09 aoû 2001, vous avez écrit : > What version of Mysql is it? > > > -Opprinnelig melding- > > Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]] > > Sendt: 9. august 2001 19:45 > > Til:

Re: Table too large?

Normally the size can be 2G, 4G or more... You can check the maximum table size for a table with the myisamchk -dv table_name or table_file if It doesn't work. You should have run myisamchk or mysqlcheck (whick worked better for me) to check your table. Le jeu, 09 aoû 2001, vous avez écrit : > H

Re: 2008 : MySQL client run out of memory

Hello, I tried with unbuffered queries and It doesn't solve the problem at all I have an weird error performing "select id from categories where name = 'Hifi'". The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is unbuffer

Re: 2008 : MySQL client run out of memory

nough memory to store the whole result. But as I said the query works with phpMyAdmin and is performed several times in the script with free_results() after each performing. Patrice Le jeu, 09 aoû 2001, vous avez écrit : > If it is a memory problem, try for example > > ini_set("

2008 : MySQL client run out of memory

t's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

1030 : Got error 134 from table handler ?

! Can you explain me the reason of that error ? Thank you, Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre