/nodejs_mysql

Primary LanguageJavaScript

What is this?

This is a simple app with nodejs and mysql.

Basic codes to insert, update, delete and select records from mysql

Libraries and tools

  • mySql
  • body-parser
  • express
  • jade

Create table

  CREATE TABLE `client` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `companyName` varchar(30) NOT NULL,
   `address` varchar(200) NOT NULL,
   `manager` varchar(30) NOT NULL,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Running locally

  1. Clone the repository
  2. npm install
  3. Visit http://localhost:3000/home