You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...

create database binlog_center; CREATE TABLE `binlog_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `instance_name` varchar(32) DEFAULT NULL COMMENT 'instance name', `binlog_file` ...

ALTER TABLE `users` ADD `display_name` longtext NULL AS (CONCAT(last_name, ', ', first_name)); If I edit the generated script file and change the line to what is below, everything works correctly. No ...

So I want to make an update in MySQL where a value is updated if two conditions are true. So I have data in columns name and status. If the name and status match foo and d, then I want to change ...