sequence mysql insert into prescriptionarticleliste(libelle_article,visible_article)
SELECT CONCAT('SG ', seqValue) , 1
FROM ( SELECT
(TWO_1.SeqValue + TWO_2.SeqValue + TWO_4.SeqValue + TWO_8.SeqValue + TWO_16.SeqValue+ TWO_32.SeqValue) SeqValue
FROM
(SELECT 0 SeqValue UNION ALL SELECT 1 SeqValue) TWO_1
CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 2 SeqValue) TWO_2
CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 4 SeqValue) TWO_4
CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 8 SeqValue) TWO_8
CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 16 SeqValue) TWO_16
CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 32 SeqValue) TWO_32
HAVING SeqValue > 0 and SeqValue < 26 )s
url recherche twitter autour lieu :
https://twitter.com/search?f=realti [...] Cfrance%22
Message édité par flo850 le 25-04-2015 à 11:43:04
---------------