View Single Post
Old 01-02-2013, 02:40 AM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,237
Thanks: 59
Thanked 3,998 Times in 3,967 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
What a *MESS*!

There is NO REASON AT ALL for you to have SO MANY TABLES!

*ALL ELEVEN OF THOSE TABLES* (from 'picture' through 'pic_j') should be in *ONE* TABLE!!!

PERIOD.

Code:
CREATE TABLE pictures (
    pic_letter CHAR(1),
    pic_id INT,
    pic_link VARCHAR(100),
    PRIMARY KEY (pic_letter, pic_id)
);
INSERT INTO pictures VALUES(' ',1,'1.jpg'),(' ',2,'2.jpg'), ...
INSERT INTO pictures VALUES('A',1,'a1.jpg'),('A',2,'A2.jpg'), ...
...
INSERT INTO pictures VALUES('J',1,'j1.jpg'),('J',2,'j2.jpg'), ...
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote