Commandos02.jpg' alt='Patch Commandos 2' title='Patch Commandos 2' />D troop commandos d troop commandos. The Creature Commandos are a fictional DC Comics team of military superhumans originally set in World War II. The original team was introduced in Weird War Tales 93. Son of World War I pilot Jack Fury, Nick Fury became a legendary hero in the early years of World War II, taking missions into Europe alongside his friend Red. Commandos HQ Your n. Source for Commandos games. Commandos HQ Your n. Source for Commandos games. My. SQL Commands. This is a list of handy My. SQL commands that I use time and time again. At the bottom are statements, clauses. My. SQL. Below that are PHP and Perl API functions you can use to interface with My. SQL. To use. those you will need to build PHP with My. SQL functionality. To use My. SQL with Perl you will need to use the Perl modules. DBI and DBD mysql. Below when you see it means from the unix shell. When you see mysql it means from a My. SQL prompt after logging. My. SQL. To login from unix shell use h only if needed. Create a database on the sql server. Qualitative Research A Guide To Design And Implementation Ebook more. List all databases on the sql server. Switch to a database. To see all the tables in the db. To see databases field formats. To delete a db. mysql drop database database name To delete a table. Show all data in a table. SELECT FROM table name Returns the columns and column information pertaining to the designated table. Show certain selected rows with the value whatever. SELECT FROM table name WHERE field name whatever Show all records containing the name Bob AND the phone number 3. SELECT FROM table name WHERE name Bob AND phonenumber 3. Show all records not containing the name Bob AND the phone number 3. SELECT FROM table name WHERE name Bob AND phonenumber 3. Show all records starting with the letters bob AND the phone number 3. SELECT FROM table name WHERE name like Bob AND phonenumber 3. Show all records starting with the letters bob AND the phone number 3. SELECT FROM table name WHERE name like Bob AND phonenumber 3. Use a regular expression to find records. Use REGEXP BINARY to force case sensitivity. This finds any record beginning with a. SELECT FROM table name WHERE rec RLIKE a Show unique records. SELECT DISTINCT column name FROM table name Show selected records sorted in an ascending asc or descending desc. SELECT col. 1,col. FROM table name ORDER BY col. DESC Return number of rows. SELECT COUNT FROM table name Sum column. SELECT SUM FROM table name Join tables on common columns. Creating a new user. Login as root. Switch to the My. SQL db. Make the user. Update privs. mysql u root pmysql use mysql mysql INSERT INTO user Host,User,Password VALUES,username,PASSWORDpassword mysql flush privileges. Change a users password from unix shell. Change a users password from My. SQL prompt. Login as root. Set the password. Update privs. mysql u root pmysql SET PASSWORD FOR userhostname PASSWORDpasswordhere mysql flush privileges. Recover a My. SQL root password. Stop the My. SQL server process. Start again with no grant tables. Login to My. SQL as root. Set new password. Exit My. SQL and restart My. SQL server. etcinit. PASSWORDnewrootpassword where Userroot mysql flush privileges mysql quit etcinit. Set a root password if there is on root password. Update a root password. Allow the user bob to connect to the server from localhost using the password passwd. Login as root. Switch to the My. SQL db. Give privs. Update privs. mysql u root pmysql use mysql mysql grant usage on to boblocalhost identified by passwd mysql flush privileges. Give user privilages for a db. Login as root. Switch to the My. SQL db. Grant privs. Update privs. mysql u root pmysql use mysql mysql INSERT INTO db Host,Db,User,Selectpriv,Insertpriv,Updatepriv,Deletepriv,Createpriv,Droppriv VALUES. Y,Y,Y,Y,Y,N mysql flush privileges. To update info already in a table. UPDATE table name SET Selectpriv Y,Insertpriv Y,Updatepriv Y where field name user Delete a rows from a table. DELETE from table name where field name whatever Update database permissionsprivilages. Delete a column. mysql alter table table name drop column column name Add a new column to db. Change column name. Make a unique column so you get no dupes. Make a column bigger. VARCHAR3 Delete unique from table. Load a CSV file into a table. LOAD DATA INFILE tmpfilename. INTO TABLE table name FIELDS TERMINATED BY, LINES TERMINATED BY n field. Dump all databases for backup. Backup file is sql commands to recreate all dbs. Dump one database for backup. Dump a table from a database. Restore database or database table from backup. Create Table Example 1. CREATE TABLE table name firstname VARCHAR2. VARCHAR3, lastname VARCHAR3. VARCHAR3,officeid VARCHAR1. VARCHAR1. 5,username VARCHAR8,email VARCHAR3. VARCHAR2. 5, groups VARCHAR1. DATE,timestamp time,pgpemail VARCHAR2. Create Table Example 2. MYSQL Statements and clauses. CHANGE MASTER TO. CREATE DATABASE. LOAD DATA FROM MASTER. LOAD DATA INFILE. LOAD INDEX INTO CACHE. LOAD TABLE. FROM MASTER. PURGE MASTER LOGS. ROLLBACK TO SAVEPOINT. SET SQLLOGBIN. SET TRANSACTION. SHOW BINLOG EVENTS. SHOW CHARACTER SET. SHOW CREATE DATABASE. SHOW CREATE TABLE. SHOW CREATE VIEW. SHOW INNODB STATUS. SHOW MASTER LOGS. SHOW MASTER STATUS. SHOW PRIVILEGES. SHOW PROCESSLIST. SHOW SLAVE HOSTS. SHOW SLAVE STATUS. SHOW TABLE STATUS. START TRANSACTION. String Functions. CHARACTERLENGTH. MATCH AGAINST. SUBSTRINGINDEX. UNCOMPRESSEDLENGTH. Date and Time Functions. CURRENTTIMESTAMP. Mathematical and Aggregate Functions. Flow Control Functions. Command Line Utilities. Perl API using functions and methods built into the Perl DBI with My. SQL. availabledrivers. Attributes for Handles. PHP API using functions built into PHP with My. SQL. mysqlaffectedrows. Reddit Related stories.