MySQL葡萄树

今天是2018年6月11日,上午10点28分,现在开始尝试创建武汉叶子节点.

sql脚本语句:

#其余叶子节点分别是 lizhuangleaf01、zhoushanleaf02、leyanleaf03

create database wuhanleaf04; 

#共三张主表 undergraduate、postgraduate、ljdy

create table undergraduate(
    id int not null primary key auto_increment,
    timeofscene datetime,
    location text,
    person text,

    description text);

create table postgraduate(
    id int not null primary key auto_increment,
    timeofscene datetime,
    location text,
    person text,

    description text);

create table ljdy(
    id int not null primary key auto_increment,
    timeofscene datetime,
    location text,
    person text,

    description text);

# 举个例子，应该是当前map表单

create table ljdy20180611(
    currentdate date, 
    currenttime time,
    fragment text,
    description text);

# 插入记忆碎片

insert into ljdy20180611(currentdate,currenttime,fragment,description) 

value('2018-06-11','11:29:00',"java","learning scheme");

#打开sql更新开关

set sql_safe_updates = 0;

update ljdy20180611 set description='as a developer, you need to learn Java';