search

ANSEHEN / ANSEHEN-CCTV-CLIENT

0 stars 0 forks source link

db #1

Open sungkyun88 opened 7 years ago

sungkyun88 commented 7 years ago

create database ansehen;

use ansehen;

create table USER_INFO_CCTV ( unique_key varchar(100) not null, image_add varchar(200) not null, primary key(unique_key) )ENGINE=InnoDB DEFAULT CHARSET=utf8;

show tables; ///////////////////////////// select * from USER_INFO_CCTV;

delete from USER_INFO_CCTV;

insert into USER_INFO_CCTV (unique_key,image_add) values ('123','123.jpg'); insert into USER_INFO_CCTV (unique_key,image_add) values ('%s','%s');
////////////////////////// mysql -u root -p

bitiotansehen

use ansehen;

EHKIM10 commented 7 years ago

create table CCTV_INFO ( cctv_id int not null, beacon_id varchar(40), ip_address varchar(40), location varchar(100), end varchar(200) not null, primary key(cctv_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8

EHKIM10 commented 7 years ago

insert into CCTV_INFO values (1,'1111','123.111.1.1','seoul'); insert into CCTV_INFO values (2,'2222','123.111.1.2','seoul'); insert into CCTV_INFO values (3,'3333','123.111.1.3','seoul');

sungkyun88 commented 7 years ago

create table CCTV_INFO ( cctv_id int not null, beacon_id varchar(40), ip_address varchar(40), location varchar(100), primary key(cctv_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8;