mysql cheat sheet

User Creation:

CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test623';
GRANT ALL ON testdb.* TO 'testuser'@'localhost';
FLUSH PRIVILEGES;


Sql Create Table:

 CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Comments

Post a Comment

Popular posts from this blog

How to install Openbox

sudo apt install openbox obconf sudo apt install xcompmgr cairo-dock     # create folder and file cd ~/.config mkdir openbox cd openbox # Edit file using any file editing tool like nano, vim, gedit etc nano autostart # Add following entries and save xcompmgr & cairo-dock &   sudo apt-get install menu cp / var / lib / openbox / debian-menu.xml ~ / .config / openbox / debian-menu.xml cp / etc / xdg / openbox / menu.xml ~ / .config / openbox / menu.xml cp / etc / xdg / openbox / rc.xml ~ / .config / openbox / rc.xml openbox --reconfigure     or if X11   cp / etc / X11 / openbox / menu.xml ~ / .config / openbox / menu.xml cp / etc / X11 / openbox / rc.xml ~ / .config / openbox / rc.xml  Adding a panel/taskbar sudo apt-get install tint2     sudo apt-get install feh      
Read more

Setting Up Out-of-Office Messages in Outlook

Image
Setting Up Out-of-Office Messages in Outlook Learn how to set up email to respond to incoming email with your out-of-office message. In the right place? See also Setting Up Out-of-Office Messages on Outlook Web Access . Collapse all 1. Start your setup. In Outlook, click on File , Info then select Automatic Replies (Out of Office) . Click on Send Automatic Replies and check the Only send during this time range check box. Specify a start and end time for the reply to activate and deactivate using the Start time and End time fields. Enter a message in the Inside My Organization field. This message will be sent to internal UCSD email addresses. 2. Auto reply to external email addresses. Click on the Outside My Organization tab. Make sure Auto-reply to people outside my organization is checked. Enter the message that will be sent to external (non-UCSD) email addresses. Click on OK . 3. Deac...
Read more