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

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 Madison

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

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,...) possible

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); I

#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 query_cache_wlock_invalidat

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 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' COLLA