Re: Using mySQL connectJ issue

hi it seems that the mysql-connector-java-3.0.8-stable-bin.jar file is not in the classpath. best regards benny - Original Message - From: Joe Yan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 7:58 PM Subject: Using mySQL connectJ issue Hi all, when I

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

hi you mix the password and key, use AES_ENCRYPT(the clear password, the key to crypt); AES_DECRYPT(the crypted password, the key to crypt); example UPDATE user_profile SET username=james , password=AES_ENCRYPT(bond007, sydo89) WHERE personid=1; saves the password in the record

Re: Select statement with a field name that is a number?

hi use ` instead of ' may solve the problem. regards benny - Original Message - From: Zach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 7:04 PM Subject: Select statement with a field name that is a number? I'm trying to use a select statement for a table

i need help, innodb blocks insertion into table for a while

hi dear mysql list members i have setup a mysql database 4.013 with innodb enabled. when i set the transaction isolation level to serializable. after executing a specific query is the insertion into a table blocked for about 20 seconds. the table is defined as follows CREATE TABLE

RE: i need help, innodb blocks insertion into table for a while

hi i solved the problem by executing the commit after the select. best regards benny

compare longblob with binary data

hi all a question about checking the data of a longblob for equality. assume the `data` field is of type longblob. the following statement returns the image records with equal data. SELECT * FROM `image` WHERE `data`=? how does mysql performe the test. does it check the length of the blob

recursive sql statement

hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny

Re: recursive sql statement

for me a recursive sql statement is when the result of a query can be used for a following query. the statement has start and stop condition. such kind of queries is useful for tree traversal. sql is based on relational algebra that does not allow to write such expressions. but as mentioned by

Re: recursive sql statement

hi victoria sorry for this mysql newbie question, but what means planned for the near future? ist this weeks, months or years away? best regards benny

RE: RESETTING AUTO_INCREMENT

hi mike you suggested the following If you are referring to recovering some auto_increment values that were previously used by no rows now use them, it is better to avoid this. how can you prevent this? best regards benny

innodb transaction

hi all i started working with the innodb databasel. after reading the manual i am not sure how i shall use transctions. say i have the following case: SELECT read some row UPDATE depending on the select COMMIT to make the command sequence safe, the select has to lock the table. it would be

Re: innodb transaction

hi many thanks for that quick and precise answer - a big smile. i am very impressed by this user group, especially regarding the speed and quality of the answers. regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: AUTO_INCREMENT

hi you can reset the counter yourself with the following sql statement ALTER TABLE tbl_name AUTO_INCREMENT = 1; best regards benny - Original Message - From: Dylan Pham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 7:27 PM Subject: AUTO_INCREMENT Hi, I am