sathish_nadu

i tried to upload some data from csv to MySql data base. but it not working someone help me on this. the below one is my code #!/usr/bin/perl -w use DBI; use strict; use TEXT::CSV; use warnings; my $driver = "mysql"; my $database = "test"; my $host = "localhost" my …

I am using MySQL 5.0 on WinXP pro. Below is the script for creating the table CREATE TABLE `tbl_test` ( `gameID` VARCHAR(45) NOT NULL, `gameName` VARCHAR(100) NOT NULL, `gameStartDateTime` DATETIME NOT NULL ); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 1:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 8:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 12:00:00'); I would …

Found this article to be nice: http://www.rapidprogramming.com/questions-answers/What-is-the-difference-between-MySQL-and-MS-SQL--575

I like SQLyog from windows. But you can run on MAC:http://faq.webyog.com/content/31/181/en/can-i-use-sqlyog-on-a-mac.html

I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 …

Im using LOAD DATA INFILE to import a csv file, the files date format is 29/11/2010 and the database format is 2010-11-29, what can i use to format the date inside the query? I've tried str_to_date: `SET date_start = STR_TO_DATE(@from_date,'%Y-%m-%d'),` but that only inserts 0000-00-00

I prefer [SQLyog](www.webyog.com) for this. The UI is intuitive and easy to use. The free version is available [here](http://code.google.com/p/sqlyog/wiki/Downloads).

I use [SQLyog ](www.webyog.com)for this where we can connect to the remote server and take a back up with this tool.

I'm trying to set a query that will pull all clients whose birthday is today. I'm using phpmyadmin localhost via Unix socket, birthday is set as DATE. All I need returned is the firstname (emp.emp_firstname asfirst name) , lastname (emp.emp_lastname aslast name) and date of birth (emp_birthday as 'dob')

I have the following simple table: CustomerID CustomerName NumOfOrders 1 Joe 15 2 Jane 20 7 Clara 1 I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution.

I have a MySQL dump and the dump has timestamp datatype. But the values are not escaped in qoutes. I want to write a regular expression to write to match the time tamp column and replace it by enclosing in quotes I have some thing like this: 2006-02-15 04:44:00 I …

I need to get the Club_ID of all the clubs that have more than one member; Here is the sql: CREATE TABLE `Members` ( `ID` INT NOT NULL AUTO_INCREMENT , `Club_ID` INT NULL , `Name` VARCHAR(45) NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Jim'); …