replication involving now() is sketchy if the two server clocks differ.
>Description: replication involving now() is sketchy if the two server clocks differ. >How-To-Repeat: Have a replicating server with a different clock (or timezone!) than the primary server. Do an insert or update or anything involving now() and it'll get weird, since the second server may or may not have the same kind of data. Replicated data should not use now() but should instead have the value calculated by now(). >Fix: >Submitter-Id: >Originator: >Organization: tani hosokawa river styx internet > >MySQL support: email support >Synopsis: now() shouldn't be used in the replication/logs >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.31 (Official MySQL binary) >Environment: System: Linux .x.xxx 2.2.19 #4 Tue May 1 12:20:47 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -fe lide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Sep 24 2000 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19533408 Apr 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 16 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --ena ble-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i686-linux ~ -- tani hosokawa river styx internet - 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: if or statement possible?
On Fri, 18 May 2001, Kip Turk wrote:
>
> Is it possible to make this type of logical command in MySQL?
>
> if ((x == y) or (x == z)) { response1 }
> else { response2 }
>
I'll go ahead and follow up my own post, as I found a solution, using
regexp. Here's a test case I ran if anyone else is interested:
select distinct(if(substring(username,1,8) regexp 'ange(wcc|pin)-',
lcase(trim(leading concat(substring_index(username,'-',1), '-') from
username)), lcase(username))) as username from radacct where acctstarttime
between '2001-05-17' and '2001-05-18' order by username;
Basically, I wanted to see if the username started with angewcc- or
angepin- and if so, remove that portion of the string. It worked quite
well, returning 3000 rows in less than a second.
cheers,
--
===
Kip Turkphone: 915.234.5678
Systems Administrator or 800.695.9016
Killer of Spam/Writer of Code/Penguin Proponent
West Central Net fax: 915.656.0071
===
-
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
if or statement possible?
Is it possible to make this type of logical command in MySQL?
if ((x == y) or (x == z)) { response1 }
else{ response2 }
>From what I can see the sql if statement will only handle one argument on
the LHS. Can this be done, or do I need to look at multiple queries and
then combine the results externally?
--
===
Kip Turkphone: 915.234.5678
Systems Administrator or 800.695.9016
Killer of Spam/Writer of Code/Penguin Proponent
West Central Net fax: 915.656.0071
===
-
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: if then (SQL statement) else (SQL statement 2)
Hi, > Hi, > I'm trying to use an if then alike statement in MySQL, myabe > anyone can tell me the correct syntax if got a variable named > naam. when the content of this variables is empty the following > SQL statement should be executed: > select * from beheerder; > when naam is not empty: > select * from beheerder wherer naam like '%naam%' > Can this be done with SQL language? that looks like something that should be done in your front-end level (Perl, PHP, whatever). but actually, if you run "select * from beheerder wherer naam like '%naam%'" and naam (what you probably pass from a script) is empty, the query will produce the same results as "select * from beheerder", since "%%" will match everything. Rgds, Tfr --==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==-- - 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
if then (SQL statement) else (SQL statement 2)
Hi, I'm trying to use an if then alike statement in MySQL, myabe anyone can tell me the correct syntax if got a variable named naam. when the content of this variables is empty the following SQL statement should be executed: select * from beheerder; when naam is not empty: select * from beheerder wherer naam like '%naam%' Can this be done with SQL language? thank you, Roy
PATCH: InnoDB asserts in trx0roll.c if run out of space in 3.23.38
Hi! I noticed that in the rollback code of 3.23.38 a new bug had slipped in. If you run out of tablespace, you will get an assertion failure in trx0roll.c line 887. You can download a fixed mysql/innobase/row/row0undo.c from http://www.innobase.fi/bugfixes.html, or alternatively just delete the call to trx_undo_rec_release on line 174 of row0undo.c. I apologize for the inconvenience. Regards, Heikki Tuuri Innobase Oy http://www.innobase.fi - 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: killing mysql session if the client CGI program quits.
On 09-May-01 [EMAIL PROTECTED] wrote:
> Does anyone know how mysql behaves when a client CGI script quits? Does
> the SQL query march on through? I wondering if anyone knows of ways to
> protect against browser reloads and other forms of similar
> abuse....especially if the the sql query is expensive?
>
Under PHP, if the query is still building the temp table, the server continues
the process. When the results are returned is when the connection (or lack of)
is detected. My observation, Monty & friends should have the final word.
> BTW, I'm not allowed to use cookies to keep track of a users session.
a spinlock ?
# mkdir /tmp/nobody
# chown nobody /tmp/nobody
your.cgi :
$lockname="/tmp/nobody/$ENV{'REMOTE_ADDR'}";
mkdir($lockname,0777) || die ('already in');
do_query("blah");
rmdir($lockname);
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
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
killing mysql session if the client CGI program quits.
Does anyone know how mysql behaves when a client CGI script quits? Does the SQL query march on through? I wondering if anyone knows of ways to protect against browser reloads and other forms of similar abuseespecially if the the sql query is expensive? BTW, I'm not allowed to use cookies to keep track of a users session. Paul - 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: QS works if applied through phpMyAdmin but not from a PHP-Script
if you are not getting a valid result set back,
then the sql server is returning some type of
error.
to find the error, try this:
if($select_=mysql_query($sql,$db->CONN)) {
//query is good
//continue code
} else {
//query is bad
$err=1
$errMsg="Failed Query: $sql".mysql_errno()." : ".mysql_error();
}
//in your html
if(!$err) {
//display html stuff
} else {
printf("%s",$errMsg);
}
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 06, 2001 11:51 AM
To: [EMAIL PROTECTED]
Subject: RE: QS works if applied through phpMyAdmin but not from a
PHP-Script
Have you looked at mysql_error() ? Are you sure $select_ is a valid php
variable name?
> Oi,
>
> I cannot get my head around that.
> I got a QS that worked fine, then I edited the PHP-script, not the part
> which is now causing errors, and it does not work anymore. That
> is strange,
> if there was a mistake in my query qhy should it work on my PC but not on
> the web? Well maybe different versions of mysql and PHP but then
> it should
> not work with the phpMyAdmin neither. This toll is using exactly the same
> programs as php does, in fact phpmyAdmin uses php for its
> communication to
> mysql.
>
> $sql = "SELECT DISTINCT region_2,stadt_2 FROM inserate ORDER BY
> region_2,stadt_2 ASC";
> $select_ = mysql_query($sql,$db->CONN);
> ^^
> ^Cannot be the mistake, cause some lines before it works perfectly well.
>
> while($temp_array = mysql_fetch_object($select_,MYSQL_ASSOC))
> ^
> This is causing the following
>
> Warning: Supplied argument is not a valid MySQL result resource in...
>
> Any suggestions?
>
> Regards,
>
> Sven
-
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: QS works if applied through phpMyAdmin but not from a PHP-Script
Have you looked at mysql_error() ? Are you sure $select_ is a valid php variable name? > Oi, > > I cannot get my head around that. > I got a QS that worked fine, then I edited the PHP-script, not the part > which is now causing errors, and it does not work anymore. That > is strange, > if there was a mistake in my query qhy should it work on my PC but not on > the web? Well maybe different versions of mysql and PHP but then > it should > not work with the phpMyAdmin neither. This toll is using exactly the same > programs as php does, in fact phpmyAdmin uses php for its > communication to > mysql. > > $sql = "SELECT DISTINCT region_2,stadt_2 FROM inserate ORDER BY > region_2,stadt_2 ASC"; > $select_ = mysql_query($sql,$db->CONN); > ^^ > ^Cannot be the mistake, cause some lines before it works perfectly well. > > while($temp_array = mysql_fetch_object($select_,MYSQL_ASSOC)) > ^ > This is causing the following > > Warning: Supplied argument is not a valid MySQL result resource in... > > Any suggestions? > > Regards, > > Sven - 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
QS works if applied through phpMyAdmin but not from a PHP-Script
Oi, I cannot get my head around that. I got a QS that worked fine, then I edited the PHP-script, not the part which is now causing errors, and it does not work anymore. That is strange, if there was a mistake in my query qhy should it work on my PC but not on the web? Well maybe different versions of mysql and PHP but then it should not work with the phpMyAdmin neither. This toll is using exactly the same programs as php does, in fact phpmyAdmin uses php for its communication to mysql. $sql = "SELECT DISTINCT region_2,stadt_2 FROM inserate ORDER BY region_2,stadt_2 ASC"; $select_ = mysql_query($sql,$db->CONN); ^^ ^Cannot be the mistake, cause some lines before it works perfectly well. while($temp_array = mysql_fetch_object($select_,MYSQL_ASSOC)) ^ This is causing the following Warning: Supplied argument is not a valid MySQL result resource in... Any suggestions? Regards, Sven - 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: if no var/db directory where R DB files?
Continue following the directions. After "my_install_db --user=mysql" you should be able to find them. Diego Montalvo wrote: > Hello, > > I have just installed mysql-3.23.37 in FreeBSD 4.2, I have already > ../configure - make and - make install and notice that there is no > /var/db directory, so I am wondering where the database files are? how > can I find these database files? > > Thank you, > > Diego Montalvo > > > - > 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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
if no var/db directory where R DB files?
Hello, I have just installed mysql-3.23.37 in FreeBSD 4.2, I have already ./configure - make and - make install and notice that there is no /var/db directory, so I am wondering where the database files are? how can I find these database files? Thank you, Diego Montalvo - 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: if Linux and Win2000 dual boot is possible?
johnd wrote: > > Hi, > We have Win2000 server version installed. > If we want to install Linux on the same computer, is it possible? > How to do it? > Need install Linux first then install Win2000? > We would like to compare Linux and Win2000 work with MySQL for our application >development. > Greately appreciate for your help. > > Regards, > > John Ding John: Make sure you have the bootable partitions for both drives on the primary master. Create a 2 GBytes partition on the drive, and install Win2K. Boot up from the RH CD-ROM. Using FDisk, create your / partition on /dev/hda2 (/dev/sga2 if scsi). Set up the remaining paritions on the drive for your data, and leave at least a 2 GBytes partition for your MySQL data directory under Win2k. Use an extra drive as necessary. When Linux is installed, allow it to detect the Win2K bootable partition, and make sure you have one Win2k entry and one Linux entry in your Lilo boot selection menu. Install the boot-loader to the MBR, and it should work fine. Van -- = Linux rocks!!! http://www.dedserius.com = - 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: if Linux and Win2000 dual boot is possible?
Hi I have this very set up. I use System Commander from VCommunications. Also I run Win2000 in a VMWare virtual machine under Linux. MySQL runs fine using either method At 09:57 27/04/1999 -0400, johnd wrote: >Hi, >We have Win2000 server version installed. >If we want to install Linux on the same computer, is it possible? >How to do it? >Need install Linux first then install Win2000? >We would like to compare Linux and Win2000 work with MySQL for our >application development. > Greately appreciate for your help. > >Regards, > >John Ding Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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
Re: if Linux and Win2000 dual boot is possible?
Yes it's possible and quite easy no matter which one you install first, but this is a mysql mailing list. You can find everything you need at http://www.linux.org jason - Original Message - From: "johnd" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 27, 1999 11:57 PM Subject: if Linux and Win2000 dual boot is possible? Hi, We have Win2000 server version installed. If we want to install Linux on the same computer, is it possible? How to do it? Need install Linux first then install Win2000? We would like to compare Linux and Win2000 work with MySQL for our application development. Greately appreciate for your help. Regards, John Ding - 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
if Linux and Win2000 dual boot is possible?
Hi, We have Win2000 server version installed. If we want to install Linux on the same computer, is it possible? How to do it? Need install Linux first then install Win2000? We would like to compare Linux and Win2000 work with MySQL for our application development. Greately appreciate for your help. Regards, John Ding
Re: Re: Plase Let us know if there is a Racialism for Mysql productand
Why not change the sql documentation to say: \my.ini (e.g., c:\windows\my.ini) Global options instead of: windows-system-directory\my.ini Global options It's understandable why the author might have originally thought to write it that way, but to defend it on the grounds that it isn't confusing to a native English speaker is silly: It isn't English, and it's slightly ambiguous. I thought Yusuf's explanation of why it was confusing was clear, if not the King's English. -- Pete Harlan [EMAIL PROTECTED] - 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
Ynt: Plase Let us know if there is a Racialism for Mysql product and quit
Dear René , First of all i apologize from all mysql list and all mysql team (except one :) ) I think this is a virtue that realizing when to stop and when to apologize. your product and your documentation works fine and i am not directly blaming anyone related to this product. The problem is not in documentation nor in product. well like i said in my last mail this situation is become too personal between two person. That's why i am stoping to write about this subject. you 're 100% right in your mail and again sorry for wasted time for all list members. Regards. Yusuf Incekara - Original Message - From: René Tegel <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]>; John Dean <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 11:18 AM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit > Yusuf, > > i don't understand why you are so angry and are trying to fight it out on > this list. > > 1. Loads of computer-related things are vulnerable for different > explanations. especially with software that is easily ported between > platforms, it's also easy to have a manual that is not dedicated for one > platform and thus now and then one makes mistakes in interpration. There > will be thousands of other things to discuss about, but there is never > reason to get angry > > 2. All people joining this list are volunteers. They answer just what they > think, and i never discovered somebody being not honest. Maybe somebody is > wrong, but we all make mistakes. Every sentence said is the author's > personal knowledge and/or opinion. > > 3. Nobody ever blamed you for not being native english. Only thing said was: > read carefully, and if it's not working, think twice about what's being > said. > > 4. I'd love it if all software was that well documented as mysql, and that > easy-to-use > > Last but not least: i hope you have a nice time programming and researching, > which looks like a better thing to do for me than wasting your time blaming > people for things nobody really did wrong. Let's discuss things technically, > ok? > > regards, > > rene > > - Original Message - > From: "Yusuf Incekara" <[EMAIL PROTECTED]> > To: "John Dean" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, April 19, 2001 9:49 AM > Subject: Re: Plase Let us know if there is a Racialism for Mysql product and > quit > > > > - Original Message - > > From: John Dean <[EMAIL PROTECTED]> > > To: Yusuf Incekara <[EMAIL PROTECTED]> > > Sent: Wednesday, April 18, 2001 10:39 PM > > Subject: Re: Plase Let us know if there is a Racialism for Mysql product > and > > quit > > > > > > > At 18:50 18/04/2001 +0300, you wrote: > > > >You said : > > > >Only those who don't read English too good. Being a native English > > speaker > > > >it is very clear to me. > > > > > > Correct and it is obvious to me that your English is very poor > > > > > It is your humble opinion. I don't care. > > > > > > > > > >Could you please be more open and honest? > > > > > > I could not be more open or honest than what I said above. But just in > > case > > > you don't understand I will say it again. Your English is poor > > > > > It is your humble opinion. I don't care also. > > The problem is not in reading and understanding > > in English. Problem is in your mind. > > Let me try to explain. Question is about being open and honest. > > That means if you have an opinion you can easily defend this opinion in > > everywhere. > > And have to tell this in every platform as your opinion. > > If theese opinions are rude so you are rude. But this is you are. > > Act what you are and what you seems like. > > But don't try to hide them and don't act in different platform in > different > > ways. > > > > > >It is obviously seen that i can easily read and write in English. > > > > > > Only you think so > > > > > > >But if you disturbed that one Turk found your bug please let me know > > > >and quit . > > > > > > Personally I could not care less from which country you come from > > > > > > >Let all your customers become from Mansfield, England, UK. > > > > > > Look what you said above. That sentence does not make sense. What do you > > > mean, "Let all your customers become from Mansfield " You are not > e
Re: Plase Let us know if there is a Racialism for Mysql product and quit
Yusuf, i don't understand why you are so angry and are trying to fight it out on this list. 1. Loads of computer-related things are vulnerable for different explanations. especially with software that is easily ported between platforms, it's also easy to have a manual that is not dedicated for one platform and thus now and then one makes mistakes in interpration. There will be thousands of other things to discuss about, but there is never reason to get angry 2. All people joining this list are volunteers. They answer just what they think, and i never discovered somebody being not honest. Maybe somebody is wrong, but we all make mistakes. Every sentence said is the author's personal knowledge and/or opinion. 3. Nobody ever blamed you for not being native english. Only thing said was: read carefully, and if it's not working, think twice about what's being said. 4. I'd love it if all software was that well documented as mysql, and that easy-to-use Last but not least: i hope you have a nice time programming and researching, which looks like a better thing to do for me than wasting your time blaming people for things nobody really did wrong. Let's discuss things technically, ok? regards, rene - Original Message - From: "Yusuf Incekara" <[EMAIL PROTECTED]> To: "John Dean" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 9:49 AM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit > - Original Message - > From: John Dean <[EMAIL PROTECTED]> > To: Yusuf Incekara <[EMAIL PROTECTED]> > Sent: Wednesday, April 18, 2001 10:39 PM > Subject: Re: Plase Let us know if there is a Racialism for Mysql product and > quit > > > > At 18:50 18/04/2001 +0300, you wrote: > > >You said : > > >Only those who don't read English too good. Being a native English > speaker > > >it is very clear to me. > > > > Correct and it is obvious to me that your English is very poor > > > It is your humble opinion. I don't care. > > > > > > >Could you please be more open and honest? > > > > I could not be more open or honest than what I said above. But just in > case > > you don't understand I will say it again. Your English is poor > > > It is your humble opinion. I don't care also. > The problem is not in reading and understanding > in English. Problem is in your mind. > Let me try to explain. Question is about being open and honest. > That means if you have an opinion you can easily defend this opinion in > everywhere. > And have to tell this in every platform as your opinion. > If theese opinions are rude so you are rude. But this is you are. > Act what you are and what you seems like. > But don't try to hide them and don't act in different platform in different > ways. > > > >It is obviously seen that i can easily read and write in English. > > > > Only you think so > > > > >But if you disturbed that one Turk found your bug please let me know > > >and quit . > > > > Personally I could not care less from which country you come from > > > > >Let all your customers become from Mansfield, England, UK. > > > > Look what you said above. That sentence does not make sense. What do you > > mean, "Let all your customers become from Mansfield " You are not even > > a customer you are just an upset user who can not take the truth > > Well the truth is situation is not about my English or not about me to pay > license fee. > The problem is about you are harding to accept you fault. > So i solved my problem. And just don't want others users to have same > problem. > That's all. > > > > > > > >I am not insisting that my English is perfect. But be sure that > > >it is not necessary that being a native English speaker. > > > > > >I said that no matter but you are looking for a trouble ... > > > > Only you say that because you must have some kind of persecution complex > or > > inferiority complex > > Well it must be a complex of yours and i think it can be named > insufficient understanding complex , harding to accepting you fault complex > , > (thinking) faultless complex , individuality complex etc... > > > > > > > >If you read carefully followed instructions ( by using your perfect > native > > >English ) > > >you 'll see the differences between Windows directory and System > Directory. > > > > I am perfectly aware of the difference but it is obvious you don't what is > > meant by what is written in th
Re: Plase Let us know if there is a Racialism for Mysql product and quit
- Original Message - From: John Dean <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 10:39 PM Subject: Re: Plase Let us know if there is a Racialism for Mysql product and quit > At 18:50 18/04/2001 +0300, you wrote: > >You said : > >Only those who don't read English too good. Being a native English speaker > >it is very clear to me. > > Correct and it is obvious to me that your English is very poor > It is your humble opinion. I don't care. > > > >Could you please be more open and honest? > > I could not be more open or honest than what I said above. But just in case > you don't understand I will say it again. Your English is poor > It is your humble opinion. I don't care also. The problem is not in reading and understanding in English. Problem is in your mind. Let me try to explain. Question is about being open and honest. That means if you have an opinion you can easily defend this opinion in everywhere. And have to tell this in every platform as your opinion. If theese opinions are rude so you are rude. But this is you are. Act what you are and what you seems like. But don't try to hide them and don't act in different platform in different ways. > >It is obviously seen that i can easily read and write in English. > > Only you think so > > >But if you disturbed that one Turk found your bug please let me know > >and quit . > > Personally I could not care less from which country you come from > > >Let all your customers become from Mansfield, England, UK. > > Look what you said above. That sentence does not make sense. What do you > mean, "Let all your customers become from Mansfield " You are not even > a customer you are just an upset user who can not take the truth Well the truth is situation is not about my English or not about me to pay license fee. The problem is about you are harding to accept you fault. So i solved my problem. And just don't want others users to have same problem. That's all. > > > >I am not insisting that my English is perfect. But be sure that > >it is not necessary that being a native English speaker. > > > >I said that no matter but you are looking for a trouble ... > > Only you say that because you must have some kind of persecution complex or > inferiority complex Well it must be a complex of yours and i think it can be named insufficient understanding complex , harding to accepting you fault complex , (thinking) faultless complex , individuality complex etc... > > > >If you read carefully followed instructions ( by using your perfect native > >English ) > >you 'll see the differences between Windows directory and System Directory. > > I am perfectly aware of the difference but it is obvious you don't what is > meant by what is written in the manual. Windows-system-directory does not > equal windows\system. The give away are the hyphens i.e '-' between the > words windows, system and directory. Note it does not contain any > backslashes i.e. '\' > > well it is more obvious that Windows-system-directory is not equal Windows directory. Any Windows programmer - as well as noticed in Microsoft References- knows that Windows Directory is a c:\Win95 or c:\WinNT and System Directory or Windows System Directory is a c:\Win95\System or c:\WinNT\System32 (or c:\WinNT\System or whatever). And this situation becomes more personal. That'y why i won't reply any mail. I hope this will be the last... > >If still there is some issues that your perfect English mind can not > >understand > >please mail me. > > I have no the consult you whatever on any issue concerning Windows or the > Windows API > > > >If you say still i am native English. No one can knows better then me even > >Microsoft > >so there is nothing to say. > > I think you need to return to school since it is obvious you were not > taught manners and while you are there perhaps you improve your poor Engliah > Well i can easily understand what i read in English by using my poor English. But it is hard you to be success in your life with your poor personality. You should better go to a psychiatrist. > > >If you undertand your mistake and wanna apologize please forget it. > > This I would never do especially to somebody as bad mannered as you > > > >Regards. > > > >Yusuf Incekara > >Avukatpro Limited Sirketi > >Izmit/Turkey (sorry for not being a native English but smart) > > No you not naive English nor are you smart > Thanks god for not to be a native English (if they are all like you) and thanks also giving us a gift that does not exist on them ? (yo
Re: Plase Let us know if there is a Racialism for Mysql product and quit
At 18:50 18/04/2001 +0300, Yusuf Incekara wrote: >You said : >Only those who don't read English too good. What I meant was a clarification of your problem since English is not your native language. This has nothing to do with racism whatsoever. For you information I have lived and worked in the Arabian Gulf (Saudi Arabia, Kuwait, Dubai, Abu Dhabi, Yemen, Bahrain and Qatar), Egypt, the Congo, Thailand, Singapore and all over Europe. During this time I made many friend in these countries. So I think you are quite wrong to suggest that my comment is racist. But I stand by the fact that I believe you do not understand what is written in the manual >Being a native English speaker >it is very clear to me. > > >Could you please be more open and honest? > >It is obviously seen that i can easily read and write in English. >But if you disturbed that one Turk found your bug please let me know >and quit . Let all your customers become from Mansfield, England, UK. I am not at all disturbed as you put it and if it was a 'bug' I would be very happy that you had noticed it. But it is not a 'bug' >I am not insisting that my English is perfect. But be sure that >it is not necessary that being a native English speaker. > >I said that no matter but you are looking for a trouble ... > >If you read carefully followed instructions ( by using your perfect native >English ) >you 'll see the differences between Windows directory and System Directory. If you will not be guided then there is nothing I can do The manual states windows-system-directory not windows/system or windows/system32 or winnt/system or winnt/system32. The directory where Windows whatever version is installed. It could be windows or windows.000 or windows.001, etc >If still there is some issues that your perfect English mind can not >understand >please mail me. > >If you say still i am native English. No one can knows better then me even >Microsoft >so there is nothing to say. > >If you undertand your mistake and wanna apologize please forget it. > >Regards. > >Yusuf Incekara >Avukatpro Limited Sirketi >Izmit/Turkey (sorry for not being a native English but smart) > > > > >GetSystemDirectory > >Reference : Microsoft Web site : >http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm > >The GetSystemDirectory function retrieves the path of the system directory. >The system directory contains such files as dynamic-link libraries, drivers, >and font files. > >UINT GetSystemDirectory( > LPTSTR lpBuffer, // buffer for system directory > UINT uSize// size of directory buffer >); >Parameters >lpBuffer >[out] Pointer to the buffer to receive the null-terminated string containing >the path. This path does not end with a backslash unless the system >directory is the root directory. For example, if the system directory is >named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved >by this function is C:\WINDOWS\SYSTEM. >uSize >[in] Specifies the maximum size of the buffer, in TCHARs. This value should >be set to at least MAX_PATH. >Return Values > > > >GetWindowsDirectory > >Reference : Microsoft Web site : >http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm > > >GetWindowsDirectory >The GetWindowsDirectory function retrieves the path of the Windows >directory. The Windows directory contains such files as applications, >initialization files, and help files. > >UINT GetWindowsDirectory( > LPTSTR lpBuffer, // buffer for Windows directory > UINT uSize// size of directory buffer >); >Parameters >lpBuffer >[out] Pointer to the buffer to receive the null-terminated string containing >the path. This path does not end with a backslash unless the Windows >directory is the root directory. For example, if the Windows directory is >named WINDOWS on drive C, the path of the Windows directory retrieved by >this function is C:\WINDOWS. If the system was installed in the root >directory of drive C, the path retrieved is C:\. >uSize >[in] Specifies the maximum size, in TCHARs, of the buffer specified by the >lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient >room for the path. > > > > > >- Original Message - >From: John Dean <[EMAIL PROTECTED]> >To: Yusuf Incekara <[EMAIL PROTECTED]> >Sent: Wednesday, April 18, 2001 10:11 AM >Subject: Re: Ynt: Bug in Documentation ? > > > > At 09:29 18/04/2001 +0300, you wrote: > > >Ok . No matter for me anymore. cause i solved my problem. > > >i'm paying attention for other users not to have > > >the same problem. > > > > Only those who
Re: Plase Let us know if there is a Racialism for Mysql product and quit
lol. guess yusuf gots some point here. Obviously, for one reason or another m$ decided to place some files in the %windir%, and some in the %windir%\system32 dir. Although it never became totally clear to me what structure they had in mind (if there is any). Roughly said: %windir% is for executables, .ini files and other stuff, and %windir%\system32 for 32-bit dll's (and %windir%\system for 16 bit dll's). but hey, take a look at a random installation, and you see loads of (especially big...) companies messing up. In the end, windows doesn't care at all where .dll's , and lot of other stuff, is placed, as long as it is in the path. Although yusuf, if you know the windows api's that well, you should also know that application .ini files should be placed in the windir. with regards, rene - Original Message - From: "Yusuf Incekara" <[EMAIL PROTECTED]> To: "John Dean" <[EMAIL PROTECTED]>; "Mysql Mailing list" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 5:50 PM Subject: Plase Let us know if there is a Racialism for Mysql product and quit > You said : > Only those who don't read English too good. Being a native English speaker > it is very clear to me. > > > Could you please be more open and honest? > > It is obviously seen that i can easily read and write in English. > But if you disturbed that one Turk found your bug please let me know > and quit . Let all your customers become from Mansfield, England, UK. > > I am not insisting that my English is perfect. But be sure that > it is not necessary that being a native English speaker. > > I said that no matter but you are looking for a trouble ... > > If you read carefully followed instructions ( by using your perfect native > English ) > you 'll see the differences between Windows directory and System Directory. > > If still there is some issues that your perfect English mind can not > understand > please mail me. > > If you say still i am native English. No one can knows better then me even > Microsoft > so there is nothing to say. > > If you undertand your mistake and wanna apologize please forget it. > > Regards. > > Yusuf Incekara > Avukatpro Limited Sirketi > Izmit/Turkey (sorry for not being a native English but smart) > > > > > GetSystemDirectory > > Reference : Microsoft Web site : > http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm > > The GetSystemDirectory function retrieves the path of the system directory. > The system directory contains such files as dynamic-link libraries, drivers, > and font files. > > UINT GetSystemDirectory( > LPTSTR lpBuffer, // buffer for system directory > UINT uSize// size of directory buffer > ); > Parameters > lpBuffer > [out] Pointer to the buffer to receive the null-terminated string containing > the path. This path does not end with a backslash unless the system > directory is the root directory. For example, if the system directory is > named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved > by this function is C:\WINDOWS\SYSTEM. > uSize > [in] Specifies the maximum size of the buffer, in TCHARs. This value should > be set to at least MAX_PATH. > Return Values > > > > GetWindowsDirectory > > Reference : Microsoft Web site : > http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm > > > GetWindowsDirectory > The GetWindowsDirectory function retrieves the path of the Windows > directory. The Windows directory contains such files as applications, > initialization files, and help files. > > UINT GetWindowsDirectory( > LPTSTR lpBuffer, // buffer for Windows directory > UINT uSize// size of directory buffer > ); > Parameters > lpBuffer > [out] Pointer to the buffer to receive the null-terminated string containing > the path. This path does not end with a backslash unless the Windows > directory is the root directory. For example, if the Windows directory is > named WINDOWS on drive C, the path of the Windows directory retrieved by > this function is C:\WINDOWS. If the system was installed in the root > directory of drive C, the path retrieved is C:\. > uSize > [in] Specifies the maximum size, in TCHARs, of the buffer specified by the > lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient > room for the path. > > > > > > - Original Message - > From: John Dean <[EMAIL PROTECTED]> > To: Yusuf Incekara <[EMAIL PROTECTED]> > Sent: Wednesday, April 18, 2001 10:11 AM > Subject: Re: Ynt: Bug in Documentation ? > > > > At 09:29 18/04/2001 +0300, you wrote: > > >Ok . No matter for me anymo
Plase Let us know if there is a Racialism for Mysql product and quit
You said : Only those who don't read English too good. Being a native English speaker it is very clear to me. Could you please be more open and honest? It is obviously seen that i can easily read and write in English. But if you disturbed that one Turk found your bug please let me know and quit . Let all your customers become from Mansfield, England, UK. I am not insisting that my English is perfect. But be sure that it is not necessary that being a native English speaker. I said that no matter but you are looking for a trouble ... If you read carefully followed instructions ( by using your perfect native English ) you 'll see the differences between Windows directory and System Directory. If still there is some issues that your perfect English mind can not understand please mail me. If you say still i am native English. No one can knows better then me even Microsoft so there is nothing to say. If you undertand your mistake and wanna apologize please forget it. Regards. Yusuf Incekara Avukatpro Limited Sirketi Izmit/Turkey (sorry for not being a native English but smart) GetSystemDirectory Reference : Microsoft Web site : http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm The GetSystemDirectory function retrieves the path of the system directory. The system directory contains such files as dynamic-link libraries, drivers, and font files. UINT GetSystemDirectory( LPTSTR lpBuffer, // buffer for system directory UINT uSize// size of directory buffer ); Parameters lpBuffer [out] Pointer to the buffer to receive the null-terminated string containing the path. This path does not end with a backslash unless the system directory is the root directory. For example, if the system directory is named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved by this function is C:\WINDOWS\SYSTEM. uSize [in] Specifies the maximum size of the buffer, in TCHARs. This value should be set to at least MAX_PATH. Return Values GetWindowsDirectory Reference : Microsoft Web site : http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm GetWindowsDirectory The GetWindowsDirectory function retrieves the path of the Windows directory. The Windows directory contains such files as applications, initialization files, and help files. UINT GetWindowsDirectory( LPTSTR lpBuffer, // buffer for Windows directory UINT uSize// size of directory buffer ); Parameters lpBuffer [out] Pointer to the buffer to receive the null-terminated string containing the path. This path does not end with a backslash unless the Windows directory is the root directory. For example, if the Windows directory is named WINDOWS on drive C, the path of the Windows directory retrieved by this function is C:\WINDOWS. If the system was installed in the root directory of drive C, the path retrieved is C:\. uSize [in] Specifies the maximum size, in TCHARs, of the buffer specified by the lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient room for the path. - Original Message - From: John Dean <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 10:11 AM Subject: Re: Ynt: Bug in Documentation ? > At 09:29 18/04/2001 +0300, you wrote: > >Ok . No matter for me anymore. cause i solved my problem. > >i'm paying attention for other users not to have > >the same problem. > > Only those who don't read English too good. Being a native English speaker > it is very clear to me > > >Regards > >Yusuf Incekara > > > > > >- Original Message - > >From: John Dean <[EMAIL PROTECTED]> > >To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > >Sent: Tuesday, April 17, 2001 9:27 PM > >Subject: Re: Bug in Documentation ? > > > > > > > Hi > > > This is not a "bug" in the documentation, it is the way you have > > > interpreted what it says > > > On a Win9x/ME system the Windows-System-Directory is called x:\Windows but > > > in Windows NT and Windows 2000 it is called WinNT. If the author meant to > > > write windows(winnt)\system that is what he would have written, not > > > windows-system-directory. So I am sorry to say it is you that is wrong not > > > the documentation writer. > > > > > > At 10:00 17/04/2001 +0300, Yusuf Incekara wrote: > > > >in Mysql documents > > > >section 4.16.5 Options files > > > >it is documented as : > > > > > > > >MySQL reads default options from the following files on Windows: > > > > > > > >Filename Purpose > > > >windows-system-directory\my.ini Global options > > > >C:\my.
logging doesnt work with bdb if --with-debug
>> Description: oliver> After several sig 11 I compliled a --with-debug version and enabled oliver> debugging and logging. Mysqld crashed shortly after starting without oliver> trace (!) and then immediatly crashed again after restart. oliver> /sw/pkg/mysqldebug/3.23.36/libexec/mysqld: ready for connections oliver> mysqld got signal 11; oliver> The manual section 'Debugging a MySQL server' tells you how to use a oliver> stack trace and/or the core file to produce a readable backtrace that may oliver> help in finding out why mysqld died. oliver> 010407 20:37:48 mysqld restarted oliver> __db_assert: "( &logp->dbentry[i].dblist)->tqh_first == ( dbp)" failed: file "../.././bdb/dist/../log/log_rec.c", line 433 oliver> 010407 20:37:48 mysqld ended >> How-To-Repeat: oliver> Compile mysql with --with-debug and --with-berkeley-db, use bdb tables oliver> and run mysqld with --debug --log >> Fix: oliver> Dont do that :/ Actually, the above problem has nothing to do with debugging. The problem is that you have got something bad in the BDB log files, which BDB because of some strange reason can't resolve. Fix: Remove all filed of type 'log.xxx' from the MySQL data directory and restart MySQL. If you get this problem again, then where is what you should try to do: - Dump all BDB tables to text files. - close down mysqld - Remove all log files of the above format - Move all BDB tables to some secure place (as a backup) - Restart mysqld - Read back the BDB tables. If you get a crash, make a copy of log files and the bdb tables and contact us; We will help you make a bug report that we can send to the Berkeley DB people to help sort this out; They are very dedicated in trying to find and fix any bugs in their recovery code. Regards, Monty - 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
logging doesnt work with bdb if --with-debug
>Description: After several sig 11 I compliled a --with-debug version and enabled debugging and logging. Mysqld crashed shortly after starting without trace (!) and then immediatly crashed again after restart. /sw/pkg/mysqldebug/3.23.36/libexec/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010407 20:37:48 mysqld restarted __db_assert: "( &logp->dbentry[i].dblist)->tqh_first == ( dbp)" failed: file "../.././bdb/dist/../log/log_rec.c", line 433 010407 20:37:48 mysqld ended >How-To-Repeat: Compile mysql with --with-debug and --with-berkeley-db, use bdb tables and run mysqld with --debug --log >Fix: Dont do that :/ >Submitter-Id: >Originator:Oliver Blasnik >Organization: Nextra Germany >MySQL support: none >Synopsis: --debug --log with bdb fails >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Environment: System: FreeBSD 4.2-20010102-STABLE GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169330 Jan 2 13:23 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Mar 2 12:55 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 559324 Jan 2 13:23 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/sw/pkg/mysqldb3/3.23.36 --localstatedir=/server-root/DATABASE \ --without-docs --without-bench --without-debug --enable-assembler --with-mysqld-user=mysql --without-perl \ --with-mit-threads=no --without-readline --with-low-memory --with-berkeley-db --with-innobase Perl: This is perl, version 5.005_03 built for i386-freebsd - 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
Simple question: I can't find the latest binary for mysql 3.23.x for Solaris "Intel" version. Can someone tell me if they even have a Intel version of 3.23???
Simple question: I can't find the latest binary for mysql 3.23.x for Solaris "Intel" version. Can someone tell me if they even have a Intel version of 3.23??? Technology Consultant 310-426-5619 (h) / 888-431-7571 (p) http://www.access1.net/esteban1
RE: i stand corrected if this is wrong - :-
oops sorry again the DBD stuff should be install Bundle::DBD::mysql ... and in the rush to attempt to help, the little kahuna makes numerous mistakes... but in the end truth and justice prevails... he hopes... -Original Message- From: Irmund Thum [mailto:[EMAIL PROTECTED]] Sent: 21 February 2001 10:32 To: Barry Radloff Subject: Re: i stand corrected if this is wrong - :- Barry Radloff wrote: > > oops wrong site name :-( > go to www.cpan.org... > > Sorry > -Original Message- > From: Barry Radloff > Sent: 21 February 2001 08:16 > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: :mySQL > > hi ryan > > DBD::... are 'drivers' for perl to a specific db, you need to go to > www.cpan.com and download the DBI module for perl and the relevant driver I > assume mysql as this is a mysql list... > > alternatively if you have net access you can use: > perl -MCPAN -e shell > > and type install Bundle::DBI (i stand corrected if this is wrong) > > and install Bundle::mysql (see disclaimer above) cpan> install Bundle::mysql Can't install Bundle::mysql, don't have an associated bundle file. :-( at /usr/lib/perl5/5.6.0/CPAN.pm line 1806 (Mysql is correct :-) > read the docs and enjoy... > > Barry > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] -- http://it97.dyn.dhs.org -- IrmundThum +49 179 6998564 +49 6374 992541 - 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: ISM,FRM Problem plese help if possible
create directory in your mysql data directory, like /var/lib/mysql/mydatabase. copy your .frm, .ISD, ism to that directory. now you have database named mydatabase. --ilham-- On Fri, 16 Feb 2001, Ryan Ahmed wrote: > Q:--have you heard about that guy who finally > discovered what a woman is all about > A:sadly,he died laughing before he could tell > anybody > > (And one for the ladies) > Q:---Why was moses wandering around in the desert for > 40 years? > A:---Coz even then men couldnt take directions!!! > > > Hi Everyone, > Now that I've hopefully got you in a nice mood, > First a bit of history, > I was hosting with a very bad hosting service and so > had to move all my files and so my databases too. > I moved all my files but had no idea on how to move my > DB's so I contacted my hosting service and they sent > me a zip file with the following extentions > .ism > .frm > .isd > Where am I supposed to dump them or what should I do? > Kindly help, > Thank you > -Ryan. > > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > > - > 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
ISM,FRM Problem plese help if possible
Q:--have you heard about that guy who finally discovered what a woman is all about A:sadly,he died laughing before he could tell anybody (And one for the ladies) Q:---Why was moses wandering around in the desert for 40 years? A:---Coz even then men couldnt take directions!!! Hi Everyone, Now that I've hopefully got you in a nice mood, First a bit of history, I was hosting with a very bad hosting service and so had to move all my files and so my databases too. I moved all my files but had no idea on how to move my DB's so I contacted my hosting service and they sent me a zip file with the following extentions .ism .frm .isd Where am I supposed to dump them or what should I do? Kindly help, Thank you -Ryan. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - 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: If, then, else . . .
Hi, U can do nested ifs in Mysql. I am not sure if there is a limit in the no of levels it can go upto. If U R going to do this for 1000's of records there may be a slight drop in performance. SELECT field1, if(field1="a",100,if(field1="b",200,"ERROR")) FROM table; will do perfect. Cheers! Thiru On Thu, 15 Feb 2001 16:32:25 -0700 John Halladay <[EMAIL PROTECTED]> wrote: -> If I am querying a field that has either "a" or "b" as a value and I want a -> second field's value to be dependant on the first field's value, how would I -> right that? -> -> SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; -> -> The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, -> Access side of my brain talking. Sorry for the basis question. Any help -> would be much appreciated. -> -> Thanks. -> -> John H. -> -> - -> 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 -> -> ¨æêlÅ·B æëµãI --- T[rXJ peB@(a) eB àü|2402 --- - 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: If, then, else . . .
Hi, Look in the manual under Flow Control functions for use in select statements, and you should find what you need. Regards Quentin -Original Message- From: John Halladay [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 12:32 To: MySQL List (E-mail) Subject: If, then, else . . . If I am querying a field that has either "a" or "b" as a value and I want a second field's value to be dependant on the first field's value, how would I right that? SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, Access side of my brain talking. Sorry for the basis question. Any help would be much appreciated. Thanks. John H. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
If, then, else . . .
If I am querying a field that has either "a" or "b" as a value and I want a second field's value to be dependant on the first field's value, how would I right that? SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, Access side of my brain talking. Sorry for the basis question. Any help would be much appreciated. Thanks. John H. - 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: If-then-else in MySQL selects, like DECODE in Oracle?
>hi > >does mysql support any equivalent of DECODE in oracle? >i have been looking all over for info on this, but >cannot find any. i have several SQL scripts in our >code that use the decode stmt, and now that some of >our stuff is being ported to MySQL, i have hit a wall. > > >will i have to get my perl to do the looping and then >display the results? i want something as follows: > > > Quantity Sold for week beginning 5 Feb > > 05/02 06/02 07/02 08/02 09/02 > >product 1 22 90 78 12 09 >product 2 22 78 12 34 10 >product 3 10 12 12 23 23 > >this is simply done with DECODE in oracle, but what to >do in mysql? would appreciate any help/advice! > >thanks/erick Sir, MySQL has both the If function, and the CASE IF THEN ELSE structure. Check the online documentation. I know what decode() is, but I have very little experience with Oracle and I can't figure out how you used decode() to arrive at the output above, so I can't offer any more help. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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
mysql not reading all options if started with -p
mysql (the monitor) seems not to read the option character-sets-dir out of any configuration files (at least not /etc/my.cnf on Linux resp. c:my.ini and windows/my.ini on Windows) if it is started with option -p or with --password, i.e. if it shows a password prompt everything works fine if mysql is started without these options or if it is started with --password=xy this happens both on Linux and on Windows with 3.23.32 any ideas? thank you, Michael Kofler http://www.kofler.cc - 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
If-then-else in MySQL selects, like DECODE in Oracle?
hi does mysql support any equivalent of DECODE in oracle? i have been looking all over for info on this, but cannot find any. i have several SQL scripts in our code that use the decode stmt, and now that some of our stuff is being ported to MySQL, i have hit a wall. will i have to get my perl to do the looping and then display the results? i want something as follows: Quantity Sold for week beginning 5 Feb 05/02 06/02 07/02 08/02 09/02 product 1 22 90 78 12 09 product 2 22 78 12 34 10 product 3 10 12 12 23 23 this is simply done with DECODE in oracle, but what to do in mysql? would appreciate any help/advice! thanks/erick __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - 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
Enhancement: \P with --pager not specified now uses PAGER if set
>Description:
If one doesn't provide a default pager to the monitor using --pager,
and gives the monitor a \P command with no pager specified, the default
pager is set to stdout, even if the PAGER environment variable is set.
To my thinking, a bare \P is the user saying "just give me a pager,"
and if PAGER is set, he has an obvious preference. Hence, PAGER should
be used if available. Your opinion may vary.
>How-To-Repeat:
grotum:/tmp$ mysql.orig --version
mysql.orig Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
grotum:/tmp$ export PAGER=less
grotum:/tmp$ mysql.orig -s
mysql> \P
Default pager wasn't set, using stdout.
mysql> quit
grotum:/tmp$
>Fix:
--- mysql.ccSat Feb 3 19:05:05 2001
+++ mysql.useenvpager.ccSat Feb 3 19:03:59 2001
@@ -1764,7 +1764,7 @@
static int
com_pager(String *buffer, char *line __attribute__((unused)))
{
- char pager_name[FN_REFLEN], *end, *param;
+ char pager_name[FN_REFLEN], *end, *param, *envpager;
if (status.batch)
return 0;
@@ -1775,11 +1775,15 @@
{
if (!strlen(default_pager))
{
- tee_fprintf(stdout, "Default pager wasn't set, using stdout.\n");
- opt_nopager=1;
- strmov(pager, "stdout");
- PAGER= stdout;
- return 0;
+ if (! (envpager=(char*) getenv("PAGER")))
+ {
+tee_fprintf(stdout, "Default pager wasn't set, using stdout.\n");
+opt_nopager=1;
+strmov(pager, "stdout");
+PAGER= stdout;
+return 0;
+ }
+ strmov(default_pager, envpager);
}
strmov(pager, default_pager);
}
[end patch]
I tried the possibilities, and all looks well. The short result:
grotum:/tmp$ mysql.useenvpager -s
mysql> \P
PAGER set to less
mysql> quit
grotum:/tmp$
Basically, a bare \P will now behave as if --pager had been provided,
which makes sense to me, since both show that the user wants a pager.
>Submitter-Id: Brian Robison again?
>Originator: ditto?
>Organization:
>MySQL support: none
>Synopsis: \P with --pager not specified doesn't use PAGER if set
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: change-request
>Release: mysql-3.23.32 (Source distribution)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu
>on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 21 min 55 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.003
>Environment:
System: Linux grotum 2.2.16 #3 Mon Jul 31 23:15:18 PDT 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 16 2000 /lib/libc.so.6 -> libc-2.1.2.so
-rwxr-xr-x 1 root root 1008844 Sep 9 1999 /lib/libc-2.1.2.so
-rw-r--r-- 1 root root 20019674 Sep 15 1999 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 15 1999 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
-
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: select * from table where float(3,1)=number; if number has decimals, it doesn't work.
[EMAIL PROTECTED] wrote: > > >Description: > > if a column is defined as float(3,1) and your sql query > uses where in that particular column and the value has > decimals on it then you got empty set. > > >How-To-Repeat: > > ($:~) mysql stuff > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 35 to server version: 3.23.32 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > > mysql> select max(tiesaailma) from tiesaa; > +-+ > | max(tiesaailma) | > +-+ > | 5.3 | > +-+ > 1 row in set (3.92 sec) > > mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=5.3; > Empty set (1.13 sec) > > mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=3; > ++---+ > | tiesaailma | tiesaacity| > ++---+ > |3.0 | Tie 8; Pattijoki | > |3.0 | Tie 8; Närpiö, Bäckliden | > |3.0 | Tie 8; Närpiö, Bäckliden | > |3.0 | Tie 8; Pattijoki | > |3.0 | Tie 2; Pori, Kähkönen | > |3.0 | Tie 8; Kristiinankaup, Lapväärtti | > |3.0 | Tie 83; Ylitornio, Raanujärvi | > ++---+ > 7 rows in set (1.12 sec) > > mysql> > > >Fix: > > not known. > > The fix is to not test floating point numbers for equality. 5.3 can not be represented exactly in binary. If you wish to test for equality, use DECIMAL instead of FLOAT. It is stored unpacked ( as a string ). - 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
select * from table where float(3,1)=number; if number has decimals, it doesn't work.
>Description:
if a column is defined as float(3,1) and your sql query
uses where in that particular column and the value has
decimals on it then you got empty set.
>How-To-Repeat:
($:~) mysql stuff
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35 to server version: 3.23.32
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> select max(tiesaailma) from tiesaa;
+-+
| max(tiesaailma) |
+-+
| 5.3 |
+-+
1 row in set (3.92 sec)
mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=5.3;
Empty set (1.13 sec)
mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=3;
++---+
| tiesaailma | tiesaacity|
++---+
|3.0 | Tie 8; Pattijoki |
|3.0 | Tie 8; Närpiö, Bäckliden |
|3.0 | Tie 8; Närpiö, Bäckliden |
|3.0 | Tie 8; Pattijoki |
|3.0 | Tie 2; Pori, Kähkönen |
|3.0 | Tie 8; Kristiinankaup, Lapväärtti |
|3.0 | Tie 83; Ylitornio, Raanujärvi |
++---+
7 rows in set (1.12 sec)
mysql>
>Fix:
not known.
>Submitter-Id:
>Originator:Jani Ollikainen
>Organization:
-
bestis [EMAIL PROTECTED]
Jani Ollikainen http://come.to/bestis
-
>
>MySQL support: none
>Synopsis: some implementations of getting data with max() don't work.
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 min 21 sec
Threads: 1 Questions: 60 Slow queries: 0 Opens: 23 Flush tables: 1 Open tables:
17 Queries per second avg: 0.299
>Environment:
System: Linux ls.sicom.fi 2.4.0 #5 Mon Jan 22 16:10:56 EET 2001 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root9 May 18 1999 /lib/libc.so.5 -> libc.so.6
lrwxrwxrwx1 root root 11 Dec 9 12:45 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x1 root root 5072386 Jan 11 01:37 /lib/libc-2.2.so
-rw-r--r--1 root root 24498288 Jan 11 01:35 /usr/lib/libc.a
-rw-r--r--1 root root 178 Jan 11 01:35 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline --enable-shared
--with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all
-
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: SV: If exists UPDATE else INSERT
Do it the other way around. If insert fails, do the update. Udate may fail, and before you insert, another tread could do the insert. Now your insert would fail, and your data would be lost. Pål Wester wrote: > > Why not do an update regardless if the record exist or not, > then insert it if you get an error? > > -Opprinnelig melding- > Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]] > Sendt: 26. januar 2001 19:02 > Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Emne: Re: If exists UPDATE else INSERT > > I've seen something about this in the manual. At the moment > the problem was how to call such an SQL command (like > REPLACE for DELETE/INSERT). I wonder if it was > implemented in 3.23.32 or is it only in 4.x? > > - Original Message - > From: "Jan Willamowius" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 26, 2001 7:34 PM > Subject: If exists UPDATE else INSERT > > > I'm have a lot of queries where i have to check if a record exists > > and if it does, increment a counter in it (most of the time). If it > doesn't > > exist I insert a new record with counter=1 (this case is rare). > > > > Right now I do a select form Perl and then do one or the other. > > To speed things up I could always do an INSERT IGNORE and always an > UPDATE. > > This would save one statement on the INSERT case, but that is rare > anyway. > > > > I'd really like to do this in one (fast) statement, since this is a > > real time application with literally milions of UPDATEs that come in > > this way every day. > > > > Would it be possible to write a UDF to do this ? > > > > Cheers, > > Jan > > -- > - 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
SV: If exists UPDATE else INSERT
Why not do an update regardless if the record exist or not, then insert it if you get an error? -Opprinnelig melding- Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sendt: 26. januar 2001 19:02 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: Re: If exists UPDATE else INSERT I've seen something about this in the manual. At the moment the problem was how to call such an SQL command (like REPLACE for DELETE/INSERT). I wonder if it was implemented in 3.23.32 or is it only in 4.x? - Original Message - From: "Jan Willamowius" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 7:34 PM Subject: If exists UPDATE else INSERT > I'm have a lot of queries where i have to check if a record exists > and if it does, increment a counter in it (most of the time). If it doesn't > exist I insert a new record with counter=1 (this case is rare). > > Right now I do a select form Perl and then do one or the other. > To speed things up I could always do an INSERT IGNORE and always an UPDATE. > This would save one statement on the INSERT case, but that is rare anyway. > > I'd really like to do this in one (fast) statement, since this is a > real time application with literally milions of UPDATEs that come in > this way every day. > > Would it be possible to write a UDF to do this ? > > Cheers, > Jan > -- > Jan Willamowius, [EMAIL PROTECTED], http://www.willamowius.de/ > Caution: Penguin Inside ! > > - > 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 - 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: If exists UPDATE else INSERT
I've seen something about this in the manual. At the moment the problem was how to call such an SQL command (like REPLACE for DELETE/INSERT). I wonder if it was implemented in 3.23.32 or is it only in 4.x? - Original Message - From: "Jan Willamowius" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 7:34 PM Subject: If exists UPDATE else INSERT > I'm have a lot of queries where i have to check if a record exists > and if it does, increment a counter in it (most of the time). If it doesn't > exist I insert a new record with counter=1 (this case is rare). > > Right now I do a select form Perl and then do one or the other. > To speed things up I could always do an INSERT IGNORE and always an UPDATE. > This would save one statement on the INSERT case, but that is rare anyway. > > I'd really like to do this in one (fast) statement, since this is a > real time application with literally milions of UPDATEs that come in > this way every day. > > Would it be possible to write a UDF to do this ? > > Cheers, > Jan > -- > Jan Willamowius, [EMAIL PROTECTED], http://www.willamowius.de/ > Caution: Penguin Inside ! > > - > 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
If exists UPDATE else INSERT
I'm have a lot of queries where i have to check if a record exists and if it does, increment a counter in it (most of the time). If it doesn't exist I insert a new record with counter=1 (this case is rare). Right now I do a select form Perl and then do one or the other. To speed things up I could always do an INSERT IGNORE and always an UPDATE. This would save one statement on the INSERT case, but that is rare anyway. I'd really like to do this in one (fast) statement, since this is a real time application with literally milions of UPDATEs that come in this way every day. Would it be possible to write a UDF to do this ? Cheers, Jan -- Jan Willamowius, [EMAIL PROTECTED], http://www.willamowius.de/ Caution: Penguin Inside ! - 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
if ... else ...
Hi all,
I am having 5 rows in a mysql database related to five
different users. these rows contains their firstname,
lastname and details of scenes 1 to 5(these details
are numeric values from 1 to 3). if any of these
fields from scenes 1 to 5 are empty that will be
detected from the firstname of the user(collected from
a form with a filed name 'fname') by opening the
database and will be indicated to that user from which
scene he got empty fields. here is the code that i
wrote works like a champ.
$db = mysql_connect ("localhost","myname","password")
or die("Unable to connect to database.");
mysql_select_db ("nimitztest",$db) or die("Unable
to select database.");
$result = mysql_query ("select * from mytable order by
id",$db);
if ($row=mysql_fetch_array($result))
{
while ($row=mysql_fetch_array($result))
{
$FirstName = $row["firstname"];
if ($fname == $FirstName)
{
for ($i=1; $i<=5; $i++)
{
$Num[$i] = $row["num$i"];
if ($Num[$i] == '') {
printf ("You have to goto Scene$i");
break;
}
}
}
}
}
But when i include the else statement like below, to
indicate an user with all the fields filled up as 'You
don't have any thing to fill', this code is giving
weird results such as printing like this onto the
screen:
You don't have anything to fill
You have to goto Scene2
You have to goto Scene3
You have to goto Scene4
You have to goto Scene5
for a user with scene2 onwards empty fields.
This may be, because of fault in my code or because of
misinterpretation of the mysql functions by me.
-
for ($i=1; $i<=5; $i++)
{
$Num[$i] = $row["num$i"];
if ($Num[$i] == '') {
printf ("You have to goto Scene$i");
}
else {
printf ("You don't have anything to fill");
}
}
--
Please correct me about the mistake i am making over
above.
TIA
Chakravarthy K Sannedhi
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-
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: How do I know if a record exsist?
Don wrote:
>
> Hi,
>
> I'm using Perl to maintain a database. I'd like to search for a record
> in a database and if it does not exist, add it. Otherwise, just update
> the fields. In my script, I have:
>
> $sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
> '$port' ");
> $sqlCmd->execute();
$rc = $sqlCmd->execute().
$rc is the return code.
>
> Where '$port' is a scaler variable.
> If the record exists, I suppose I can do an INSERT. If not, I'll do an
> UPDATE. I can't seem to find the code/function to check for this simple
> test.
>
> Thanks,
> Don
>
-
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
How do I know if a record exsist?
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
$sqlCmd->execute();
Where '$port' is a scaler variable.
If the record exists, I suppose I can do an INSERT. If not, I'll do an
UPDATE. I can't seem to find the code/function to check for this simple
test.
Thanks,
Don
-
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: Checking if a date is correct
>try doing
>"SELECT UNIX_TIMESTAMP('1990-2-31')"
>and you'll get a number.
>This is very weird, since this is an incorrect date.
>
>Is there any way to figure out if a date is correct in mysql
>SQL implementation? And why UNIX_TIMESTAMP does
>not return NULL for incorrect date?
Sir, this seems to work.
SELECT If(DayOfMonth(From_Unixtime(Unix_Timestamp('1990-2-31'))) =
DayOfMonth('1990-2-31'), '1990-2-31', NULL);
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
-
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: Checking if a date is correct
> -Original Message-
> From: Artem Koutchine [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 1:44 PM
> To: [EMAIL PROTECTED]
> Subject: Checking if a date is correct
>
>
> try doing
> "SELECT UNIX_TIMESTAMP('1990-2-31')"
> and you'll get a number.
> This is very weird, since this is an incorrect date.
This is the documented behavior. Section 7.4.6 of the manual:
"To make the date checking 'fast', MySQL only checks that
the month is in the range of 0-12 and the day is in the range
of 0-31" ... "This is extremely useful for applications that need
to store a birth-date for which you don't know the exact date.
In this case you simply store the date like 1999-00-00 or
1999-01-00. (You can of course not expect to get a correct value
from functions like DATE_SUB() or DATE_ADD for dates like these)."
>
> Is there any way to figure out if a date is correct in mysql
> SQL implementation?
No. You must check this yourself before entering the information
into the database. Most programming languages have this facility
built in.
> And why UNIX_TIMESTAMP does
> not return NULL for incorrect date?
See above.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
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
Checking if a date is correct
try doing
"SELECT UNIX_TIMESTAMP('1990-2-31')"
and you'll get a number.
This is very weird, since this is an incorrect date.
Is there any way to figure out if a date is correct in mysql
SQL implementation? And why UNIX_TIMESTAMP does
not return NULL for incorrect date?
Artem
-
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: Checking if a record exists
Xavi Gracia wrote: > > Hi !!! > > I was wondering if there's any other method in SQL to test if a given record exists >that the typical error handling or the archetypical select clause looking for the >primary key. > > I'm making a table where the e-mail adress is the primary key, nothing amazing but >it's my first MYSQL database. :-) > > Another question, it's usual that if i try to add a new record with a e-mail address >already in, the php script didn't told me nothing about ( doesn't add the record, but >it didn't say nothing about duplicated record ). You need to check the returned value from your insert statement, and take appropriate action. You should check the return codes of all sql statements. - 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
Checking if a record exists
Hi !!! I was wondering if there's any other method in SQL to test if a given record exists that the typical error handling or the archetypical select clause looking for the primary key. I'm making a table where the e-mail adress is the primary key, nothing amazing but it's my first MYSQL database. :-) Another question, it's usual that if i try to add a new record with a e-mail address already in, the php script didn't told me nothing about ( doesn't add the record, but it didn't say nothing about duplicated record ).
