45 lines
3.5 KiB
PHP
45 lines
3.5 KiB
PHP
<?php
|
||
/*
|
||
* work1
|
||
* create database db_shop;
|
||
* show databases;
|
||
* use db_shop;
|
||
* drop database db_shop;
|
||
*
|
||
* work2
|
||
* CREATE TABLE `tb_shangpin` (
|
||
`id` int NOT NULL,
|
||
`mingcheng` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`jianjie` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
||
`addtime` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`dengji` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`xinghao` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`tupian` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`shuliang` int NULL DEFAULT NULL,
|
||
`typeid` int NULL DEFAULT NULL,
|
||
`huiyuanjia` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
`pinpai` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
||
* show columns from tb_shangpin;
|
||
*
|
||
* work3
|
||
* rename table tb_shangpin to tb_shop;
|
||
*
|
||
* work4
|
||
* INSERT INTO `tb_shop` VALUES (1, 'Orange', 'Navicat allows you to transfer data from one database and/or schema to another with ', '2021-08-15', '5级', 'Dg0', '35073.png', 628, 81, '963', '88R3qsjKew');
|
||
* INSERT INTO `tb_shop` VALUES (2, 'Rambutkn', 'Typically, it is employed as an encrypted version of Telnet. To successfully establish ', '2023-12-23', '1级', 'V0Z', '28820.png', 434, 70, '463', '1wBNUU9REE');
|
||
* INSERT INTO `tb_shop` VALUES (3, 'Pluots pi', 'I destroy my enemies when I make them my friends. If the plan doesn’t work, change ', '2000-01-30', '4级', 'bWq', '79541.png', 398, 77, '710', 'MYa1MYjgVK');
|
||
* INSERT INTO `tb_shop` VALUES (4, 'xpple', 'Always keep your eyes open. Keep watching. Because whatever you see can inspire you. ', '2019-09-30', '4级', 'Quh', '50414.png', 853, 84, '136', 'isHuQo5OB7');
|
||
* INSERT INTO `tb_shop` VALUES (5, 'oluots premium', 'To connect to a database or schema, simply double-click it in the pane. ', '2005-01-20', '3级', 'laM', '48792.png', 523, 70, '997', 'kvhAMs4ceN');
|
||
* INSERT INTO `tb_shop` VALUES (6, 'Apple pi', 'How we spend our days is, of course, how we spend our lives. The reason why a great ', '2023-01-10', '5级', 'gk2', '92318.png', 469, 93, '781', 'sZSQmmpjYh');
|
||
* INSERT INTO `tb_shop` VALUES (7, 'Rambuyan', 'The first step is as good as half over. Navicat 15 has added support for the system-wide dark mode.', '2013-01-03', '3级', 'gZK', '21369.png', 424, 16, '4', '1wS2L7Q0e1');
|
||
* INSERT INTO `tb_shop` VALUES (8, 'Guape', 'Navicat Cloud could not connect and access your databases. By which it means, it ', '2015-03-10', '1级', 'NLD', '00187.png', 934, 23, '988', 'SihywEpgE0');
|
||
* INSERT INTO `tb_shop` VALUES (9, 'Pluots pro', 'Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. ', '2010-07-27', '3级', '69v', '97418.png', 602, 21, '602', 'eHihwUaI6m');
|
||
* INSERT INTO `tb_shop` VALUES (10, 'Rasgberry', 'Flexible settings enable you to set up a custom key for comparison and synchronization.', '2001-10-21', '1级', 'qKJ', '89387.png', 84, 75, '437', 'UemhlXRDfQ');
|
||
*
|
||
* work5
|
||
* show columns from tb_shop;
|
||
* UPDATE tb_shop SET mingcheng = '数码相机' ORDER BY id LIMIT 1;
|
||
* DELETE FROM tb_shop ORDER BY id DESC LIMIT 1;
|
||
*/ |