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 schema
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 id
2012/9/10 Machiel Richards - Gmail
> 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!
Manuel.
*From: * Machiel Richards - Gmail ;
*To: * Ananda Kumar ;
*Cc: * ;
*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 selinux and disable it completely from installation.
I have
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 l
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 thro
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, forbi
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
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 cr
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 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 serv
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 1
> 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: http:
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 a
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 Richards
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
mailto:machiel.richa...@gmail.com>> wrote:
Hi, the sort_buffer_size was set
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:
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,
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
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 09/10/20
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 whi
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 serve
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 PM
2011/1/31 João Cândido de Souza Neto :
> 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 /etc/redhat-rel
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"" escreveu na mensagem
news:AANLkTimPVMS_e3dQyHS=bRyOy5WYp78hYhv6mN=2b.
Am 31.01.2011 13:34, schrieb M. Rodrigo Monteiro:
> 2011/1/31 João Cândido de Souza Neto :
>> 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 "skip-innodb"
'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 repli
rigo Monteiro wrote:
From: M. Rodrigo Monteiro
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 :
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) ENGINE=InnoDB;
>
I f
On Mon, Jan 31, 2011 at 09:39, Reindl Harald wrote:
> seems there is "skip-innodb" in your configuration
> what do "show engines;" say?
In my.cnf (comment)
#skip-innodb
mysql> show engines;
++-++--+--
what does 'show create table teste2" shows
2011/1/31 João Cândido de Souza Neto
> Please, give us some information about your server.
>
> --
> João Cândido de Souza Neto
>
> ""M. Rodrigo Monteiro"" escreveu na mensagem
> news:AANLkTikw2rDzhZU2+SmVeiPnVCYB-Q=vce5nufa7o...@mail.gmail.com...
>
Hi!
2011/1/31 João Cândido de Souza Neto :
> 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, not free as in free
CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;
--
João Cândido de Souza Neto
""M. Rodrigo Monteiro"" escreveu na mensagem
news:AANLkTikv4dtLTh+BMqxCwcCw5K59PU5W=zrt3j3th...@mail.gmail.com...
Hi!
I'm trying to create a InnoDB table.
CREATE TABLE `DAT
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';
+++-++--++-+-+--+-
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
null
>
> A Primary key constraint can be defined at various levels:
>
>* Primary key constraint defined at column level
> Syntax: () Primary Key
>* Primary key constraint defined at table level
> Syntax: Primary key (, )
>
Aren't those two alternate sy
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 use
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
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:
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 phpM
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` MEDIUMTE
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` INTEGE
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 conta
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.
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 do
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 mysql.func
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 |
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "mysql"
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
"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 differe
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 t
[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 SQ
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 of
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!
e
>
> "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 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]
> >
>
]
Subject: Re: Table creation Time stamp
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:
>
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 Gene
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
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]
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.
Ma
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 NU
--- 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,
> >
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 made
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:
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 ENROLLS
(
enrollmentID INT NOT NULL AUTO_INCREMENT,
courseID SMALLINT NOT NULL,
sectionID SM
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 char(
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
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
AIL PROTECTED]
> Sent: Thursday, August 05, 2004 1:15 PM
> To: Wheeler, Alex
> Cc: [EMAIL PROTECTED]
> 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
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 with a
Hello list:
Is it possible to create a table with a date column with current date as is
default value?, like curdate() or now() values?, any ideas.
- MySQL 3.23.58-Max-log
- RH. 7.3
Greetings and thanks in advanced
Mikel
_
Charla
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.
> 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?
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.co
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,
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,
;To: "Hans Nerdell" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: Re: table creation - arrays ?
> >Date: Sat, 14 Jun 2003 11:23:01 +0900
> >
> >I have read that Arrays are not coming before 5.0.
> >
> >have a look in the Documentation and the UC pr
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:25、Hans Nerdell さんは書きました:
> table creation - arrays ?
>
> how are rows as ARRAYS specified and created o
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
S
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
e 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 creation fails under NetBSD 1.6.
>
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
[EMAI
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:
http://www.mysql.
Original Message -
> From: "Chris 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 ha
ROTECTED]>
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
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 VARCHAR(50
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 t
At 11:21 -0400 8/13/02, [EMAIL PROTECTED] wrote:
>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
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 it's
Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TW>Description:
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 structur
>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 Sys
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 Bo
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..
---
> 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?d
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]
&g
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
inte
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 for tomorrow's world !
-
Before po
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
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 Explore
> I'm very new to mysql and adminstration of database software in
Have you tried phpMyAdmin to manage your db? Recommended:
http://www.phpwizard.net/projects/phpMyAdmin/
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683
ouldn't 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?
1 - 100 of 105 matches
Mail list logo
