반응형 생활코딩/Dadabase - MySQL5 IFNULL - NULL 값 변환 SELECT ANIMAL_TYPE, IFNULL(NAME, "No name") AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS 2021. 10. 21. DATABASE2 MySQL - 13.DELETE mysql> ################ mysql> ######################################################################################## mysql> ################# DATA DELETE ################################## mysql> ################################################################# mysql> SELECT * FROM topics; ERROR 1146 (42S02): Table 'opentutorials.topics' doesn't exist mysql> SELECT * FROM topic; +----+-------.. 2021. 10. 13. DATABASE2 MySQL - 11.SELECT - egoing mysql> DESC topic; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int | NO | PRI | NULL | auto_increment | | title | varchar(100) | NO | | NULL | | | description | text | YES | | NULL | | | created | datetime | NO | | NULL | | | author | varchar(30.. 2021. 10. 13. MySQL 테이블의 생성 - egoing mysql> create table topic( -> id INT(11) NOT NULL AUTO_INCREMENT, -> title VARCHAR(100) NOT NULL, -> description TEXT NULL, -> created DATETIME NOT NULL, -> author VARCHAR(30) NULL, -> profile VARCHAR(100) NULL, -> PRIMARY KEY(id)); mysql> DESC topic; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------.. 2021. 10. 13. 이전 1 2 다음 반응형
