In this article we will learn about some of the frequently asked TypeScript programming questions in technical like “sql” Code Answer’s. When creating scripts and web applications, error handling is an important part. If your code lacks error checking code, your program may look very unprofessional and you may be open to security risks. Error or stack handling on typescript was simple and easy. An error message with filename, line number and a message describing the error is sent to the browser. This tutorial contains some of the most common error checking methods in Typescript. Below are some solution about “sql” Code Answer’s.
sql
xxxxxxxxxx
1
SELECT - extracts data from a database
2
UPDATE - updates data in a database
3
DELETE - deletes data from a database
4
INSERT INTO - inserts new data into a database
5
CREATE DATABASE - creates a new database
6
ALTER DATABASE - modifies a database
7
CREATE TABLE - creates a new table
8
ALTER TABLE - modifies a table
9
DROP TABLE - deletes a table
10
CREATE INDEX - creates an index (search key)
11
DROP INDEX - deletes an index
SQL
xxxxxxxxxx
1
Let's create a database!
sql
xxxxxxxxxx
1
Structured Query Language
SQL
xxxxxxxxxx
1
CREATE TABLE friends (
2
id INTEGER,
3
name TEXT,
4
birthday DATE
5
);
6
7
INSERT INTO friends (id, name, birthday)
8
VALUES (1, 'Jane Doe', '1990-05-30');
9
10
11
INSERT INTO friends(id , name , birthday)
12
VALUES(2 , 'APOORV' , '2000-2-2');
13
14
15
16
UPDATE friends
17
SET name = 'Jane Srivastava'
18
WHERE id = 1;
19
20
ALTER TABLE friends
21
ADD COLUMN email TEXT;
22
23
24
UPDATE friends
25
SET email = '203029@klsafjls'
26
where id = 1;
27
28
UPDATE friends
29
SET email = '203029@klsafjls'
30
where id = 2;
31
32
DELETE FROM friends
33
WHERE id = 1;
34
35
36
SELECT *
37
FROM friends;
sql
xxxxxxxxxx
1
SQL - the standard language to communicate with DBMS.
sql
xxxxxxxxxx
1
SQL is a domain-specific language used in programming and designed for managing
2
data held in a relational database management system, or for stream processing
3
in a relational data stream management system.
sql
xxxxxxxxxx
1
SELECT * FROM STUDENT
sql
xxxxxxxxxx
1
DOWNLOAD XAMPP
2
And then start apache and mysql then go to localhost/phpmyadmin
sql
xxxxxxxxxx
1
What is SQL?
2
SQL stands for Structured Query Language
3
SQL lets you access and manipulate databases
4
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
5
What Can SQL do?
6
SQL can execute queries against a database
7
SQL can retrieve data from a database
8
SQL can insert records in a database
9
SQL can update records in a database
10
SQL can delete records from a database
11
SQL can create new databases
12
SQL can create new tables in a database
13
SQL can create stored procedures in a database
14
SQL can create views in a database
15
SQL can set permissions on tables, procedures, and views
sql
xxxxxxxxxx
1
SQL stands for:
2
Structured Query Language
3
4
It's language which enables a user to create,
5
modify and essentially interact with a database.
6
As a tester we are usually using Data manipulation
7
language part of SQL
8
9
SQL has 2 parts:
10
1-DATA MANIPULATION LANGUAGE
11
It is used to add, retrieve or update the data.
12
= insert, select, update, delete
13
14
2-DATA DEFINITION LANGUAGE
15
It is used to create database schema and can
16
be used to define some constraints as well.
17
=create, alter, drop, truncate
18
19
create table
20
create window etc.