Skip to content

Instantly share code, notes, and snippets.

View Swuzz123's full-sized avatar

Nguyen Minh Tri Swuzz123

View GitHub Profile
-- Scripts to create database schema
CREATE DATABASE csdl_congty;
GO -- GO is not a SQL standard statement
-- Change the working database to csdl_congty
USE csdl_congty;
-- CREATE TABLE phongban
CREATE TABLE phongban (
mapb INT NOT NULL,
group: XeBuyt
TRAMDUNG = {
MaTD:number, TenTram:string, Loai:string, DiaDiem:string
1,'Cong Truong Me Linh','Ben xe','Cong truong Me Linh Thi Sach, Quan 1'
2,'Ben Bach Dang','Tru dung','21 Ton Duc Thang, Quan 1'
3,'Cuc Hai Quan Thanh Pho','Nha cho','2-4 Ham Nghi, Quan 1'
4,'Cho Cu','Nha cho','84 Ham Nghi, Quan 1'
5,'Truong Cao Thang','Nha cho','122 Ham Nghi, Quan 1'
6,'Cong ty Duong sat','Nha cho','136 Ham Nghi, Quan 1'