SQL Reference
Import a sql file
==================
source ~/dump.sql
SQL Commands -
==================
ALTER TABLE PRODUCT CHANGE PRODUCT_NAME PRODUCT_NAME VARCHAR(255);
Give all rights
==================
CREATE USER 'dbAdmin'@'%' IDENTIFIED BY 'some pass';
GRANT ALL PRIVILEGES ON *.* TO 'dbAdmin'@'localhost' IDENTIFIED BY 'newpasswd' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'dbAdmin'@'%' IDENTIFIED BY 'newpasswd' WITH GRANT OPTION;
SQL Reference -
==================
http://www.1keydata.com/sql/sql.html
http://www.w3schools.com/sql/default.asp

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home