Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- CREATE TABLE `myguests` (
- `id` int(6) UNSIGNED NOT NULL,
- `firstname` varchar(30) NOT NULL,
- `lastname` varchar(30) NOT NULL,
- `email` varchar(50) DEFAULT NULL,
- `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `myguests` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES
- (1, 'Kishan', 'Patel', 'kishan@google.com', '2019-03-13 05:24:55'),
- (2, 'Jinal', '', 'jinal@google.com', '2019-03-15 09:06:45'),
- (3, 'Jinal', '.', 'jinal@google.com', '2019-03-15 09:08:01'),
- (4, 'Jinal', '.1', 'jinal@google.com', '2019-03-15 09:08:15'),
- (9, 'sudip ghosh', '.21', 'sudip@google.com', '2019-03-15 09:15:53'),
- (10, 'sudip ghosh', '21', 'sudip@google.com', '2019-03-15 09:16:24'),
- (11, 'sudip ghosh', '21', 'sudip@google.com', '2019-03-15 09:37:23'),
- (12, 'Kishan Patel', '21', 'kishan.237@gmail.com', '2019-03-15 09:37:37'),
- (13, 'Kishan Patel', '21', 'kishan.237@gmail.com', '2019-03-15 09:45:26'),
- (14, 'Kishan Patel', '21', 'kishan.237@gmail.com', '2019-03-15 09:45:35'),
- (15, 'Kishan Patel', '21', 'kishan.237@gmail.com', '2019-03-15 09:50:18'),
- (16, 'Kishan Patel', '21', 'kishan.237@gmail.com', '2019-03-15 09:51:23');
- ALTER TABLE `myguests`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `myguests`
- MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
- COMMIT;
Add Comment
Please, Sign In to add comment