목록SQL (14)

Channi Studies

[MySQL] Day 5. CURRENT_DATE() & CURRENT_TIME()

Let's starty by creating a temporary database for this post. CREATE DATABASE test( my_date DATE, my_time TIME, my_datetime DATETIME);SELECT * from test; To get current date, time, or date time, there are 3 built-in functions, CURRENT_DATE(), CURRENT_TIME, and NOW()Let's try inserting a new row of appropriate data obtained by these functions. INSERT INTO testVALUES (CURRENT_DATE(), CURR..
SQL 2025. 3. 28. 15:41
[MySQL] Day 4. AUTOCOMMIT, COMMIT, ROLLBACK

Today, I learned about AUTOCOMMIT, COMMIT, and ROLLBACK keywords in MySQL. AUTOCOMMIT is a mode; by default, AUTOCOMMIT is set to ON. When AUTOCOMMIT is on (by default), every change you make is immediately nad permanently saved.  It means that you can't roll back if you made an error because each statement is automatically committed.We can turn it off by using following statement:SET AUTOCOMMIT..
SQL 2025. 3. 26. 18:17
[MySQL] Day 3. Update and Delete

Updating and Deleting Data 지난 포스트에 이어서, 현재 우리가 가지고 있는 데이터는 다음과 같습니다.  여섯번째 행의 데이터, Plankton 데이터의 시급과 취직 날짜가 NULL 인 것을 볼 수 있습니다. 우리는 이 데이터들을 업데이트 하고 싶습니다.  이 때, 우리는 UPDATE 키워드를 사용합니다. UPDATE 키워드에 추가적으로 SET 키워드로 업데이트할 값을 지정해주고, WHERE 키워드로 변경할 대상 row를 특정합니다. UPDATE employeesSET hourly_pay = 15.00WHERE employee_id = 6; We can also update mutiple columns at once, by separating them with commas. (Noti..
SQL 2025. 3. 25. 16:04
[SQL] Day 2: INSERT INTO & SELECT WHERE

Today, we learned about:Row insertingSELECT Row Insert Continued from yesterday's database, our employee table in myDB database has following columns We want to add a row of data into the table. In such situation, we will be using INSERT command. INSERT INTO employeesVALUES (1, "Eugene", "Krabs", 25.50, "2024-10-22");When insrting a row to a table, the new data have to follow the order of the co..
SQL 2025. 3. 15. 15:44
이전 Prev 1 2 3 4 Next 다음