Help: file write

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

The work seems to be simpler, if I use this query.

show create table 'table_name'

But I want to know feyd, is this the command you use to create table structures during backup?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I use DESCRIBE for various reasons.. like filtering certain things... Making sure the information comes out the way I want it to..
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

I was telling you earlier that I dont get information on the foreign keys using describe tables which says there are multiple keys available.

If you are not using 'show create table' then how do you extract foreign key information?

When you say filtering certain things, I would like to know them. When you are free, may be you can give a sample list of them.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I don't use foreign keys.. ever. Reason why: I have to support many databases. Some compromises have been done.
Post Reply