Re: mysql repair question

Try using myisamchk -r option for repairing the table. On Wed, Mar 12, 2008 at 2:53 PM, pengyao [EMAIL PROTECTED] wrote: hi,i have a question,such as: mysql select * from test; ERROR 1194 (HY000): Table 'test' is marked as crashed and should be repaired . i think the test table was

I: information from another table for custom engine

Anyone - Messaggio inoltrato - Da: Scara Maccai [EMAIL PROTECTED] A: mysql@lists.mysql.com Inviato: Venerdì 7 marzo 2008, 6:07:42 Oggetto: information from another table for custom engine Hi, I'm writing a custom engine to read data written in a legacy format as it was a

MySQL University session on March 13 - canceled

Today's MySQL University session: Checking Threading and Locking With Helgrind http://forge.mysql.com/wiki/Checking_Threading_and_Locking_With_Helgrind has been canceled and will be rescheduled for a later date. I apologize for the short notice. -- Paul DuBois, MySQL Documentation Team

Re: information from another table for custom engine

are you asking how is it you can access information in a MySQL DB without connecting to MySQL DB? please elaborate No, the thing is that I'm already running in the mysqld process because I'm talking about a custom engine library that I wrote. So my code runs inside mysql, hence I don't

revisit data structure

hi all, i come up these tables for my project and i'm looking for advice/suggestion how to improve/optimize the structure further. table item(itemid,warehouse,category,shapeid,) table shape(shapeid,physical_shape,...) table dimension(dimensionid,itemid,shapeid,characteristic,...)

RE: Auto Fill blank Rows

Now I come to exapnd the requirement it not correct... to elaborate.. I create tables as such... DROP TABLE IF EXISTS filler; CREATE TABLE filler (row_id int); INSERT INTO filler (row_id) VALUES (1); INSERT INTO filler (row_id) VALUES (2); INSERT INTO filler (row_id) VALUES (3);

#1005 - Can't create table '.\unb2test\#sql-770_2.frm' (errno: 150)

Hello, I'm using MySQL 5.0 on Windows XP, with a few InnoDB tables and would like to create a new foreign key constraint to one table. Here's a simplified structure: CREATE TABLE message ( MessageId INTEGER UNSIGNED NOT NULL PRIMARY KEY, Owner INTEGER UNSIGNED NOT NULL,

Re: write lock and sql_cache

I agree. Don't duplicate posts or post to multiple lists. Jump on the IRC channel if you need help right away :-) sorry again, I was not in hurry, but I had a fault on my mailer, since I was trying to send the post from office and from the wrong account.. The

Re: cursors

On Wed, Mar 12, 2008 at 9:52 PM, smriti Sebastian [EMAIL PROTECTED] wrote: Hi all, I tried to implement a cursor using the following statement: create procedure curdemo() begin declare cursor1 cursor for select SID from customer; I have a customer table with a field SID. BUt I am

i quick question please

i am a newbie in this mysql path... what are the diferences between mysql 5.0, 5.1 and 6.0 I work mostly with Ms-SQL 2003. any sugestion? any answer? any help would be nice! thx Roberto Zarate Mendoza lima-peru 511 9238-4883

Re: i quick question please

On Thu, 13 Mar 2008, Roberto Zarate [EMAIL PROTECTED] wrote: i am a newbie in this mysql path... what are the diferences between mysql 5.0, 5.1 and 6.0 I work mostly with Ms-SQL 2003. any sugestion? any answer? any help would be nice! I did a Google search for mysql and the top hit was

Re: #1005 - Can't create table '.\unb2test\#sql-770_2.frm' (errno: 150)

On Thu, Mar 13, 2008 at 12:33 PM, Yves Goergen [EMAIL PROTECTED] wrote: CREATE TABLE message ( MessageId INTEGER UNSIGNED NOT NULL PRIMARY KEY, Owner INTEGER UNSIGNED NOT NULL, SearchRevision INTEGER UNSIGNED) ENGINE 'InnoDB' CHARACTER SET 'utf8' COLLATE 'utf8_bin';