Archive:PHP and MySQL Programming/Basic Queries

2009-03-16T15:42:24Z

93.86.126.137: /* ALTER */

== Introduction ==

Here are a few basic queries to get you going. For more detailed information, have a look at the online documentation on the MySQL website http://dev.mysql.com/doc/refman/5.1/en/index.html .

== SELECT ==

The SELECT query is the standard means by which to retrieve information from the database. The syntax for the SELECT query is as follows:

mysql> SELECT field1, field2, ...
FROM table_name
[WHERE condition1
AND condition2
...
[ORDER BY field1, field2, etc...]
[LIMIT number]];

Example :

mysql> SELECT * FROM books;

mysql> SELECT Title, Author
FROM books
WHERE Year > 2001
AND Year < 2006
ORDER BY Author ASC
LIMIT 100;

== INSERT ==

The INSERT statement is used to insert data into a particular table of a database. The Syntax is as follows :

mysql> INSERT INTO table_name
(field1, field2, etc...)
VALUES ('val1', 'val2', etc...);

Example :

mysql> INSERT INTO books
(ISBN, Title, Author, Year)
VALUES ('1234567890', 'Programming PHP and MySQL', 'Poisson, R.W', 2006);

== DELETE ==

The DELETE statement is used to remove row(s) from a table. The syntax is as follows :

mysql> DELETE FROM table_name
[WHERE condition1, condition2 etc...];

Example :

mysql> DELETE FROM books
WHERE ISBN = '123456789ĞÁ0';

== ALTER ==

ALTER is used to modify the structure of a table. Here is the syntax for ALTER :

ALTER [IGNORE] TABLE tbl_name
alter_specification [, alter_specification] ...

alter_specification:
ADD [COLUMN] column_definition [FIRST | AFTER col_name ]
| ADD [COLUMN] (column_definition,...)
| ADD INDEX [index_name] [index_type] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
PRIMARY KEY [index_type] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
UNIQUE [INDEX] [index_name] [index_type] (index_col_name,...)
| ADD FULLTEXT [INDEX] [index_name] (index_col_name,...)
[WITH PARSER parser_name]
| ADD SPATIAL [INDEX] [index_name] (index_col_name,...)
| ADD [CONSTRAINT [symbol]]
FOREIGN KEY [index_name] (index_col_name,...)
[reference_definition]
| ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
| CHANGE [COLUMN] old_col_name column_definition
[FIRST|AFTER col_name]
| MODIFY [COLUMN] column_definition [FIRST | AFTER col_name]
| DROP [COLUMN] col_name
| DROP PRIMARY KEY
| DROP INDEX index_name
| DROP FOREIGN KEY fk_symbol
| DISABLE KEYS
| ENABLE KEYS
| RENAME [TO] new_tbl_name
| ORDER BY col_name
| CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
| [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name]
| DISCARD TABLESPACE
| IMPORT TABLESPACE
| table_options
| partition_options
| ADD PARTITION (partition_definition)
| DROP PARTITION partition_names
| COALESCE PARTITION number
| REORGANIZE PARTITION partition_names INTO (partition_definitions)
| ANALYZE PARTITION partition_names
| CHECK PARTITION partition_names
| OPTIMIZE PARTITION partition_names
| REBUILD PARTITION partition_names
| REPAIR PARTITION partition_names
| REMOVE PARTITIONING

== DROP ==

DROP is used to completely remove a table or database. The syntax is as follows :

mysql> DROP table_name;

== TRUNCATE ==

TRUNCATE is used when you want to remove the data, but not the structure of a table. The syntax is as follows :

mysql> TRUNCATE table_name;

[[../Creating a Table/|Previous: Creating a Table]] | [[../|TOC]] | [[../Common Functions and Operators/|Next: Common Functions and Operators]]

[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]]

Archive:Miroslav Mišković

2008-07-11T08:33:20Z

93.86.16.155:

{{Infobox Celebrity
| image = Replace this image male.svg 
| image_size = 150px |
| name = Miroslav Mišković
| caption =
| birth_date = {{birth date and age|1945|6|5}}
| birth_place = [[Bošnjane]], [[Serbia]], [[Socialist Federal Republic of Yugoslavia|Democratic Federal Yugoslavia]]
| occupation = [[President]], [[Delta Holding]]
| networth = {{gain}} [[United States dollar|US$]] 2 billion, [http://najbogatsieuropejczycy.wprost.pl The list of the 100 richest persons in the post-communist countries]
| spouse = Ljiljana Mišković
| website =
| footnotes =
}}
'''Miroslav Mišković''' ([[Serbian language|Serbian]] [[Cyrillic]]: '''Мирослав Мишковић''') (born [[July 5]], [[1945]] in [[Bošnjane|Bošnjane village]], near [[Varvarin]], [[Serbia]], [[Socialist Federal Republic of Yugoslavia|Democratic Federal Yugoslavia]]) is a [[Serbia]]n [[businessman]], the owner of [[Delta Holding]]. He is considered to be the second richest person in Serbia, behind [[Philip Zepter]], with a wealth estimated at approximately [[Dollar|$]] 2 billion as of [[2007]], according to the list of 100 wealthiest persons of the post-communist countries made by [[Poland|Polish]] magazine ''[[Wprost]]''.<ref>[http://najbogatsieuropejczycy.wprost.pl The wealthiest in post-communist countries]</ref> Mišković holds 42nd place on this list, but is fifth among the [[tycoon]]s outside the former [[Soviet Union]]. According to the [[List of billionaires (2007) 100-946|2007 list of the richest people in the world]], published annually by [[Forbes|Forbes magazine]], Mišković is a newcomer to this list, taking the 891st spot, with a net worth of [[Dollar|$]]1 billion. He is the first person from Serbia to enter this list.<ref>[http://www.forbes.com/lists/2007/10/07billionaires_Miroslav-Miskovic_CVDZ.html 2007 Forbes' annual billionaires' list]</ref>

Mišković was born in [[Bošnjane]], near [[Varvarin]], and he graduated from high school in [[Kruševac]], before moving to [[Belgrade]] and getting his degree in [[economics]] in [[1971]]. Afterwards, he worked at [[Jugobanka]] and [[Trayal]] in Kruševac until [[1977]], when he moved to [[Župa Chemical Industries]]. There, he became financial director in [[1984]] and [[chief executive officer|chief executive]] in [[1987]], holding this position until [[1990]], when he was appointed a Serbian deputy prime minister. Mišković held office for only six months. Meanwhile, Mišković founded Delta M (Delta M being a sort of abbreviation of his initials - ''double M''), a company that became very successful in the following years, during the [[Yugoslav wars]] and under the regime of [[Slobodan Milošević]]. Soon afterwards, he launched [[Delta banka]] (sold to [[Banca Intesa]] in [[2005]]), that was to become the first part of Mišković's extremely successful [[Delta Holding]] corporation that is involved in agribusiness, retail sales, distribution, financial brokerage, real estate development and insurance.

Mišković's connection to [[Slobodan Milošević]] was never obvious, except for his short stint as deputy prime minister in 1990. After the [[5th October Overthrow|overthrow of Milošević's regime]], Mišković was linked to [[Dušan Mihajlović (politician)|Dušan Mihajlović]], the interior minister at the time, and the other leaders of the [[Democratic Opposition of Serbia]] coalition. Mišković is today considered to be an important political figure with a great deal of influence on the leading politicians in Serbia.

Mišković was abducted on [[April 9]], [[2001]], but was released the next day, when the ransom (estimated at about [[German mark|DM]] 7 million) was paid 18 hours later. After the assassination of Serbian Prime Minister [[Zoran Đinđić]] [[March 12]], [[2003]], the abduction of Mišković was attributed to the same group that has been convicted of the death of the prime minister, indicating a possibility of other connections between the two crimes.

Mišković is largely reputed amongst the Serbian populace to have acquired his wealth through illegal and illicit means, as is the general concensus regarding any wealthy figurehead in the former Yugoslavia.

==References==
<div class="references-small">
<references/>
</div>

==External links==
* [http://www.forbes.com/lists/2007/10/07billionaires_Miroslav-Miskovic_CVDZ.html Mišković's biography at Forbes.com]
* [http://www.b92.net/info/kojeko/miskovic.php Mišković's biography at B92.net] (in Serbian)
* [http://www.serbian-business-club.co.yu/biografije/miskovic-deltaholding.htm Mišković's biography at Serbian Business Club.co.yu] (in Serbian)
* [http://www.vreme.com/cms/view.php?id=449550 Mišković's biography at Vreme.com] (in Serbian)
* [http://najbogatsieuropejczycy.wprost.pl The list of the 100 richest persons in the post-communist countries at Wprost.pl]

{{DEFAULTSORT:Miskovic, Miroslav}}

[[Category:1945 births]]
[[Category:Living people]]
[[Category:Serbian businesspeople]]
[[Category:Delta Holding]]
[[Category:Kidnapped businesspeople]]
[[Category:Serbian billionaires]]
[[Category:Kidnapped Serbian people]]

[[sr:Мирослав Мишковић]]

IdeaWazaWiki - User contributions [en]

Archive:PHP and MySQL Programming/Basic Queries

Archive:Miroslav Mišković