Search results
3 mar 2013 · How do I generate a range of consecutive numbers (one per line) from a MySQL query so that I can insert them into a table? For example: nr 1 2 3 4 5 I would like to use only MySQL for this (not PHP or other languages).
18 lip 2019 · If you need a range of dates you can do. SELECT DATE_ADD('start_date',v) as day FROM ViewInt16 WHERE v<NumDays; or. SELECT DATE_ADD('start_date',v) as day FROM ViewInt16 WHERE day<'end_date'; you might be able to speed this up with the slightly faster MAKEDATE function
5 wrz 2014 · With MySQL 8.0, MariaDB 10.2, and later versions, you can use recursive CTEs, so: WITH RECURSIVE nums AS ( SELECT 1 AS value UNION ALL SELECT value + 1 AS value FROM nums WHERE nums.value <= 9 ) SELECT * FROM nums; You can obviously modify this to use the start value, step and end value of your choice.
11 lip 2024 · In MySQL (version 8.0 and higher) we can use recursive CTE (common table expression) to generate a range of values: WITH RECURSIVE numbers AS ( SELECT 5 AS number UNION ALL SELECT number + 1 FROM numbers WHERE number < 10 ) SELECT number FROM numbers;
7 maj 2022 · CREATE TABLE dbat ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, num VARCHAR(25) NOT NULL, PRIMARY KEY (id), UNIQUE KEY num (num) ); INSERT INTO dbat (id, num) VALUES (19, 'A1000'), (20, 'A1001'), (21, 'A1002'), (22, 'A1003'), (23, 'A1010'), (24, 'A1011'), (25, 'A1012'), (26, 'A1013'), (27, 'A1020'), (28, 'A1030'), (29, 'A1031'), (30, 'A1032 ...
27 mar 2019 · mysql_query(INSERT INTO table (`chair`) VALUE (Range(1, 50) as long as picked number not taken))
For MyISAM tables, you can specify AUTO_INCREMENT on a secondary column in a multiple-column index. In this case, the generated value for the AUTO_INCREMENT column is calculated as MAX(auto_increment_column) + 1 WHERE prefix=given-prefix.This is useful when you want to put data into ordered groups.
