Re: integers fields and strings

2008-03-14 Thread Les Fletcher
Thanks for the link. That helps a lot. Rob Wultsch wrote: On Fri, Mar 14, 2008 at 12:04 PM, Les Fletcher <[EMAIL PROTECTED]> wrote: | Field | Type| Null | Key | Default | Extra | | intfield1 | smallint(6) | YES | | 0| | | intfield2 | smallint(6) | YES |

Re: integers fields and strings

2008-03-14 Thread Rob Wultsch
On Fri, Mar 14, 2008 at 12:04 PM, Les Fletcher <[EMAIL PROTECTED]> wrote: > | Field | Type| Null | Key | Default | Extra | > | intfield1 | smallint(6) | YES | | 0| | > | intfield2 | smallint(6) | YES | | NULL| | > | intfield3 | smallint(6) | YES |

integers fields and strings

2008-03-14 Thread Les Fletcher
I am having some issues with some integer fields and string input. The table setup is the following: | Field | Type| Null | Key | Default | Extra | | intfield1 | smallint(6) | YES | | 0| | | intfield2 | smallint(6) | YES | | NULL| | | intfield3 | smal

[ANN] PBXT storage engine version 1.0-Alpha released

2008-03-14 Thread Paul McCullagh
Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http://www.primebase.org/ download. PBXT is a highly scalable, transactional storage engine for MyS

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

2008-03-14 Thread Baron Schwartz
On Thu, Mar 13, 2008 at 7:55 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > 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, >

I: information from another table for custom engine

2008-03-14 Thread Scara Maccai
> 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