Главная    Ex Libris    Книги    Журналы    Статьи    Серии    Каталог    Wanted    Загрузка    ХудЛит    Справка    Поиск по индексам    Поиск    Форум   
blank
Авторизация

       
blank
Поиск по указателям

blank
blank
blank
Красота
blank
Forta B. — MySQL Crash Course
Forta B. — MySQL Crash Course

Читать книгу
бесплатно

Скачать книгу с нашего сайта нельзя

Обсудите книгу на научном форуме



Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter


Название: MySQL Crash Course

Автор: Forta B.

Аннотация:

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

* Retrieve and sort data
* Filter data using comparisons, regular expressions, full text search, and much more
* Join relational data
* Create and alter tables
* Insert, update, and delete data
* Leverage the power of stored procedures and triggers
* Use views and Cursors
* Manage transactional processing
* Create user accounts and manage security via access control


Язык: en

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2005

Количество страниц: 336

Добавлена в каталог: 22.08.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
% (wildcards)      
% (wildcards), overview      2nd
*=
*=, support for      
-
-, ranges, defining with      
.      [See matches (regular expressions)]
., basic character matches      
=*
=*, support for      
access controls      
access controls, mistakes, preventing      
access controls, overview      2nd
access controls, user accounts      2nd 3rd 4th
Administrator (MySQL)      [See MySQL Administrator] [See MySQL Administrator]
advantages of (MySQL)      
After      
AFTER, versus BEFORE      
Against()      
Against(), full-text searches      2nd 3rd 4th
Aggregate functions      
aggregate functions, ALL argument      
aggregate functions, AVG()      
aggregate functions, AVG(), limitations of      
aggregate functions, AVG(), overview      2nd
aggregate functions, combining      2nd
aggregate functions, COUNT()      
aggregate functions, COUNT(), DISTINCT arguments      
aggregate functions, COUNT(), overview      2nd
aggregate functions, DISTINCT argument      2nd
aggregate functions, DISTINCT arguments      2nd
aggregate functions, DISTINCT arguments, MIN()/MAX() interaction      
aggregate functions, joins, utilizing      2nd
aggregate functions, MAX()      
aggregate functions, MAX(), non-numeric data      2nd
aggregate functions, MAX(), overview      2nd
aggregate functions, MIN()      
aggregate functions, MIN(), non-numeric data      
aggregate functions, MIN(), overview      2nd
aggregate functions, naming aliases      
aggregate functions, overview      2nd
aggregate functions, SUM()      
aggregate functions, SUM(), multiple columns      
aggregate functions, SUM(), overview      2nd
Aliases      
aliases, aggregate functions      
aliases, aggregate functions, naming      
aliases, alternative uses      
aliases, concatenating fields      2nd
aliases, table names      2nd
ALTER TABLE statements      2nd 3rd
ANALYZE TABLE      
anchors (regular expressions      2nd
AND      
and operator      
AND operator, WHERE clauses, combining      
AND, definition of      
AND, OR, combining      [See also OR]
AND, WHERE clauses, combining      
application filtering      
application filtering, compared to SQL      
AS keyword      2nd
ASC      
ASC, utilizing      
asterisk wildcard      
asterisk wildcard, columns, retrieving      
asterisk wildcards      
asterisk wildcards, columns, retrieving      2nd
AUTO INCREMENT      2nd 3rd 4th
auto increment, description of      
autocommit flags      
AVG()      
AVG() function      
AVG() function, DISTINCT arguments      2nd
AVG(), limitations of      
AVG(), overview      2nd
backing up      
backing up, data      2nd
basic character matching      
basic character matching (regular expressions)      [See matches (regular expressions)]
basic character matching, case-sensitiviy      
Before      
BEFORE versus AFTER      
BETWEEN      
BETWEEN, range values with WHERE clauses      
BETWEEN, range values, checking      
binary datatypes      2nd
boolean mode      
boolean mode, utilizing      2nd 3rd 4th 5th
boolean mode, versus FULLTEXT clauses      
Calculated fields      
calculated fields, concatenating fields      2nd 3rd
calculated fields, concatenating fields, column aliases      2nd
calculated fields, mathematical calculations      2nd 3rd
calculated fields, overview      2nd 3rd
calculated fields, subqueries as      2nd 3rd
Cartesian products      
Cartesian products, overview      2nd
case sensitivity      
case sensitivity, full-text searches      
case sensitivity, sort orders      
case sensitivity, statements      
Case-sensitivity      
case-sensitivity, expression matching      
case-sensitivity, searches      
character classes (regular expressions), matching      2nd
character matching      [See basic character matching]
characters sets      
characters sets, overview      2nd
characters sets, working with      2nd 3rd
CHECK TABLE      
clauses      
clauses, definition of      [See also commands]
client-based results fomatting      
client-based results fomatting, compared to server-based      
client-server software      
client-server software, overview      2nd
collation sequences      
collation sequences, overview      2nd
collation sequences, working with      2nd 3rd
column aliases      
column aliases, alternative uses      
column aliases, concatening fields      2nd
Columns      [See also fields]
columns, commas between names      
columns, definition of      
columns, derived      
columns, fully qualified names      
columns, INSERT statement      
columns, INSERT statement, columns, omitting      
columns, padded spaces      
columns, padded spaces, RTRIM() function      2nd
columns, primary keys      
columns, primary keys, definition of      2nd
columns, retrieving all      
columns, retrieving all, with SELECT      2nd
columns, retrieving individually      
columns, retrieving individually with SELECT      2nd
columns, retrieving multiple      
columns, retrieving multiple with SELECT      2nd
columns, separating correctly      
columns, sorting by multiple      2nd 3rd
columns, subquery result restrictions      
combined queries      
combined queries, creating      
command line (mysql)      [See mysql command line]
command line (mysql), overview      
command-line utilities      
command-line utilities, delimiters      2nd
Commands      [See also keywords]
commas      
commas, between column names      
COMMENT keyword      
COMMENT keyword, stored procedures      
commiting      
commiting, definition of      
commits      
commits, default behavior, changing      2nd
commits, transactions, controlling      2nd
complex joins      
complex joins, views, simplifying with      2nd
compound queries      
compound queries, creating      2nd
compound queries, overview      2nd
compound queries, rules of      2nd
compound queries, sorting results      2nd
compound queries, WHERE clause combinations      
compound quiries      
compound quiries, rows, eliminating/including dublicates      2nd
concaenating      
concaenating, definition of      
concatenating, fields      2nd 3rd
concatenating, fields, cloumn aliases      
concatenating, fields, column aliases      
concatenating, fields, mathematical calcualtions      2nd 3rd
Connection      [See also logins]
count()      
count() function      
COUNT() function, DISTINCT arguments      
COUNT() function, joins      
COUNT(), overview      2nd
COUNT(*) calculations      
COUNT(*) calculations, performing through subqueries      
create      
CREATE TABLE      [See also tables]
CREATE TABLE statements      2nd 3rd
CREATE TABLE, engines      2nd
CREATE, auto increment      
CREATE, auto increment, utilizing      
cross joins      [See also Cartesian products]
currency numbers, storing      
cursors      
cursors, creating      2nd
cursors, FETCH statements      2nd 3rd 4th
cursors, opening/closing      2nd
cursors, overview      2nd
cursors, utilizing      2nd
customers table      2nd
DATA      
data, backing up      2nd
data, grouping      [See GROUP BY]
data, separating correctly      
Database Management Systems      [See DBMSs]
database server      
database server, client-server software interaction      
databases      
databases, backing up      2nd
databases, compared to Database Management Systems (DBMSs)      
databases, compared to schema      
databases, definition of      
databases, maintenance, performing      2nd
Databases, selecting      
databases, selecting with USE      2nd
datatype      
datatype, definition of      
Datatypes      
datatypes, binary datatypes      2nd
datatypes, date and time datatypes      2nd
datatypes, numeric datatypes      2nd 3rd
datatypes, overview      2nd
datatypes, string datatypes      2nd 3rd
date and time manipulation functions      
date and time manipulation functions, overview      2nd 3rd 4th
date datatypes      2nd
DBMS performance, improving      2nd 3rd
DBMSs      
DBMSs, compared to databases      
DECLARE statements      
DECLARE statements, organizing      
DECLARE statements, stored procedures      
default      
DEFAULT, tables      2nd
DELAYED keywords      
DELETE statements      2nd
DELETE statements versus TRUNCATE TABLE      
DELETE triggers      2nd
delimiters      2nd
derived columns      [See aliases]
DESC      
DESC, utilizing      2nd
describe      
DESCRIBE, description of      
DISTINCT      [See also LIMIT]
DISTINCT arguments      
DISTINCT arguments, AVG() function      2nd
DISTINCT arguments, COUNT() interaction      
DISTINCT, retrieving distinct rows      2nd 3rd
downloading MySQL      
DROP PROCEDURE      
DROP TABLE statement      2nd
DROP USER      
encodings      
encodings, definition of      
engies      
engies, transaction support      
Engines      
engines, CREATE TABLE      2nd
engines, foreign keys      
engines, list of      
error codes      
error codes, website list of      
expression matching      [See matches (regular expressions)]
FETCH statements      
FETCH statements, cursors      2nd 3rd 4th
Fields      
fields, calculated      
fields, calculated, concatenating fields      2nd 3rd 4th 5th
fields, calculated, mathematical calculations      2nd 3rd
fields, calculated, overview      2nd 3rd
fields.      2nd [See also columns] [See also calculated fields]
FLUSH LOGS statements      
FLUSH TABLES statements      
foreign keys      
foreign keys, spanning engines      
Formatting      
formatting, server-based compared to client-based      
from      
FROM, purpose of      
full-text searches      
full-text searches, boolean mode      2nd 3rd 4th 5th
full-text searches, case sensitivity      
full-text searches, multiple search terms, ranking      
full-text searches, overview      2nd
full-text searches, performing      2nd 3rd 4th
full-text searching      
full-text searching, enabling      2nd
full-text searching, engine support      
full-text searchs, query expansion      2nd 3rd
FULLTEXT clauses      
FULLTEXT clauses, utilizing      2nd
FULLTEXT clauses, versus boolean mode      
FULLTEXT, importing data with      
fully qualified table names      
fully qualified table names, overview      2nd
functions, date and time manipulation functions      
functions,, date and time manipulation functions, overview      2nd 3rd 4th
functions,, numeric manipulation functions      
functions,, numeric manipulation functions, overview      2nd
functions,, overview      
functions,, portability of      2nd
1 2 3
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2017
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте