Basics of mysql - The Diigo Meta page

• 20 Sep 08
  

  nirav hamlai

  mysql

• 24 Oct 06
  

  basics coding commands help mysql

  • Basics of mysql  

    Start the console: mysql 

     

    List all databases: show databases;  

     

    Switch to a database: use $dbname;  

     

    List tables in a current database: show tables;  

     

    List columns in a given table: describe $tablename;  

     

    Setting permissions to a database: GRANT SELECT ON $database.* TO '$user_name'@'%' IDENTIFIED BY '$password';  

     

    Deleting rows: delete from $db.$table where $condition;  

     

    Selects: select count(*) from $db.$table;  

     

    Altering a table: 

       

    ALTER TABLE get_cookie_log ADD COLUMN log_id INT(10) NOT NULL auto_increment, ADD PRIMARY KEY(log_id);` ALTER TABLE get_cookie_log ADD COLUMN log_id INT(10) NOT NULL auto_increment, ADD INDEX(log_id);` ALTER TABLE verify_reg_code_log ADD COLUMN log_id INT(10) NOT NULL auto_increment, ADD INDEX(log_id);` 

      

    Backup database: mysqldump $database [[-all] | [$table]]s >$file-name.sql  

     

    Import database: 

       

    mysql -e "DROP DATABASE $db; CREATE DATABASE $db;" mysql $databasename <$file-name.sql

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.