|
Home
|
Sign up!
|
Projects
|
Seminars
|
Research Notes
|
Today's Lecture
|
About
|
Update Project Form
Course:
Project Topic:
Project Description:
Superna Sharma and I are currently working on creating a database that displays the courses for a student along with data like teachers,course numbers, etc. on being given the specific information(i.e course code etc).
The various MySQL queries used are given below :
mysql->create database Time_Table;
mysql->use Time_Table;
mysql->create table Course(C_Code char(20) not null,C_Name char(30),Credits int,Lecturer char(30),primary key (C_code));
You can refer to Superna's Project Report to find out about other tables and the various primary and foreign keys in them.
To insert values into the tables:
mysql->insert into Course values( "FSS 101",......);
To see the table :
mysql->select * from ____( give the table name );
To see all the tables :
mysql-> show tables;
To see only the fields:
mysql->describe ____(table name);
To delete a specific row or a specific column :
mysql-> delete fields from tablename where _____;
Your Password:
Prof. Ashay Dharwadker