Re: Re: Mysql module

in reply to Re: Mysql module
in thread Mysql module

Does leaving out that parameter yeild an error message saying the problem is near `"'? I don't know. Just asking.

Comment on Re: Re: Mysql module

Replies are listed 'Best First'.
Re: Re: Re: Mysql module by pfaut (Priest) on Mar 07, 2003 at 02:52 UTC
`mysql> select left("abcdef") -> ; ERROR 1064: You have an error in your SQL syntax near ')' at line 1 mysql> select left("abcdef",3); +------------------+ \| left("abcdef",3) \| +------------------+ \| abc \| +------------------+ 1 row in set (0.00 sec)` [download] `--- print map { my ($m)=1<<hex($_)&11?' ':''; $m.=substr('AHJPacehklnorstu',hex($_),1) } split //,'2fde0abe76c36c914586c';` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: Re: Re: Mysql module
by pfaut (Priest) on Mar 07, 2003 at 02:52 UTC

mysql> select left("abcdef")
    -> ;
ERROR 1064: You have an error in your SQL syntax near ')' at line 1
mysql> select left("abcdef",3);
+------------------+
| left("abcdef",3) |
+------------------+
| abc              |
+------------------+
1 row in set (0.00 sec)
[download]

---
print map { my ($m)=1<<hex($_)&11?' ':'';
$m.=substr('AHJPacehklnorstu',hex($_),1) }
split //,'2fde0abe76c36c914586c';
[download]

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom