WHERE is used to search for a specific data.
Syntax :-
1. Specific data from all column
Syntax:-
SELECT * FROM table_name
WHERE column_name operator 'value';
Ex...
WHERE Clause and Equal Operator
Saturday, 21 April 2018
Friday, 20 April 2018
Single quotes Problem
We will write a simple/normal syntax.
INSERT INTO my_tab (t_id, c_name, address) VALUES (142, 'K.K's Company', 'Delhi');
There are two way to solve this problem :-
Use backslash
Ex :- 'K.K\'s Company'
Use two time single quotes
Ex...
Select Statement
The SELECT statement is used to select data from database and retrieve the information.
1. Select all columns from the table
Syntax :- SELECT * FROM table_name;
Ex :- SELECT * FROM...
Thursday, 19 April 2018
Insert into
The INSERT INTO statement is used to insert new records/row/tuple in a table.
Syntax :-
INSERT INTO table_name (column1, column2, column3, column4,.....)
VALUES (value1, 'value2', 'value3', value4.....);
Ex :-
INSERT INTO my_tab (stu_id,...
Wednesday, 18 April 2018
Data Types
INT or INTEGER - It holds whole number between -32,768 and 32,767 either it is negative or positive. It can not hold a decimal numbers. The maximum number of digits may be specified in parenthesis.
Syntax :-
column_name INT (size);
Ex...
Tuesday, 17 April 2018
Show Databases/ Tables
SHOW DATABASES - This command is used to view all the databases name.
Syntax :-
SHOW DATABASES;
SHOW TABLES - This command is used to view all tables of current database.
Syntax :-
SHOW TABLES;
...
DESC Command
This is used to describe your table. DESC only describes structure of table not the information (rows) inside table. DESC is short form of describe.
Syntax :-
DESC table_name;
Ex :-
DESC my_tab;
...
Create Table
Syntax :-
CREATE TABLE table name
(
Column_name1 data-type (size),
Column_name2 data-type (size),
Column_name3 data-type (size)
);
Ex :-
CREATE TABLE my_tab
(
name varchar (30),
roll int (4),
address varchar (100)
);
Another way to...
Sunday, 15 April 2018
Create Database
It is used to create database.
Syntax:- CREATE DATABASE database_name;
Ex:- CREATE DATABASE my_db;
Guide for creation of database:-
Name should start with an alphabet
Blank space and single quotes are not allowed
Reserve words of that...
Student Registration Form
Program:-
<html>
<head>
<script type=”text/javascript” src=”validate.js”></script>
</head>
<body>
<form action=”#” name=”StudentRegistration” onsubmit=”return(validate());”>
<table cellpadding=”2″ width=”20%” bgcolor=”99FFFF” align=”center”
cellspacing=”2″>
<tr>
<td colspan=2>
...
Entry Level Form
Program:-
<html>
<head>
<title>Entry Level Form</title>
</head>
<body>
<form>
<ul class=”form-style-1″>
<li><label>Full Name <span
class=”required”>*</span></label><input type=”text”
name=”field1″ class=”field-divided” placeholder=”First” />
...
Personal Details Form
Program:-
<html>
<head>
<title>Personal Details Form</title>
</head>
<body>
<div class=”form-style-3″>
<form>
<fieldset><legend>Personal Details</legend>
<label for=”field1″><span> Full Name <span class=”required”>*</span></span>
<input...
Information Form
Program:-
<html>
<head>
<title>Information Form</title>
</head>
<body>
<form class=“form-style-9”>
<ul>
<li>
<input type=“text” name=“field1” class=“field-style field-split align-left” placeholder=“Name” />
<input type=“email” name=“field2” class=“field-style...
Website Design in HTML and CSS
<html>
<head>
<title>Castor Classes</title>
<style type=”text/css”>
body{
background-color:gray;
font-family:Arial,Helvetica,sans-serif;
}
*
{
margin:0;
padding:0;
}
#wrapper{
border:1px solid;
width:970px;
padding:2px;
background-color:gray;
}
#header{
border:1px solid;
width:100%;
background-color:white;
...
How to set style of list in CSS?
—>This is use for give some decoration of list.
Syntax:-
ul{
list-style-type:circle OR squre OR upper roman OR upper alpha;
list-style-image:url(‘folder name’);
}
ul li{
line-height:30px;
}
ul li:hover{
margin-left:10px;
}
ul li a{
text-decoration:none;
}
Example:-
<!Doctype html>
<html>
<head>
<title>CastorClasses.com</title>
...
Popular Posts
-
What you'll learn Understand why version control is a fundamental tool for coding and collaboration Install and run Git on your local ... -
What’s happening here? fruits is a list of 5 string items. [ 'Python' , 'Py' , 'Anaconda' , 'CPython' , ... -
Introduction to Data Science in Python: Course Review and Insights Python has become one of the most powerful and popular programming lang... -
Step-by-Step Breakdown: Variable Assignment: word = 'clcoding' The string 'clcoding' is assigned to the variable word.... -
Step-by-step Explanation: playerScores = dict() Creates an empty dictionary named playerScores. Adding player scores: playerSc... -
Step-by-step Execution: try block execution: The try block contains print("Python"). Since print("Python") doe... -
tep 1: First if Condition if not (code >= 100 and code <= 200 ): print("1") code = 501, so we check: code >... -
Introduction to Scripting in Python Specialization Python is one of the most versatile and beginner-friendly programming languages, making... -
%20(3).png)
Step 1: Install Python Download Python : Go to Python.org and download the latest version. Install Python : During installation, ensure you... -
Understanding any() Function: The any() function checks if at least one element in the iterable satisfies the given condition. The...
Python Coding for Kids ( Free Demo for Everyone)
.png)
%20(3).png)
Posts
