02-28 03:24
Notice
Recent Posts
Recent Comments
Link
«   2025/02   »
일 월 화 수 목 금 토
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28
Tags more
Archives
Today
Total
관리 메뉴

목록Data Science/MySQL (2)

Scientific Computing & Data Science

Frequently Used MySQL Quries

SHOW DATABASES; // print the current list of database USE test; // select the database "test" CREATE DATABASE test; // create a database named "test" CREATE TABLE mytable( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(25) NOT NULL, content VARCHAR(255) NOT NULL ); // create a table named "mytable" with the fields of id, name and content DESC mytable; // print out the structure of myta..
Data Science/MySQL 2014. 1. 5. 22:53
Execute MySQL Console on Mac

On terminal on your mac type the followings:cd /usr/local/mysql/binsudo ./mysql
Data Science/MySQL 2014. 1. 5. 22:23
Prev 1 Next