The question mark means the code is not yet added and committed to your repository

(community.openhab.org/t/solved-eclipse-ide-meaning-of-symbols-in-package-explorer-creating-a-jar-file/66620)



linux, source

카테고리 없음 2021. 4. 14. 15:28


mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >

stackoverflow.com/questions/2518459/mysql-mysqldump-routines-to-only-export-1-stored-procedure-by-name-and-not/7080270#7080270


mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >

stackoverflow.com/questions/2518459/mysql-mysqldump-routines-to-only-export-1-stored-procedure-by-name-and-not/7080270#7080270




mysql 테이블 명세

mysql 2021. 4. 2. 15:08

select -- *
COLUMN_NAME, COLUMN_COMMENT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMN_KEY, 
CASE
WHEN IS_NULLABLE = 'YES'
THEN 'N'
ELSE 'Y'
END as NOTNULL
, COLUMN_DEFAULT
from information_schema.columns
where table_schema = 'mytableschema'
and table_name = 'MY_TABLE'
order by ordinal_position
;