[SQLite3로 가볍게 배우는 데이터베이스:SQL 기초 실습] 따라하기 A07

 [ 출처 : wikidocs "SQLite3로 가볍게 배우는 데이터베이스:SQL 기초 실습" - A07 ]



■ 테이블 변경


1. 컬럼 추가 (ALTER TABLE)


- personal 테이블에 'new'라는 컬럼 추가



- 새 컬럼에 값을 입력하기



2. 컬럼명 변경 (ALTER TABLE)


- 컬럼 'New' --> 'Height'



★ 연습문제


- Person 테이블에 Weight 컬럼을 추가해보라.




SQLite로 가볍게 배우는 데이터베이스.db.sql

0.00MB


댓글

댓글 쓰기

이 블로그의 인기 게시물

[Programming with Mosh] Python Tutorial for Beginners | Full Python Programming Course [2019]

이미지
Watch this Python tutorial for beginners to learn Python programming from scratch. Includes exercises and projects. 👍Subscribe for more Python tutorials like this: https://goo.gl/6PYaGF 📕Get My FREE Python Cheat Sheet: http://bit.ly/2Gp80s6 🔥Get My Complete Python Programming Course with a 90% Discount (LIMITED to the first 200 students): https://goo.gl/P64rZ8 #Python , #MachineLearning , #WebDevelopment 🔗Supplementary Materials (Spreadsheet): https://goo.gl/x77mLc 📔Python Exercises for Beginners https://goo.gl/1XnQB1 ⭐My Favorite Python Books - Python Crash Course: https://amzn.to/2GqMdjG - Automate the Boring Stuff with Python: https://amzn.to/2N71d6S - A Smarter Way to Learn Python: https://amzn.to/2UZa6lE - Machine Learning for Absolute Beginners: https://amzn.to/2Gs0koL - Hands-on Machine Learning with scikit-learn and TensorFlow: https://amzn.to/2IdUuJy TABLE OF CONTENT 00:00:00 Introduction 00:01:49 Installing Python 3 00:06:10 Your First Pyt...
계속 읽기