Mysql sql - Revision history

Pchero: /* ETC */

2023-07-03T02:43:27Z

ETC

← Older revision		Revision as of 02:43, 3 July 2023
Line 144:		Line 144:

	== ETC ==		== ETC ==
			=== Checksum ===
			<pre>
			CHECKSUM TABLE tbl_name [, tbl_name] ... [QUICK \| EXTENDED]
			</pre>
			CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state.

	=== Check table exist ===		=== Check table exist ===
	특정 테이블이 있는지, 아닌지를 알고 싶을 때가 있다. 이런 경우, 다음의 쿼리를 입력하면, 테이블이 있으면 정상, 없으면 오류를 리턴한다.<ref>http://stackoverflow.com/questions/8829102/mysql-check-if-table-exists-without-using-select-from</ref>		특정 테이블이 있는지, 아닌지를 알고 싶을 때가 있다. 이런 경우, 다음의 쿼리를 입력하면, 테이블이 있으면 정상, 없으면 오류를 리턴한다.<ref>http://stackoverflow.com/questions/8829102/mysql-check-if-table-exists-without-using-select-from</ref>

2020-08-31T10:44:55Z

Alter

← Older revision		Revision as of 10:44, 31 August 2020
Line 72:		Line 72:
	<source lang=sql>		<source lang=sql>
	ALTER TABLE Customers ADD Email varchar(255);		ALTER TABLE Customers ADD Email varchar(255);
			</source>

			<source lang=sql>
			ALTER TABLE table_name MODIFY COLUMN column_name datatype;
	</source>		</source>

2020-08-16T00:43:52Z

Alter

← Older revision		Revision as of 00:43, 16 August 2020
Line 66:		Line 66:
	Drop the column from the table.		Drop the column from the table.
	<source lang=sql>		<source lang=sql>
	ALTER TABLE "table_name" DROP "column_name";		ALTER TABLE table_name DROP column_name;
			</source>

			Add the column to the table
			<source lang=sql>
			ALTER TABLE Customers ADD Email varchar(255);
	</source>		</source>

2020-08-14T00:16:46Z

Update

← Older revision		Revision as of 00:16, 14 August 2020
Line 59:		Line 59:
	primary key(group_id, agent_id)		primary key(group_id, agent_id)
	);		);
			</source>

			== Alter ==
			이미 생성되어 있는 테이블의 내용을 변경한다.

			Drop the column from the table.
			<source lang=sql>
			ALTER TABLE "table_name" DROP "column_name";
	</source>		</source>

2020-07-15T15:46:07Z

Add query timeout

← Older revision		Revision as of 15:46, 15 July 2020
Line 167:		Line 167:
	</source>		</source>

	=== ~~Add query timeout~~ ===		=== MAX_EXECUTION_TIME ===
	Mysql 5.7 버전부터 사용할 수 있다. select 및 다른 SQL query 실행에 timeout 을 설정하는 옵션이다.		Mysql 5.7 버전부터 사용할 수 있다. select 및 다른 SQL query 실행에 timeout 을 설정하는 옵션이다.

	<source lang=sql>		<source lang=sql>
	SELECT/+ MAX_EXECUTION_TIME(1000) / * FROM calls where destination = '11234';		SELECT /+ MAX_EXECUTION_TIME(1000) / * FROM calls where destination = '11234';

	SELECT /+ MAX_EXECUTION_TIME(1000) / * FROM t1 INNER JOIN t2 WHERE ...		SELECT /+ MAX_EXECUTION_TIME(1000) / * FROM t1 INNER JOIN t2 WHERE ...

2020-07-15T15:45:41Z

ETC

@@ Line 166: / Line 166: @@
 +--------------------------------------+
 </source>
 == See also ==

2019-07-29T10:06:15Z

Insert

← Older revision		Revision as of 10:06, 29 July 2019
Line 83:		Line 83:
	<pre>		<pre>
	INSERT INTO <table> (columns) VALUES (values);		INSERT INTO <table> (columns) VALUES (values);
			</pre>

			== Delete ==
			<pre>
			DELETE FROM `table_name` [WHERE condition];
	</pre>		</pre>

2016-10-01T22:37:56Z

Installation

@@ Line 1: / Line 1: @@
 == Overview ==
 Mysql 사용법 정리.
 == Basic ==

2016-07-31T16:44:53Z

Pchero moved page Mysql to Mysql sql

← Older revision	Revision as of 16:44, 31 July 2016
(No difference)

2016-07-31T16:44:02Z