Mysql doesn't have a printf function
Regards
Den 2010 10 29 00:47 skrev "Ethan Rosenberg" :
> Dear List -
>
> I am afraid that I am missing something in a major way.
>
> mysql> printf("%b %d %f %s\n", 123, 123, 123, "test");
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
Dear List -
I am afraid that I am missing something in a major way.
mysql> printf("%b %d %f %s\n", 123, 123, 123, "test");
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'printf("%b %
However, I am totally confused. All the texts state that to set a
variable, the code is: $st=100;
That's how you do it in php.
Doing it in the db is different and depends on the db you are using.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http:
At 05:13 PM 10/28/2010, Andrés G. Montañez wrote:
mysql> SET @st=100;
mysql> SELECT @st;
+--+
| @st |
+--+
| 100 |
+--+
Cheers.
On 28 October 2010 19:10, Ethan Rosenberg wrote:
> Dear List -
>
> I cannot figure this one out:
>
> mysql> $st=1000;
> ERROR 1064 (42000): You have a
mysql> SET @st=100;
mysql> SELECT @st;
+--+
| @st |
+--+
| 100 |
+--+
Cheers.
On 28 October 2010 19:10, Ethan Rosenberg wrote:
> Dear List -
>
> I cannot figure this one out:
>
> mysql> $st=1000;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that co
Dear List -
I cannot figure this one out:
mysql> $st=1000;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '$st=1000' at line 1
Ethan
MySQL 5.1 PHP 5 Linux [Debian (sid)]
--
PHP
On Thu, Oct 28, 2010 at 2:14 PM, Jimmy Sole wrote:
> Actually, after looking at it further, you have the records set to only have
> not null values yet you are passing a null value to it.
>
> -Original Message-
> From: Ethan Rosenberg [mailto:eth...@earthlink.net]
> Sent: Thursday, October
Actually, after looking at it further, you have the records set to only have
not null values yet you are passing a null value to it.
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Thursday, October 28, 2010 2:02 PM
To: Bastien Koert
Cc: Max E.K; php-db-lists.
The () around null seem like that could be the issue, just try to put NULL
for the value
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Thursday, October 28, 2010 2:02 PM
To: Bastien Koert
Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com
Subject: R
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg wrote:
> At 03:40 AM 10/28/2010, Max E.K wrote:
>
>> From: "Ethan Rosenberg"
>> To: rquadl...@googlemail.com, "Ethan Rosenberg"
>> Cc: "php-db-lists.php.net"
>> Sent: Thursday, October 28, 2010 4:55:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg wrote:
> At 03:40 AM 10/28/2010, Max E.K wrote:
>
>> From: "Ethan Rosenberg"
>> To: rquadl...@googlemail.com, "Ethan Rosenberg"
>> Cc: "php-db-lists.php.net"
>> Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
>> / Bern /
At 03:40 AM 10/28/2010, Max E.K wrote:
From: "Ethan Rosenberg"
To: rquadl...@googlemail.com, "Ethan Rosenberg"
Cc: "php-db-lists.php.net"
Sent: Thursday, October 28, 2010 4:55:34 AM GMT
+01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary K
From: "Ethan Rosenberg"
To: rquadl...@googlemail.com, "Ethan Rosenberg"
Cc: "php-db-lists.php.net"
Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadli
13 matches
Mail list logo
