Re: is type casting available
Hi. On Mon, Dec 10, 2001 at 06:30:47PM +0530, [EMAIL PROTECTED] wrote: [...] here shortname is varchar and pcallid is integer. i need shortname and pcallid as ' callno' of length 6. pcallid starts from 1 .. 999. to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and pick last 3 characters and concat with shortname. If you always want pcallid to have always leading zeros, you can declared it like PCallID SMALLINT(3) ZEROFILL concat(ShortName , substring(Cast( (.PCallID + 1000) as varchar(10) ),2 3) ) as 'Call No' here i would like to cast (.PCallID + 1000) as varchar As I said, in such situations MySQL will perform an implicit cast, so simply write: SELECT CONCAT(ShortName, SUBSTRING(PCallID + 1000, 2, 3)) AS 'Call No' Btw, alternatives to that would be SELECT CONCAT(ShortName, RIGHT(PCallID + 1000, 3) AS 'Call No' SELECT CONCAT(ShortName, LPAD(PCallID, 3, '0') AS 'Call No' or, if the column is declared with ZEROFILL, as explained above SELECT CONCAT(ShortName, PCallID) AS 'Call No' Bye, Benjamin. [...] how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In expressions, MySQL doesn't use varchar, but simply string, integer and floating point. You can force a string to an integer by adding 0 (like 'SELECT 1234+0') and an number to a string by some string functions (like 'SELECT CONCAT(10)'). I assume, there are no explicit casts, because if you want to add some number, you get the conversion implicitly by using '+'. If you could provide an example why you need explicit casts, maybe we could give a more precise answer. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is type casting available
hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. thanks in advance. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: is type casting available
Hi. Best and simpliest way ist to use phpMyAdmin for such changes. Greetz - Daniel Backhausen -Ursprüngliche Nachricht- Von: sreedhar [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 12:43 An: mysql Betreff: is type casting available hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. thanks in advance. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is type casting available
Hi. On Mon, Dec 10, 2001 at 05:13:21PM +0530, [EMAIL PROTECTED] wrote: hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In expressions, MySQL doesn't use varchar, but simply string, integer and floating point. You can force a string to an integer by adding 0 (like 'SELECT 1234+0') and an number to a string by some string functions (like 'SELECT CONCAT(10)'). I assume, there are no explicit casts, because if you want to add some number, you get the conversion implicitly by using '+'. If you could provide an example why you need explicit casts, maybe we could give a more precise answer. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is type casting available
hi Benjamin, thanks, here shortname is varchar and pcallid is integer. i need shortname and pcallid as ' callno' of length 6. pcallid starts from 1 .. 999. to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and pick last 3 characters and concat with shortname. simply concat(ShortName , substring(Cast( (.PCallID + 1000) as varchar(10) ),2 3) ) as 'Call No' here i would like to cast (.PCallID + 1000) as varchar thanks, regards, sreedhar - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: sreedhar [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Monday, December 10, 2001 5:32 PM Subject: Re: is type casting available Hi. On Mon, Dec 10, 2001 at 05:13:21PM +0530, [EMAIL PROTECTED] wrote: hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In expressions, MySQL doesn't use varchar, but simply string, integer and floating point. You can force a string to an integer by adding 0 (like 'SELECT 1234+0') and an number to a string by some string functions (like 'SELECT CONCAT(10)'). I assume, there are no explicit casts, because if you want to add some number, you get the conversion implicitly by using '+'. If you could provide an example why you need explicit casts, maybe we could give a more precise answer. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php