date_format(from_unixtime(time/1000), '%Y-%m-%d %H:%i:%s')
|
USE DBNAME
GO
select * from information_schema.tables
GO
|
USE DBNAME
GO
select * from information_schema.columns
where COLUMN_NAME='컬럼명'
|
 | The Knight at Dawn (Paperback) -  메리 폽 어즈번 지음, 살 머도카 그림/Random House |
| File Name | Purpose |
|---|---|
/etc/my.cnf | Global options |
/etc/mysql/my.cnf | Global options |
| Global options |
$MYSQL_HOME/my.cnf | Server-specific options (server only) |
defaults-extra-file | The file specified with --defaults-extra-file, if any |
~/.my.cnf | User-specific options |
~/.mylogin.cnf | User-specific login path options (clients only) |
mysql > GRANT ALL ON *.* TO '계정'@'ip address';
|
mysql> select * from information_schema.EVENTS;
|
mysql> show variables like 'event%';
|
SET GLOBAL event_scheduler = ON; SET @@global.event_scheduler = ON; SET GLOBAL event_scheduler = 1; SET @@global.event_scheduler = 1;
CREATE EVENT `이벤트 명` ON SCHEDULE EVERY 1 DAY STARTS 'YYYY-MM-DD HH:MM:SS'
DO
BEGIN
CALL DB스키마.프로시저명;
END
|
mysql> check table 'table_name';
|
mysql> repair table 'table_name';
|
mysql> check table 'table_name';
|
<?xml version="1.0"?>
<configuration>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0.30319"/>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>
|
USE DBNAME
GO
EXEC sp_rename '스키마.테이블이름.기존컬럼이름', '새로운컬럼이름', 'COLUMN'
|
USE dbname
GO
SELECT t.[text], s.last_execution_time
FROM sys.dm_exec_cached_plans AS p
INNER JOIN sys.dm_exec_query_stats AS s
ON p.plan_handle = s.plan_handle
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%'
ORDER BY s.last_execution_time DESC;
|
SELECT j.name
FROM msdb.dbo.sysjobs AS j
WHERE EXISTS
(
SELECT 1 FROM msdb.dbo.sysjobsteps AS s
WHERE s.job_id = j.job_id
AND s.command LIKE '%procedurename%'
);
|
sp_depends '프로시저명'
|
SELECT 이름, SUM(영어) AS 영어, SUM(수학) AS 수학, (영어+수학)/2 AS 평균
FROM (SELECT 이름,
CASE WHEN 영어 THEN 점수 ELSE 0 ELSE 0 END AS 영어,
CASE WHEN 수학 THEN 점수 ELSE 0 ELSE 0 END AS 수학,
FROM A) AS B
GROUP BY 이름
|
SELECT 이름,
CASE WHEN 과목 = 영어 THEN SUM (점수) END AS 영어
CASE WHEN 과목 = 수학 THEN SUM (점수) END AS 수학
AVG(점수) AS 평균
FROM A
GROUP BY 이름
|
SELECT 이름,
SUM(CASE WHEN 과목 = 영어 THEN 점수 ELSE 0 END) AS 영어,
SUM(CASE WHEN 과목 = 수학 THEN 점수 ELSE 0 END) AS 수학,
AVG(점수) AS 평균
FROM A
GROUP BY 이름
|
