Varakorn Ungvichian wrote:
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
Varakorn Ungvichian wrote:
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but
now:
1. "Show Create Table" still doesn't show
reference
links, and
Well, of course not. It won't sh
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
>
> Varakorn Ungvichian wrote:
> > Just realised something: my table was MyIsam. I
> > switched it to InnoDB (which support FKs), but
> now:
> > 1. "Show Create Table" still doesn't show
> reference
> > links, and
>
> Well, of course not. It won't
Varakorn Ungvichian wrote:
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
Well, of course not. It won't show them until you create them, which you
haven't done according to #2.
2.
> Just realised something: my table was MyIsam. I
> switched it to InnoDB (which support FKs), but now:
> 1. "Show Create Table" still doesn't show reference
> links, and
> 2. I can't seem to make foreign keys, because it
> generates the error: "ERROR 1005: Can't create table
> '.\ltab\#sql-60c_1
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
2. I can't seem to make foreign keys, because it
generates the error: "ERROR 1005: Can't create table
'.\ltab\#sql-60c_11.frm' (errno: 1
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> The only way to do this is via
> SHOW CREATE TABLE
I've just tried the command in question, but here's
the result:
CREATE TABLE `employees` (
`employee_id` tinyint(4) NOT NULL auto_increment,
`employee_first` varchar(20) NOT NULL default '',
Hello,
> You can use:
>
> show create table employee;
>
> or
>
> show table status like 'employee';
> in the column "comment" you have the information you are looking for.
I don't think "comment" works properly - it's too small if you have
multiple foreign key constraints.
With regards,
Martijn
You can use:
show create table employee;
or
show table status like 'employee';
in the column "comment" you have the information you are looking for.
Marc.
-Message d'origine-
De : Varakorn Ungvichian [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 26 novembre 2004 09:32
À : [EMAIL PROTECT
> So, I'm running a MySQL database (version: 4.0.21) for
> a personal project of mine, and I would like to learn
> how to retrieve constraints and links from the table
> after it's been created. The create statements read
> thusly:
> When I run "show columns from employees", there is no
> indicat
