본문 바로가기

MySQL

 (4)
MySQL 8.0.22 시스템뷰의 결과값 오류 ? 버전:Server version: 8.0.22 MySQL Community Server - GPL 목표:primary key 없는 테이불조회 1.전체테리불 리스트 추출 SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.TABLES t WHERE TABLE_SCHEMA NOT IN ( 'mysql', 'sys', 'information_schema', 'performance_schema' ) AND TABLE_TYPE = 'BASE TABLE'; +--------------+------------------+ | TABLE_SCHEMA | TABLE_NAME | +--------------+------------------+ | employees | dep..
MySQL 5.7 sys.schema_redundant_indexes view turning As a DBA, we often use the SYS view, but in the following situations SQL there is no result for more than 70 seconds. SELECT TABLE_SCHEMA, TABLE_NAME, REDUNDANT_INDEX_NAME, REDUNDANT_INDEX_COLUMNS FROM sys.schema_redundant_indexes WHERE TABLE_SCHEMA NOT IN ('information_schema','performance_schema','mysql','sys', 'test') GROUP BY TABLE_SCHEMA, TABLE_NAME, REDUNDANT_INDEX_NAME, REDUNDANT_INDEX_CO..
MySQL 날짜 함수 에러 ? 안녕하세요 거북탄토끼 입니다 아래와 같은 3개 예제 가 있습니다 . 1 root@mysql3357.sock>[information_schema]>select str_to_Date('1992-04-01','%Y-%m-%d')-str_to_Date('1992-04-01','%Y-%m-%d') dt ; +------+ | dt | +------+ | 0 | +------+ 1 row in set (0.00 sec) 2 root@mysql3357.sock>[information_schema]>select str_to_Date('1992-04-11','%Y-%m-%d')-str_to_Date('1992-04-1','%Y-%m-%d') dt ; +------+ | dt | +------+ | 10 | +------..
MySQL8.0 desc Index 사용사례 안녕하세요 어늘 웹서칭하다가 카페에서 아래와 같은 내용을 읽게되였습니다 SELECT t2.column1 , t3.column1 FROM tb_test1 t1 INNER JOIN tb_test2 t2 ON t2.column1 = t1.column1 INNER JOIN tb_test3 ON t3.column1 = t1.column1 WHERE t1.coulmn1 = #{idNo} AND t1.column2 = 'N' AND t1.column3 in ( 'A','B','C') ORDER BY t1.column4 DESC LIMIT #{offset}, #{limit}; 여기서 idx1 ( column1,column2,column4,column3) 아래 인덱스를 생성하고 언하는것은 index condition p..

티스토리툴바