How can I select all tables in a database?

Antonio878

Master Sergeant

Join Date: Sep 2007

Posts: 68
- Share
- Tweet
#1

How can I select all tables in a database?

08-07-2008, 04:04 AM

I want to select all the tables in my database but i don't know how to, can someone please help me be able to select all tables in the database:

mysql_query("UPDATE table SET bones = 'name'

Check out:
Great Windmill (A Place Where You Can Have Fun!)

You can do so much on the website, check it out!
Tags: None
navaldesign

General & Forum Moderator

Join Date: Oct 2005

Posts: 12080
- Share
- Tweet
#2

08-07-2008, 11:42 PM

Re: How can I select all tables in a database?

You can't. You need to repeat the query for all tables, one at a time.

Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!
Comment

Announcement