Hi Toa Sty
here the comman explain :
table type possible_keys key key_len ref rows Extra
Co ALL NULL NULL NULL NULL 458 Using temporary; Using filesort
Pl ALL NULL NULL NULL NULL 768
A eq_ref PRIMARY PRIMARY 4 Co.id 1
P ALL NULL NULL NULL NULL 768 where used
C eq_ref PRIMARY PRIMARY 4 P.id_audio 1 where used
Cs eq_ref PRIMARY PRIMARY 4 C.id_support 1
U eq_ref PRIMARY PRIMARY 4 P.id_user 1 where used
output for show table:
Table Create Table
playlist_user CREATE TABLE `playlist_user` (
`id_playlist` int(5) NOT NULL auto_increment,
`id_user` int(5) NOT NULL default '0',
`id_audio` int(5) NOT NULL default '0',
`date_playlist` date NOT NULL default '0000-00-00',
`note_audio` char(1) NOT NULL default '',
PRIMARY KEY (`id_playlist`)
) TYPE=MyISAM
catalogue_audio CREATE TABLE `catalogue_audio` (
`id_audio` int(5) NOT NULL auto_increment,
`id_artiste` int(5) NOT NULL default '0',
`id_support` int(5) NOT NULL default '0',
`nom_audio` varchar(255) NOT NULL default '',
`prix_audio` decimal(4,2) NOT NULL default '0.00',
`genre_audio` varchar(8) NOT NULL default '',
`urlMp3` varchar(255) NOT NULL default '',
`online` char(3) NOT NULL default '',
PRIMARY KEY (`id_audio`)
) TYPE=MyISAM
catalogue_support CREATE TABLE `catalogue_support` (
`id_support` int(5) NOT NULL auto_increment,
`id_artiste` int(5) NOT NULL default '0',
`titre_support` varchar(255) NOT NULL default '',
`label_support` varchar(255) NOT NULL default '',
`annee_support` varchar(4) NOT NULL default '',
`cover_support` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_support`)
) TYPE=MyISAM
artistes CREATE TABLE `artistes` (
`id_artiste` int(11) NOT NULL auto_increment,
`nom_artiste` varchar(255) NOT NULL default '',
`site_artiste` varchar(255) NOT NULL default '',
`description_artiste` varchar(255) NOT NULL default '',
`bio_artiste` longtext NOT NULL,
`genre_artiste` varchar(8) NOT NULL default '',
`typeCompte_artistique` int(1) NOT NULL default '0',
`typeContrat_artiste` int(1) NOT NULL default '0',
`sacem_artiste` int(1) NOT NULL default '0',
`inscription_artiste` varchar(20) NOT NULL default '0',
`urlMp3_artiste` varchar(255) NOT NULL default '',
`uploadMp3_artiste` varchar(255) NOT NULL default '',
`online` char(3) NOT NULL default 'non',
PRIMARY KEY (`id_artiste`)
) TYPE=MyISAM
comptes CREATE TABLE `comptes` (
`id_compte` int(5) NOT NULL auto_increment,
`nom_compte` varchar(255) NOT NULL default '',
`email_compte` varchar(255) NOT NULL default '',
`pass_compte` varchar(32) NOT NULL default '',
`type_compte` int(1) NOT NULL default '1',
`url` varchar(255) NOT NULL default '',
`id` int(5) NOT NULL default '0',
`dateInscription_compte` date NOT NULL default '0000-00-00',
`avatar_compte` varchar(255) NOT NULL default '',
`last_connexion` timestamp(14) NOT NULL,
`online` char(3) NOT NULL default 'oui',
PRIMARY KEY (`id_compte`)
) TYPE=MyISAM
Thank for your help