Installing MySQL client into workstations using GPO

2009-02-05 Thread Scott Hamm
My objective is to have all Windows XP workstation (300+) report their activities using mysql client that exports in CSV format to our Active Directory's MySQL server. Is it possible to install just the MySQL client over GPO, is this possible? Thanks, Scott Hamm Technology Coordinato

mysqlimport failed to import

2008-09-19 Thread Scott Hamm
I created a csv file entitled 'disposed.csv' and placed it in computer_inventory data folder with the following inside: 1087 1046 1086 1161 1049 1178 1029 1030 1224 1044 1106 Now I created the table 'disposed' as following: Create disposed ( Mot_id INT(4) UNIQUE NOT NULL ); Then I issued the c

mysqlimport problem with , inside fields

2007-02-18 Thread Scott Hamm
I've been trying to import fields that contains the comma character ',' inside double quotes '"', with the results following: mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark "c:\documents and set

Re: CREATE TABLE Inv_Id

2006-10-19 Thread Scott Hamm
Wish MySQL would have something like what Microsoft use, "uniqueidentifier" as datatype.

Re: CREATE TABLE Inv_Id

2006-10-16 Thread Scott Hamm
Thanks! On 10/16/06, Gabriel PREDA <[EMAIL PROTECTED]> wrote: I would try: CREATE TABLE Inv_Id ( ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY, MID INT NOT NULL, FOREIGN (MID) REFERENCES 'Model' (ID) ); Note the UNSIGNED and ZEROFILL flags ! -- -- -- -- -- -- -- -- -- -- -- -- --

Re: CREATE TABLE Inv_Id

2006-10-16 Thread Scott Hamm
10/16/06, Gerald L. Clark <[EMAIL PROTECTED]> wrote: Scott Hamm wrote: > I'm trying to create a table as follows: > > CREATE TABLE Inv_Id ( > ID INT(12) AUTO_INCREMENT PRIMARY KEY, > MID INT NOT NULL, > FOREIGN (MID) REFERENCES 'Model' (ID) > ); > &g

CREATE TABLE Inv_Id

2006-10-16 Thread Scott Hamm
I'm trying to create a table as follows: CREATE TABLE Inv_Id ( ID INT(12) AUTO_INCREMENT PRIMARY KEY, MID INT NOT NULL, FOREIGN (MID) REFERENCES 'Model' (ID) ); How do I make ID to start out as '0001' for UPC barcode assignment? --

Counting char in a column

2006-10-10 Thread Scott Hamm
I'm running MySQL 5.0.15 on Windows system. How do I count how many specific char is there in a column, for example finding 'c' in lowercase string of "Characteristics" would total to 3. -- `Twas brillig, and the slithy tove

Mysqlimport complex question

2006-10-04 Thread Scott Hamm
/* OBJECTIVE: INPUT: E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter Rd|Dover|MD|76709|,041| WHERE error (,###) can be in any fields *AFTER* the first "|" char DESIRED OUTPUT: filename: E524541015.txt ord: 20061004 error: 535 error1: 999 error2: 410 error3: 041 error4:

dir /w > mysql

2006-09-28 Thread Scott Hamm
How do I use windows command line to do the similiar following: dir *.txt /b /o:n 1> "C:\Documents and Settings\ScottHam\Desktop\current.tmp" 2>nul into mysql with this table: mysql> desc files; +---+-+--+-+---++ | Field | Type| Nul

Creating a stored procedure for zip_list_by_miles

2006-09-21 Thread Scott Hamm
I'm trying to create stored procedure, but after reading mysql's online document, I was not able to comprehend its usage. Here is what I do, put in target zip code and miles range, then find a list of zipcode, city, state and miles from target zip code. How do I get around to it? [code] SET @ta

Stored Procedure for list_zip_by_miles

2006-09-20 Thread Scott Hamm
I'm trying to create stored procedure, but after reading mysql's online document, I was not able to comprehend its usage. Here is what I do, put in target zip code and miles range, then find a list of zipcode, city, state and miles from target zip code. How do I get around to it? [code] SET @ta

Dictionary

2006-02-01 Thread Scott Hamm
I've been trying to google to no avail for English dictionary (with definitions) in any format that I can download and import into MySQL. Do anyone know where I can find it? Thanks in advance, Scott -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://list

Just for fun... subqueries

2005-11-11 Thread Scott Hamm
I was fooling around, learning subqueries, group by and everything unearthing my mental unknowns of SQL world. So I thought I would divide total letters of the entire bible by total numbers of books, chapters and verses. Here is what I came up with the best optimization possible to my knowledge p

Re: GROUP BY / HAVING / Aggregrates

2005-11-10 Thread Scott Hamm
AND dk.month=month('2005-11-04') AND dk.year=year('2005-11-04') > WHERE > k.date='2005-11-04' > GROUP BY k.aid > ORDER BY > k.training, k.shift, k.id; > > PB > > - > > Scott Hamm wrote: > > >I created a report that shows effien

GROUP BY / HAVING / Aggregrates

2005-11-10 Thread Scott Hamm
I created a report that shows effiency for each associate (K.AID). I am trying to figure out how to use GROUP BY to AVG(Effiency) for each K.AID in subquery. Originally I used temporary tables (4) to figure out the average effiency for each K.AID. That often left hanging temporary tables and took

Re: Consolidating two databases into one

2005-11-10 Thread Scott Hamm
erver, you will need to export > the data you want to move to a file and re-import it at the destination. > > http://dev.mysql.com/doc/refman/5.0/en/rename-table.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > Scott Hamm <

Consolidating two databases into one

2005-11-10 Thread Scott Hamm
I got two databases that do not have similiar tables and would like to consolidate those two databases into one. What function should I use to do that? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mai

Re: case sensitivity

2005-11-08 Thread Scott Hamm
ECTED]> wrote: > Instead of using COLLATE you can try using the "BINARY" option > instead. It will work in older versions of MySQL and I think it makes > you select a bit more readable. Just put "BINARY" before the > comparison you want to be case sensitive. > > WHE

case sensitivity

2005-11-08 Thread Scott Hamm
I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as front-end for word search in Bible. My goal is to set an option for case sensitivity in text search. For example, if I want to search for the word "Jehovah*" I would expect "Jehovah" not "JEHOVAH". This query works for my objective:

Mysqli

2005-11-04 Thread Scott Hamm
I was working on Php web page and attemtped to use stored procedure. Last night on Php line, they said that I should consider MySQLi and to ask MySQL list about it. Do anyone know anything about executing a stored procedure from php page? Something to do with interface or? Do I need something e

DELETE Trigger

2005-10-26 Thread Scott Hamm
How do I create a trigger in MySQL similiar to the trigger created for mssql: CREATE TRIGGER DEL_DE ON KRONOS AFTER DELETE AS DELETE FROM DE_Metrics WHERE KID=( SELECT ID

Creating a table on MySQL from Access

2005-10-18 Thread Scott Hamm
Is there a way I can create a table on MySQL using Access and establish a link remotely? -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

cmd

2005-10-04 Thread Scott Hamm
How do I pipe the Windows cmd output into mysql inserts? i.e. dir /w /o:n > mysql -u process (INSERT INTO TABLE) -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

MySQL Query Browser

2005-09-29 Thread Scott Hamm
How do I run more than 1 queries in MySQL Query Browser? -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

MySQL 5.0 Release Candidate sproc's

2005-09-28 Thread Scott Hamm
I got MySQL 5.0 up and running on new hard drive. Now I would like to transfer MSSQL's stored proc to MySQL. Is it possible if I can transfer it over even if it have errors and that I will try to get them working with MySQL in later time? Or what is the best way to do them? Currently MySQL Migrati

Re: MySQL 5.0 Release Candidate

2005-09-28 Thread Scott Hamm
d will be displayed. > > Fred > > > -Original Message- > From: Scott Hamm [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 27, 2005 10:25 AM > To: 'Mysql ' > Subject: MySQL 5.0 Release Candidate > > While I try to install MySQL 5.0 and start it as

MySQL 5.0 Release Candidate

2005-09-27 Thread Scott Hamm
MySQL 5.0 was installed up to the point where I tried to start it in Instnace Configuration wizard. It won't start at all even mysqld and mysqld --safe-mode I'm getting frustrated -- hosed hard drive, reinstalled Windows 2000 Pro and installed MySQL 5.0 and it still *wont* run. -- Please avoid

MySQL 5.0 Release Candidate

2005-09-27 Thread Scott Hamm
While I try to install MySQL 5.0 and start it as "QCDA" server, and upon "execute" it could not start service during MySQL Instance Configuration Wizard on Windows 2000 Pro. The older and removed Mysql are set disabled in services properties. Error no. 0 What is the workaroud here? -- Please avoi

INDEX

2005-09-26 Thread Scott Hamm
How do I set Index to enforce that ONLY 1 QAID can own that order number, but nothing else? For example: QAID [order] ErrorType 11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one QAID number uses it. 11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX (QA

MySQL 5.0 crashes

2005-09-12 Thread Scott Hamm
MySQL 5.0.12 crashed when I tried to select, backup or left join from certain table with 431433 rows with Data length of 23.6 MB using InnoDB engine. Tested on MySQL 4.1.14 with no problem in all aspects. Has this occured to anyone before? -- Please avoid sending me Word or PowerPoint attachme

MySQL Migration 1.14 rc not closing mdb

2005-09-07 Thread Scott Hamm
Is it normal for MySQL migration 1.14 rc to leave MS Access open when it is done with migration (leaving ldb file)? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

Re: Deleted rows

2005-08-18 Thread Scott Hamm
> > Peter Brawley <[EMAIL PROTECTED]> wrote on 08/18/2005 10:56:34 > AM: > > > Scott, > > > > >How do I execute a query that shows missing ID's like so: > > > > SELECT id AS i > > FROM tbl > > WHERE i <> 1 AND NOT E

Cost-Effective Database Scale-Out Using MySQL

2005-08-18 Thread Scott Hamm
I just got an email from MySQL concerning web seminar. Since I'm deaf I would like to attend, is there any accomodations that I can use to get in touch? There is a "Video Relay Interpreting" service online and am wondering if MySQL could use that service? -- Please avoid sending me Word or

Deleted rows

2005-08-18 Thread Scott Hamm
If I got a table as follows: ID foo 1 12345 2 12346 4 12348 6 12349 7 12388 9 12390 How do I execute a query that shows missing ID's like so: 3 5 8 I wouldn't expect for it to show deleted data that was deleted, just show the "skipped" ID's. That way I determine if operator deleted too much (

Re: Linux vs. Windows?

2005-08-12 Thread Scott Hamm
On 8/12/05, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > [snip] > I am willing to bet you I can write a more scalable higher performing > socket > server using NT I/O Completion Ports than you can write using Linux's > epoll. > > It you're running a 32 cpu system, Windows will consistently outper

Minimial settings on Windows XP AND Linux for MySQL server

2005-08-12 Thread Scott Hamm
I would like to install MySQL 5.0.x beta into two computers and test them. They will run Windows XP Home Edition (of course with massive updates and whatsnot) and Linux (SlackWare 10.0 vanilla). I am familiar with Registry Editor and bash shell scripting for /etc start up directory in technical

Re: MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
Shawn, Apology accepted. :) No hard feeling. Scott On 8/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAIL PROTECTED]> wrote on 08/08/2005 11:24:22 AM: > > > On 8/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >

Re: MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
On 8/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAIL PROTECTED]> wrote on 08/08/2005 08:11:18 AM: > > > Where can I put in my suggestion (I'm sure others suggested the same) > for > > MySQL Query Browser? > &

MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

Re: True randominess

2005-08-05 Thread Scott Hamm
On 8/4/05, Scott Gifford <[EMAIL PROTECTED]> wrote: > > Pat Adams <[EMAIL PROTECTED]> writes: > > > On Thu, 2005-08-04 at 14:44 -0500, 2wsxdr5 wrote: > >> There are also several places that you can get a reasonably random > >> number for the seed from your machine. The amount of free disk space,

True randominess

2005-08-04 Thread Scott Hamm
I've noticed that rand() do not change on each query request. Is there a way I could get a TRUE randominess into MySQL? -- Power to people, Linux is here.

Re: Database equivalent to NorthWind for M$ SQL

2005-08-04 Thread Scott Hamm
Lol On 8/4/05, mos <[EMAIL PROTECTED]> wrote: > > At 09:02 AM 8/4/2005, you wrote: > >Is it possible if MySQL could create its own ficitional database to > >standardize the way we train ourselves in MySQL and to be able to > >communicate our ideas to others than having to expose our actual workin

Re: Database equivalent to NorthWind for M$ SQL

2005-08-04 Thread Scott Hamm
Is it possible if MySQL could create its own ficitional database to standardize the way we train ourselves in MySQL and to be able to communicate our ideas to others than having to expose our actual working datas to others? Let M$ have their own NorthWind and we have ours. On 8/4/05, [EMAIL PRO

Re: Database equivalent to NorthWind for M$ SQL

2005-08-04 Thread Scott Hamm
Ok. Now that I got NorthWind into my MySQL 5.0.9 database and also am running M$ SQL database server at where I work, this might be a good opportunity for me to learn how to mirgate from M$ SQL database to MySQL using Northwind and to see the difference between them. Is there anything that I sh

Re: STORED PROCEDURE

2005-08-02 Thread Scott Hamm
Your second statement hit the spot. :) Thanks! On 8/2/05, Mark Leith <[EMAIL PROTECTED]> wrote: > > > -Original Message- > > From: Scott Hamm [mailto:[EMAIL PROTECTED] > > Sent: 02 August 2005 15:38 > > To: [EMAIL PROTECTED] > > Cc: Mysql > >

Re: STORED PROCEDURE

2005-08-02 Thread Scott Hamm
MySQL 5.0.9 Beta :) On 8/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAIL PROTECTED]> wrote on 08/02/2005 10:12:01 AM: > > > I'm used with MS SQL and could not understand MySQL's document. I'm > tryi

Re: STORED PROCEDURE

2005-08-02 Thread Scott Hamm
> | title | > +-+ > | %Unconditional% | > +-+ > 1 row in set (0.01 sec) > > HTH > > Mark > > Mark Leith > Cool-Tools UK Limited > http://www.cool-tools.co.uk > > > -Original Message- > > From: Scott Hamm [mailto:[EMAIL

STORED PROCEDURE

2005-08-02 Thread Scott Hamm
I'm used with MS SQL and could not understand MySQL's document. I'm trying to create something like the simple example DECLARE @title varchar(255) SET @title='%Unconditional%' SELECT @title; How do I get around to it in MySQL? -- Power to people, Linux is here.

Re: mysqladmin Shutdown fail

2005-08-02 Thread Scott Hamm
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p it should prompt for password. On 8/2/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote: > > I used command: c:\mysql\bin\mysqladmin -u root shutdown > and I got error : > > mysqladmin: connect to sever at 'localhost' fail > er

Database equivalent to NorthWind for M$ SQL

2005-07-29 Thread Scott Hamm
Is there any database file similiar to M$'s Northwind that I can use to play with? It would be nice if there is one inside MySQL by default for newbies to start out with. Microsoft's document often used Northwind as an example to teach functions. -- Power to people, Linux is here.

Re: Migration from ORACLE 9i to MySQL

2005-07-28 Thread Scott Hamm
I got no experience in migrating Oracle to Mysql, but here might be what you were looking for: http://dev.mysql.com/downloads/migration-toolkit/1.0.html Scott On 7/28/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote: > > > I will be migrating Oracle database 9i to Mysql. Do anyone have any > expe

Re: Which Engine to use...

2005-07-27 Thread Scott Hamm
Created QAID & QEID indices, now select time went down to .2787 seconds. Sorry about top-posting, it's a nice feature in gmail where it hides the text that was previously posted. Here is the updated explain result. mysql> EXPLAIN -> SELECT * -> FROM QA -> LEFT JOIN Batch -> ON Batch.QAID=QA.I

Re: Which Engine to use...

2005-07-27 Thread Scott Hamm
ALL | NULL | NULL | NULL | NULL | 9871 | | ++-+--+---+---+-+-+--+--+--+ 3 rows in set (0.00 sec) On 7/27/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAI

Re: Which Engine to use...

2005-07-27 Thread Scott Hamm
`KeyDate` datetime default NULL, `ReceiveDate` datetime default NULL, `Training` tinyint(1) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1' On 7/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAIL PROTECTED]> wrote on 07/2

Re: Which Engine to use...

2005-07-27 Thread Scott Hamm
OOPS!!! Wrong tables On 7/27/05, Scott Hamm <[EMAIL PROTECTED]> wrote: > > 'Bands', 'CREATE TABLE `bands` ( > `BandID` int(11) NOT NULL auto_increment, > `Band_Name` varchar(255) default NULL, > PRIMARY KEY (`BandID`) > ) ENGINE=MyISAM DEFAULT CHARSE

Re: Which Engine to use...

2005-07-27 Thread Scott Hamm
(`ID`), KEY `FK_Band` (`B_ID`), KEY `FK_CDType` (`C_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1' On 7/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Scott Hamm <[EMAIL PROTECTED]> wrote on 07/21/2005 09:39:48 AM: > > > I'm now trying to l

Which Engine to use...

2005-07-21 Thread Scott Hamm
I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to MySQL to learn the migration process and executed the following: SELECT * FROM QA LEFT JOIN Batch ON Batch.QAID=QA.ID LEFT JOIN QAErrors ON QAErrors.ID=Batch.QEID WHERE QA.ID BETWEEN '106805' AN

Re: SQLyog Enterprise

2005-07-21 Thread Scott Hamm
ver), so you can actually browse the database as though it was > > local. There's also a free version if you don't need enterprise > > features, so maybe try that out first. > > > > Navicat is an alternative with good support for procs and views. > > There

Re: SQLyog Enterprise

2005-07-21 Thread Scott Hamm
ww.be-known-online.com > > > > Hello, > > > > I find SQLyog Enterprise an indispensable tool. > > > > Your $49 will be saved within the first 3 days of use > > because of improved productivity with MySQL. > > > > Karam > > > > --- Scott Ha

Renaming a database

2005-07-18 Thread Scott Hamm
How do I rename a database? The help online is pretty ambigous. -- Power to people, Linux is here.

Stored Procedure in MySQL 5.x

2005-07-15 Thread Scott Hamm
How effective is Stored Procedure in MySQL 5.x? -- Power to people, Linux is here.

Null & alphabetic order

2005-07-13 Thread Scott Hamm
How do I use ORDER BY in a way that it list null last after Z instead of before A? I.e. instead of: Null, A, B, C result would be: X, Y, Z, null How can I get around to that? -- Power to people, Linux is here.

SQLyog Enterprise

2005-07-11 Thread Scott Hamm
I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical) for personal use. Do anyone use it and how does it fare in your opinion? -- Power to people, Linux is here.

"Document Library"

2005-06-27 Thread Scott Hamm
I am currently projecting a project where we can use MySQL to control documents similiar to ISBN for IntraNet. We plan to export into XML as well. It will require a good labelling, strategy and planning. Do anyone know where I can find good resource to get started? Thanks, Scott -- Power to

limit 3 subqueries per query selected

2005-05-09 Thread Scott Hamm
How do I limit subqueries to 3 selects for each query selected, for example, an operator put in 5 orders in each batch, and there are 2 different reports which is accuracy for all orders and 3 out of each 5 orders processed. QA table holds batch information and Batch table holds all order informat

Massive selects, improvements sought.

2005-05-03 Thread Scott Hamm
Since I'm learning about Left joins and am trying to figure out a way to quickly gather info from Database all at once, here is the SQL statement. Please give me feedback how I should improve it for better performance. There are around 10 users that will hit database like this along with

Newbie trying the impossible?

2005-04-21 Thread Scott Hamm
I could understand this simple SQL statement: SELECT Associates.LastName + ', ' + Associates.FirstName as name, Production.Hours, Production.Quantity FROM production, Associates WHERE Associates.ID=Production.OID; Would produce full name in table. However when I used left join (try

Re: Duplicated records

2005-04-05 Thread Scott Hamm
ults from the first query or even just do your > original query once for each of the values returned by the counting query. > > A much better alternative would be to use a subquery but that is only an > option if you are running MySQL 4.1 or later. That would let you combine > both que

Re: Duplicated records

2005-04-05 Thread Scott Hamm
:00:00 2661 5334 JulieAnt 90575439584414 2004-10-03 00:00:00 5657 5334 JulieAnt On Apr 5, 2005 10:54 AM, Rhino <[EMAIL PROTECTED]> wrote: > > - Original Message - > From: "Scott Hamm" <[EMAIL PROTECTED

Duplicated records

2005-04-05 Thread Scott Hamm
Here is my novice question: I need to find duplicates in "Batch" category when I issued this query: SELECT * FROM QA WHERE Batch=439584414; Result: 90577 1 26615334JulieAnt25 5 5 439584414 2004-10-03 00:00:00 2004-10-03 00:00:000 905

Re: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

2005-03-07 Thread Scott Hamm
Thanks! I'll try and import using ODBC. Is there any good web sites about ODBC and its operations that I can learn about it? Scott On Mon, 07 Mar 2005 09:26:56 +1100, Daniel Kasak <[EMAIL PROTECTED]> wrote: > Scott Hamm wrote: > > >How do I create a table using: >

Re: Exporting Data via Command Line

2005-03-04 Thread Scott Hamm
http://www.mysql.com would be a nice place to start. On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote: > Hello Guys, > > I am a newbie to mySQL and im trying to export my database via the > mySQL Command line but i cant seem to find any good documentation on how > to

select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

2005-03-04 Thread Scott Hamm
How do I create a table using: date_format('2004-10-03 15:06:14','%m/%d/%y %T'); That way I can import Access Data? -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: import problem.

2005-03-03 Thread Scott Hamm
It works! Here is what I used: LOAD DATA INFILE 'Batch.txt' INTO TABLE Batch FIELDS TERMINATED BY '{' LINES TERMINATED BY '\r\n'; And the result: mysql> select * from batch where orderid=240414989; +---+---++--+ | QAID | OrderID |

import problem.

2005-03-03 Thread Scott Hamm
I got my csv delimited using "{" as follows: 87547{240414986{0{ 87547{240414987{0{ 87547{240414988{0{ 87547{240414989{0{ 87547{240414990{1{GALLEGOS---MISKEYED MONTH IN BIRTHDATE I tried to import using SQLyog as following: Lines Terminated By: \n Fields set to Variable length, Fields Terminated b

Re: Equivalent syntax similiar to "dir /w /s" in Windows command prompt

2005-03-02 Thread Scott Hamm
nux [EMAIL PROTECTED] | > / One Hour Emergency Response (877) 546-8934 | > \___| > > On Wed, 2 Mar 2005, Scott Hamm wrote: > > >Is there any equivalent syntax similiar to dir /w /s for all *.doc to > >insert int

Equivalent syntax similiar to "dir /w /s" in Windows command prompt

2005-03-02 Thread Scott Hamm
Is there any equivalent syntax similiar to dir /w /s for all *.doc to insert into mysql database? -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to send queries to a database periodically

2005-02-24 Thread Scott Hamm
Where can I find cron for Windows? That will make my life a whole lot better! On Thu, 24 Feb 2005 08:14:13 -0500, Rhino <[EMAIL PROTECTED]> wrote: > > - Original Message - > From: "Peter PeterDresden" <[EMAIL PROTECTED]> > To: > Sent: Thursday, February 24, 2005 8:05 AM > Subject: How t

Re: Filtering a date/time out of timestamp

2005-02-17 Thread Scott Hamm
Thanks to both of you, here is my string: select * from test where date(now())=substring(date,1,10); :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Filtering a date/time out of timestamp

2005-02-17 Thread Scott Hamm
I have been trying to figure out a way to filter a date out of timestamp to no success. How do I filter out specific critieria that I need using now()? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Happy Thanksgiving Everyone!

2004-11-24 Thread Scott Hamm
I wish everyone a good and fateenin' Thanksgiving from United States! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Client program

2004-11-24 Thread Scott Hamm
Isn't there any text-based program like telnet.exe or putty.exe that allows me to use similiar to 'cmd'? -Original Message- From: Ferhat BINGOL [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 8:47 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: Re: Cl

Client program

2004-11-24 Thread Scott Hamm
What is the best client program that I can use to get connected to MySQL remotely? I'm running Windows 2000... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Prepared statement for MySQL 4.1

2004-11-11 Thread Scott Hamm
*THAT* one was what I already ready and could not understand it since English isn't my first language. -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 12:45 PM To: Scott Hamm Cc: 'Mysql ' (E-mail) Subject: Re: Prepared stat

Prepared statement for MySQL 4.1

2004-11-11 Thread Scott Hamm
I've read the article about 'prepared statement' found in MySQL 4.1, and am not sure if I understood what 'prepared statement' does and how can it benefit us. Can anyone elaborate on what 'prepared statement' could do with examples where possible? Thanks, The Newbie Scott -- MySQL General Mai

RE: enum TRUE/FALSE

2004-11-10 Thread Scott Hamm
ssage- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 10:22 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: RE: enum TRUE/FALSE [snip] mysql> select count(*) from Associate where Active=FALSE; mysql> select count(*) from Associate where Acti

RE: enum TRUE/FALSE

2004-11-10 Thread Scott Hamm
#x27;null','1') | YES | | null | | | Active | enum('null','1') | YES | | NULL | | | Creator | varchar(8) | | || | | NewAssociateDate | date | | | -00-00 | | +--+-

enum TRUE/FALSE

2004-11-10 Thread Scott Hamm
I'm trying to figure out how to make Active's null as FALSE and '1' as TRUE, in enum point of view Can anyone help me out here, trying to learn enum's phenomenon? I'm not sure I understood document quite clear -- as of yet :( mysql> desc Associate; +--+--+

RE: Column grouped by months

2004-11-05 Thread Scott Hamm
EMAIL PROTECTED] Sent: Friday, November 05, 2004 9:31 AM To: Scott Hamm Cc: 'Mysql ' (E-mail) Subject: Re: Column grouped by months You're kind of mixing display formatting with data retrieval. MySQL is a database, so it's display options for data are fairly limited, that's

RE: Column grouped by months

2004-11-05 Thread Scott Hamm
- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 9:42 AM To: Scott Hamm Cc: 'Mysql ' (E-mail) Subject: Re: Column grouped by months I believe you need a self join. Something like SELECT c.Category, g11.Reqvalue AS Nov, g12.Reqvalue AS Dec FRO

Column grouped by months

2004-11-05 Thread Scott Hamm
My current database: mysql> SELECT -> Category.Category, -> GoalData.Reqvalue, -> GoalData.GoalMonth -> FROM -> goaldata, -> category -> WHERE -> goaldata.catid=category.id; +-+--+---+ | Category

RE: True/False data type

2004-11-04 Thread Scott Hamm
work. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, November 04, 2004 3:19 PM To: Scott Hamm; [EMAIL PROTECTED] Subject: RE: True/False data type [snip] What data type should I use to use True/False type when I create a table? [/snip] ENUM http://www.mysq

True/False data type

2004-11-04 Thread Scott Hamm
What data type should I use to use True/False type when I create a table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Re[2]: Commercial Licensing Question

2004-10-20 Thread Scott Hamm
But isn't it your job to inform the person reciving application about the license? -Original Message- From: DebugasRu [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 10:57 AM To: [EMAIL PROTECTED] Subject: Re[2]: Commercial Licensing Question Exactly: m> If you distribute an

RE: Date as Primary ID

2004-10-18 Thread Scott Hamm
ailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 11:14 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: Re: Date as Primary ID - Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sen

RE: Date as Primary ID

2004-10-18 Thread Scott Hamm
mething to prevent DateID duplication] ); -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 9:42 AM To: Scott Hamm Cc: 'Mysql ' (E-mail) Subject: Re: Date as Primary ID Scott Hamm wrote: >How do I create table that

Date as Primary ID

2004-10-18 Thread Scott Hamm
How do I create table that uses timestamp in -dd-mm format as primary id (no duplicates)? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL on RedHat ES 3.0

2004-10-11 Thread Scott Hamm
Before you go further, I would like to point out a caution: When you do a rpm -qa | grep -i mysql It outputs various packages, not necessarily indicate that mysql itself is installed, it might mean different things i.e. libraries, perl, php that supports MySQL. Specifically the output line "mysq

RE: MySQL on RedHat ES 3.0

2004-10-11 Thread Scott Hamm
Yes, they seems to be installed already. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 11:34 AM To: Benjamin Arai Cc: [EMAIL PROTECTED] Subject: RE: MySQL on RedHat ES 3.0 Thanks. Here is what it got after I ran your command.

  1   2   >