RE: MySQL running out of date

Same here. Got 0's for the invalid dates, correct date for the other. What is wrong? Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Rajesh Kumar [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 1:35 PM > To: Hans van Harten > Cc: [EMAIL PROT

Design Suggestion

y" It seems to me the second way would be slower, because it has to do many more string tests. But does it make a difference? Is testing integer equality actually faster than string equality? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists

Design Suggestion

y" It seems to me the second way would be slower, because it has to do many more string tests. But does it make a difference? Is testing integer equality actually faster than string equality? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists

RE: No valid command found

I know I have been. Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 12:52 PM > To: [EMAIL PROTECTED] > Subject: Fw: No valid command found > > > Is everyone o

RE: php and mysql

There shouldn't be anything else required (besides PHP). PHP has built in functions to access MySQL. See: http://www.php.net/manual/en/ref.mysql.php Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: gamalt tant [mailto:[EMAIL PROTECTED] > Sent: Saturday, Septem

Moving database from Windows -> *nix?

I am going to possibly have to transfer a MySQL database that is currently running on Windows to a Linux/Unix box (not sure exactly what version it is running yet). Any pitfalls to avoid here? Thanks Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

RE: what means "shell" ?

For Windows, it’s the DOS prompt. Go to start/run and type "cmd". Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Stephan Wölfel [mailto:[EMAIL PROTECTED] > Sent: Sunday, October 12, 2003 12:27 PM > To: [EMAIL PROTECTED] > Subject: what means "

SHOW CREATE TABLE on one line?

is it possible to make it return the result on just one line? Thanks, Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: SHOW CREATE TABLE on one line?

un SHOW CREATE TABLE If (create != str) recreate table Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Monday, October 13, 2003 3:15 PM > To: Adam Clauss; [EMAIL PROTECTED] > Subject: Re: SHOW CREATE

How to best accomplish selecting string (unless it is null)

. Ex: I have a table similar to: Key | str1 | str2 0 | "str1" | "anotherstr" 1 | NULL | "string" 2 | NULL | NULL I would like the select statement to return: Key | Str 0 | "str1" 1 | "string"

Filling in data from already existing rows in table

n 4.0xx MySQL, which doesn't yet support nested queries. Any suggestions? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

"Got error 22 from table handler"

d argument I'm using multithreading in my app, but I make sure to LOCK/UNLOCK my tables before and after use. What would cause this? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MyISAM table corrupting in 4.0.16???

ocked it. Note that this same code did not cause this problem with 4.0.12 (had problems in other places, which are the reasons I just upgraded this). Any ideas? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MyISAM table corrupting in 4.0.16???

Narrowed it down - it doesn't seem to have anything to do with the table locking. I removed ALL locking/unlocking and it made no difference. Still getting there error. What would cause the 127 error? (perror says: 127 = Record-file is crashed) Adam Clauss [EMAIL PROTECTED] > -

How to optimize this query?

ally seen it finish yet - I've always run out of time (10-15min) to wait for it and have aborted. Any ideas/suggestions on what I could do to cut this time down? Or another alternative for filling in this information? Adam Clauss [EMAIL PROTECTED]

Is my logic wrong here?

ected results have a size of 0 (indicating that the specified object does not exist), but then when I try to insert that very same item, it gives me a key violation. I just upgraded this program to be using a 4.0.17 server - was previously using 4.0.12 and did not have this problem. Any ideas on what might be wrong? Adam Clauss [EMAIL PROTECTED]

Delete items which aren't present in another table?

MySQL at least partially supported nested SELECT queries, but either it does not support them in DELETE's or I got the syntax wrong. Here's what I was trying to use: DELETE FROM Categories WHERE NOT(catID IN (SELECT DISTINCT catID FROM items)); Any easy alternatives here? Adam Clauss cabadam@

RE: How to fill an Blob with binary data

I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE

RE: How to fill an Blob with binary data

In my case, its neither. Some "random" binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [

RE: How to fill an Blob with binary data

it to a file, then have MySQL read it back in. The app is using the C++ API and I was wondering if there was any other way to directly 'stream' the data in? Thanks, Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May

RE: How to fill an Blob with binary data

imaginable. Adam Clauss [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:53 PM To: [EMAIL PROTECTED] Cc: Adam Clauss Subject: RE: How to fill an Blob with binary data Depending on size of data there are a few different

RE: Catching Exceptions

erence? I've typically just done it by value. Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Select name, email where birthday = ??

Where MONTH(birthday)=MONTH(now()) AND DAYOFMONTH(birthday)=DAYOFMONTH(now()) Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 27, 2003 9:21 PM > To: MySql > Subject: Select name, email

RE: Limiting words...

delimiter (counting from the right) is returned: mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2); -> 'www.mysql' Except do with sapces instead of period? Adam Clauss [EMAIL PROTECTED] > -Original Message- > From: Steve Marquez [m

Question About Compiling

I am using VC++ 6 on Win2K. What is the exact process I need to go through to set this up to use it? I compiled the original project in the root directory. I then setup one of my programs to include the as the example had. I also have the lib file included to link in the project settings. Bu