Il cuore di un database

[MySql]

CREATE TABLE A_users_groups_users (
groupID int(11) NOT NULL default '0',
uid int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE o_users_groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(32) NOT NULL default '',
PRIMARY KEY (groupID)
) TYPE=MyISAM;
_

[lsu]

[pcosta]

Originally posted by MySql

CREATE TABLE A_users_groups_users (
groupID int(11) NOT NULL default '0',
uid int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE o_users_groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(32) NOT NULL default '',
PRIMARY KEY (groupID)
) TYPE=MyISAM;
_

select groupID, uid, groupName from A_users_groups_users, o_users_groups

Love is joining hearts

[Jaki]

Originally posted by MySql

CREATE TABLE A_users_groups_users (
groupID int(11) NOT NULL default '0',
uid int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE o_users_groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(32) NOT NULL default '',
PRIMARY KEY (groupID)
) TYPE=MyISAM;
_