Alternatively you can use:
SHOW TABLE STATUS from name_db like '%part_of_table_name%';
to get a list of all fk constraints in the database that match
a certain string. It also gives some other interesting information.
As far as dependencies go you can see which table the constraint
references
On Fri, 27 Oct 2006, Ferindo Middleton wrote:
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have
On Wed, 25 Oct 2006, Paul DuBois wrote:
At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for some
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for something like "next" record.
Thanks,
Waldemar
--
MySQL General Mailing List
For list archives: http:/
RE orders.cust_id IS NULL;
Or am I missing something (as usual)?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Waldemar Jankowski [mailto:[EMAIL PROTECTED]
Sent: Friday, October
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
Ok. Just found I gave wrong info. To make my life easier, the person who
created db named cust_id in 'orders' table as SoldTo
[EMAIL PROTECTED]
in this case,
select cust_id from customers
where cust_id not in
(select Soldto from orders);
will no
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
hi to all,
I have table customers (PK cust_id)
I have table orders (PK order_id, FK cust_id)
I need query that will selecct all customers from 'customers' they don't
have any order, there is not their cust_id in 'orders'.
couls somebody help me?
t
