Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Sql
#MySQL 5.7.12 #please drop objects you've created at the end of the script #or check for their existance before creating #'\\' is a delimiter select version() as 'mysql version'; create table testutfxy(aspecialstring varchar(20)); insert into testutfxy values ('▲'); select * from testutfxy; create table testutfxz(aspecialstring varchar(20) CHARACTER SET utf8); insert into testutfxz values ('▲'); select * from testutfxz; create table testutfzz(aspecialstring varchar(20) CHARACTER SET utf8mb4 ); insert into testutfzz values ('▲'); select * from testutfzz; drop table testutfzz; drop table testutfxz; drop table testutfxy;
run
|
edit
|
history
|
help
1
MySQL : calculate overlapping periods
mysql - having
My tables
grre
media challenge response
compile visitors list for last 8 days
mywallpk
Closest companies
Srinivas
PBD