-
Notifications
You must be signed in to change notification settings - Fork 0
/
SQL Commands.txt
20 lines (11 loc) · 909 Bytes
/
SQL Commands.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Sql Commands to be run in Mysql
create database ebs;
use ebs;
create table login(meter_no varchar(20), username varchar(30), name varchar(30), password varchar(20), user varchar(20));
select*from login;
create table customer(name varchar(20), meter_no varchar(20), address varchar(50), city varchar(30), state varchar(30), email varchar(40), phone varchar(20));
select*from customer;
create table meter_info(meter_no varchar(20), meter_location varchar(20), meter_type varchar(20), phase_code varchar(20), bill_type varchar(20), days varchar(20));
create table tax(cost_per_unit varchar(20), meter_rent varchar(20), service_charge varchar(20), service_tax varchar(20), swacch_bharat_cess varchar(20), fixed_tax varchar(20));
insert into tax values('9','47','22','57','6','18');
create table bill(meter_no varchar(20), month varchar(30), units varchar(20), totalbill varchar(20), status varchar(20));