music

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

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).

---