04-26 00:04
Notice
Recent Posts
Recent Comments
Link
«   2024/04   »
일 월 화 수 목 금 토
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 29 30
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