Getting started with MySQL using wamp server

After installing the wamp server on your computer follow the below steps.

Step 1 : Run the command prompt. 

Step 2 : Copy the path of the bin folder of the wamp server. usually it is,

C:\wamp64\bin\mysql\mysql5.7.19\bin

Step 3 : Go back to the command prompt and change the directory to the path you copied

C:\Users\admin>cd C:\wamp64\bin\mysql\mysql5.7.19\bin

Step 4 : Then type the command "mysql -u root -p", then press enter.

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -u root -p

Step 5 : Then it will request the password, just enter because there isn't a password.

Enter password:

Step 6 : If you have successfully connected following message will be prompted.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Now you can start typing MySQL commands here onwards. To quit the wamp server simply type "quit".

mysql> quit
Bye

Comments

Post a Comment

Popular posts from this blog

Java ADF surfing through pages using buttons

Image
Open 'Oracle JDeveloper Studio' by double clicking on the icon. Select Studio Developer (All Features) and press 'Ok'.  Press 'Finish' We need to create a folder before creating page fragments. Select from gallery Add a folder name and press 'Ok'.  Then create page fragments. Here we are studying the connection between two pages therefore we need to create two page fragments. Change the file name and press 'Ok'. At the components panel search 'panel box' then drag and drop a panel box onto the page fragment.  Then drag and drop a button from the panel 'General Controls'. You can change the names of the button and the panel box at the 'Common' tab. Then go to page flow in web content (in Applications tab) and create a ADF Task Flow.
Read more

SQL vs ORM

Creating a table In SQL the table can be created using the CREATE TABLE command CREATE TABLE people( name VARCHAR(30), NIC VARCHAR(10) PRIMARY KEY, phone VARCHAR(20) ); In ORM we can create types and use them to create a table. Object Type syntax CREATE TYPE <object_type_name> AS OBJECT( <attribute1> <datatype>, <attribute2> <datatype> ); First, we have to create a type as an object using the CREATE TYPE command CREATE TYPE person AS OBJECT( name VARCHAR(30), phone VARCHAR(20) ); Then we can create the table using the above type CREATE TABLE person_table OF person( NIC PRIMARY KEY ); Inserting data into a table We can insert data in two ways Method 1 Without specifying the object name INSERT INTO person_table VALUES(101, 'John', 'Smith', 'jsmith@example.com', '1-650-555-0135'); Method 2 Using the object name INSERT INTO person_table VALUES(person(101, 'John', 'Smith', &#
Read more