diff options
author | RossTheRoss <mstrapp@protonmail.com> | 2021-04-30 08:41:38 -0500 |
---|---|---|
committer | RossTheRoss <mstrapp@protonmail.com> | 2021-04-30 08:41:38 -0500 |
commit | 05c691be64d1356b0a996d1c2a2f5b0286653c85 (patch) | |
tree | dadbde32d1384913fc981982b2c74eef098eeef5 /csci4131/hw7/create_contacts_table.js | |
parent | Add HW5 to git (diff) | |
parent | Add HW6 files (diff) | |
download | homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar.gz homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar.bz2 homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar.lz homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar.xz homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.tar.zst homework-05c691be64d1356b0a996d1c2a2f5b0286653c85.zip |
Merge branch 'master' of github.com:RosstheRoss/TestingFun
Diffstat (limited to 'csci4131/hw7/create_contacts_table.js')
-rw-r--r-- | csci4131/hw7/create_contacts_table.js | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/csci4131/hw7/create_contacts_table.js b/csci4131/hw7/create_contacts_table.js new file mode 100644 index 0000000..bcad389 --- /dev/null +++ b/csci4131/hw7/create_contacts_table.js @@ -0,0 +1,44 @@ +/* +TO DO: +----- +READ ALL COMMENTS AND REPLACE VALUES ACCORDINGLY +*/ + +const mysql = require("mysql"); + +const dbCon = mysql.createConnection({ + host: "cse-mysql-classes-01.cse.umn.edu", + user: "C4131S21U83", // replace with the database user provided to you + password: "6919", // replace with the database password provided to you + database: "C4131S21U83", // replace with the database user provided to you + port: 3306 +}); + +console.log("Attempting database connection"); +dbCon.connect(function (err) { + if (err) { + throw err; + } + console.log("Connected to database!"); + + const sql = `CREATE TABLE tbl_contacts ( + contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, + name VARCHAR(30), + category VARCHAR(40), + location VARCHAR(300), + contact_info VARCHAR(200), + email VARCHAR(30), + website VARCHAR(300), + website_url VARCHAR(300) + )`; + + console.log("Attempting to create table: tbl_contacts"); + dbCon.query(sql, function (err, result) { + if (err) { + throw err; + } + console.log("Table tbl_accounts created"); + }); + + dbCon.end(); +}); |