Search In
Technology is evolving almost daily. A business has more opportunities because of these changes. A business can expand without having the worries that they would have had decades before. The company can have an office in another state and not be limi
http://stackoverflow.com/questions/58952607/trying-to-delete-duplicates-from-tables-with-relationship
I would like to know how to delete duplicate cases in a database with tables that are joined through the use of primary key and a foreign k
Hello all,
Below is an example of pure CSS3 game using CSS3 animation. This example show efficiency of CSS3.
Below is the sample of flying plane game.
CSS:-
* {margin: 0;padding: 0;}
.board {width: 300px;height: 600px;margin:20px auto 0 !importan
The process of combining rows of two or more then two tables based on a common field between them are known as SQL joins.
Types of SQL joins :
INNER JOIN: It is returns rows only when at least one row matches from both tables.
LEFT JOIN: It
SQL Create statement is used to create a database .
Syntax
create database databaseName ;
Now if you wanna to add tables in that database then first you have to use that databse using USE DATABASE_NAME and then use create table statement .
Now If
Using this function we can retrieve random row from a table in database . Mostly it is used in online exam , for random passwords etc .
Every Database has their own syntax for random function .
Syntax for MySQL Database
select col_name from table_n
Basically this tag is used with select statement to find and retrieve the data from multiple tables . And this can be done with the help of join query .
suppose i have two tables , name is student and teacher then i can add the columns with the help
Basically Date is used to extract the data from a table in database . Suppose you want to find and extract the data from database for particular date then you can do this with the Date statement .
Example ->
Table name -> student
Student_nam
With the help of SQL Order By statement we can sort our data in a table either in ascending order or descending order based upon the user, what he wants.
Note -> Some Databases have already sort the data order by default .
Syntax :
select express
What is Null ? Null means no data or missing data or we don't have a data in a table . If you think Null means 0 ( zero ) than you are wrong .
There can be two condition for Null
1) when SQL is Null
2) when SQL is not Null
If in a table you write
