Hi All
I am hoping someone can point me in the right direction.
We have a mysql 5.0 database which is giving us hassles when trying
to create a temporary table.
The creation works perfectly on the slave machine as well as all
our other db's, however on the one specific main
try this command and see if you can get more info about the error
show innodb status\G
On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi All
I am hoping someone can point me in the right direction.
We have a mysql 5.0 database which is
Hi
We tried that as well, however the databases are quite busy and
either other transactions overwrite the info, or there is nothing logged.
We even tried running the create statement and immediately running
Show innodb status, but nothing for that statement.
Regards
On
can you trying setting sort_buffer_size to big value at your session level
and create the table
On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi
We tried that as well, however the databases are quite busy and either
other transactions
Hi, the sort_buffer_size was set to 8Mb as well as 32M for the session
(currently 1M) and retried with same result.
On 09/10/2012 11:55 AM, Ananda Kumar wrote:
can you trying setting sort_buffer_size to big value at your session
level and create the table
On Mon, Sep 10, 2012 at 2:54 PM,
start with 500MB and try
On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi, the sort_buffer_size was set to 8Mb as well as 32M for the session
(currently 1M) and retried with same result.
On 09/10/2012 11:55 AM, Ananda Kumar wrote:
can
Hi,
still no luck, same error being given immediately after pressing
enter.
On 09/10/2012 12:02 PM, Ananda Kumar wrote:
start with 500MB and try
On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com mailto:machiel.richa...@gmail.com wrote:
Hi, the
Hi,
If you dont have data on the server, would you please initialize the data
directory.
Use mysql-install-db and give proper data directory and proper cnf file if
you are giving so.
Also specify the user as root if you have root access.
Thanks
On Mon, Sep 10, 2012 at 3:34 PM, Machiel
This is a current production database with about 100Gb + of data and the
DB is extremely busy.
On 09/10/2012 12:08 PM, Akshay Suryavanshi wrote:
Hi,
If you dont have data on the server, would you please initialize the
data directory.
Use mysql-install-db and give proper data directory
the message ERROR 1005 (HY000): Can't create table
'/tmp/#sql4a27_68eed1_0.frm' (errno: -1)
Basics first:
1) Is the /tmp directory write readable for the user mysql runs as?
2) Has the /tmp directory enough free space?
--
Rik Wasmus
--
MySQL General Mailing List
For list archives:
Hi,
We confirmed that the /tmp directory permissions is set to
rwxrwxrwxt and is owned by root , the same as all our other servers.
There is also about 60Gb of free space on the filesystem where /tmp
resides.
Regards
On 09/10/2012 01:11 PM, Rik Wasmus wrote:
the message ERROR
this temp table will hold how many rows, what would be its size.
On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi,
We confirmed that the /tmp directory permissions is set to rwxrwxrwxt
and is owned by root , the same as all our other servers.
Hi
at the moment this does not really matter to us.
we have even tried to create a temp table with only one field in
order to insert one row for testing, but we are currently not able to
create any temporary tables whatsoever as even the simplest form of
table still gives the same
did u check if there any firewall settings, forbidding you to create files,
check if SELinux is disabled
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi
at the moment this does not really matter to us.
we have even tried to create a
Hi,
If you can afford try changing the tmpdir for mysql. This is a static
variable and will require a mysql restart.
thanks
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
Hi
at the moment this does not really matter to us.
we have even
no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have also gone through the firewall settings and that is only rules
for connections.
On 09/10/2012 02:40 PM, Ananda Kumar wrote:
did u check if there any firewall settings,
please share the command ur using to create the temp table
On Mon, Sep 10, 2012 at 6:11 PM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have also gone through
Apologies if I missed this in the thread but have you confirmed not only the
effectve perms for the directory but that another user can write to this
dirrectory? Perhaps outside of mysql for instance; I.e. other processes are
successfully writting logs to /tmp? Anything to share from the mysql
*From: * Machiel Richards - Gmail machiel.richa...@gmail.com;
*To: * Ananda Kumar anan...@gmail.com;
*Cc: * mysql@lists.mysql.com;
*Subject: * Re: Temporary table creation fails
*Sent: * Mon, Sep 10, 2012 12:41:51 PM
no selinux , checked this as well.
We generally dont use
2012/9/10 Machiel Richards - Gmail machiel.richa...@gmail.com
Hi,
permissions are confirmed as being correct. Other applications and
users are currently writing files to this directory yes.
Have you tried su - mysql and touch /tmp/test? (if your mysql user has
shell...)
Good luck!
Not to beat the perms to death but /tmp should have the sticky bit set as
well... so 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS
unless this is production and u expect other DB's to be running... if u have
duplicated this DB schema somewhow by mistake and a second or first
On 9/10/2012 9:55 AM, Garot Conklin wrote:
Not to beat the perms to death but /tmp should have the sticky bit set as
well... so 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS
unless this is production and u expect other DB's to be running... if u have
duplicated this DB
Hi!
I'm trying to create a InnoDB table.
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) TYPE=InnoDB;
show table status from DATABASE like 'Teste2';
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;
--
João Cândido de Souza Neto
M. Rodrigo Monteiro fale...@rodrigomonteiro.net escreveu na mensagem
news:AANLkTikv4dtLTh+BMqxCwcCw5K59PU5W=zrt3j3th...@mail.gmail.com...
Hi!
I'm trying to create a InnoDB
Hi!
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;
I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.
Regards,
Rodrigo.
--
M. Rodrigo Monteiro
Free as in Freedom,
what does 'show create table teste2 shows
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br
Please, give us some information about your server.
--
João Cândido de Souza Neto
M. Rodrigo Monteiro fale...@rodrigomonteiro.net escreveu na mensagem
On Mon, Jan 31, 2011 at 09:39, Reindl Harald h.rei...@thelounge.net wrote:
seems there is skip-innodb in your configuration
what do show engines; say?
In my.cnf (comment)
#skip-innodb
mysql show engines;
...@rodrigomonteiro.net wrote:
From: M. Rodrigo Monteiro fale...@rodrigomonteiro.net
Subject: Re: Table creation
To: mysql@lists.mysql.com
Date: Monday, January 31, 2011, 10:34 AM
Hi!
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2
'TYPE' is deprecated since long time ago and should be
replaced everywhere with 'ENGINE'
with mysql 5.5 'TYPE' is a hard error which can be problematic
if running statement-based replication with a 5.1 master
and 5.5 slave because the master writes the statement to
binlog and slave will stop
Am 31.01.2011 13:34, schrieb M. Rodrigo Monteiro:
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;
I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.
seems there is
I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was
disabled by default so you must be almost a PhD to enable it.
What about updating server?
--
João Cândido de Souza Neto
M. Rodrigo Monteiro fale...@rodrigomonteiro.net escreveu na mensagem
2011/1/31 João Cândido de Souza Neto j...@consultorweb.cnt.br:
I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was
disabled by default so you must be almost a PhD to enable it.
But the version of MySQL is 5.1 as you can see below...
What about updating server?
# cat
Hi,
You should check your error logs for innodb errors, there will be the
key to the solution. If you want to avoid this behaviour, you can set
innodb=force in your configuration file to make innodb error fatal, or
set sql_mode to 'NO_ENGINE_SUBSTITUTION'.
Peter Boros
On 01/31/2011 08:21
Correct,
a primary key is used to uniquely identify each row in a table. It can
either be part of the actual record itself , or it can be an artificial
field (one that has nothing to do with the actual record).
A primary key can consist of one or more fields on a table. When multiple
fields are
A Primary key constraint can be defined at various levels:
* Primary key constraint defined at column level
Syntax: Column Name datatype(size) Primary Key
* Primary key constraint defined at table level
Syntax: Primary key (Column Name, Column
Yes, but few exceptions;
Column level constraints are applicable to that column only, whereas table
level constraints are used to define composite keys like primary key for the
combination of two or more columns in a table.
column level constraints contain all types of constraints (like, not
Hi David, all!
David Stoltz wrote:
Actually,
That table isn't supposed to have a PK, so I removed that, and it
works...same effect you suggested.
Even if you currently don't need a primary key in that table, IMO you
should still define one. Use some 'id_testresult' column with an
Hi Folks,
I use an online SQL Design tool to design my tables, etc. This generates
script code that I can run in phpMySQL to create the tables, etc.
The below code is causing an error - see below:
CREATE TABLE `testresults` (
`id_employees` INTEGER DEFAULT NULL ,
`id_test_test`
Hi,
default cannot be used with primary key.
mysql CREATE TABLE `testresults` (
-
- `id_employees` INTEGER DEFAULT NULL ,
- `id_test_test` INTEGER DEFAULT NULL ,
- `testdate` DATE DEFAULT NULL ,
- `result` VARCHAR( 10 ) DEFAULT NULL ,
- `resultsdescription` MEDIUMTEXT
David,
You did not define a primary key for the table.
The PRIMARY KEY ( ) is expecting a column name inside the ( )
Mike
At 11:21 AM 6/23/2010, David Stoltz wrote:
Hi Folks,
I use an online SQL Design tool to design my tables, etc. This generates
script code that I can run in
Actually,
That table isn't supposed to have a PK, so I removed that, and it
works...same effect you suggested.
Thanks!
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Wednesday, June 23, 2010 12:29 PM
To: David Stoltz
Cc: mysql@lists.mysql.com
Subject: Re: Table
Depending on the version you use MySQL will see a definition of
varchar(25) as 25 bytes or 25 characters. I believe this changed from
4.1 to 5.0 respectively but I am not sure.
THis could be the root of the problem
Boyd
CONFIDENTIALITY NOTICE: This email attached documents may
On 3/26/07, Anil D [EMAIL PROTECTED] wrote:
Varchar = 0 bytes
I don't think this is right, see below.
Charset used: UTF8
UTF8 means that some characters may be two bytes, see below.
Note: When consider even the size Varchar(m) = m+1 bytes, the size of row
has reached 35,000 bytes.
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What does
describe
sheeri kritzer wrote:
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What
I've just noticed in one of my databases a table named 'func', which I'm
positive I never created.
It was empty and has 4 columns:
mysql describe func;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Can anyone help me with an InnoDB problem?
I am trying to create a sequence of related tables using InnoDB but I'm not
having a lot of luck. The script I'm running would work fine in DB2 but the
rules are obviously different in MySQL. I'm hoping someone can tell me how
to modify my script so
Rhino [EMAIL PROTECTED] wrote on 01/16/2006 10:30:33 AM:
Can anyone help me with an InnoDB problem?
I am trying to create a sequence of related tables using InnoDB but I'm
not
having a lot of luck. The script I'm running would work fine in DB2 but
the
rules are obviously different in
- Original Message -
From: [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Monday, January 16, 2006 10:54 AM
Subject: Re: InnoDB table creation sequence
Rhino [EMAIL PROTECTED] wrote on 01/16/2006 10:30:33 AM:
Can anyone help me with an InnoDB
Hello all at mysql,
Are there tools available to automatically generate database (tables) creation
code starting from some grafical description of data... maybe it's a crazy idea
but I think it makes sense...
maybe: ER Diagrams to SQL
or:Object Diagrams to SQL
anything based on some kind
[EMAIL PROTECTED] wrote:
Hello all at mysql,
Are there tools available to automatically generate database (tables) creation
code starting from some grafical description of data... maybe it's a crazy idea
but I think it makes sense...
maybe: ER Diagrams to SQL
or:Object Diagrams to SQL
Hi!
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 13, 2004 6:43 PM
Subject: RE: Table creation Time stamp
--=_alternative 005527E185256F2C_=
Content-Type: text/plain; charset=US-ASCII
By Jove! you are right! Sorry! I can't
Hi,
where can we find the time stamp of table creation i.e when that table was
created
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
use the command: SHOW TABLE STATUS
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Anil Doppalapudi [EMAIL PROTECTED] wrote on 10/13/2004
10:42:11 AM:
Hi,
where can we find the time stamp of table creation i.e
SHOW TABLE STATUS LIKE 'your_table_name';
See the manual for details
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html.
Michael
Anil Doppalapudi wrote:
Hi,
where can we find the time stamp of table creation i.e when that table was
created
Thanks
Anil
DBA
--
MySQL General Mailing List
and not for InnoDB table
type. where can we find for Innodb Table type
Thanks
Anil
DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 8:18 PM
To: Anil Doppalapudi
Cc: [EMAIL PROTECTED]
Subject: Re: Table creation Time stamp
Hi Michael,
I made some changes to the sql statments to create the
ENROLLS table as follows:
CREATE TABLE ENROLLS
(courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
studentID SMALLINT NOT NULL,
grade SMALLINT)TYPE=INNODB;
PRIMARY KEY(courseID,sectionID,studentID),
INDEX(courseID),
FOREIGN
Mulugeta Maru wrote:
Hi Michael,
I made some changes to the sql statments to create the
ENROLLS table as follows:
CREATE TABLE ENROLLS
(
courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
studentID SMALLINT NOT NULL,
grade SMALLINT)TYPE=INNODB;
^
You
--- Michael Stassen [EMAIL PROTECTED]
wrote:
Mulugeta Maru wrote:
Hi Michael,
I made some changes to the sql statments to create
the
ENROLLS table as follows:
CREATE TABLE ENROLLS
(
courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
studentID SMALLINT NOT
Mulugeta Maru wrote:
--- Michael Stassen [EMAIL PROTECTED] wrote:
Mulugeta Maru wrote:
Hi Michael,
I made some changes to the sql statments to create the
ENROLLS table as follows:
** Did you read this part? **
CREATE TABLE ENROLLS
(
courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT
I am sorry. I did not remove TYPE=INNODB in the middle
of the statment. You are right. I am now getting a
different error message;
ERROR 1005 at line 33: Can't creat table
'.\enrollment1\enrolls.frm' (errno: 150)
All the tables except enrolls is created. What am I
doing wrong again?
Regards.
I was able to create all the tables below except
ENROLLS. Can anyone please help me what is wrong in my
syntax in the section that faild to create the ENROLLS
table.
CREATE TABLE STUDENTS
(studentID SMALLINT NOT NULL,
student_name char(18),
address char(20),
city char(10),
state char(2),
zip
Mulugeta Maru wrote:
I was able to create all the tables below except
ENROLLS. Can anyone please help me what is wrong in my
syntax in the section that faild to create the ENROLLS
table.
snip
CREATE TABLE ENROLLS
(
enrollmentID INT NOT NULL AUTO_INCREMENT,
courseID SMALLINT NOT NULL,
When executing:
CREATE TEMPORARY TABLE temp_1 AS
SELECT * FROM table_name
Is it possible to indicate an index within the syntax of this statement - as
opposed to issuing an ALTER TABLE command after the table is created?
Thanks in advance for any help.
--
MySQL General Mailing List
For
during TEMPORARY table creation
When executing:
CREATE TEMPORARY TABLE temp_1 AS
SELECT * FROM table_name
Is it possible to indicate an index within the syntax of this statement
- as
opposed to issuing an ALTER TABLE command after the table is created?
Thanks in advance for any help
]
Subject: Re: Nodes crash on table creation
Hi Alex,
I tried a similar configuration with all nodes on the same computer and
that worked fine.
Please provide the trace file in some manner and I'll check it once
more.
The other nodes fail since there is only one replica and thus when one
node
Create the column as a timestamp and the column will be updated on insert
and update.
-Original Message-
From: Mikel - [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: table creation
Hello list:
Is it possible to create a table
What is wrong with this table creation
CREATE TABLE `spid_1__0` (
`recordname` varchar(255) NOT NULL default '',
`data` enum NOT NULL,
PRIMARY KEY (`recordname`,`data`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
What is wrong with this table creation
CREATE TABLE `spid_1__0` (
`recordname` varchar(255) NOT NULL default '',
`data` enum NOT NULL,
PRIMARY KEY (`recordname`,`data`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
What is the specific error you are getting?
W/o knowing that information, I
In the last episode (Nov 06), Arnoldus Th.J. Koeleman said:
What is wrong with this table creation
CREATE TABLE `spid_1__0` (
`recordname` varchar(255) NOT NULL default '',
`data` enum NOT NULL,
You didn't specify the values for your enum type. When you post
questions like this, it's
Hi,
I've three tables that my local MySQL server accepts, but when I try to
create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
u_uname VARCHAR(20) NOT NULL UNIQUE,
At 18:11 +0200 6/28/03, anders thoresson wrote:
Hi,
I've three tables that my local MySQL server accepts, but when I try
to create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
a bit between the lines and you will find it ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003 6 16 01:19:
thanks for the info !
wbrgds
Hans
From: Nils Valentin [EMAIL PROTECTED]
To: Hans Nerdell [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: table creation - arrays ?
Date: Sat, 14 Jun
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
_
Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer
--
MySQL General Mailing List
For list archives: http
Arrays are not currently supported in any production-release versions of MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Hans Nerdell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 09:25
Subject: table creation - arrays
I have read that Arrays are not coming before 5.0.
have a look in the Documentation and the UC presentations.
Best regards
NIls Valentin
Tokyo/Japan
2003 6 10 22:25Hans Nerdell :
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
even compile,
due to configuration problems where the include directory for
mit-pthreads is missed.
Fix:
Don't use BDB tables. No work around known.
Submitter-Id: Resun2003001
Originator:Don Phillips
Organization:
MySQL support: none
Synopsis: BDB table
well i think i have everything how i want it.. but now i need to add a
column to one of my tables.. and i can't find it in the mysql manual.
anyone know how?
thanks,
Brendan.
-
Before posting, please check:
In the last episode (Dec 02), Brendan Mansell said:
well i think i have everything how i want it.. but now i need to add a
column to one of my tables.. and i can't find it in the mysql manual.
anyone know how?
http://www.mysql.com/doc/en/ALTER_TABLE.html
--
Dan Nelson
[EMAIL
PROTECTED]
To: "kayamboo" [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 5:35 PM
Subject: Re: table creation error with innodb/ sql,query
InnoDB requires that you have an index on both ends of a foreign key
constraint. Thus, you need to index the "type" field of the pers
Tucker [EMAIL PROTECTED]
To: kayamboo [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 5:35 PM
Subject: Re: table creation error with innodb/ sql,query
InnoDB requires that you have an index on both ends of a foreign key
constraint. Thus, you need to index the type field of the person
Hello experts
I am trying to create innodb tables with foreign key relations but I get
error 150 meaning that foregin key constraint can't be established.
Here are the statements
1.CREATE TABLE relation( type VARCHAR(50) NOT NULL PRIMARY KEY)TYPE =
INNODB;
2.CREATE TABLE person( name
I am using MySQL version 3.23.33
I was just playing around showing some one here at work some things when I
accidently created a table named '44'. The server allowed me to do so -
but will now not enable me to rename or drop the table (or add data to it
for that matter). Here is a dump of
Robert,
Tuesday, August 13, 2002, 6:21:08 PM, you wrote:
R I am using MySQL version 3.23.33
R I was just playing around showing some one here at work some things when I
R accidently created a table named '44'. The server allowed me to do so -
R but will now not enable me to rename or drop the
Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TWDescription:
TW When dumping the 'mysql' database, the dump file contains syntax errors,
TW and I can't find where this has been rectified in later releases.
TW Example dump using 'mysqldump -cl mysql':
TW [snip]#
TW # Table structure for
Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default '',
Davis, Charles M writes:
Hello,
I downloaded the beta version of MySQLGUI and was unable to perform any
table creation. Is this feature currently not supported?
Thanks,
Charles
Charles Davis
Member Engineering Staff, Data Analysis Systems
Lockheed Martin - Naval Electronics
Hello,
I downloaded the beta version of MySQLGUI and was unable to perform any
table creation. Is this feature currently not supported?
Thanks,
Charles
Charles Davis
Member Engineering Staff, Data Analysis Systems
Lockheed Martin - Naval Electronics Surveillance Systems
MS 530-2, 199 Borton
hi,
I am not able to create the third table i.e. AUTHENTICATE, In the first
two tables I have no problem ( i.e. DOMAIN and USER), I am giving you
the structure of all the three table along with the error i am getting..
I am not able to find out the mistake have done, please, help me..
Calvin Chin writes:
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
http://www.mysql.com/downloads/index.html
I use phpMyAdmin which is a neat web tool that works with most
browsers (requires frames and tables). You might be more
interested
Have a look at urSQL -- http://www.urbanresearch.com/ursql
On Fri, 21 Sep 2001, Calvin Chin wrote:
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
Thank you.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
Here is an ERD based tool with full support for MySQL. Versions for various platforms
including Linux and Windows
http://www.thekompany.com/products/dataarchitect/index.php3?dhtml_ok=1
Peter
be embedded into my applications on connection
statements to the mysql server, right?
The other question I have involves table creation, let's say I create a
table, is it easy to add more fields to that table with mysql? Are there
any problems associated with performing this task?
Does anyone have any
Hi,
I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98,
I seem to be missing components?
1. I can only create Databases not Tables?
2. I'm don't know which source editor/compiler I can use?
Can anyone help?
Thanks.Get more from the Web. FREE MSN
Please, go through the manual found at http://www.mysql.com
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Richard Bergeron wrote:
Hi,
I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98,
I seem to
can someone tell me what I'm doing wrong here?I keep getting the error
You have an error in your SQL syntax near 'describe text, fulltext text,
section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6 and I don't
understand why:
CREATE TABLE article(
id INT (4) DEFAULT '0' NOT NULL
]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 4:52 PM
Subject: Table Creation woes
can someone tell me what I'm doing wrong here?I keep getting the error
You have an error in your SQL syntax near 'describe text, fulltext text,
section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6
describe is a reserved word and so is fulltext, I think.
- Original Message -
From: Matt TrollBoy Wiseman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 5:52
Subject: Table Creation woes
can someone tell me what I'm doing wrong here?I keep getting the error
At 5:52 PM -0400 6/6/01, Matt \TrollBoy\ Wiseman wrote:
can someone tell me what I'm doing wrong here?I keep getting the error
You have an error in your SQL syntax near 'describe text, fulltext text,
section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6 and I don't
understand why:
99 matches
Mail list logo