Skip to main content

SQL Query Commands

sql command

SQL Query Commands


Structured Query Language (SQL) structured query language is known as the standard programming language for database management systems.

CREATE TABLE: Provides the creation of a new table, fields and indexes.
CREATE INDEX: Allows creation of (index) for a specified table.
DROP TABLE: Deletes the specified table and indexes from the database.
ALTER TABLE: Allows you to add new fields to the table or modify field definitions.

SELECT: Selects the records in the table according to a specified measure.
INSERT: Provides the insertion of a new record into the records in the table.
UPDATE: Used to update the fields of a specified record of the table.
DELETE: Tablodan causes the specified records to be deleted.

FROM :They define what table is to be questioned.
WHERE : Defines the criteria to be used during the query.
GROUP BY :Groups the records by the specified area.
HAVING :Each group defines the criteria that must be followed.
CONSTRAINT :It allows the index definition and association with another table.

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.