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
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
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
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
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
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,
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
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 it
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
fine.
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 ,
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/
__ ___ ___ __
/ |/
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;
++
|
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 near '010823
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.com/
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
Hey -
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
16 matches
Mail list logo