Hi Brad,
> We actually only have about 60 tables in that database. I've tried increasing
> the cache and open tables limits and get the same behaviour.
Hmm.. Shawn’s guesses are probably better than mine then.
> A few other tests I've tried:
>
> 1. Stand up a new machine, dump just the schema
Hello Brad,
On 3/17/2014 5:50 PM, Brad Heller wrote:
Hey Morgan,
We actually only have about 60 tables in that database. I've tried
increasing the cache and open tables limits and get the same behavior.
mysql> select @@table_definition_cache, @@table_open_cache,
@@innodb_file_per_table, @@inno
the process list (scrubbed) and the show engine
> > innodb status. Notice that all of the SHOW CREATE TABLE aren't for hte
> same
> > table, just got cleaned up that way.
>
> It shouldn't matter if they are for the same or different - in 5.5 there
> is one table ope
Hi Brad,
> That sounds right. Here's the process list (scrubbed) and the show engine
> innodb status. Notice that all of the SHOW CREATE TABLE aren't for hte same
> table, just got cleaned up that way.
It shouldn't matter if they are for the same or different - in 5.5
Hey Morgan,
That sounds right. Here's the process list (scrubbed) and the show engine
innodb status. Notice that all of the SHOW CREATE TABLE aren't for hte same
table, just got cleaned up that way.
https://gist.github.com/bradhe/c9f00eaf93ac588b8339
We have the de
Hi Brad,
> I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE query so I
> can figure out what could possibly have made them suddenly slow down?
>
> mysql> SHOW CREATE TABLE `my_table`;
> ...
> 1 row in set (37.48 sec)
>
> We tend to execute many
t;Brad Heller" wrote:
>
>> Hey all,
>>
>> I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE query so
>> I
>> can figure out what could possibly have made them suddenly slow down?
>>
>> mysql> SHOW CREATE TABLE `my_table`;
>>
Hey Brad. What version are you using? My immediate thought is to check if
innodb_stats_on_metadata is off. If it is on, switch off and check your
timings again.
Regards
On 17 Mar 2014 04:40, "Brad Heller" wrote:
> Hey all,
>
> I'm trying to figure out how InnoDB exec
Hey all,
I'm trying to figure out how InnoDB executes a SHOW CREATE TABLE query so I
can figure out what could possibly have made them suddenly slow down?
mysql> SHOW CREATE TABLE `my_table`;
...
1 row in set (37.48 sec)
We tend to execute many of these statements concurrently, but it
@10.253.19. <http://10.253.19.149/>xx (Version: 5.1.68)
[mysqld(API)]2 node(s)
id=4@10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68)
id=5@10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68)
Then I tried to create the following 'use
Sorry for another email. But this is just to expand on what SHawn said..I
could also have created an index and then referenced the column.
So without a primary key. I can create the parent , then create the child
and the index .
mysql> create TABLE parent ( id int(16) , name varchar(128))ENG
.
So when I changed my example to do this:
mysql> create TABLE parent ( id int(16) , name varchar(128), primary key
(id))ENGINE=Innodb;
mysql> create TABLE child ( id int(16) , name varchar(128), parent_id
int(16))ENGINE=Innodb;
mysql> ALTER TABLE child ADD CONSTRAINT child_parent_id_fk FO
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql> show innodb sta
Hi I am getting a Foreign key error .
The command that gives the error is
ALTER TABLE child ADD CONSTRAINT child_parent_fk FOREIGN KEY (id) REFERENCES
parent(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
And the error message is
ERROR 1005 (HY000): Can't create table
'./testforeignkey
>> Manasi Save
>> Artificial Machines Pvt Ltd.
>>
>> > Hello Manasi,
>> >
>> > Manasi Save wrote:
>> >> Hi All,
>> >>
>> >> Can anyone give me any input on How mysql create table write data into
>> >> system
gt;
> Manasi Save wrote:
>> Hi All,
>>
>> Can anyone give me any input on How mysql create table write data
into
>> system database and where it has been stored besides
information_schema.
>>
>> Is there any article on mysql System Databases anyone went
ot read the tables inside it.
>
> Can you tell me what might be the possible reason for that.
>
> --
> Thanks and Regards,
> Manasi Save
> Artificial Machines Pvt Ltd.
>
> > Hello Manasi,
> >
> > Manasi Save wrote:
> >> Hi All,
> >&g
.
> Hello Manasi,
>
> Manasi Save wrote:
>> Hi All,
>>
>> Can anyone give me any input on How mysql create table write data into
>> system database and where it has been stored besides information_schema.
>>
>> Is there any article on mysql System Databas
Hello Manasi,
Manasi Save wrote:
Hi All,
Can anyone give me any input on How mysql create table write data into
system database and where it has been stored besides information_schema.
Is there any article on mysql System Databases anyone went through as I am
not able to find it on Google.
I
Hi All,
Can anyone give me any input on How mysql create table write data into
system database and where it has been stored besides information_schema.
Is there any article on mysql System Databases anyone went through as I am
not able to find it on Google.
I want to write a table information
Octavian Râºniþã wrote:
Hello,
I've tried to create these 4 test tables, but when I try to create the last
one, MySQL gives the following error:
ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm'
(errno
: 150)
It seems that the foreign keys
Hello,
I've tried to create these 4 test tables, but when I try to create the last
one, MySQL gives the following error:
ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm'
(errno
: 150)
It seems that the foreign keys are not created well in the
list & the community were a big help in pointing me in the
right direction.
Cheers,
- Brad
On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen <[EMAIL PROTECTED]> wrote:
> Brad Heintz wrote:
>
> > Thanks for responding.
> >
> > The CREATE TABLE docs for 5.1 say that DATA DIR
gt;> > retry FILE operation
>> >
>> > Martin
>> > __
>> > Disclaimer and confidentiality note
>> > Everything in this e-mail and any attachments relates to the official
>> > business of Sender. This tra
; Brad Heintz wrote:
>
> > Thanks for responding.
> >
> > The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX
> > DIRECTORY take absolute paths (not relative), and will in fact reject
> > paths containing
> > the MySQL data dir. Because I'm out of othe
ily endorse content contained within this
> transmission.
>
>
>
>
> > Date: Sat, 6 Dec 2008 10:40:17 -0500
> > From: [EMAIL PROTECTED]
> > To: mysql@lists.mysql.com
> > Subject: Re: Vexing permissions issue with partitioned CREATE TABLE
>
> >
> >
: Re: Vexing permissions issue with partitioned CREATE TABLE
>
> John -
>
> I've seen people confuse MySQL users with OS users, too. I'm not doing
> that, and I understand the difference between MySQL privs and filesystem
> permissions. MySQL is running as the mysql user.
ature and Sender
> > does not endorse distribution to any party other than intended recipient.
> > Sender does not necessarily endorse content contained within this
> > transmission.
> >
> >
> >
> >
> > > Date: Fri, 5 Dec 2008 15:44:06 -0500
> > >
Brad Heintz wrote:
> Thanks for responding.
>
> The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX
> DIRECTORY take absolute paths (not relative), and will in fact reject
> paths containing
> the MySQL data dir. Because I'm out of other ideas, I did try
>
ly endorse content contained within this
> > transmission.
> >
> >
> >
> >
> > > Date: Fri, 5 Dec 2008 15:44:06 -0500
> > > From: [EMAIL PROTECTED]
> > > To: mysql@lists.mysql.com
> > > Subject: Vexing permissions issue with partitioned CRE
Brad Heintz wrote:
I've googled extensively, searched the list archives, and exhausted every
other avenue I could think of before posting to the list, but am no closer
to an answer. Does anyone have any ideas? Have I missed something in the
docs?
SELinux?
--
Florin Andrei
http://florin.my
>
>
>
>
> > Date: Fri, 5 Dec 2008 15:44:06 -0500
> > From: [EMAIL PROTECTED]
> > To: mysql@lists.mysql.com
> > Subject: Vexing permissions issue with partitioned CREATE TABLE
>
> >
> > All -
> >
> > Thanks in advance for help with a
Thanks for responding.
The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX DIRECTORY
take absolute paths (not relative), and will in fact reject paths containing
the MySQL data dir. Because I'm out of other ideas, I did try creating the
directories under the MySQL data dir a
I've never created a partitioned table, but...
$ perror 13
OS error code 13: Permission denied
So I suspect some kind of file-system permissions issue...
Are you sure that the path you are giving isn't "relative" to the mysql data
dir?
In which case it's trying to use something mor
All -
Thanks in advance for help with a sticky problem.
I'm attempting to create a partitioned table thus:
CREATE TABLE `my_precious_table` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`startTimeStamp` datetime NOT NULL DEFAULT '-00-00 00:00:00',
PRIMARY KEY (`id`,
Thanks Dan for your quick response - it works now. I am new to SQL in general
and MySQL in particular.
O.O.
--- Ven 4/7/08, Dan Nelson <[EMAIL PROTECTED]> ha scritto:
> Da: Dan Nelson <[EMAIL PROTECTED]>
> Oggetto: Re: Create Table from Results of SQL Query
> A: "O
uture. I am wondering if someone could show me how to create a
> table from the results of the SQL Query.
CREATE TABLE table2 SELECT field1,field2 FROM table1
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
Note that you may need to add appropriate indexes after this, to make
your later
Hi,
I have a SQL Query that has an inner join and it is taking too long to
execute. I am thinking of speeding this up by dumping the result into a
separate table – as I would be requiring the result of this query many times in
the future.
I am wondering if someone could show m
On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote:
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is
dropped by DROP TABLE IF EXISTS, becomes randomly unable to be
recr
nt: Tuesday, June 24, 2008 2:58 AM
To: mysql@lists.mysql.com
Subject: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is dropped
by DROP TAB
rted tables.
-Original Message-
From: Gwynne Raskind [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 2:58 AM
To: mysql@lists.mysql.com
Subject: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is dropped
by DROP TABLE IF EXISTS, becomes randomly unable to be recreated. Here
is my comment on that bug:
Having this
On Tue, Apr 15, 2008 at 7:27 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote:
>
> > Hi,
> >
> > I have created a table name group.
> >
> > CREATE TABLE `group` (
> > `group_id` int(11
uesday, April 15, 2008 6:27 PM
Subject: Re: Create table
> At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote:
> >Hi,
> >
> >I have created a table name group.
> >
> >CREATE TABLE `group` (
> > `group_id` int(11) NOT NULL,
> > `group_name` v
At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote:
Hi,
I have created a table name group.
CREATE TABLE `group` (
`group_id` int(11) NOT NULL,
`group_name` varchar(128) NOT NULL,
`date_created` datetime NOT NULL,
`created_by` int(11) NOT NULL,
`modified_by` int(11) default
Hi.
group is a reserved word
i think you must enclose the table name with single quotes (as when you
created the table) in order to avoid the confusion.
Carlos
Krishna Chandra Prajapati wrote:
Hi,
I have created a table name group.
CREATE TABLE `group` (
`group_id` int(11) NOT NULL
> I have created a table name group.
>
> CREATE TABLE `group` (
> `group_id` int(11) NOT NULL,
> `group_name` varchar(128) NOT NULL,
> `date_created` datetime NOT NULL,
> `created_by` int(11) NOT NULL,
> `modified_by` int(11) default NULL,
> `status` char(1) NOT NULL defa
Hi,
I have created a table name group.
CREATE TABLE `group` (
`group_id` int(11) NOT NULL,
`group_name` varchar(128) NOT NULL,
`date_created` datetime NOT NULL,
`created_by` int(11) NOT NULL,
`modified_by` int(11) default NULL,
`status` char(1) NOT NULL default 'Y',
P
On 14.03.2008 00:55 CE(S)T, Rob Wultsch wrote:
I am guessing it is an issue with "SearchRevision" being an INTEGER,
and "RevisionNumber" being a SMALLINT.
Thank you, that was the problem. My design was incorrect anyway to use
different types here... Now that's fixed, too. :)
http://www.goo
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 PRIMAR
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"
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,
&qu
> This is a create table statement output from mysqldump from a 4.0.24
> installation.
>
> Restoring on 5.0.22 gives a warning.
>
> Can anyone enlighten me?
>
> I guess I'm a little behind on my reading...
>
> David
>
> mysql> CREATE TABLE `c
Do a "SHOW WARNINGS" at the command line.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 13 June 2007 16:11
To: mysql@lists.mysql.com
Subject: Create Table Warning
This is a create table statement output from mysqldump from a 4.0.24
installation.
Hi ,
[EMAIL PROTECTED] wrote:
This is a create table statement output from mysqldump from a 4.0.24
installation.
Restoring on 5.0.22 gives a warning.
Can anyone enlighten me?
I guess I'm a little behind on my reading...
David
mysql> CREATE TABLE `container` (
-> `carri
This is a create table statement output from mysqldump from a 4.0.24
installation.
Restoring on 5.0.22 gives a warning.
Can anyone enlighten me?
I guess I'm a little behind on my reading...
David
mysql> CREATE TABLE `container` (
-> `carrier` varchar(128) NOT N
Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 19, 2006 9:45 AM
> To: Dan Buettner; Scott Hamm
> Cc: Mysql
> Subject: Re: Re: CREATE TABLE Inv_Id
>
>
>
>
> > Scott, what's wrong with 'PRIMARY
> Scott, what's wrong with 'PRIMARY KEY' ?
A PRIMARY KEY has nothing to do with the "uniqueidentifier" datatype.
A "uniqueidentifier" is a GUID.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscen
Scott, what's wrong with 'PRIMARY KEY' ?
Dan
On 10/19/06, Scott Hamm <[EMAIL PROTECTED]> wrote:
Wish MySQL would have something like what Microsoft use, "uniqueidentifier"
as datatype.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Wish MySQL would have something like what Microsoft use, "uniqueidentifier"
as datatype.
Thanks!
On 10/16/06, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
I would try:
CREATE TABLE Inv_Id (
ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
Note the UNSIGNED an
I would try:
CREATE TABLE Inv_Id (
ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
Note the UNSIGNED and ZEROFILL flags !
-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
--
MyS
(casecode prefix,
a manufacturers id, a partnumber, and a check digit) to the table definition.
- Original Message -
From: Gerald L. Clark <[EMAIL PROTECTED]>
To: Scott Hamm <[EMAIL PROTECTED]>
Cc: Mysql
Sent: Monday, October 16, 2006 2:31:47 PM GMT-0500 US/Eastern
Subject: R
10/16/06, Gerald L. Clark <[EMAIL PROTECTED]> wrote:
Scott Hamm wrote:
> I'm trying to create a table as follows:
>
> CREATE TABLE Inv_Id (
> ID INT(12) AUTO_INCREMENT PRIMARY KEY,
> MID INT NOT NULL,
> FOREIGN (MID) REFERENCES 'Model' (ID)
> );
>
&g
What you can do is left pad it with zeros whenever you select it:
select LPAD(id,12,0) from Inv_Id order by id;
HTH,
Dan
On 10/16/06, Scott Hamm <[EMAIL PROTECTED]> wrote:
I'm trying to create a table as follows:
CREATE TABLE Inv_Id (
ID INT(12) AUTO_INCREMENT PRIMARY KEY,
MID INT N
Scott Hamm wrote:
I'm trying to create a table as follows:
CREATE TABLE Inv_Id (
ID INT(12) AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
How do I make ID to start out as '0001' for UPC barcode assignment?
UPC ba
I'm trying to create a table as follows:
CREATE TABLE Inv_Id (
ID INT(12) AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
How do I make ID to start out as '0001' f
I've now figured out that the error occurs when I try to create any
table that has a primary key. creating tables without the primary key
works.
hmm.. is there any limitation in the mysql (ndb)-settings that I've to
change?
Its the standard-installation of 4.1.21-max...
--
Sebastian Mork
[EMAIL PR
Hi,
I get this error when trying to create newtables in a cluster.
I just created about 27 tables using ndbcluster-engine without a problem.
trying to create any more tables fails with this error.
anybody knows?
thx
--
Sebastian Mork <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list
elp.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
> CREATE TABLE Order (
> DID int not n
is REALLY something wrong with the
MySQL engine or something! Here is the script:
CREATE TABLE Order (
DIDint not null,
DeskNoint not null,
OrderDatedatetimenot null,/* KOT Date */
OrderNoint not null,/* KOT N
Hi All,
I have been repeatedly trying to create the following table - without
__ANY__ success. Looks like there is REALLY something wrong with the
MySQL engine or something! Here is the script:
CREATE TABLE Order (
DID int not null,
DeskNo int
Hi
The following happened when I tried to create table. Can anyone please help?
mysql> create table sfgbackup.advEmail select * from sfg.advEmail;
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against
On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
> >I require something along the lines of this:
>
> >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
>
> CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log;
>
> PB
Excellent. Exactly
Terry
I require something along the lines of this:
CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log;
PB
-
Terry Burton wrote:
Hi,
I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
s
On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote:
> I dont think that it is possible to specify the engine when creating a table
> this way, you could however create the table using the:
>
> CREATE TABLE old AS SELECT * FROM request_log
>
> and then issue an alter t
I dont think that it is possible to specify the engine when creating a table
this way, you could however create the table using the:
CREATE TABLE old AS SELECT * FROM request_log
and then issue an alter table command setting the engine to whatever you like.
Pure Web Solution
http
Hi,
I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
syntax alongside the ENGINE = x pragma, since this would make
archiving of tables very simple.
I require something along the lines of this:
CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
If this cannot be
I appreciate the suggestion, but I'm not looking to drop anything. I
only want it as a safety net in the event that the table doesn't
already exist. I'm doing syncing of sorts, and I want the CREATE
TABLE IF NOT EXISTS so as not to throw errors in the event that the
table
DROP TABLE IF NOT EXISTS?
On 1/16/06, Michael Williams <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> Having a bit of mysqldump trouble again. I've looked over the
> documentation (again) and can't seem to find the flag to make
> 'mysqldump' out pu
Hi All,
Having a bit of mysqldump trouble again. I've looked over the
documentation (again) and can't seem to find the flag to make
'mysqldump' out put "CREATE TABLE IF NOT EXISTS". Any ideas?
Regards,
Michael
--
MySQL General Mailing List
For list ar
Hello.
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
Put Area in backticks ('`'). See:
http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
Nabegh Al-Thalji wrote:
> When I execute the following query
>
> CREATE TABLE Sponsor (
> sNum
Hi,
You are using a reserved function name "AREA" (polygon function) as a
fieldname. Simply change the field's name or try using quotes around
it...
Detlev
> [...]
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
> [...]
> Any ideas?
--
MySQL General Mailing List
For list archives:
When I execute the following query
CREATE TABLE Sponsor (
sNum INTEGER UNSIGNED NOT NULL,
sAdrBlock CHAR(2),
sCivil_ID CHAR(12),
sDateOfBirth DATE,
sDrvLicenseExp DATE,
sDrvLicenseNum CHAR(9),
sGender ENUM('M','F'),
sName VARCHAR(20),
sStatus VARCHAR(20),
sTelephone CHAR(7
nd
>>the query entered into the binlog, however the slave ignores it silently:
>> CREATE TABLE `db`.`table` (a INT DEFAULT 0)
>>
>>I have duplicated this exact issue on several different setups, one
>>running 4.0.24 on both the slave and master. Is this by design, is it
wrote:
> I ran into a problem on a replication setup, where if you issue the
> following CREATE statement on the master the table will get created and
> the query entered into the binlog, however the slave ignores it silently:
> CREATE TABLE `db`.`table` (a INT DEFAULT 0)
>
iling.database.myodbc
Sent: Tuesday, October 25, 2005 5:33 AM
Subject: ERROR 1005 (HY000): Can't create table
'.\testDataBase\#sql-ec4_c.frm' (errno: 139)
--_=_NextPart_001_01C5D90C.62DB5CF5
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quot
(I am using mysql-5.0.15-win32)
Why I am getting this error and is there any way I can fix it, or is it
a bug?
Between I don't get this error if I change the field size to 767 or
below:
drop table Address;
CREATE TABLE `Address`
(
`RecId` CHAR(32) NOT NULL,
`WebAddress` VARCHAR
ter the table will get created and
> the query entered into the binlog, however the slave ignores it silently:
> CREATE TABLE `db`.`table` (a INT DEFAULT 0)
>
> I have duplicated this exact issue on several different setups, one
> running 4.0.24 on both the slave and master.
I ran into a problem on a replication setup, where if you issue the
following CREATE statement on the master the table will get created and
the query entered into the binlog, however the slave ignores it silently:
CREATE TABLE `db`.`table` (a INT DEFAULT 0)
I have duplicated this exact
Jigal van Hemert spill.nl> writes:
> http://dev.mysql.com/doc/mysql/en/show-create-table.html
>
> Use output of SHOW CREATE TABLE, modify name and execute that query.
Superb solution. I didn't know that MySQL has such a command. My question was
very basic. Sorry for botheri
Konrad Billewicz wrote:
Hello,
I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL
3.23 and this command is available since 4.1. How would you handle this task
using this, older MySQL?
http://dev.mysql.com/doc/mysql/en/show-create-table.html
Use output of SHOW
Hello,
I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have
MySQL
3.23 and this command is available since 4.1. How would you handle this task
using this, older MySQL?
Best regards,
Konrad Billewicz
--
MySQL General Mailing List
For list archives: http
Les Schaffer wrote:
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
upgrading to 5.0.6 solved the problem.
do i need to let MySQL developers know about this or do they monitor the
list or once a release is gone, i can assume THIS problem was fixed?
th
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
upgrading to 5.0.6 solved the problem.
do i need to let MySQL developers know about this or do they monitor the
list or once a release is gone, i can assume THIS problem was fixed?
thanks to all for the f
Les Schaffer wrote:
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
i was running 5.0.4 on Windows:
mysql> \s
--
mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32)
switching to 5.0.6 now. anyone wanna make a bet ;-)
les schaffer
eu
Les Schaffer wrote:
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
i was running 5.0.4 on Windows:
mysql> \s
--
mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32)
switching to 5.0.6 now. anyone wanna make a bet ;-)
les schaffer
eu
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
i was running 5.0.4 on Windows:
mysql> \s
--
mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32)
switching to 5.0.6 now. anyone wanna make a bet ;-)
les schaffer
--
MySQL General Mailing
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows and they
both seem to look fine {see the SHOW CREATE TABLE's following the CREATE
TABLE statements}
RUN ON 4.0.20
mysql> CREATE TABLE ID (
-> mat INT UNIQUE PRIMARY KEY,
-> ID_firstname CHAR(35) D
i am trying to create a table as follows:
CREATE TABLE ID (
mat INT PRIMARY KEY UNIQUE,
ID_firstname CHAR(35),
ID_lastname CHAR(35),
ID_ramqnb CHAR(12),
ID_numciv_hosp CHAR(10) DEFAULT '-9',
ID_appt_hosp CHAR(10) DEFAULT '-9',
ID_streetname_hosp CHAR(75) DEFAULT '-9&#x
1 - 100 of 404 matches
Mail list logo
