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

Is 'find' what you're looking for? find ${path} -type f -iname '*.doc' -print find ${path} -type f -iname '*.doc' -exec /some/import/script {} \; Thanks, Ryan Yagatich ,__, / Ryan Yagatich Pantek Incorporated | \ http

Re: select count

'status' be an enum of 'r','s', 'c'. Furthermore, to make it even faster, try setting the status field to be an unsigned int, so you can do a status = 1, 2, 3 or whatever. Thanks, Ryan Yagatich ,__, / Ryan Yagatich Pantek

Re: Admin Question

stats. As of version 0.7, it even runs on Windows (somewhat). /quote Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http://www.pantek.com/security

Re: There has to be a way to do this

(ethernet_address) VALUES ($ethernet_address) UPDATEQUERY=UPDATE hardware_assets SET Operating_system='10.3.3' if [ $result -eq 0 ]; then echo $INSERTQUERY; | $MYSQLSTRING else echo $UPDATEQUERY; | $MYSQLSTRING fi Thanks, Ryan Yagatich

Re: There has to be a way to do this

Ignore this as aparently someone already posted almost the exact same thing :) Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http://www.pantek.com

Re: Subtracting date fields

(firstdate, postdate) AS diff FROM calendar; This will return the number of days from the first to the second day. See: http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1373 Thanks, Ryan Yagatich Thanks, Kenneth -- ,_, \ Ryan

RE: create own auto increment number

format you like). Hopefully this has been a little enlightening. Again, its basically the same thing that was previously posted, just some descriptions and references to go along with it. Thanks, Ryan Yagatich -- Diana Soares snip I was wondering if its possible to have a AUTO_INCREMENT

Re: web data entry problem

-error.php Thanks, Ryan Yagatich snip -- ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http://www.pantek.com/security(440) 519-1802 \ / Are your networks

Re: What provides libmysqlclient.so?

-client* [...] Above, I have the current version already selected, replace your version # with the number apropriate. You could also checkout their websites for other mirrors: Redhat : http://www.redhat.com/mirrors.html Mandrake: http://www.linux-mandrake.com/en/ftp.php3 Thanks, Ryan Yagatich

Re: char

to correctly identify the purpose, but hopefully this information will guide you in the right direction. Thanks, Ryan Yagatich On Sun, 2003-06-22 at 12:40, Namor Taror wrote: I just created a table with some char columns (I am using Control Center). Every time I save the table (during

RE: i nned ur help

-disconnect || die Failed to disconnect\n; pls help me . Thanx chandana -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- ,_, \ Ryan

Re: Http post not working HELP!

above are not mysql issues but php issues. This email was sent to the mysql lists. Steve Thanks, Ryan Yagatich -- ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http

Re: several key values in one field?

) Thanks, Ryan Yagatich On Sun, 2003-06-15 at 21:02, Lingua2001 wrote: Hi, while trying to handle severl key values, I wonder if it is more efficient to put those values in a row seperated by a certain seperator (eg. comma). The talbe has two fields and looks like; UID ForeinID 1

Re: several key values in one field?

all about what data you are retrieving and what you want to do with it. In short, yes 2 program functions are more efficient than 2 sql queries iff the amount of resources required for the database to process outweigh that of the application. Thanks, Ryan Yagatich On Mon, 2003-06-16 at 16:32

Re: fastest way to get last row

Couldn't something like this work? SELECT id,foo,bar FROM tbl ORDER BY id DESC LIMIT 1 Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http

Re: Problems installing DBD::mysql for My SQL 4

I believe the package you are looking for is zlib-devel The latest version from redhat is available at http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm Thanks, Ryan Yagatich ,_, \ Ryan Yagatich