| | CREATE TABLE `author` (
`ID_author` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`surname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID_author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=160 ;
-----------------------------------------
INSERT INTO `author` (`ID_author`, `name`, `surname`) VALUES
(1, 'Vilhelms', 'Smids'),
(2, 'Makss', 'Selers'),
(3, 'Fridrihs', 'Sellings'),
(4, 'Toms', 'Louensteins'),
(5, 'Deivids', 'Ross'),
(6, 'Fridrihs', 'Nice'),
(7, 'Vija', 'Ancane'),
(8, 'Arija', 'Elksne'),
(9, 'Eriks', 'Kulis'),
(10, 'Janis', 'Jaunsudrabins');
-------------------------------------------------------------
Структура таблицы `books`
--
CREATE TABLE `books` (
`ID_books` int(5) unsigned NOT NULL AUTO_INCREMENT,
`books_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`author` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
`publisher` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`price` double NOT NULL,
`topic` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`subsection` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`category` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`the keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID_books`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
Vopros:==> kak sdelatj ctobi v table BOOKS, gde author ne vpisivatj dannie, a bratj iz table AUTHOR.?????? | |
