Ask a question to Desklib · AI bot

Ask NowBETA

Dumping data for table 'ORDER' - mysql dump

12 Pages2020 Words492 Views
   

Added on  2019-09-21

About This Document

MySQL Practice Example: Part-1 | MySQL

BookmarkShareRelated Documents
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET AUTOCOMMIT = 0;START TRANSACTION;SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `shopping`---- ------------------------------------------------------------ Table structure for table `admin`--CREATE TABLE `admin` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
Dumping data for table 'ORDER' - mysql dump_1
2 `updationDate` varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `admin`--INSERT INTO `admin` (`id`, `username`, `password`, `creationDate`, `updationDate`) VALUES(1, 'admin', 'f925916e2754e5e03f75dd58a5733251', '2017-01-18 16:21:18', '21-06-2019 08:27:55 PM');-- ------------------------------------------------------------ Table structure for table `category`--CREATE TABLE `category` ( `id` int(11) NOT NULL, `categoryName` varchar(255) DEFAULT NULL, `categoryDescription` longtext, `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updationDate` varchar(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;--
Dumping data for table 'ORDER' - mysql dump_2
3-- Dumping data for table `category`--INSERT INTO `category` (`id`, `categoryName`, `categoryDescription`, `creationDate`, `updationDate`) VALUES(3, 'T-shirts', 'Testtees', '2018-01-10 19:17:37', '30-01-2020 12:22:24 AM'),(4, 'Full T-shirt', 'Electron like', '2017-01-08 19:19:32', '');-- ------------------------------------------------------------ Table structure for table `orders`--CREATE TABLE `orders` ( `id` int(11) NOT NULL, `userId` int(11) DEFAULT NULL, `productId` varchar(255) DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `orderDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paymentMethod` varchar(50) DEFAULT NULL, `orderStatus` varchar(55) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `orders`
Dumping data for table 'ORDER' - mysql dump_3
4--INSERT INTO `orders` (`id`, `userId`, `productId`, `quantity`, `orderDate`, `paymentMethod`, `orderStatus`) VALUES(9, 4, '21', 1, '2019-08-15 05:12:16', 'Internet Banking', NULL);-- ------------------------------------------------------------ Table structure for table `ordertrackhistory`--CREATE TABLE `ordertrackhistory` ( `id` int(11) NOT NULL, `orderId` int(11) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `remark` mediumtext, `postingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------------------------------------ Table structure for table `productreviews`--
Dumping data for table 'ORDER' - mysql dump_4

Found this document preview useful?

Related Documents
Database Management System
|19
|2055
|397

Database System: Entities, Attributes, Relationships, and Normalization
|19
|1425
|294

Data Modelling & Database Design tasks 2022
|10
|1825
|14