hi, habe hier en sql befehl, das er mir 2 tabellen erstellen soll...aber nachdem ich das eingegeben habe kommt zwar erfolgreich aber ich seh die tabellen net...wieso?
PHP:
217.175.244.50 # Generation Time: Apr 21, 2002 at 08:49 PM # Server
version: 3.23.39 # PHP Version: 4.0.6 # Database : `janinabook` # -
------------------------------------------------------- # # Table
structure for table `janinabook` # CREATE TABLE janinabook ( id
tinyint(4) NOT NULL auto_increment, name varchar(255) NOT NULL
default '', email varchar(255) NOT NULL default '0', wohnort varchar
(255) NOT NULL default '', eintrag text NOT NULL, homepage varchar
(255) NOT NULL default '0', icq varchar(15) NOT NULL default '0',
eintragzeit varchar(15) NOT NULL default '', ip varchar(255) NOT NULL
default '', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM; # # Dumping
data for table `janinabook` # # -----------------------------------
--------------------- # # Table structure for table `pipebooksmilies`
# CREATE TABLE pipebooksmilies ( id tinyint(4) NOT NULL
auto_increment, zeichen varchar(255) NOT NULL default '', url text
NOT NULL, PRIMARY KEY (id,zeichen), KEY zeichen (zeichen) )
TYPE=MyISAM; # # Dumping data for table `janinabooksmilies` # INSERT
INTO janinabooksmilies (id, zeichen, url) VALUES (1, ':)', 'images/smilies/smilies_smile.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (2, ':D', 'images/smilies/smilies_biggrin.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (3, ':??', 'images/smilies/smilies_konfus.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (4, '8-)', 'images/smilies/smilies_mrcool.gif'); INSERT INTO
janinaebooksmilies (id, zeichen, url) VALUES (5, ':-P', 'images/smilies/smilies_razzfatz.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (6, ':-(', 'images/smilies/smilies_sad.gif'); INSERT INTO janinabooksmilies
(id, zeichen, url) VALUES (7, ';-)', 'images/smilies/smilies_zwincker.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (8, ':hihi:', 'images/smilies/smilies_lol.gif'); INSERT INTO
janinabooksmilies (id, zeichen, url) VALUES (9, '=((', 'images/smilies/smilies_teufel.gif'); INSERT INTO janinabooksmilies (id, zeichen, url) VALUES (10, ':mad:', 'images/smilies/smilies_mad.gif');
Zuletzt bearbeitet: