Re: Importing SQL dumps into MySQL through Command line

2013-03-31 Thread Manuel Arostegui
2013/3/31 Norah Jones > Hi, > > To source sqldump i can use the source command, but if I need to do the > same stuff using command line without going to the sqlpromt, can I achieve > that. > > Hello, You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ? Manuel.

Re: Query help - Solved

2013-03-31 Thread william drescher
of course, "Group By" bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Query help -

2013-03-31 Thread william drescher
On 3/31/2013 7:32 AM, william drescher wrote: I have a table, schedule: CREATE TABLE `schedule` ( `schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT, `provider` varchar(15) NOT NULL, `apptTime` datetime NOT NULL, `location` varchar(10) NOT NULL, `duration` smallint(5) unsigned NOT

Query help -

2013-03-31 Thread william drescher
I have a table, schedule: CREATE TABLE `schedule` ( `schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT, `provider` varchar(15) NOT NULL, `apptTime` datetime NOT NULL, `location` varchar(10) NOT NULL, `duration` smallint(5) unsigned NOT NULL, `standing_script` mediumint(9) DEFAULT NULL,