Once more into the fray,

Free to use, user-contributed trivia question database. 4,068 VERIFIED QUESTIONS AND 8,079 PENDING QUESTIONS

ㅁ

* 파일로 출력 mysql> select * from usertbl; +--------+-----------+-----------+--------+---------+---------+--------+---------------------+ | userid | name | birthyear | addr | mobile1 | mobile2 | height | mdate | +--------+-----------+-----------+--------+---------+---------+--------+---------------------+ | BBK | 바비킴 | 1973 | 서울 | 010 | 0000000 | 176 | 2013-..

(임시)변수 사용 SET @myVar1 = 3 ; PREPARE myQuery FROM 'SELECT Name, height FROM usertbl ORDER BY height LIMIT ?'; EXECUTE myQuery USING @myVar1 ; ==> mysql> SET @myVar1 = 3 ; Query OK, 0 rows affected (0.00 sec) mysql> PREPARE myQuery -> FROM 'SELECT Name, height FROM usertbl ORDER BY height LIMIT ?'; Query OK, 0 rows affected (0.00 sec) Statement prepared m..

DML : 데이터 조작 - select, update, insert, delete 등 - rollback 가능 DDL : 데이터 정의 - create, drop, alter 등 - ddl은 트랜잭션을 발생시키지 않는다. 따라서 rollback, commit 불가. 즉시 적용 DCL : 데이터 제어 - grant, revoke, deny 등 insert mysql> create table testtbl1(id int, username char(20),age int); Query OK, 0 rows affected (..

https://www.youtube.com/watch?v=hUXOf8JEupM&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X&index=18

order by : 정렬(오름차순-asc, 내림차순-desc) limit : 5개만 출력 mysql> select emp_no, hire_date from employees order by hire_date asc limit 5; +--------+------------+ | emp_no | hire_date | +--------+------------+ | 110022 | 1985-01-01 | | 110511 | 1985-01-01 | | 110303 | 1985-01-01 | | 110085 | 1985-01-01 | | 110183 | 1985-01-01 | +--------+------------+ 5 ro..