Stored create table example ( id bigint generated always as identity, a integer , b integer , c integer GENERATED ALWAYS AS (CASE WHEN ((a IS NOT NULL) AND (b IS NOT NULL) AND (b > 0)) THEN floor(((a / b))::double precision) ELSE NULL::double precision END) STORED ) create table example ( id bigint generated […] →Czytaj dalej
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE Command NOT LIKE 'Sleep' AND USER != 'system user'; SELECT * FROM performance_schema.replication_group_members; SELECT * FROM performance_schema.replication_group_member_stats; SELECT * FROM performance_schema.replication_connection_status; SELECT * FROM performance_schema.replication_applier_status_by_worker; SELECT * FROM performance_schema.replication_applier_status_by_coordinator; SELECT * FROM performance_schema.replication_applier_status; →Czytaj dalej
CREATE TABLE "tbl" ( "id" bigint NOT NULL GENERATED ALWAYS AS IDENTITY, "user_id" bigint NOT NULL, "date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, ) PARTITION BY HASH (user_id); CREATE TABLE tbl_p01 PARTITION OF tbl FOR VALUES WITH (MODULUS 4, REMAINDER 0); CREATE TABLE tbl_p02 PARTITION OF tbl FOR VALUES WITH (MODULUS 4, REMAINDER 1); CREATE TABLE […] →Czytaj dalej
Show grants for user: SHOW GRANTS FOR user@'%' Grant privileves for user: GRANT ALL PRIVILEGES ON *.* to user@'%' Grant privileves for user with allow set grants: GRANT ALL PRIVILEGES ON *.* to user@'%' WITH GRANT OPTION →Czytaj dalej