Record Locking

hi all, Can someone show me how to lock a record in mySQL? As far as my understanding goes, only innoDB tables support record locking level. I am currently using mySQL version 3.23 and my tables are in myISAM. Thanks in advance for any assistance. Mike -

Converting Sequel to MYSQL

Hi all, Does anyone have any suggestion for converting a Sequel database to MYSQL? I just want to copy a Sequel database data to a Mysql one. Thanks in advance for any suggestion, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Update Table By ID Ranges

Hi, How do i use the UPDATE statement to update a range of Primary Key id numbers. (let say 100 through 1000). Example, UPDATE testTable set testField='' WHERE test_id in (100:1000); Thanks in advance for any comments, Mike -- MySQL General Mailing List For list archives: http://lis

get record last updated date

Hi, Is there a way in mysql to get the record's last updated date? Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

redirect mysql output to file

Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table > test_table.file without doing a MYSQLDUMP. thanks, MT - Before posting, please check: http://www.mysql

digest mode for mysql list

hi list, Is there a way i can subscribe to this list as a digest user's mode, Similar to mailman's digest feature. I was trying to get to the mailman user's preference page but cannot find it on mysql.com. Can anyone help me out here. thanks, MT -

setting auto increment start value

Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT -- - Before posting, please check: http://www.mysql

undo last transaction

Hi all, How do i undo the last transaction in mysql? Thanks for any suggestions. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

order by birthday not year

Hi, I want to use the order by clause to list the birthday field by the birthday not year. How do i do this? example birthday=1972/02/14 How do i tell mysql to order by the day (14) only so that I can list same birthday in a month in acending order. Thanks -- Mike Doanh Tran Shuffle