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's never
been a problem until recently. I upgraded the IO subsystem
,
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's never
been
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 of these statements concurrently, but it's
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 defaults
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 there is one
table open cache
. 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 open cache instance - so only one person can be opening or
closing tables at a time.
In 5.6 this is configurable
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,
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 in
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's never
(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 'user_table' on 'user_database':
create table user_table(
ycsb_key varchar(32
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
'./testforeignkeysyntax_lap
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 status
.
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 FOREIGN KEY
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))ENGINE
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 Googl
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,
Can anyone give me any input on How mysql create table write data into
system database
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,
Can anyone give me any input on How mysql create table write data into
system database and where it has
.
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
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
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 fourth table, and
I
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 are not created well
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 DIRECTORY and INDEX
DIRECTORY take absolute paths
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
Subject: Vexing permissions issue with partitioned CREATE TABLE
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
with partitioned CREATE TABLE
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
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
creating the directories under
TABLE
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
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. I'm running the query as
MySQL's root.
I am
.
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
John -
I've seen people confuse MySQL users with OS users, too. I'm not doing
that, and I understand the difference
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`,`startTimeStamp
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 more
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
Subject: Vexing permissions issue with partitioned CREATE TABLE
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
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
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
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 queries on the temp
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. Olson [EMAIL PROTECTED]
Cc
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
recreated
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 same
-
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?id=30513
). To summarize, a table which previously
: 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 TABLE IF EXISTS, becomes randomly unable to be recreated. Here
is my comment
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
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` varchar(128) NOT NULL,
`date_created` datetime NOT NULL,
`created_by` int(11) NOT NULL
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) NOT NULL,
`group_name` varchar(128) NOT NULL,
`date_created
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',
PRIMARY KEY
Do a show tables and see what is the actual table name.
I think group is a key work and hence its giving you the error.
See the table names in that database.
regards
anandkl
On 4/15/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi,
I have created a table name group.
CREATE TABLE
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
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. :)
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
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
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
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` (
- `carrier` varchar
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.
Restoring
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 NULL default
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 NULL default
Wish MySQL would have something like what Microsoft use, uniqueidentifier
as datatype.
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:
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:
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 KEY' ?
A PRIMARY KEY has nothing to do with the uniqueidentifier datatype
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
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 barcodes are not sequential
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 NOT NULL,
FOREIGN
. 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)
);
How do I make ID to start out as '0001' for UPC barcode
assignment?
UPC
: CREATE TABLE Inv_Id
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 barcodes
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
--
MySQL General
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 and ZEROFILL flags
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
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
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
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 No */
CRMIDint
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 null,
DeskNo int not null,
OrderDate
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
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 done
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
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 table command setting the engine
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
syntax
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 what I need. Thanks :-)
--
MySQL General
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 archives: http://lists.mysql.com
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 put CREATE TABLE IF NOT EXISTS. Any ideas?
Regards
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 already exists
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 INTEGER UNSIGNED NOT NULL,
sAdrBlock
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),
A_areaNum INTEGER
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:
On Thu, 20 Oct 2005, Atle Veka 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
, 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: quoted-printable
(I am using mysql-5.0.15-win32)
Why I am
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 issue
(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(1000
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. Is this by design, is it a
bug
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
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
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
Jigal van Hemert jigal at 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 bothering.
Best
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?
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',
ID_streettype_hosp CHAR(6
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) DEFAULT 'filler
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
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
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
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
1 - 100 of 378 matches
Mail list logo