Software Outsourcing, Offshore Software Development, Offshore Outsourcing Services, IT Outsourcing, Offshore Development
MySQL manual Offshore Software Outsourcing and Programming, IT Outsourcing Offshore Software Development  
Call Us Today: 1-800-678-9001
Offshore Software Outsourcing and Programming, IT Outsourcing Offshore Software Development

Home / Technical Support / MySQL

Key Offerings:

B2B and B2C E-Business Solutions

Offshore Software Development Outsourcing

Strategic Consulting

Offshore Software Outsourcing

About ALTOROS: ALTOROS Systems is headquartered in Tampa, Florida and maintains an office near Boston, Massachusetts and technology development center in Belarus and Russia. ALTOROS specializes on providing value-added e-commerce and web-based software development and offshore software outsourcing services to emerging enterprises helping them successfully plan and implement business initiatives.

Contact Us for more information.

Node: Function Index, Next: Concept Index, Prev: LGPL license, Up: Top
SQL command, type and function index
 
! (logical NOT):      Logical Operators.
!= (not equal):      Comparison Operators.
":      Legal names.
% (modulo):      Mathematical functions.
% (wildcard character):      String syntax.
& (bitwise AND):      Bit functions.
&& (logical AND):      Logical Operators.
() (parentheses):      Parentheses.
(Control-Z) \z:      String syntax.
* (multiplication):      Arithmetic functions.
+ (addition):      Arithmetic functions.
- (subtraction):      Arithmetic functions.
- (unary minus):      Mathematical functions.
-p option:      Password security.
-password option:      Password security.
.my.cnf file <1>:      Option files.
.my.cnf file <2>:      Windows vs Unix.
.my.cnf file <3>:      Access denied.
.my.cnf file <4>:      Connecting.
.my.cnf file <5>:      Password security.
.my.cnf file <6>:      Option files.
.my.cnf file:      Multiple servers.
.mysql_history file <1>:      Server-Side Overview.
.mysql_history file:      Client-Side Overview.
.pid (process ID) file:      Maintenance regimen.
/ (division):      Arithmetic functions.
/etc/passwd:      SELECT.
< (less than):      Comparison Operators.
<< (left shift):      Bit functions.
<<:      Calculating days.
<= (less than or equal):      Comparison Operators.
<=> (Equal to):      Comparison Operators.
<> (not equal):      Comparison Operators.
= (equal):      Comparison Operators.
> (greater than):      Comparison Operators.
>= (greater than or equal):      Comparison Operators.
>> (right shift):      Bit functions.
\" (double quote):      String syntax.
\' (single quote):      String syntax.
\0 (ASCII 0):      String syntax.
\\ (escape):      String syntax.
\b (backspace):      String syntax.
\n (newline):      String syntax.
\r (carriage return):      String syntax.
\t (tab):      String syntax.
\z (Control-Z) ASCII(26):      String syntax.
^ (bitwise XOR):      Bit functions.
_ (wildcard character):      String syntax.
`:      Legal names.
ABS():      Mathematical functions.
ACOS():      Mathematical functions.
ADDDATE():      Date and time functions.
addition (+):      Arithmetic functions.
AES_DECRYPT():      Miscellaneous functions.
AES_ENCRYPT():      Miscellaneous functions.
alias:      Problems with alias.
ALTER COLUMN:      ALTER TABLE.
ALTER TABLE <1>:      ALTER TABLE.
ALTER TABLE:      ALTER TABLE problems.
ANALYZE TABLE:      ANALYZE TABLE.
AND, bitwise:      Bit functions.
AND, logical:      Logical Operators.
arithmetic functions:      Bit functions.
ASCII():      String functions.
ASIN():      Mathematical functions.
AS <1>:      SELECT.
AS:      JOIN.
ATAN():      Mathematical functions.
ATAN2():      Mathematical functions.
AUTO_INCREMENT, using with DBI:      Perl DBI Class.
AVG():      Group by functions.
backspace (\b):      String syntax.
BACKUP TABLE:      BACKUP TABLE.
BEGIN:      COMMIT.
BENCHMARK():      Miscellaneous functions.
BETWEEN ... AND:      Comparison Operators.
BIGINT:      Column types.
BIN():      String functions.
BINARY:      Case Sensitivity Operators.
bit functions:      Bit functions.
BIT_AND():      Group by functions.
BIT_COUNT():      Bit functions.
BIT_COUNT:      Calculating days.
BIT_LENGTH():      String functions.
BIT_OR():      Group by functions.
BIT_OR:      Calculating days.
BIT:      Column types.
BLOB <1>:      Column types.
BLOB:      BLOB.
BOOL:      Column types.
carriage return (\r):      String syntax.
CASE:      Control flow functions.
casts:      Case Sensitivity Operators.
CAST:      Cast Functions.
CC environment variable <1>:      Compilation problems.
CC environment variable:      Environment variables.
CCX environment variable:      Environment variables.
CEILING():      Mathematical functions.
CFLAGS environment variable <1>:      Environment variables.
CFLAGS environment variable:      Compilation problems.
CHAR VARYING:      Column types.
CHAR():      String functions.
CHAR_LENGTH():      String functions.
CHARACTER VARYING:      Column types.
CHARACTER_LENGTH():      String functions.
CHARACTER:      Column types.
CHAR <1>:      Column types.
CHAR:      String types.
CHECK TABLE:      CHECK TABLE.
ChopBlanks DBI method:      Perl DBI Class.
COALESCE():      Comparison Operators.
command-line options:      Command-line options.
Comment syntax:      Comments.
COMMIT <1>:      COMMIT.
COMMIT:      ANSI diff Transactions.
comparison operators:      Comparison Operators.
CONCAT():      String functions.
CONCAT_WS():      String functions.
configure option, --with-charset:      configure options.
configure option, --with-extra-charset:      configure options.
connect() DBI method:      Perl DBI Class.
CONNECTION_ID():      Miscellaneous functions.
control flow functions:      Control flow functions.
CONV():      String functions.
CONVERT:      Cast Functions.
COS():      Mathematical functions.
COT():      Mathematical functions.
COUNT():      Group by functions.
COUNT(DISTINCT):      Group by functions.
CREATE DATABASE:      CREATE DATABASE.
CREATE FUNCTION:      CREATE FUNCTION.
CREATE INDEX:      CREATE INDEX.
CREATE TABLE:      CREATE TABLE.
CROSS JOIN:      JOIN.
CURDATE():      Date and time functions.
CURRENT_DATE:      Date and time functions.
CURRENT_TIMESTAMP:      Date and time functions.
CURRENT_TIME:      Date and time functions.
CURTIME():      Date and time functions.
CXX environment variable:      Compilation problems.
CXXFLAGS environment variable <1>:      Compilation problems.
CXXFLAGS environment variable <2>:      configure options.
CXXFLAGS environment variable <3>:      Environment variables.
CXXFLAGS environment variable:      configure options.
data_sources() DBI method:      Perl DBI Class.
DATABASE():      Miscellaneous functions.
date and time functions:      Date and time functions.
DATE_ADD():      Date and time functions.
DATE_FORMAT():      Date and time functions.
DATE_SUB():      Date and time functions.
DATETIME <1>:      Column types.
DATETIME:      DATETIME.
DATE <1>:      Using DATE.
DATE <2>:      DATETIME.
DATE:      Column types.
DAYNAME():      Date and time functions.
DAYOFMONTH():      Date and time functions.
DAYOFWEEK():      Date and time functions.
DAYOFYEAR():      Date and time functions.
DBI->{ChopBlanks}:      Perl DBI Class.
DBI->{insertid}:      Perl DBI Class.
DBI->{is_blob}:      Perl DBI Class.
DBI->{is_key}:      Perl DBI Class.
DBI->{is_not_null}:      Perl DBI Class.
DBI->{is_num}:      Perl DBI Class.
DBI->{is_pri_key}:      Perl DBI Class.
DBI->{length}:      Perl DBI Class.
DBI->{max_length}:      Perl DBI Class.
DBI->{NAME}:      Perl DBI Class.
DBI->{NULLABLE}:      Perl DBI Class.
DBI->{NUM_OF_FIELDS}:      Perl DBI Class.
DBI->{table}:      Perl DBI Class.
DBI->{type}:      Perl DBI Class.
DBI->connect():      Perl DBI Class.
DBI->data_sources():      Perl DBI Class.
DBI->disconnect:      Perl DBI Class.
DBI->do():      Perl DBI Class.
DBI->execute:      Perl DBI Class.
DBI->fetchall_arrayref:      Perl DBI Class.
DBI->fetchrow_arrayref:      Perl DBI Class.
DBI->fetchrow_array:      Perl DBI Class.
DBI->fetchrow_hashref:      Perl DBI Class.
DBI->finish:      Perl DBI Class.
DBI->prepare():      Perl DBI Class.
DBI->quote():      Perl DBI Class.
DBI->quote:      String syntax.
DBI->rows:      Perl DBI Class.
DBI->trace <1>:      Using gdb on mysqld.
DBI->trace:      Perl DBI Class.
DBI_TRACE environment variable <1>:      Environment variables.
DBI_TRACE environment variable:      Using gdb on mysqld.
DBI_USER environment variable:      Environment variables.
DECIMAL:      Column types.
DECODE():      Miscellaneous functions.
DEC:      Column types.
DEGREES():      Mathematical functions.
DELAYED:      INSERT DELAYED.
DELETE:      DELETE.
DES_DECRYPT():      Miscellaneous functions.
DES_ENCRYPT():      Miscellaneous functions.
DESCRIBE <1>:      Getting information.
DESCRIBE:      DESCRIBE.
DESC:      DESCRIBE.
disconnect DBI method:      Perl DBI Class.
DISTINCT <1>:      Selecting columns.
DISTINCT <2>:      Group by functions.
DISTINCT:      DISTINCT optimisation.
division (/):      Arithmetic functions.
do() DBI method:      Perl DBI Class.
DOUBLE PRECISION:      Column types.
double quote (\"):      String syntax.
DOUBLE:      Column types.
DO:      DO.
DROP DATABASE:      DROP DATABASE.
DROP FUNCTION:      CREATE FUNCTION.
DROP INDEX <1>:      DROP INDEX.
DROP INDEX:      ALTER TABLE.
DROP PRIMARY KEY:      ALTER TABLE.
DROP TABLE:      DROP TABLE.
DUMPFILE:      SELECT.
ELT():      String functions.
ENCODE():      Miscellaneous functions.
ENCRYPT():      Miscellaneous functions.
ENUM <1>:      Column types.
ENUM:      ENUM.
Environment variable, CCX:      Environment variables.
environment variable, CC:      Compilation problems.
Environment variable, CC:      Environment variables.
Environment variable, CFLAGS:      Environment variables.
environment variable, CFLAGS:      Compilation problems.
environment variable, CXXFLAGS <1>:      configure options.
environment variable, CXXFLAGS:      Compilation problems.
Environment variable, CXXFLAGS:      Environment variables.
environment variable, CXXFLAGS:      configure options.
Environment variable, CXX:      Compilation problems.
environment variable, CXX:      Compilation problems.
Environment variable, DBI_TRACE <1>:      Using gdb on mysqld.
Environment variable, DBI_TRACE:      Environment variables.
Environment variable, DBI_USER:      Environment variables.
Environment variable, HOME:      Environment variables.
Environment variable, LD_RUN_PATH <1>:      Environment variables.
Environment variable, LD_RUN_PATH:      Perl support problems.
environment variable, LD_RUN_PATH:      Linux.
Environment variable, LD_RUN_PATH:      Solaris.
Environment variable, MYSQL_DEBUG <1>:      Debugging client.
Environment variable, MYSQL_DEBUG:      Environment variables.
Environment variable, MYSQL_HISTFILE:      Environment variables.
Environment variable, MYSQL_HOST:      Environment variables.
Environment variable, MYSQL_PS1:      Environment variables.
Environment variable, MYSQL_PWD:      Environment variables.
environment variable, MYSQL_TCP_PORT:      Multiple servers.
Environment variable, MYSQL_TCP_PORT:      Environment variables.
Environment variable, MYSQL_UNIX_PORT:      Environment variables.
environment variable, MYSQL_UNIX_PORT:      Multiple servers.
Environment variable, MYSQL_UNIX_PORT:      mysql_install_db.
Environment variable, PATH:      Environment variables.
environment variable, PATH:      Installing binary.
Environment variable, TMPDIR <1>:      Environment variables.
Environment variable, TMPDIR:      mysql_install_db.
Environment variable, TZ <1>:      Environment variables.
Environment variable, TZ:      Timezone problems.
Environment variable, UMASK_DIR <1>:      File permissions.
Environment variable, UMASK_DIR:      Environment variables.
Environment variable, UMASK <1>:      Environment variables.
Environment variable, UMASK:      File permissions.
Environment variable, USER:      Environment variables.
environment variable, CC:      configure options.
environment variable, CXX:      configure options.
environment variable, DBI_TRACE:      Perl DBI Class.
environment variable, HOME <1>:      Server-Side Overview.
environment variable, HOME:      Client-Side Overview.
environment variable, MYSQL_DEBUG <1>:      Server-Side Overview.
environment variable, MYSQL_DEBUG:      Client-Side Overview.
environment variable, MYSQL_HISTFILE <1>:      Client-Side Overview.
environment variable, MYSQL_HISTFILE:      Server-Side Overview.
environment variable, MYSQL_HOST:      Connecting.
environment variable, MYSQL_PWD <1>:      Connecting.
environment variable, MYSQL_PWD <2>:      Client-Side Overview.
environment variable, MYSQL_PWD:      Server-Side Overview.
environment variable, MYSQL_TCP_PORT <1>:      Client-Side Overview.
environment variable, MYSQL_TCP_PORT <2>:      Installing many servers.
environment variable, MYSQL_TCP_PORT:      Server-Side Overview.
environment variable, MYSQL_UNIX_PORT <1>:      Client-Side Overview.
environment variable, MYSQL_UNIX_PORT <2>:      Server-Side Overview.
environment variable, MYSQL_UNIX_PORT:      Installing many servers.
environment variable, USER:      Connecting.
Environment variables, CXX:      Compilation problems.
equal (=):      Comparison Operators.
escape (\\):      String syntax.
execute DBI method:      Perl DBI Class.
EXP():      Mathematical functions.
EXPLAIN:      EXPLAIN.
EXPORT_SET():      String functions.
EXTRACT():      Date and time functions.
fetchall_arrayref DBI method:      Perl DBI Class.
fetchrow_array DBI method:      Perl DBI Class.
fetchrow_arrayref DBI method:      Perl DBI Class.
fetchrow_hashref DBI method:      Perl DBI Class.
FIELD():      String functions.
FILE:      String functions.
FIND_IN_SET():      String functions.
finish DBI method:      Perl DBI Class.
FLOAT(M,D):      Column types.
FLOAT(precision):      Column types.
FLOAT:      Column types.
FLOOR():      Mathematical functions.
FLUSH:      FLUSH.
FORMAT():      Miscellaneous functions.
FOUND_ROWS():      Miscellaneous functions.
FROM_DAYS():      Date and time functions.
FROM_UNIXTIME():      Date and time functions.
functions, arithmetic:      Bit functions.
functions, bit:      Bit functions.
functions, control flow:      Control flow functions.
functions, date and time:      Date and time functions.
functions, GROUP BY:      Group by functions.
functions, mathematical:      Mathematical functions.
functions, miscellaneous:      Miscellaneous functions.
functions, string comparison:      String comparison functions.
functions, string:      String functions.
Functions, user-defined:      CREATE FUNCTION.
GET_LOCK():      Miscellaneous functions.
GRANT statemenet:      Secure GRANT.
GRANT statement:      Adding users.
GRANT:      GRANT.
greater than (>):      Comparison Operators.
greater than or equal (>=):      Comparison Operators.
GREATEST():      Mathematical functions.
GROUP BY functions:      Group by functions.
HANDLER:      UNION.
HEX():      String functions.
hexadecimal values:      Hexadecimal values.
HOME environment variable:      Environment variables.
host.frm, problems finding:      Post-installation.
HOUR():      Date and time functions.
identifiers, quoting:      Legal names.
IF():      Control flow functions.
IFNULL():      Control flow functions.
IGNORE INDEX <1>:      SELECT.
IGNORE INDEX:      JOIN.
IGNORE KEY <1>:      SELECT.
IGNORE KEY:      JOIN.
INET_ATON():      Miscellaneous functions.
INET_NTOA():      Miscellaneous functions.
INNER JOIN:      JOIN.
INSERT ... SELECT:      INSERT.
INSERT DELAYED:      INSERT DELAYED.
INSERT statement, grant privileges:      Adding users.
INSERT():      String functions.
insertid DBI method:      Perl DBI Class.
INSERT <1>:      INSERT.
INSERT:      Insert speed.
INSTR():      String functions.
INTEGER:      Column types.
INTERVAL():      Comparison Operators.
INT:      Column types.
IN:      Comparison Operators.
IS NOT NULL:      Comparison Operators.
IS NULL, and indexes:      MySQL indexes.
IS NULL:      Comparison Operators.
is_blob DBI method:      Perl DBI Class.
IS_FREE_LOCK():      Miscellaneous functions.
is_key DBI method:      Perl DBI Class.
is_not_null DBI method:      Perl DBI Class.
is_num DBI method:      Perl DBI Class.
is_pri_key DBI method:      Perl DBI Class.
ISNULL():      Comparison Operators.
ISOLATION LEVEL:      SET TRANSACTION.
JOIN:      JOIN.
KILL:      KILL.
LAST_INSERT_ID():      ANSI diff Transactions.
LAST_INSERT_ID([expr]):      Miscellaneous functions.
LCASE():      String functions.
LD_RUN_PATH environment variable <1>:      Environment variables.
LD_RUN_PATH environment variable <2>:      Perl support problems.
LD_RUN_PATH environment variable <3>:      Solaris.
LD_RUN_PATH environment variable:      Linux.
LEAST():      Mathematical functions.
LEFT JOIN <1>:      JOIN.
LEFT JOIN:      LEFT JOIN optimisation.
LEFT OUTER JOIN:      JOIN.
LEFT():      String functions.