JWnZQcvJ

1CREATE TABLE admins (
2   id INT(11) NOT NULL AUTO_INCREMENT,
3   username VARCHAR 
4   username VARCHAR(50) NOT NULL,
5   hashed_password VARCHAR(60) NOT NULL,
6   PRIMARY KEY (id)
7);
8	
9shell> mysql db_name < text_file
10	
11CREATE TABLE admins (
12  id INT(11) NOT NULL AUTO_INCREMENT,
13  username VARCHAR(50) NOT NULL, 
14  hashed_password VARCHAR(60) NOT NULL, 
15  PRIMARY KAEY (id)
16);
17	
18USE dbgpon; IF EXISTS( SELECT `id` FROM `gpon` WHERE `ip` = '1.3.2.214' )
19THEN UPDATE `gpon` SET `hostname` = 'OLT-3F', `description` = 'VFNO2'
20WHERE `ip` = '10.3.26.214' ELSE INSERT INTO `gpon` (`ip`,`hostname`,`description`)
21VALUES ('1.3.2.214','OLT-3F','VFNO2') ;
22
23ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the
24manual that corresponds to your MariaDB server version for the right syntax to use
25near 'ELSE INSERT INTO `gpon` (`ip`,`hostname`,`description`) 
26VALUES ('1.3.2.214'' at line 4
27	
28USE dbgpon; INSERT INTO `gpon` (`ip`,`hostname`,`description`)
29VALUES ('1.3.2.214','OLT-3F','VFNO2')
30ON DUPLICATE KEY UPDATE `hostname` = 'OLT-3F', `description` = 'VFNO2';
31	
32CREATE TABLE `gpon` (
33`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
34`ip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
35`hostname` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
36`description` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
37PRIMARY KEY (`id`),
38UNIQUE KEY `gpon_UN` (`ip`)
39) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;