앨리스래빗팀 기술블로그

ORDER BY FIELD(task_status, 'new', 'checked', 'started', 'completed')

Decimal 고정 소수법 / 십진법 / 정확함Double 부동 소주 / 범위가 큼

mariadb -h '' -u '' -P -p

RDMS Tool 이 아닌 터미널에서 RDS 인스턴스에 직접 접속하고 싶은 경우https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html Connecting to a DB instance running the MySQL database engine - Amazon Relational Database ServiceConnecting to a DB instance running the MySQL database engine Before you can connect to a DB instance running the MySQL database engine, you must create a DB instance. For i..

SELECT COLUMN_NAME AS 'field_name', COLUMN_COMMENT AS 'comment', COLUMN_TYPE AS 'type', COLUMN_KEY AS 'KEY', IS_NULLABLE AS 'NULL', EXTRA AS 'auto', COLUMN_DEFAULT 'default' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '테이블명' AND TABLE_SCHEMA = '스키마명' AND COLUMN_NAME != 'created_at' AND COLUMN_NAME != 'updated_at' AND COLUMN_NAME != 'is_deleted' ORDER BY TABLE_NAME, ORDINAL_POSITION;

INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; https://zetawiki.com/wiki/SQL_SELECT_%EA%B2%B0%EA%B3%BC%EB%A5%BC_INSERT_%ED%95%98%EA%B8%B0 SQL SELECT 결과를 INSERT 하기 - 제타위키 다음 문자열 포함... zetawiki.com

show create table [ 테이블명 ];

https://stackoverflow.com/questions/4932503/how-to-kill-mysql-connections How to kill MySQL connections I'm building a website with MySQL. I'm using TOAD for MySQL and suddenly I can't connect to the database as I'm getting an error: "Too many connections" Is there any way in Toad for MySQL to v... stackoverflow.com SHOW PROCESSLIST; KILL 192;

show variables like 'max_connections'; t2.micro: 66 t2.small: 150 m3.medium: 296 t2.medium: 312 M3.large: 609 t2.large: 648 M4.large: 648 M3.xlarge: 1237 R3.large: 1258 M4.xlarge: 1320 M2.xlarge: 1412 M3.2xlarge: 2492 R3.xlarge: 2540

SET SQL_SAFE_UPDATES = 0;