Forum How to initialize user-defined MySQL variables?

sergeisokolov

posted 10 years ago

Database

Last updated 2 years ago.

quyle92 liked this thread

jimgwhit

replied 10 years ago

Have you thought about using a stored procedure?

awsp

replied 10 years ago

Solution

This seems work for me...What were you trying to do?

DB::statement(DB::raw('SET @total = "bar"'));
$a = DB::select(DB::raw('select * from applications where foo = @total'));
    
DB::statement(DB::raw('SET @total = "id"'));
$b = DB::select('select @total from applications');

quyle92 liked this reply

jarektkaczyk

replied 10 years ago

There's inline initializing available in MySQL:

DB::select(DB::raw('@total := @total + x as total_x'), ...)
   ->from(DB::raw('your_table, (select @total := 0) as var'))
   ... 
   ->get();

quyle92 liked this reply

pmvalente

replied 9 years ago

could you help me to put this query in laravel

SET @prev=0,@rownum=0;
SELECT utilizador_id, nome
FROM (SELECT *,
         IF( @prev <> utilizador_id,
             @rownum := 1,
             @rownum := @rownum+1
         ) AS rank,
         @prev := utilizador_id,
         @rownum
  FROM ( SELECT * FROM anuncios
    ORDER BY utilizador_id, rand()
  ) random_prodcts
) products_ranked
WHERE rank <= 2

thanks in advance

Last updated 9 years ago.

quyle92 liked this reply