01-03 05:04
Notice
Recent Posts
Recent Comments
Link
«   2025/01   »
일 월 화 수 목 금 토
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 31
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