Posts

Showing posts from June, 2015

How to get data between two dates in mysql?

If any one knows means tell me... Please answer here.............

404 Not Found and Some HTTP Errors Explained clearly

 This post is published in one of the popular networks.. I Just shared the link here http://www.techgig.com/readnews.php?category=Future+Tech&tgnews_link=http%3A%2F%2Frss.feedsportal.com%2Fc%2F35261%2Ff%2F656072%2Fs%2F47aaa956%2Fsc%2F15%2Fl%2F0L0Shongkiat0N0Cblog0Ccommon0Ehttp0Eerrors0C%2Fstory01.htm&tg_type=rss&tgnews_id=57606 You too know it and forward to your friends and developers

How can we print the current date in the Mysql Database?

Most formally we use the now(); method... For Now() method it display the current date. If use now method directly in   pst = con.prepareStatement             ("insert into uploadfilename values('" + uf.id + "','" + myFileFilename + "','" + now() + "')");             int x = pst.executeUpdate(); I used this and execute it in the local database. It is updated in the database. but while executing in the live server it will through two exceptions                          InvocationTargetException and NoClassDefFoundError Exception. It will execute the current date in the database but it shows some warnings.. but it is not the correct way to display the date             Date d = new Date();...

How can we know the username of the Mysql through Mysql command line prompt?

By enter into the Mysql command line prompt Enter the Password : ****** MySql > select User from mysql.user;    // give this command and give enter  ----- |user | ------- |root | |d1   | |d5   |    |d14  | ------- 5 rows in set The list of username is displayed in the command line prompt...

How to copy a file from one directory to another directory through command prompt?

By Opening the command prompt Just go to the place which drive u saved ur files Then  Give the following command by Just assume that your file is in D:\ D: \> xcopy d:\Aruns elvan\*.* e:\Arunselvan  [and give enter ]                      Source folder       Destination folder All the files will paste to the destination folder.. If the same file will be in the destination folder... It will ask you whether to overwrite or not. <yes/no/All> As per your response it will process the remaining things. Thanks for viewing this post.... I think this may be helpfull for you.........  

How to set max connections in mysql?

First we want to enter into the Mysql command line prompt by giving the Password MySQL> Enter the password : xxxxxxx To know how many connections are in the database MySQL> show variables like "max_connections"; It will list out the output as Variable Name         Value max_connections        100 Default value for the max_connections is 100. If we want to increase the max connections then we wan to give Set global max_connections = "our value" [our value refers= 200,300,500 etc...] It will affect immediately. and it will again remain to max_connections as 100 when the mysql server restarts. For that we want to change the  My.conf[for linux OS] or My.ini file [for windows OS] Thanks for viewing our post..

How to read all the files inside the directory in java ?

/* To Read all the list of files inside the folder using Java code  */ package basics; import java.io.File; /**  *  * @Easy Java */ public class ReadFilesFromFolder {   public static File folder = new File("D:\\Author");   static String temp = "";   public static void main(String[] args) {     // TODO Auto-generated method stub     System.out.println("Reading files under the folder "+ folder.getAbsolutePath());     listFilesForFolder(folder);   }   public static void listFilesForFolder(final File folder) {     for (final File fileEntry : folder.listFiles()) {       if (fileEntry.isDirectory()) {         // System.out.println("Reading files under the folder "+folder.getAbsolutePath());         listFilesForFolder(fileEntry);       } else {      ...