https://www.niagahoster.co.id/blog/ghost-adalah/
#markdown #opensource #free #nodejs #cms #web #situs #ghost #install
#markdown #opensource #free #nodejs #cms #web #situs #ghost #install
Niagahoster Blog
Ghost CMS: Fitur, Kelebihan, dan Cara Installnya di cPanel Hosting
Ghost CMS adalah platform yang dirancang untuk blogging. Apa keunggulannya? Bagaimana cara install Ghost di cPanel hosting? Baca di sini!
https://matob.web.id/mengenal-ghost-org-penantang-baru-wordpress-di-dunia-cms/
#markdown #opensource #free #nodejs #cms #web #situs #ghost #install
#markdown #opensource #free #nodejs #cms #web #situs #ghost #install
Matob Creative
Mengenal Ghost CMS, Penantang baru Wordpress di Dunia CMS | Matob Creative
WordPress adalah salah satu sistem manajemen konten (CMS) paling populer di dunia. Menurut W3Techs , lebih dari 37% dari semua situs web didukung oleh
Power of IT-Bisa pinned «Tips n tricks DB: - Jangan join > 2 table - Klo join, pastiin type column, collation size sama as is - wildcard utk like, pakai HANYA dibelakang string - range ada start dan end... Jangan hanya > atau < aja - hindari kalkulasi where - hindari count distinct…»
SET @database = "kenzasto_db";
SET @charset = "utf8mb4";
SET @collate = "utf8mb4_general_ci";
SELECT "SET foreign_key_checks = 0;"
UNION ALL
SELECT concat(
"ALTER DATABASE `",
"` CHARACTER SET = ",
@charset,
" COLLATE = ",
@collate,
";"
) AS
AND (
OR
)
UNION ALL
SELECT concat(
"ALTER TABLE `",
"
"` CONVERT TO CHARACTER SET ",
@charset,
" COLLATE ",
@collate,
";"
) AS
AND
AND
UNION ALL
SELECT concat(
"ALTER TABLE `",
c.
"
c.
"
c.
"
c.
"` ",
c.
" CHARACTER SET ",
@charset,
" COLLATE ",
@collate,
if(c.
";"
) AS
WHERE c.
AND c.
'varchar',
'char',
'text',
'tinytext',
'mediumtext',
'longtext'
)
AND (
c.
AND t.
UNION ALL
SELECT "SET foreign_key_checks = 1;";
#collation #set #charset #mysql #database #data #base
SET @charset = "utf8mb4";
SET @collate = "utf8mb4_general_ci";
SELECT "SET foreign_key_checks = 0;"
UNION ALL
SELECT concat(
"ALTER DATABASE `",
SCHEMA_NAME,"` CHARACTER SET = ",
@charset,
" COLLATE = ",
@collate,
";"
) AS
sql
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME = @databaseAND (
DEFAULT_CHARACTER_SET_NAME <> @charsetOR
DEFAULT_COLLATION_NAME <> @collate)
UNION ALL
SELECT concat(
"ALTER TABLE `",
TABLE_SCHEMA,"
.",TABLE_NAME,"` CONVERT TO CHARACTER SET ",
@charset,
" COLLATE ",
@collate,
";"
) AS
sql
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = @databaseAND
TABLE_TYPE = "BASE TABLE"AND
TABLE_COLLATION <> @collateUNION ALL
SELECT concat(
"ALTER TABLE `",
c.
TABLE_SCHEMA,"
.",c.
TABLE_NAME,"
CHANGE ",c.
COLUMN_NAME,"
",c.
COLUMN_NAME,"` ",
c.
COLUMN_TYPE," CHARACTER SET ",
@charset,
" COLLATE ",
@collate,
if(c.
IS_NULLABLE="YES", " NULL", " NOT NULL"),";"
) AS
sql
FROM information_schema.COLUMNS c,information_schema.TABLES t,information_schema.COLLATION_CHARACTER_SET_APPLICABILITY aWHERE c.
TABLE_SCHEMA = t.TABLE_SCHEMA
AND c.TABLE_NAME = t.TABLE_NAME
AND t.TABLE_COLLATION = a.COLLATION_NAME
AND c.TABLE_SCHEMA = @databaseAND c.
DATA_TYPE IN ('varchar',
'char',
'text',
'tinytext',
'mediumtext',
'longtext'
)
AND (
c.
CHARACTER_SET_NAME <> a.CHARACTER_SET_NAME
OR c.COLLATION_NAME <> t.TABLE_COLLATION
)AND t.
TABLE_TYPE = "BASE TABLE"UNION ALL
SELECT "SET foreign_key_checks = 1;";
#collation #set #charset #mysql #database #data #base
https://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables-to-utf8mb4-in-mysql-5-5
#collation #set #charset #mysql #database
#collation #set #charset #mysql #database
Database Administrators Stack Exchange
How to easily convert utf8 tables to utf8mb4 in MySQL 5.5
I have a database which now needs to support 4 byte characters (Chinese). Luckily I already have MySQL 5.5 in production.
So I would just like to make all collations which are utf8_bin to utf8mb4_...
So I would just like to make all collations which are utf8_bin to utf8mb4_...
https://deals.majorgeeks.com/sales/full-stack-web-development-mastery-course-zero-to-hero-2022
#crack #software #aplikasi #murah #meriah #tutorial #belajar #web #stack #course #kursus #murmer
#crack #software #aplikasi #murah #meriah #tutorial #belajar #web #stack #course #kursus #murmer
Major Geeks
Full Stack Web Development MASTERY Course: Zero to Hero | Major Geeks
<p>Go From Zero to Full-Stack Hero as You Create Web Projects with JavaScript, CSS 3, Mongoose, & More</p>