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
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 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
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
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
Hey -
ok it looks like your funneling whatever query you have in create_member.sql
into mysql and executing it on the samp_db database. From your filename I'm
assuming that you have a "create table" query within create_member.sql. Is
the table not being created within samp_db?
Try this:
./bin/mysql s
18 matches
Mail list logo