Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
new_road
CREATE TABLE new_road new_id INT(20) , name VARCHAR(40) , type VARCHAR(20) , sub_type VARCHAR(20) , pt POINT NOT NULL , SPATIAL INDEX(pt) ) ENGINE=InnoDB; INSERT INTO new_road (new_id, name, type, sub_type, pt) VALUES ('11','R-1', 'Shop', 'Cloth', Point(10,8)) , ('12', 'R-2','Cafe', '', Point(19,12)) ;
run
|
edit
|
history
|
help
0
Estudiantes
OK
test
TEST
Test for MySQL "serializable" transaction, part 2
Yta
collate reservations
filter the growth rate for current month
find tax rates for current time period
Get max score and the fields in the max score row in MySQL 5.7