SELECT count(*) INTO @EXIST
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'column_name'
AND TABLE_NAME = 'table_name' LIMIT 1;
SET @query = IF (@EXIST<= 0, 'ALTER TABLE `table_name` ADD COLUMN `column_name` VARCHAR(100) NULL AFTER `isPublic`',
'select \'column_name COLUMN EXISTS\' status');
PREPARE stmt FROM @query;
EXECUTE stmt;
'MySQL'에 해당되는 글 3건
- 2022.03.23 Add Column if not exists
- 2020.08.19 Logstash와 JDBC를 사용해 Elasticsearch와 관계형 데이터베이스의 동기화를 유지하는 방법
- 2020.03.13 MariaDB
Study/MySQL2022. 3. 23. 14:24
Study/Elastic Logstash Kibana2020. 8. 19. 12:23
동기화 코드다음의 logstash 파이프라인은 앞서 설명드린 동기화 코드를 구현합니다.
|
[P] Download2020. 3. 13. 00:44
MariaDB 10.4 Series
MariaDB 10.4 is the current stable (GA) series of MariaDB. It is built on MariaDB 10.3 with new features not found anywhere else.
See "What is MariaDB 10.4?" for an overview.
mariadb-10.4.12-winx64.msi | MSI Package | Windows x86_64 | 56.9 MB | Checksum Instructions |