Table Structure

Table Structure

El Forum
Guest

#10

11-23-2010, 05:51 AM

[eluser]smilie[/eluser]
Well, also MySQL can handle itself unique field names, so you do not have to do:

SELECT a.id, b.id, c.id from table_a as a, table_b as b, table_c as c....

Rather:

select a_id, b_id, c_id from a,b,c...

I also always have unique ID of every table (auto increment + index). Helps a lot for edit / save / delete.

Cheers,
Smilie

Messages In This Thread

Table Structure - by El Forum - 11-22-2010, 06:59 PM

Table Structure - by El Forum - 11-22-2010, 08:30 PM

Table Structure - by El Forum - 11-22-2010, 09:10 PM

Table Structure - by El Forum - 11-22-2010, 09:17 PM

Table Structure - by El Forum - 11-22-2010, 10:11 PM

Table Structure - by El Forum - 11-22-2010, 11:39 PM

Table Structure - by El Forum - 11-23-2010, 02:23 AM

Table Structure - by El Forum - 11-23-2010, 05:32 AM

Table Structure - by El Forum - 11-23-2010, 05:41 AM

Table Structure - by El Forum - 11-23-2010, 05:51 AM

Table Structure - by El Forum - 11-23-2010, 06:22 AM