Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Comparación de Collations general-spanish-latin en MySQL
drop table if exists CollationTest; create table CollationTest ( texto varchar(50) not null ); insert into CollationTest (texto) values ('lana'), ('llano'), ('lazy'), ('nora'), ('ñoño'), ('Manita'), ('Mamá'), ('gato'),('Güero'),('gusano'), ('cena'),('chino'),('cinco'); select texto as general from CollationTest order by texto collate utf8_general_ci; select texto as spanish from CollationTest order by texto collate utf8_spanish_ci; select texto as spanish2 from CollationTest order by texto collate utf8_spanish2_ci; drop table CollationTest;
run
|
edit
|
history
|
help
0
TEST
suraj222
gandu
mysql - where (in,like)
Mycreation
ITM_14210069
MYSQL PIVOT
compile visitors list for last 8 days
Práctica MySQL 1
mysql - having