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 se

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 te

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

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; &

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 *

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

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

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 co

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=&quo

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 s

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

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,

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 -

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 appl

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 Lin

Re: if Linux and Win2000 dual boot is possible?

ay, 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 Win2

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

Re: Re: Plase Let us know if there is a Racialism for Mysql productand

ounds 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. -

Ynt: Plase Let us know if there is a Racialism for Mysql product and quit

f 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 produ

Re: Plase Let us know if there is a Racialism for Mysql product and quit

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

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

Re: Plase Let us know if there is a Racialism for Mysql product and quit

e 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

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

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 kno

logging doesnt work with bdb if --with-debug

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

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 co

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 - :-

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:

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 a

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 Ever

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")) FR

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, 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 ta

Re: If-then-else in MySQL selects, like DECODE in Oracle?

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 THE

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

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

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

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: > &g

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 nam

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 ins

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

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 PROTE

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 t

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

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 Por

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' &qu

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

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')" > an

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 f

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

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

<    5   6   7   8   9   10