DIR : /home/kozerus/public_html/go/cr_kogo.sql

/home/kozerus/public_html/go

create table if not exists bhandi (
bhid varchar,
t varchar,
x varchar,
y varchar,
note varchar 
	);

create table if not exists players (
pid varchar,
dttm varchar,
status varchar,
addr varchar,
port varchar,
agent varchar,
note varchar
	);

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jkwii','20211211_1520','a','10-5-50-112','','moz01','note_jkwii' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'skwii','20211211_1521','a','10-5-50-122','','moz02','note_skwii' );


insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jk','20211211_1520','a','10-5-50-112','','moz01','note_jk' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'sk','20211211_1520','a','10-5-50-112','','moz01','note_sk' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jak1','20211211_1520','a','10-5-50-112','','moz01','note_jak1' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jak2','20211211_1520','a','10-5-50-112','','moz01','note_jak2' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jak3','20211211_1520','a','10-5-50-112','','moz01','note_jak3' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jh','20211211_1520','a','10-5-50-112','','moz01','note_jh' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'bc','20211211_1520','a','10-5-50-112','','moz01','note_bc' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'glen','20211211_1520','a','10-5-50-112','','moz01','note_glen' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'carter','20211211_1520','a','10-5-50-112','','moz01','note_carter' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'paityn','20211211_1520','a','10-5-50-112','','moz01','note_paityn' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'black','20211211_1520','a','10-5-50-112','','moz01','note_black' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jcm','20211211_1520','a','10-5-50-112','','moz01','note_jcm' );

insert into Players ('pid','dttm','status','addr','port','agent', 'note' )
values ( 'jam','20211211_1520','a','10-5-50-112','','moz01','note_jam' );