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>
https://www.youtube.com/watch?v=hDJdkcdG1iA
#bi #business #intelligence #market #sales #sale #market #marketing #youtube #tutorial #sinau #belajar
#bi #business #intelligence #market #sales #sale #market #marketing #youtube #tutorial #sinau #belajar
YouTube
What is Business Intelligence (BI)?
There are many definitions for Business Intelligence, or BI. To put it simply, BI is about delivering relevant and reliable information to the right people at the right time with the goal of achieving better decisions faster. If you wanna have efficient access…
https://www.youtube.com/watch?v=Tnz0i9VpncA
#datacenter #server #center #toto #sugiri #bisnis #kedaulatan #data #otto
kantor adalah tempat kolaborasi, bukan ruang yang tersekat sekat. kalau mau tersekat sekat mending kerja dirumah aja, dikamar kamar rumah.
Kita mampu jadi negara produsen bukan hanya menjadi konsumen. Jadilah Entrepreneur, Breaking the Wall~Toto Sugiri
#datacenter #server #center #toto #sugiri #bisnis #kedaulatan #data #otto
kantor adalah tempat kolaborasi, bukan ruang yang tersekat sekat. kalau mau tersekat sekat mending kerja dirumah aja, dikamar kamar rumah.
Kita mampu jadi negara produsen bukan hanya menjadi konsumen. Jadilah Entrepreneur, Breaking the Wall~Toto Sugiri
YouTube
Toto Sugiri Blak-Blakkan Bicara Bisnis Data Center dan Kedaulatan Digital Indonesia | THE VISITOR
Toto Sugiri, CEO dan Co-founder PT DCI Indonesia membuka pintu selebar-lebarnya untuk saya dan tim. Bagi Anda yang ingin tahu jeroan Data Center Tier 4, seperti apa cara mengoperasikannya, bagaimana gurih bisnisnya, dan hubungannya dengan kedaulatan digital…
tier-4 max 5 menit per tahun full redundant UPS-TRAFO- semua ada 2 unit
tier-3 max 52 menit per tahun
sertifikasi dari inggris
tier-3 max 52 menit per tahun
sertifikasi dari inggris
https://www.tokopedia.com/archive-yellowstlyle-1630738759/option-globesurfer-x1-3g-print-server-nas-logo-or-berkualitas?extParam=ivf%3Dfalse%26src%3Dsearch
#server #nas #murah
#server #nas #murah
Tokopedia
Option GlobeSurfer X.1 3G + Print Server + NAS (Logo Or Berkualitas di YELLOW STYLE | Tokopedia
Beli Option GlobeSurfer X.1 3G + Print Server + NAS (Logo Or Berkualitas di YELLOW STYLE. Promo khusus pengguna baru di aplikasi Tokopedia!