EXCELLENT! Thanks!
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 30, 2006 8:31 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: Need way to see all relations?
>
> Daevid,
>
> >I have a '
Daevid,
I have a 'users' table. And there are all kinds of related
tables like 'logs', 'preferences', etc. that all have a FK
reference back to this user ID.
I want to make a query or use some PHP to build a list of
all tables in my DB that are references.
Query to find tables with FK refere
Oh, InnoDB tables? I was assuming MyISAM tables.. :) And I'm not a
total expert, but that's my understanding.
Peter
On 6/30/06, Daevid Vincent <[EMAIL PROTECTED]> wrote:
That doesn't seem right. I know that MYISAM tables don't understand
relations, but INNODB tables
That doesn't seem right. I know that MYISAM tables don't understand
relations, but INNODB tables most certainly understand foreign key
constraints and in fact cause me a lot of grief sometimes when trying to
insert a record or create a new table that violates said constraints
That is, as far as I know, impossible. Mysql does not know which
tables are related to which ones.
Peter
On 6/30/06, Daevid Vincent <[EMAIL PROTECTED]> wrote:
Is there a way with InnoDB tables to see all related tables/columns?
Basically what I want to do is make a script that somehow will dyn
Is there a way with InnoDB tables to see all related tables/columns?
Basically what I want to do is make a script that somehow will dynamically
create a "backup" of a single user record. But I don't want to have to
manually add a new table or column everytime to the script.
So for example, I have
5.xx, which is not production ready yet.
"mel list_php" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to buil a hierarchical database, with different kind of relations.
> I have differents elements which are linked between them by different kinds
> of rel
Hi,
I want to buil a hierarchical database, with different kind of relations.
I have differents elements which are linked between them by different kinds
of relations.
Ex:
element 1 IS A element 72
element 22 IS PART OF element 36
I want to have a table "elements",for several
If by "relations" you mean "foreign keys" the answer is YES. Use the
InnoDB table type and read these instructions:
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Foreign_Keys.html
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
Don't forget to
Hello folks
Can I use or implement database relations in sql as some do in databases
in accecss..?
tommie
--
___
msc. tomas alberto ramirez.andujar
webmaster - cejisoft - +5332 262451 /261410
universidad pedagogica jose marti. camaguey
circunvalacion norte
'',
UNIQUE KEY idx1 (id)
) type MyISAM;
CREATE TABLE relations(
relation_id int(11) auto_increment,
location_id1 int(11) NOT NULL,
location_id2 int(12) NOT NULL,
distance float NOT NULL default '0',
UNIQUE KEY idx1 (location_id1, location_id
--- Adolfo Bello <[EMAIL PROTECTED]> wrote:
>
> > As far as I know and how I understand it, the relationships are basically
> all
> > in your head... You just have to coordinate it in your queries and other
> functions
>
> This is not true. Fot type innodb tables, you can define REFERENCES
> usin
> As far as I know and how I understand it, the relationships are basically all
> in your head... You just have to coordinate it in your queries and other functions
This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE
Ado
On Fri, Jan 10, 2003 at 04:54:14PM +0200, Octavian Rasnita wrote:
> Hi all,
>
> Is MySQL able (like MS Access) to define permanent relations between tables?
>
> For example, I want to define a master - child relation between 2 tables so
> when deleting some entries from t
--- Octavian Rasnita <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Is MySQL able (like MS Access) to define permanent relations between tables?
>
> For example, I want to define a master - child relation between 2 tables so
> when deleting some entries from the master table t
Octavian Rasnita wrote:
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without specifying this in
uestion about table relations and I would like you to help me.
> I have two tables in one server. The first tables has the following fiels:
> music_id; title; artist_id; chords
> The second one: artist_id; artist_name; country
>
> How can I JOIN this tables?? (I'm working in PHP,
On Friday 03 January 2003 11:57, Nuno Lopes wrote:
> I have a question about table relations and I would like you to help me.
> I have two tables in one server. The first tables has the following fiels:
> music_id; title; artist_id; chords
> The second one: artist_id; artist_name; cou
Hi everybody,
I have a question about table relations and I would like you to help me.
I have two tables in one server. The first tables has the following fiels:
music_id; title; artist_id; chords
The second one: artist_id; artist_name; country
How can I JOIN this tables?? (I'm working i
How can I set up mysql so as if the id of an entry from table 1 is
inserted in table 2 it will not allow me to delete the information in
table 1?
EX:
table1 holds the description of the products (table1_id is the primary
key of the table);
table2 holds the information about all the purchased p
Hi,
I'm having a problem as follows:
In my database (which just needs to work rather than be of commercial
quality) I have an orders table. Each order contains an order number and a
reference to ordered_items. Ordered_items table contains things like the
name of the product and the price.
Now
O' MyT SQL wizards!
I'm a total newbidiot w/ regard to MySql. I bought the O'Reilly
book and it's been a big help, but I have a problem that book
doesn't even gloss-over:
One table has a (large) list of developers (100,000+), each of
which can be a member of 0-5 project teams.
Another table is
Mohan;
I'm also new to this database administration and development. There are
some excellent tutorials at Devshed.com.
Below is a link to the tutorial on Database Normalization, I think this
will give you some answers to your query:
http://www.devshed.com/Server_Side/MySQL/Normal/
Joe
At 0
On Wed, 04 Jul 2001, Mohan Khurana wrote:
> database enthusiasts,
>
> I'm fairly new to database administration and development, I'm currently
> still learning about features of databases so that I can ensure that my
> design for the database that I create will be correct. I will be storing
> ge
database enthusiasts,
I'm fairly new to database administration and development, I'm currently
still learning about features of databases so that I can ensure that my
design for the database that I create will be correct. I will be storing
general pieces of information in an index table that wil
I am trying to do the same thing. The best bet so far is mysqldump.
You can find more detail in
http://www.sql.com/document and do search on mysqldump
Pär Lindhe wrote:
> Hello
>
> I need to migrate the structure of my MSSql database with its relations and
> tables to MYSql. Is
Hello
I need to migrate the structure of my MSSql database with its relations and
tables to MYSql. Is it possible? And how do i make that happen?
I have searched through a LOT of sites and forums on the internet but I have
not found the answer. Perhaps one of you know the answer?
Grateful
28 matches
Mail list logo
