Re: new MySQL Server

I believe I saw something in the mySQL manual about going with a 64 bit system if it was an option because mySQL uses lots of 64 bit data types. So you will see a significant increase in speed with 64 bits versus 32. :: drools at though of Apple w/ 8GB RAM :: :-D -Dan On Sat, 2003-09-20 at 08:1

RE: INSERT/UPDATE number weirdness

Hi Matt, Thanks. That did the trick. James -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 11:34 PM To: [EMAIL PROTECTED] Subject: Re: INSERT/UPDATE number weirdness Hi James, Well if you used [VAR]CHAR/TEXT and then did the INSERT query *wi

RE: Data store/extract help almost there ,still error's

At 8:09 AM -0600 9/20/03, Stout, Jeff wrote: Thanks John, I'm trying various syntax changes but still getting Empty set mysql> INSERT INTO user_profile (userid,password) -> VALUES ("James",AES_ENCRYPT("bond","007")); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM user_profile WHERE us

Re: Enforcing NOT NULL restriction on UPDATE

At 9:30 AM -0400 9/20/03, Steven Hilton wrote: I am experiencing odd behavior, and I'm hoping someone can tell me if I'm doing something wrong or explain why it is behaving this way, and how to get around it... When I update a row in a table with a field's data set to NULL, but the table has a NOT

Re: Data store/extract help almost there ,still error's

hi you mix the password and key, use AES_ENCRYPT(, ); AES_DECRYPT(, ); example > UPDATE user_profile SET >username="james" , password=AES_ENCRYPT("bond007", "sydo89") > WHERE personid=1; saves the password in the record with the id = 1 > SELECT username, AES_DECRYPT(password,"sydo

Re: innodb and fragmentation

When you issue this "null" ALTER TABLE, is the entire table locked during the build? i.e. Is the only way to defragment to effectively take the table offline during the rebuild? Is there a method to estimate time to do this rebuild? thanks, Jon - Original Message - From: "Per Andreas Bue

RE: Data store/extract help almost there ,still error's

Thanks John, I'm trying various syntax changes but still getting Empty set mysql> INSERT INTO user_profile (userid,password) -> VALUES ("James",AES_ENCRYPT("bond","007")); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM user_profile WHERE userid="james" AND -> AES_DECRYPT("passw

Enforcing NOT NULL restriction on UPDATE

I am experiencing odd behavior, and I'm hoping someone can tell me if I'm doing something wrong or explain why it is behaving this way, and how to get around it... When I update a row in a table with a field's data set to NULL, but the table has a NOT NULL restriction on the field, the update stil

new MySQL Server

I would like to get a viewpoint from the members on the following: 1) the amount of $$$ is NOT a consideration Looking at building a MySQL server to handle in-house critical work. Web = page data is generated from the database plus constant inputting of data = and calculation. Application to be

Re: Next release of v4.1

Daniel, - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, September 20, 2003 1:08 PM Subject: Next release of v4.1 > Hi all, > > Does anyone know when the next release of MySQL version 4.1 will come out? my guess is, before

Next release of v4.1

Hi all, Does anyone know when the next release of MySQL version 4.1 will come out? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]