truncate table cart;
Could someone please point me in the right directions to troubleshoot
this problem.
Is there a way to see which user issued the truncate command?
TIA
Ric
It seems like you got the same problem' as me :
Php (? ) do not have the librairies include, and you need to run a kink of
daemon in order to make t works.
Under linux, it is just a question of the good rpm to install (for me it was
php-mysql-4.3.9-3.i386.rpm).
Under windows, you'll need to insta
libedit=undefined ]
)
! compile_readline=no
! compile_libedit=no
if [test "$with_libedit" = "yes"] && [test "$with_readline" = "yes"]
then
>Submitter-Id:
>Originator:Ric Anderson - SIRT
>Organization:
Ric Anderson, U of Ariz
.
> I can't do it by ID because what if a row in the middle somewhere gets
> deleted? I need to do it by the position in the table, and a static
> numbering column won't work. This is a solution someone on EFNet came up
> with:
>
> SET @rowcount=0;
> select docid,@rowcount:=@rowcount+1 as num
Dear Spamsucks86,
With Mysql 4.0.x I think you are limited to either performing the
algorithm at the client side as James suggested or using temporary tables
and mysql variables at the server side.
create table test (var int);
insert into test values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(1
Mysql,
Selecting from `dual` with a simple query works fine,
mysql> select 1 x from dual;
+---+
| x |
+---+
| 1 |
+---+
but within a derived table,
mysql> select * from (select 1 x from dual) s;
ERROR 1146: Table 'test.dual' doesn't exist
Is this an oversight or is it purposefully so?
Than
