The problem here though is that there is no MyTable. There are two
separate tables, Users and Actions, and I can't alter both of them in
the same statement, as far as I know. As a result, when I alter just
Users, that fails because there's an FK between Users and Actions and
the type of the two c
At 05:16 PM 2/24/2008, Waynn Lue wrote:
That's actually why I'm dropping/recreating, because I thought the
changes I have to make require multiple statements. Let me know if
that's a wrong assumption, here's what I have to do.
1. drop two foreign keys from Users to Actions (in the previous
exa
That's actually why I'm dropping/recreating, because I thought the
changes I have to make require multiple statements. Let me know if
that's a wrong assumption, here's what I have to do.
1. drop two foreign keys from Users to Actions (in the previous
example I gave).
2. expand INT to BIGINT on
At 05:55 AM 2/23/2008, Waynn Lue wrote:
I have three or four different ALTER TABLE commands I need to run on a
9 million row table (related to the previous email I sent). I've
tried running it before and it just takes way too long, so I was
thinking the fastest way to get this done is to create
I have three or four different ALTER TABLE commands I need to run on a
9 million row table (related to the previous email I sent). I've
tried running it before and it just takes way too long, so I was
thinking the fastest way to get this done is to create new tables with
the final schema, then dro
--no-data should do the trick, try to do mysqldump --help and read the
output
Xiaobo Chen wrote:
Hi, all
If I use 'mysqldump', I will get the script to create the tables and those
'insert' statements to insert the data.
I am wondering if I just want the first part, i.e, the script to create
t
You can do something like:
mysqldump --no-data
-Original Message-
From: Xiaobo Chen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 9:11 PM
To: mysql@lists.mysql.com
Subject: Just need script for creating tables
Hi, all
If I use 'mysqldump', I will get the script
On 6/21/06, Xiaobo Chen <[EMAIL PROTECTED]> wrote:
Hi, all
If I use 'mysqldump', I will get the script to create the tables and those
'insert' statements to insert the data.
I am wondering if I just want the first part, i.e, the script to create
the table, is there a command for this end? (I co
Hi, all
If I use 'mysqldump', I will get the script to create the tables and those
'insert' statements to insert the data.
I am wondering if I just want the first part, i.e, the script to create
the table, is there a command for this end? (I could copy & paste the part
from 'mysqldump' but it's n
Hi,
according to the manual:
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
150 is "a foreign key definition would be incorrectly formed for the
altered table"
/Johan
Joppe A wrote:
Hello all,
I have a problem with a script I have made, it always stops when it tries to creat
Hello all,
I have a problem with a script I have made, it always stops when it tries to
creat a special table, I have been comparing this part of the script with the
other parts that is working and cand find anything that looks wrong...
The message MySQL write is:
Can't create table './test_
Thanks so much for the tips! It's all falling into
place now.
I'm still using the animal database tables you
suggested for me some time ago, but I also wanted to
tap into this ITIS database. Combining or linking the
two should be interesting. :)
--- [EMAIL PROTECTED] wrote:
> I see you found som
I see you found some DB code for a different platform. Most of your
questions are based on the fact that these are NOT MySQL commands (or
scripts) but SQL statements phrased for a different system. If you know
what system it is designed for (Oracle, DB2. ??? ) you should be able to
read their d
I have some questions about some instructions for
recreating tables I'm trying to follow:
1. This first table is the simplest. The only thing I
don't understand is "serial." I created char and date
columns easily enough, but I don't see "serial" listed
in phpMyAdmin.
create table "itis".kingdoms
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Kutter wrote:
| I have a pre-compiled ODBC program that creates tables and expects them to
| be transaction-safe. I have set up the mysql-max server to support InnoDB
| tables. However, since the program knows nothing about InnoDB tables, it
I have a pre-compiled ODBC program that creates tables and expects them to
be transaction-safe. I have set up the mysql-max server to support InnoDB
tables. However, since the program knows nothing about InnoDB tables, it
creates normal tables and fails when it attempts a rollback. I can fix th
Well, that would depend if the SQL script generated by
your designer is compatible with MySQL, some type
names may be different.
Good Luck!
--- [EMAIL PROTECTED] wrote:
> I generated an SQL script of my datamodel in
> PowerDesigner which I'd like
> to import into mySql to create my tables, keys,
I generated an SQL script of my datamodel in PowerDesigner which I'd like
to import into mySql to create my tables, keys, etc. How do I accomplish
this?
Thanks,
Jason E. Brawner
-
Before posting, please check:
http://www
I generated an SQL script of my datamodel in PowerDesigner which I'd like
to import into mySql to create my tables, keys, etc. How do I accomplish
this?
Thanks,
Jason E. Brawner
-
Before posting, please check:
http://www.
Uma,
Friday, March 15, 2002, 2:10:50 PM, you wrote:
UST>Now i am struck up with one problem...When i am trying to create a
UST> table in the mysql database it is giving this error...Can anyone plese
UST> help me how to rectify this problem..
UST> ERROR 1: Can't create/write to file './dbase/r
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my t
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my ta
Thi Cao writes:
> All,
>
> Using MySQL++, how do you check to see whether or not a specific table exist
> before you go ahead and create it?
>
> TIA
>
> Thi
>
HI!
This has nothing to do with MySQL++.
Try to select count(*) from a table and if you get C++ exception with
a corresponding error
All,
Using MySQL++, how do you check to see whether or not a specific table exist
before you go ahead and create it?
TIA
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Hi,
I've been checking out MySQLGUI 1.7.5-2 for win 32. I've been able to
create a database, but, I can't seem to get it to create a table using
"Commands/Tables/Create tables".
Is it safe to assume that this is a know issue?
Thanks,
Steve.
--
indrek siitan writes:
> Hi,
>
> > SO this does seem like a bug .. hope MySql guys see this. I have
> > looked but can't find anything about how to contact in case of bugs ..
>
> mail to [EMAIL PROTECTED] :-)
er, [EMAIL PROTECTED]
--
For technical support contracts, visit https://order.mysql
At 11:17 AM -0700 9/14/01, Igbar Foosenhopper wrote:
>FYI ..
>
>I just tried this my self with
>
>CREATE TABLE 010823 (tstamp TIMESTAMP (14) ,
>name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name))
>
>and got ...
>
>MySQL said: You have an error in your SQL syntax nea
Hello,
On Fri, 14 Sep 2001, powlow wrote:
> fine. d122001 is also fine. is it not possible to create tables with only a
> number as the name? is there a way round this?
mysql> CREATE TABLE `123` (id INT);
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
++
| Tabl
Hi,
> SO this does seem like a bug .. hope MySql guys see this. I have
> looked but can't find anything about how to contact in case of bugs ..
mail to [EMAIL PROTECTED] :-)
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/
FYI ..
I just tried this my self with
CREATE TABLE 010823 (tstamp TIMESTAMP (14) ,
name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name))
and got ...
MySQL said: You have an error in your SQL syntax near '010823 (tstamp TIMESTAMP (14) ,
name VARCHAR (10) not null ,
At 6:39 PM +0100 9/14/01, powlow wrote:
>Hi,
>
>first posting to the list so hello. My name is Paulo. I live and work in
>lisbon, portugal.
>
>question : i want to create a table each month. want to call it somehting
>like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
>fin
powlow wrote:
> first posting to the list so hello. My name is Paulo. I live and work in
> lisbon, portugal.
>
> question : i want to create a table each month. want to call it somehting
> like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
> fine. d122001 is also fine. is
Hi,
first posting to the list so hello. My name is Paulo. I live and work in
lisbon, portugal.
question : i want to create a table each month. want to call it somehting
like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
fine. d122001 is also fine. is it not possible to c
Hi Srikanth
)-Original Message-
)From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 12:56 AM
)To: [EMAIL PROTECTED]
)Subject: I am facing problems in creating tables
)
)
)HI
)
)This is srikanth, and i am persuing my final semester of Masters
)in
HI
This is srikanth, and i am persuing my final semester of Masters in Computers
Applications in India,
I have been recently to you site on advice of one of my friend, and i have downloaded
your setup file from the net and installed the database and the odbc setup file both
in my c:\mysql di
Hello All
What is the best way to create table in a database under Win9X
Paul
[EMAIL PROTECTED]
Foreign keys are not supported.
> - Original Message -
> From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
> To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, May 19, 2001 9:59 PM
> Subject: Re: Foreign Ke
work.
- Original Message -
From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 9:59 PM
Subject: Re: Foreign Key in creating tables
> To infer without actual proof or evid
PROTECTED]>
Sent: Sunday, May 20, 2001 1:51 AM
Subject: Re: Foreign Key in creating tables
> Let me quote from that link:
> "The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do
> anything. The syntax for them is provided only for compatibility, to
> make it eas
t;Nisha Raju"
<[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 9:48 PM
Subject: Re: Foreign Key in creating tables
> seems like he hasn't read the question properly, check out this
answer that
> I got, which is what I needed:
>
&g
"Artem Koutchine" <[EMAIL PROTECTED]>
To: "Nisha Raju" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, May 20, 2001 1:31 AM
Subject: Re: Foreign Key in creating tables
> My appoligies. I probably was pissed off by the bunch of
> n
t;Artem Koutchine" <[EMAIL PROTECTED]>; "mysql"
<[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 9:14 PM
Subject: Re: Foreign Key in creating tables
>
> I wish we maintained some ethics in writing. Knowledge shouldn't
I wish we maintained some ethics in writing. Knowledge shouldn't make us
arrogant.
> RT-F***ING-M!
>
> No foreign keys in mysql!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
eless
unhelpful replies.
-Original Message-
From: Artem Koutchine [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 12:21 PM
To: Russell Teo Wee Liang; mysql mailing list
Subject:Re: Foreign Key in creating tables
RT-F***ING-M!
No foreign keys in mysql!
- Original Me
most sincerest apologies.
- Original Message -
From: "Bryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 20, 2001 12:36 AM
Subject: Re: Foreign Key in creating tables
> Actually it's RTFM
> No need to get international !!!
>
Foreign Key in creating tables
> RT-F***ING-M!
>
> No foreign keys in mysql!
>
> - Original Message -
> From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
> To: "mysql mailing list" <[EMAIL PROTECTED]>
> Sent: Saturday, May 19, 2001 8:03 P
<[EMAIL PROTECTED]>
To: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>; "mysql mailing list"
<[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 12:20 PM
Subject: Re: Foreign Key in creating tables
> RT-F***ING-M!
>
> No foreign keys in mysql!
>
>
RT-F***ING-M!
No foreign keys in mysql!
- Original Message -
From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
To: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 8:03 PM
Subject: Foreign Key in creating tables
Hi all,
I create
Hi all,
I create a sample database using foreign keys. However, when I did a mysqldump of the
database, the creation scripts gave no indication of the foreign keys in the first
place!
I am using mysql 3.23.33 on a FreeBSD 4.0-2626-STABLE .
Would very much appreciate some feedback or some
Thanks for the responses. Both those comments will no doubt help me
out next time. this time around, pathetically enough, it was bad
line breaks due to the fact I decompressed it on a mac and then
uploaded it.
how embarasskin.
MT
--
Hi,
mysql -vvv samp_db < create_member.sql
should tell what commands mysql is executing.
Regards
Quentin
-Original Message-
From: Michael Tuminello [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 February 2001 10:05
To: [EMAIL PROTECTED]
Subject: creating tables from the shell
is:
./bin/mysql samp_db
show tables;
and see if this doesn't output the member table that you are trying to
create from withing the .sql file.
> -Original Message-
> From: Michael Tuminello [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 4:05 PM
> To: [EMAI
Hey -
sorry for being too much of a pinhead to figure this out, but the
server is really not giving me too many clues to work with.
I'm trying to execute commands from the shell to create new tables
(I'm walking through the new riders book).
the book says % mysql samp_db < create_member.sql
ko Lehtme [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 8:36 AM
> To: [EMAIL PROTECTED]
> Subject: Error creating tables
>
>
> Can anyone help?
> In this script is one bug but i can't find it :(
>
> create table top(
> Id int(11) DEFAULT
---
I suppose that M and D is not optional parameters for NUMERIC type.
- Original Message -
From: Esko Lehtme <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:36 PM
Subject: Error creating tables
> Can anyone help?
> In
Can anyone help?
In this script is one bug but i can't find it :(
create table top(
Id int(11) DEFAULT '0' NOT NULL auto_increment,
nadalnumeric,
kuupaev DATE,
usa1 text,
usa2 text,
usa3 text,
usa4 text,
usa5 text,
I have exactly the same problem with the posting below, and I have already
searched the answered message. But I can't find it on the list message. Does
anybody know how to solve ? Sorry for my bad English... :)
Thank's
--Andy--
Subject: Troubles Accessing MySql Databases and Creat
57 matches
Mail list logo