music
OSdata.com: programming text book 

OSdata.com

mysql

summary

    This subchapter looks at mysql, a Unix (and Linux) command.

free book on Unix/Linux System Administration

Teach Yourself Unix/Linux System Administration and Shell Programming

free computer programming text book project

table of contents
If you like the idea of this project,
then please donate some money.
more information on donating

Google

MySQL

    This subchapter looks at MySQL, a Unix (and Linux) command.

    mysql is the most common SQL database on Linux.

    You will probably want to learn the universal SQL commands first, and then you should be familiar with the differences between MySQL and PostGRE SQL (the two most common open source SQLs), as well as Oracle (the dominant proprietary SQL).

    Then you will want to learn about large scale systems that are too big for SQL, such as NOSQL.

    In terms of security, the first thing you want to learn is SQL injection attacks: what they are, how they work, where they come from, and what you can do to block them.

    Learn about database integrity -- how data bases can get screwed up and out of sync and lose data or have incorrect data -- and how to maintain database integrity.

    And learn about optimizing databases for various purposes, including reducing the load on the system, increasing transaction speed, and decreasing storage requirements.

interactive queries

    If you need to run a single interactive query on a particular MySQL database, use the -e flag.

    $ mysql DBname - e "select * from table_foo;"

resetting auto_increment

    The following command will reset the auto_increment value for a designated table:

    ALTER TABLE TableName AUTO_INCREMENT = 0;

official keywords

    The following is the list of the keywords for the official SQL standard:

ALL
AND
ANY
AS
ASC
AUTHORIZATION
AVG
BEGIN
BETWEEN
BY
CHAR
CHARACTER
CHECK
CLOSE
COBOL
COMMIT
CONTINUE
COUNT
CREATE
CURRENT
CURSOR
DEC
DECIMAL
DECLARE
DEFAULT
DELETE
DESC
DISTINCT
DOUBLE
END
ESCAPE
EXEC
EXISTS
FETCH
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
GO
GOTO
GRANT
GROUP
HAVING
IN
INDICATOR
INSERT
INT
INTEGER
INTO
IS
KEY
LANGUAGE
LIKE
MAX
MIN
MODULE
NOT
NULL
NUMERIC
OF
ON
OPEN
OPTION
OR
ORDER
PASCAL
PLI
PRECISION
PRIMARY
PRIVILEGES
PROCEDURE
PUBLIC
REAL
REFERENCES
ROLLBACK
SCHEMA
SECTION
SELECT
SET
SMALLINT
SOME
SQL
SQLCODE
SQLERROR
SUM
TABLE
TO
UNION
UNIQUE
UDATE
USER
VALUES
VIEW
WHENEVER
WHERE
WITH
WORK

other

    On November 8, 2010, Ramesh Natarajan named this the number 45 most frequently used Unix/Linux command at this web page 50 Most Frequently Used UNIX / Linux Commands (With Examples).


comments, suggestions, corrections, criticisms

please contact us

your name:
email address:
phone number:
message:

free music player coding example

    Coding example: I am making heavily documented and explained open source code for a method to play music for free — almost any song, no subscription fees, no download costs, no advertisements, all completely legal. This is done by building a front-end to YouTube (which checks the copyright permissions for you).

    View music player in action: www.musicinpublic.com/.

    Create your own copy from the original source code/ (presented for learning programming).

This section is under the category of owning cirticism.

In response to a posting about my article collecting social media, Moderator +Andrew Smith (Technology addict, Web Developer, API guru, futsal and football wannabe, and all round nice guy!, Swordfox Design, arrowtown, new zealand) of the Google+ community Web Developers, Web Designers, Web Coding claims “Quite frankly this is self promotion, and your site is not of great quality. I can see how +Joost SchuurÊ would think this of not high enough a standard.”


return to table of contents
free downloadable college text book
free downloadable system administrator and shell programming book

view text book
HTML file

Because I no longer have the computer and software to make PDFs, the book is available as an HTML file, which you can convert into a PDF.

previous page next page
previous page next page

free book on Unix/Linux System Administration

Teach Yourself Unix/Linux System Administration and Shell Programming

free computer programming text book project

Building a free downloadable text book on computer programming for university, college, community college, and high school classes in computer programming.

If you like the idea of this project,
then please donate some money.

send donations to:
Milo
PO Box 1361
Tustin, California 92781

Supporting the entire project:

    If you have a business or organization that can support the entire cost of this project, please contact Pr Ntr Kmt (my church)

more information on donating

Some or all of the material on this web page appears in the
free downloadable college text book on computer programming.


Google


Made with Macintosh

    This web site handcrafted on Macintosh computers using Tom Bender’s Tex-Edit Plus and served using FreeBSD .

Viewable With Any Browser


    †UNIX used as a generic term unless specifically used as a trademark (such as in the phrase “UNIX certified”). UNIX is a registered trademark in the United States and other countries, licensed exclusively through X/Open Company Ltd.

    Names and logos of various OSs are trademarks of their respective owners.

    Copyright © 2012, 2013, 2014 Milo

    Created: February 24, 2012

    Last Updated: August 29, 2014


return to table of contents
free downloadable college text book
free downloadable system administrator and shell programming book

previous page next page
previous page next page