-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `reactdb`
--

-- --------------------------------------------------------

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` int(11) NOT NULL,
  `bookname` varchar(100) NOT NULL,
  `authorname` varchar(100) NOT NULL,
  `publication` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `bookname`, `authorname`, `publication`) VALUES
(1, 'HTML & CSS: Design and Build Web Sites', 'Jon Duckett', 'Apress'),
(2, 'JavaScript and JQuery: Interactive Front-End Web Development', 'David McFarland', 'dsd'),
(3, 'CSS Pocket Reference: Visual Presentation for the Web', 'Eric A. Meyer', 'xgg'),
(4, 'PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide', 'Larry Ullman', 'fghgjhgj'),
(5, 'Pro Angular 6', 'Adam Freeman', 'cvbcvb'),
(6, 'Beginning Laravel: A Beginner\'s Guide to Application Development with Laravel 5.3', 'Sanjib Sinha', 'hghjgj');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

