Skip to main content

SQL Commands

sql training

SQL All Commands


SQL TRAINING - USING ALL COMMANDS


We are telling all SQL commands. As a result, you can have basic knowledge about SQL and database queries.

We will touch on creating tables, querying data, adding data to tables, mathematical operations, column concatenation, and other SQL topics.

--   Used to add comment lines.

CREATING A NEW SQL DATABASE

create database ... (You must enter the name of the database you want to create in the dotted area.)

CREATE SQL TABLE

create table ...  (You should write your own table name in the dotted area.)

For Example;

create table School (                 --Table Name
StudentNumber varchar (4),      --Column name (Our data type varchar)
StudentName varchar (12),        --Column name (Our data type varchar)
StudentSurname varchar (20))   --Column name (Our data type varchar)

When we create our table we open the parentheses and insert the columns into the parentheses. We need to specify the data type of each column. We have to put a comma after each column.

ADDING A NEW COLUMN TO THE CONSTRUCTED TABLE

We use the alter command to add a new column to the table we created.

For Example;

alter table School add StudentNote varchar(50)

If you want to add more than one field, we put a comma in it.

TO CHANGE A FIELD

alter table ... alter column ... smallint (You can specify the type of data you want.)

For Example;

alter table School alter column Note smallint

DELETE TABLE

The drop command is used to delete the table.

drop table ... (You must enter the table name in the dotted area.)

COLUMN DELETION

alter table ...(Here's the table name.)  drop column ... (Here's the column name.)

For Example;

alter table School drop column Note

DELETE INFORMATION IN TABLON

The truncate command is used to delete the data without deleting the table.

truncate table ... (Here's the table name.)

For Example;

truncate table School

Comments

Popular posts from this blog

Empires Dawn of the Modern World Review

Empires Dawn of the Modern World Review

This is the legendary strategy game Empires Dawn of the Modern World. Without further ado, we'll give you short notes and great information about the game. Don't go without reading these tips that will improve your game strategy.

Type of Game: Strategy
As I mentioned in the first paragraph, the genre of Empires Dawn of the Modern World is strategy. From ancient times to World War 2 you can start the game from any age. If you want to turn off the progress of the age you can only play the game you want. The last era in the game is World War II.

In the game you need to multiply your people, develop your economy, develop military and various military vehicles. The maximum number of soldiers is 8,000. This is divided by the number of 8,000 players. For example, in a 2-player scenario, two players, 4,000, are given the limit of developing troops.

Which countries are in the game ?: England, France, Korea, China, Germany, Russia
Countries also cha…

Why Android Studio

Why Android Studio
Android Programming beginners often ask questions at the beginning with which program to start programming. We would like to help you choose a program.

There are 3 major programs for Android / Mobile Programming. These; Eclipse, Netbeans and Android Studio. Those who had already started Android Programming used Eclipse and Netbeans, mostly Eclipse. However, Google has developed its own Android Programming program with the support of alternative programs. Previously, Eclipse could also be done by downloading the Android SDK plug-in. Those who still want to write Eclipse de Android Program can still download this SDK from the Internet but not from other sites over the Internet. Although this is a choice for those who are accustomed to Eclipse, it will be better for those who are new to Android Programming to start writing code with Android Studio. Android Studio, powered by Google, will be a solid infrastructure for future technologies and will allow you to produce ea…

How to Increase Alexa Ranking

How to Increase Alexa Ranking
Tactics, taking into account our tips and warnings you as soon as you can move your site up Alexa rankings.

Ways to Increase Alexa Ranking
Alexa is a ranking or rating system that site and blog owners frequently follow and care about for their site. Alexa, which shows your site's ranking in the world and in your country, the backlinks it receives, is one of the factors that are taken into consideration when buying and selling advertisements to your site. In this article, we will tell you about the ways to rise in Alexa.


Here are some advice;Entering Original ContentLong Stay on Your SiteVisitors Comment on Your SiteSharing Your Site in Social Media AccountsSharing Your Site on Other Sites
These recommendations and many other similar methods will allow your site to increase in Alexa rankings. If you continue to enter the original content in a stable way, you will ultimately get your money back.