to write an SQL query using insert statement

Ads
 

to write an SQL query using insert statement

I need to write an sql query for the below using InSERT command.pls help.

Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL.

The table details are as follows:

Movie ( mID, title, year, director ) English: There is a movie with ID number mID, a title, a release year, and a director.

Reviewer ( rID, name ) English: The reviewer with ID number rID has a certain name.

Rating ( rID, mID, stars, ratingDate ) English: The reviewer rID gave the movie mID a number of stars rating (1-5) on a certain ratingDate.

View Answers

Ads









Related Tutorials/Questions & Answers:
to write an SQL query using insert statement
to write an SQL query using insert statement  I need to write an sql query for the below using InSERT command.pls help. Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL
SQL Backup query with where statement
SQL Backup query with where statement       SQL Backup query with where statement ... The Tutorial show you a example from 'SQL Backup query with where
Advertisements
SQL Backup query with where statement
SQL Backup query with where statement       SQL Backup query with where statement ... The Tutorial show you a example from 'SQL Backup query with where
The INSERT INTO Statement, SQL Tutorial
The INSERT INTO Statement       The INSERT INTO statement is used to insert or add a record of data into the table. To insert records into a table, just write the key word
How to insert image in MySQL database using sql query?
Insert image in MySQL database using sql query  ... to insert image in MySQL database using sql query?": So, lets start... can insert the image into table using the insert into sql. Following
PHP SQL Insert Statement
PHP SQL Insert Statement       PHP SQL Insert Statement show you the message when the records... The Tutorial illustrate an example from 'PHP SQL Insert Statement'. To understand
JDBC Batch Example With SQL Insert Statement
JDBC Batch Example With SQL Insert Statement: In this tutorial, we are discuss about insert SQL statement with the jdbc batch. First of all, we... SQL insert statement for save data in the datasource and add
PHP SQL Query Insert
PHP SQL Query Insert       This example illustrates how to execute insert query in php...). Now, queries can be executed using mysql_query() method to insert values
Php Sql Query Insert
Php Sql Query Insert  This example illustrates how to execute insert query with values in php application. In this example we create two mysql query for insert statement with separate values in the database table. The table before
SQL And Statement
SQL AND Statement      ... with Example The Tutorial illustrates an example from SQL AND Statement... Query The given SQL Query uses SQL AND Operator to fetch
How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet  pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp
how to insert array data into sql server using jsp
how to insert array data into sql server using jsp  hello, i have problem to insert array data into my sql server from jsp form. beloW is my code... from form, but not insert into my sql database. try { //String
sql query
sql query  two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore
Finding MAX value from emp_id column using SQL query?
Finding MAX value from emp_id column using SQL query?  I need to select maximum of the Emp_id values from SQL server 2005 table.I was using... please tell me SQL query for finding max value in Emp id column.Thanx. MY sql
Hibernate Named Native SQL Query using XML Mapping
In this section, you will learn Named Native SQL Query using XML Mapping in Hibernate with an example
SQL PHP
is used to execute the statement using the mysql_query ( ) function... is used to execute the statement of mysql_query function. The server side script...=mysql_query($sql,$connection) or exit("Sql Error".mysql_error
SQL Query
SQL Query  Selecting the third highest salary of Employee without using any subquery?   Here is a query: SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1
Sql Query
Sql Query  Hi M Navjeet Ghai I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql query
SQL QUERY
Gopal oracle C Now i need to write a query "which...SQL QUERY  am a having a table 'PROGRAMMER' with columns... C pascal Bhanu Sql
sql php code
; SQL PHP code executes the statement using the mysql_query ( ) function... the statement of mysql_query function. The server side script retrieve the records...="Select * from stu where id =".$value; $sql_result=mysql_query
PHP SQL Insert
PHP SQL Insert       PHP SQL Insert is used to insert the record from HTML page to Mysql ... an example from PHP SQL Insert . To understand the example, firstly we need
single query to insert the data
single query to insert the data  How to insert data for all HTML fields in single MYSQL query
JDBC Prepared Statement Insert
JDBC Prepared Statement Insert   ... Statement Insert. In this Tutorial  the code describe the include a class... the given below code, we declare String variable sql,that is used to hold the insert
error : not an sql expression statement
{ Connection conn = DatabaseManager.getConnection(); Statement stmt = conn.createStatement(); String query = "insert into dbo.guru VALUES...error : not an sql expression statement  hii I am gettin followin
How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet  i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp  iam a fresher newbie to softparsing i have one task to do soft parsing tl asked to do callable statement,stored
insert query in jsp
insert query in jsp  give me insert code in jsp at run time
insert query in mysql
insert query in mysql  insert query in mysql not working   [INSERT INTO Birthdays(firstname, lastname, birthday, group) VALUES('Sam','Smith','June','Junior
SQL SELECT DISTINCT Statement
or rows into table 'Stu_Table'. SQL statement to insert data into table... SQL SELECT DISTINCT Statement     ... with the select statement. The SQL Distinct clause is used with the Select statement

Ads