Re: Mysql Date column type

2003-12-03 Thread p shah
Hi, But will the search be any faster using Integer or BigInt column type compared to using Date or DateTime columnd type. Regards, --- Nitin <[EMAIL PROTECTED]> wrote: > no problems that i see. > > - Original Message ----- > From: "p shah" <[EMAIL PROT

Mysql Date column type

2003-12-02 Thread p shah
Hi, I have one question regarding date column type in MYSQL. Can I use the column type for date as Integer instead of DateTime or Date to store the date as mmddhhmmss or mmdd? As I know MYSQL accepts this format. But I am not too sure about the column type. What are the pros and cons fo

query

2002-07-16 Thread p shah
Hi, I want to know one thing about MYSQl, Why does this software always give the unix-socket problem when compiled and installed. I am installing on redhat 7.1. Is there a remedy to this or this will continue forever. Any help will be appreciated. Thanks _

query

2002-06-09 Thread p shah
Hi, I am looking for help on writing stored procedures for Mysql 4.0 and above. Any examples or pointing to advanced tutorials covering stored procedures for Mysql will be highly appreciated. Thanks in advance. __ Do You Yahoo!? Yahoo!

sql

2002-06-09 Thread p shah
Hi, I am looking for help on writing stored procedures for Mysql 4.0 and above. Any examples or pointing to advanced tutorials covering stored procedures for Mysql will be highly appreciated. Thanks in advance. __ Do You Yahoo!? Yahoo! - Officia

query

2002-05-28 Thread p shah
Hi, I want to start the autoincrement field in mysql primary key from 1000 instead of 1. Any ideas. Thank You. Piyush. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --

Re: Mysql values

2002-05-28 Thread p shah
Hi, Currently I am using "|" (pipe) (without quotes) to separate values if they belong to the same user. eg : If a user wants to receive an e-mail on Friday and Saturday I will put in the required field 5|6. And than retrieve that split/explode it with "|" and check the value. Is there any oth