Connecting aws ec2 mysql from workbench

Hello all, After a lot of struggle I finally made connection to aws ec2 mysql from workbench, posting here to help you guys. Connecting aws ec2 mysql from workbench:     If you are getting any other exceptions then do validate the below steps once again,   Step 1: Creating root user with all the privileges: CREATE USER ‘root’@’18.188.178.178’ IDENTIFIED […]

 754 total views

» Read more

Oracle MySQL & PL/SQL Quick Notes

Hi Guys, We come across few queries in oracle and pl/sql on daily development tasks which we forget/wont remember correctly sometime. This post keeps track on those items. Keep visiting this post for the regular updates. This can be used to refresh for your oracle and pl/sql interviews as well. Feel free to add your thoughts in the comments section […]

 2,916 total views,  8 views today

» Read more

MongoDB CRUD Commands for Beginners

If you are very new to MongoDB and do not have MongoDB installed in your machine, refer the below link to install mongodb on windows 7. How to install mongodb on windows 7 ? This is how data stores in MongoDB, Database -> collections -> Documents (structured and unstructured) Where In RDBMS, Schema -> Database -> Tables -> Rows and […]

 1,190 total views

» Read more

How to connect MongoDB with Java ?

how to connect mongodb with java ?

How to connect MongoDB with Java ?: MongoDB is a document based open source data model. It stores the unstructured data’s in a JSON format. In our earlier posts we have seen how to install mongodb on windows 7 and resolved some of the most common issues while installing mongodb in windows 7.   How to install mongodb on windows […]

 1,553 total views

» Read more

How to Insert Single and Double Quotes in Oracle?

How to Insert Single and Double Quotes in Oracle? Inserting Single quote in oracle: If your query is like this, insert into emp (id,name,salary) values (10,’Naveen’s’,10000); // error then you will get the error for the single quote in the name. We have to escape it to insert in oracle using one more single quote like this, insert into emp […]

 1,214 total views,  2 views today

» Read more

Autocomplete using jQuery, PHP and MySQL

autocomplete_output

Autocomplete is a basic mandatory functionality in any web development. It will help user to find the correct item just with partial name/some letters of the item which they know about the item.     Import the below scripts and CSS’s: [plain] <script type=”text/javascript” src=”http://code.jquery.com/jquery-2.1.1.min.js”></script> <script type=”text/javascript” src=”//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js”></script> <script type=”text/javascript” src=”http://ajax.aspnetcdn.com/ajax/jquery.ui/1.11.0/jquery-ui.min.js”></script> <link rel=”stylesheet” href=”http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/redmond/jquery-ui.css” type=”text/css” /> <link rel=”stylesheet” href=”//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css” type=”text/css” […]

 2,477 total views

» Read more

Java With MySQL Select Example

Download the users_test table: Users_test table – Mysql download Loading the Mysql connection: public Connection LoadDriver() { Connection connection = null; try { // Driver Name String mySQLDriver = "org.gjt.mm.mysql.Driver"; // Path/database name [here guru is the database name] String url = "jdbc:mysql://localhost:3306/guru"; Class.forName(mySQLDriver); // User name and password connection = DriverManager.getConnection(url, "root", "pass123"); } catch (Exception exception) { System.err.println("Exception! […]

 1,533 total views,  2 views today

» Read more

select with timestamp or date in oracle

select with timestamp or date in oracle: If you want to select the date field or timestamp field with the given date, then you have to use the query like this, select * from TABLE_NAME where TO_CHAR(TIMESTAMP_OR_DATE_COLUMN,’DD-MM-YYYY’) =’25-02-2014′; Eg: select * from POST_SITE where TO_CHAR(POST_TMS,’DD-MM-YYYY’) =’25-02-2014′; here POST_SITE is the name of the table and POST_TMS is the name of […]

 1,328 total views

» Read more
1 2 3