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 …

What is the main difference b/w Mysql and Mssql?

Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in??

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

Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only …

Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you

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'); …