Corrupted auto_increment?

A server running MySQL 3.23 crashed yesterday. Since bringing it back online, doing inserts into a particular table will throw an error regarding a duplicate key value in an auto_increment field. I assume that something is corrupted. There are 779239 records, the most recently added having an

Re: add auto-increment field to fix table with no primary key - help

ALTER TABLE yourtable ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; See the manual for details . Michael leegold wrote: I have a table with no primary key. I would like to add a new auto-increment column field to each record - that

Re: very slow select with join

Michael Stassen napsal(a): Is this really your query? The LEFT JOINed tables, editor, customer, product, brand, calendar, and partner do not contribute to the output (i.e. none of their columns are selected), nor are they used to determine which rows to consider (i.e. they don't appear in the W

RE: add auto-increment field to fix table with no primary key - h elp

[snip] I have a table with no primary key. I would like to add a new auto-increment column field to each record - that would be the easiest way to remedy this. Eg. 1,2,3,4tagged onto each record successively. [/snip] ALTER TABLE t ADD id INT UNSIGNED NOT NULL auto_increment PRIMARY KEY FIRST;

Re: bash powered MySQL Queries

Edward Macnaghten wrote: Funny you should mention that May I guide you to my recent announcment of ShellSQL 0.7 - web page at http://www.edlsystems.com/shellsql - a utility to do just as you want (I think) released under GPL. It must be good - I wrote it myself :-) SELECT * FROM /dev/zero IN

Re: bash powered MySQL Queries

Funny you should mention that May I guide you to my recent announcment of ShellSQL 0.7 - web page at http://www.edlsystems.com/shellsql - a utility to do just as you want (I think) released under GPL. It must be good - I wrote it myself :-) Yours Eddy Andy wrote: Hi all I just wanted to know

bash powered MySQL Queries

Hi all I just wanted to know what would be the easiest way to retrieve simple data from a MySQL database from a bash script. With kind regards Andy -- --- Registered Linux user number 379093 --- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

add auto-increment field to fix table with no primary key - help

I have a table with no primary key. I would like to add a new auto-increment column field to each record - that would be the easiest way to remedy this. Eg. 1,2,3,4tagged onto each record successively. Is this possible with SQL? I also have PHP to use as well if needed. Thanks -- MySQL Gene

RE: disappearing data - please help!

> > From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] > > Sent: zondag 30 januari 2005 21:31 > > To: mysql@lists.mysql.com > > Subject: disappearing data - please help! > > > > What makes this all the more mysterious is that it happens > > intermittently. Sometimes when the script

RE: disappearing data - please help!

> -Original Message- > From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] > Sent: zondag 30 januari 2005 21:31 > To: mysql@lists.mysql.com > Subject: disappearing data - please help! > > What makes this all the more mysterious is that it happens > intermittently. Sometimes wh

Re: disappearing data - please help!

On Sun, Jan 30, 2005 at 04:03:37PM -0500, Sheryl (Permutations Software) wrote: > transactions. It's just the default. I don't know where I'd check AutoCommit > settings (or it they even apply to the default database type). It doesn't > refer to this in phpinfo.php. Try doing this immediately after

RE: disappearing data - please help!

I thought about this possibility, but I'm not using a database type with transactions. It's just the default. I don't know where I'd check AutoCommit settings (or it they even apply to the default database type). It doesn't refer to this in phpinfo.php. - Sheryl -Original Message

Query with 2 joins

Hello. I'm looking for some help on a complicated query. I'm not sure I'm using the Joins correctly. I have data in 5 different tables I want displayed on this page. The query I have now is SELECT Shows.Season_RID, Shows.Show_Name, Show

Re: very slow select with join

Pavel Novak wrote: Hello, I am clueless of this query, becaouse it's very slow - between 30 and 60 seconds: mysql> SELECT DISTINCT o.id AS id, o.orderid AS orderid, o.serialid AS serialid -> FROM orders o -> LEFT JOIN editor e1 ON o.createdby = e1.id -> LEFT JOIN editor e2 ON o.changed

Re: disappearing data - please help!

On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote: > but I'm having the most frustrating problem. Data I've inserted simply > VANISHES. What is the setting for AutoCommit? If it is 0, are you sure that commit is being called before the session ends? -Jason Martin -- F

disappearing data - please help!

I've got a weird problem that's driving me nuts. I'm updating a set of scripts for a customer database that supports sending out software registration codes in real time. I've had this working for some time now, but I'm having the most frustrating problem. Data I've inserted simply VANISHES. I've

Re: very slow select with join

Pavel Novák wrote: yea, but I use a lot of indexes and I don't know how to set it better. Bellow there are create table info so could you tell me what do you think would be bad, please? To begin with, you have redundant indexes. Unnecessary indexes slow you down. CREATE TABLE `order_acl` ( `ob

ANNOUNCE: ShellSQL 0.7

Hi Announcing ShellSQL 0.7 to an unsuspecting world... ShellSQL is a utility to allow SQL to be intergrated easily into UNIX/LINUX shell scripts. The web page is at http://www.edlsystems.com/shellsql - and at sourceforge at http://sourceforge.net/projects/shellsql . Version 0.7 includes many bu

Re: Need a query to get the difference of two tables

Ferhat BINGOL wrote: SELECT a.address FROM a, b WHERE (a.id LIKE b.id) AND (b.message NOT LIKE 'y') This won't work. That is, it's not equivalent to the original subquery version, which returns all the rows (ids) in a that do not have message='y' anywhere

Re: innodb SuSE 9.2

Ed Patterson wrote: Do I need to recompile MySQL to enable innodb tables, maybe I should simply go buy another book on MySQL that does not require innodb :-) Maybe -- better -- you should simply remove this crippled version of MySQL, wherever it came from, and get a binary from MySQL.com. :-) FWIW

utf8 x latin

Hi list, I was wondering which one is better to use, "utf8_general_ci" or "latin1_general_cs", with English, French, Portuguese, and Spanish? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

innodb SuSE 9.2

I am trying to enable innodb tables. rcmysql returns failed when I uncomment any or all of the lines in the innodb section of the/etc/ my.cnf. So far I have not been able to locate the file that startup errors are logged to. Do I need to recompile MySQL to enable innodb tables, maybe I should

Re: Need a query to get the difference of two tables

Roger Baklund wrote: Harish wrote: Hi, I apprecaite anybody replying me with an equvalent query for this: I am using mysql 4.0.21 select a.address from a where a.id not in (select b.iid from b where b.message='y') This can be done with a left join: select a.address from a left join b on b.iid=

RE: Need a query to get the difference of two tables

SELECT a.address FROM a, b WHERE (a.id LIKE b.id) AND (b.message NOT LIKE 'y') -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 7:19 PM To: mysql Cc: Harish Subject: Re: Need a query to get the differe

Re: Need a query to get the difference of two tables

Harish wrote: Hi, I apprecaite anybody replying me with an equvalent query for this: I am using mysql 4.0.21 select a.address from a where a.id not in (select b.iid from b where b.message='y') This can be done with a left join: select a.address from a left join b on b.iid=a.id where b.iid is

Re: mysqld restarts with no apparent reason

All, the InnoDB prints below reveal nothing of the problem. They just show mysqld crashing and starting uo again. You are not using InnoDB tables, since the log sequence number does not grow. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL Inno

Re: Why MySQL is very slow in dropping indexes?

All, slow index DROP and CREATE is a top complaint among MySQL users. Jan and Jani are now working to fix this. I guess in 2006 this problem has been removed. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool f

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

All, - Original Message - From: "mos" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, January 30, 2005 6:29 AM Subject: Re: FULLTEXT index on InnoDB tables (looking for a workaround) At 02:32 PM 1/28/2005, you wrote: And, of course, another option is to contact Heik

Re: very slow select with join

Jigal van Hemert napsal(a): | 1 | SIMPLE | o | ALL| NULL | NULL| NULL | NULL| 20402 | Using temporary; Using filesort | Well, this is a clue IMHO... no suitable indexes in o could be found to use in this query... yea, but I use a lot of indexes a

Need a query to get the difference of two tables

Hi, I apprecaite anybody replying me with an equvalent query for this: I am using mysql 4.0.21 select a.address from a where a.id not in (select b.iid from b where b.message='y') - Harish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

mysql cpu and primary memory usages

hello, version:mysql 4.1.8 os:windows XP How can we measure the primary memory used and cpu used by MySQL database and related services like query browser etc.We don't want the info.obtained from windows task manager .Can we get it from any SQL commands.A

mysql cpu and primary memory usages

hello, version:mysql 4.1.8 os:windows XP How can we measure the primary memory used and cpu used by MySQL database and related services like query browser etc.We don't want the info.obtained from windows task manager .Can we get it from any SQL commands.A

disappearing data

I've got a weird problem that's driving me nuts. I'm updating a set of scripts for a customer database that supports sending out software registration codes in real time. I've had this working for some time now, but I'm having the most frustrating problem. Data I've inserted simply VANISHES. I'