Re: Error 1062: Duplicate entry '127' for Key 1
an index cannot be null you should do this : insert into equipment (id,description) values ('','test data'); regards At 14:27 17/01/2002, you wrote: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: insert into equipment (id,description) values (null,'test data'); returns the error message in the subject line. I've tried the obvious stuff like deleting the record with id=127 in. The id field is auto_increment, btw. I'm sure it's something obvious... -- Gary Smith - [EMAIL PROTECTED] Web: http://www.l33t-d00d.co.uk Pics: http://photos.l33t-d00d.co.uk Webcam: http://webcam.l33t-d00d.co.uk -- Gary Smith - [EMAIL PROTECTED] Web: http://www.l33t-d00d.co.uk Pics: http://photos.l33t-d00d.co.uk Webcam: http://webcam.l33t-d00d.co.uk - 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 - 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: Problem with MySQL and SMP?
i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. HTH (sorry for the duplicated message Joshua, forgot to send to the ML) At 18:26 11/01/2002, you wrote: We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. j- k- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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: Disable case sensitivity
At 16:22 10/01/2002, you wrote: On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote: But how about the fields, the content of a database ?? VARCHAR and CHAR fields are not case-sensitive unless you declare them with the BINARY attribute. neither TEXT/LONGTEXT -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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: scheduling tasks within MySQL
unix, - man crontab wincron also exists, but you can use scheduled tasks in windows too regards At 17:19 10/01/2002, you wrote: I am not familiar with cron. Could you expound? Is it Unix or Windows based? Where can I get it? Thanks, Ron -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 7:33 PM To: Jeffrey Lomas; [EMAIL PROTECTED] Subject: Re: scheduling tasks within MySQL At 15:16 -0500 1/9/02, Jeffrey Lomas wrote: I'm fairly new to mysql. I have need for certain actions to occur within a database at a certain time every month. What is the best way to go about doing this? Is there a way to schedule these actions from within mysql? No. Use cron to schedule jobs. Thanks jeff - 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 - 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 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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: Spam
At 18:15 10/01/2002, you wrote: I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. maybe they think their filter is OK : Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... i won't be there to watch it too long... -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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: 4416 Great Growth Potential 185528
works great too (these are regexp) : subject:.*your account subject:.*free.*vacation.* subject:.*\$.* subject:.*\%\ .* subject:.*[a-z0-9]\+[\.|\ ]\{5,\}[a-z0-9]\+ subject:.*\ \-[a-z0-9]\+$ subject:.*\(.*\@.*\) this one would have caught by subject:.*[a-z0-9]\+[\.|\ ]\{5,\}[a-z0-9]\+ regards At 18:25 10/01/2002, you wrote: A good spam-blocking keyword is the word guarantee. Just block out messages with that keyword and most of your spam issues will go away. I've used that technique for a couple years now, and it's worked great. I've had to add a couple other words to my filter to pick up on adult material as well, but for the most part, guarantee catches all that other crap. - Jonathan -Original Message- From: Billy Harvey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 7:27 PM To: mysql Subject: Re: 4416 Great Growth Potential 185528 On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote: OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! Dear MySQL list, I'm afraid I've had it. I don't post often here - but I probably help on average one person a day by working directly with them in the background. I considered it payback for the value I got from others over the years. But, I can't stand the quantity of spam here. The list needs to be made subscriber only, or I suspect the only people that will be left here soon will be the company and the spammers. Good luck to all. Someone let me know if the policy changes. Thanks for a great product. Billy - 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 - 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 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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
order by count
Hi i've a particular select to do... here is the order i want : select *,count(*) as counted from database group by field_to_count order by counted this query works but only returns one record per field_to_count (normal behaviour) i would want to get all the records (so, group by doesn't affect the record set), but keep this order... sort of order by count(field_to_count grouped) is this possible ? thanks PS : i'm using mysql 3.23 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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