Нещо немога да го разбера това MySQL

[esdione]

Има някой уроци който пише примерно добавете тази таблица в MySQL и как точно трябва да я добавя таблицата в MySQL ?

 

[emagi]

Просто дадения ти код го слагаш в един php файл и го стартираш (визуализираш)
Да кажем имаш следния пример:

CREATE TABLE `codes` (
`code` varchar(250) NOT NULL default ''
);

Този код ще ти създаде таблица с име codes, и в нея ще имаш едно поле с име code.
Този код ко копираш,слагаш го в един php документ, и со преглеждаш в брозъра.Ако си въвел правилно име на сървъра, потребителско име и парола, всичко ще е 6 точки.
Може да създадеш тази таблица, и като влезеш в phpmyadmin.Там всичко е графично, лесно се обслужва, има много документация

 

[FestarBG]

Чрез phpMyAdmin):

Като стигнеш до SQL просто копирай sql-a от урока.

 

[esdione]

Добре това как мога да го добавя в MySQL ?


#-----[ SQL ]------------------------------------------
#


INSERT INTO phpbb_config values ('nav_pic1', 'images/navpics/faq.GIF' );
INSERT INTO phpbb_config values ('nav_text1', 'FAQ' );
INSERT INTO phpbb_config values ('nav_link1', 'faq.php' );
INSERT INTO phpbb_config values ('nav_pic2', 'images/navpics/search.GIF' );
INSERT INTO phpbb_config values ('nav_text2', 'SEARCH' );
INSERT INTO phpbb_config values ('nav_link2', 'search.php' );
INSERT INTO phpbb_config values ('nav_pic3', 'images/navpics/memberlist.GIF' );
INSERT INTO phpbb_config values ('nav_text3', 'Member list' );
INSERT INTO phpbb_config values ('nav_link3', 'memberlist.php' );
INSERT INTO phpbb_config values ('nav_pic4', 'images/navpics/Usergroups.GIF' );
INSERT INTO phpbb_config values ('nav_text4', 'Usergroups ' );
INSERT INTO phpbb_config values ('nav_link4', 'groupcp.php' );
INSERT INTO phpbb_config values ('nav_pic5', 'images/navpics/Register.GIF' );
INSERT INTO phpbb_config values ('nav_text5', 'Register ' );
INSERT INTO phpbb_config values ('nav_link5', 'profile.php?mode=register' );
INSERT INTO phpbb_config values ('nav_pic6', '' );
INSERT INTO phpbb_config values ('nav_text6', '' );
INSERT INTO phpbb_config values ('nav_link6', '' );
INSERT INTO phpbb_config values ('nav_pic7', '' );
INSERT INTO phpbb_config values ('nav_text7', '' );
INSERT INTO phpbb_config values ('nav_link7', '' );
INSERT INTO phpbb_config values ('nav_pic8', 'images/navpics/Profile.GIF' );
INSERT INTO phpbb_config values ('nav_text8', 'Profile' );
INSERT INTO phpbb_config values ('nav_link8', 'profile.php?mode=editprofile' );
INSERT INTO phpbb_config values ('nav_pic9', '' );
INSERT INTO phpbb_config values ('nav_text9', '' );
INSERT INTO phpbb_config values ('nav_link9', '' );
INSERT INTO phpbb_config values ('nav_pic10', '' );
INSERT INTO phpbb_config values ('nav_text10', '' );
INSERT INTO phpbb_config values ('nav_link10', '' );
INSERT INTO phpbb_config values ('nav_pic11', '' );
INSERT INTO phpbb_config values ('nav_text11', '' );
INSERT INTO phpbb_config values ('nav_link11', '' );
INSERT INTO phpbb_config values ('nav_pic12', '' );
INSERT INTO phpbb_config values ('nav_text12', '' );
INSERT INTO phpbb_config values ('nav_link12', '' );
INSERT INTO phpbb_config values ('nav_pic13', '' );
INSERT INTO phpbb_config values ('nav_text13', '' );
INSERT INTO phpbb_config values ('nav_link13', '' );
INSERT INTO phpbb_config values ('nav_pic14', '' );
INSERT INTO phpbb_config values ('nav_text14', '' );
INSERT INTO phpbb_config values ('nav_link14', '' );
INSERT INTO phpbb_config values ('nav_h1', '12' );
INSERT INTO phpbb_config values ('nav_w1', '13' );
INSERT INTO phpbb_config values ('nav_h2', '12' );
INSERT INTO phpbb_config values ('nav_w2', '13' );
INSERT INTO phpbb_config values ('nav_h3', '12' );
INSERT INTO phpbb_config values ('nav_w3', '13' );
INSERT INTO phpbb_config values ('nav_h4', '12' );
INSERT INTO phpbb_config values ('nav_w4', '13' );
INSERT INTO phpbb_config values ('nav_h5', '12' );
INSERT INTO phpbb_config values ('nav_w5', '13' );
INSERT INTO phpbb_config values ('nav_h6', '12' );
INSERT INTO phpbb_config values ('nav_w6', '13' );
INSERT INTO phpbb_config values ('nav_h7', '12' );
INSERT INTO phpbb_config values ('nav_w7', '13' );
INSERT INTO phpbb_config values ('nav_h8', '12' );
INSERT INTO phpbb_config values ('nav_w8', '13' );
INSERT INTO phpbb_config values ('nav_h9', '12' );
INSERT INTO phpbb_config values ('nav_w9', '13' );
INSERT INTO phpbb_config values ('nav_h10', '12' );
INSERT INTO phpbb_config values ('nav_w10', '13' );
INSERT INTO phpbb_config values ('nav_h11', '12' );
INSERT INTO phpbb_config values ('nav_w11', '13' );
INSERT INTO phpbb_config values ('nav_h12', '12' );
INSERT INTO phpbb_config values ('nav_w12', '13' );
INSERT INTO phpbb_config values ('nav_h13', '12' );
INSERT INTO phpbb_config values ('nav_w13', '13' );
INSERT INTO phpbb_config values ('nav_h14', '12' );
INSERT INTO phpbb_config values ('nav_w14', '13' );
INSERT INTO phpbb_config values ('banner_source', 'images/banners/logo_phpBB.gif' );
INSERT INTO phpbb_config values ('banner_path', 'images/banners' );
INSERT INTO phpbb_config values ('banner_link', 'index.php' );
INSERT INTO phpbb_config values ('banner_cols', '2' );
INSERT INTO phpbb_config values ('banner_width', '200' );
INSERT INTO phpbb_config values ('banner_height', '91' );