Исходное сообщение
"сгенерировать последовательность чисел" Отправлено James Millere, 31-Янв-23 15:57
Here's an example of how to generate a sequence of numbers from 00001 to 10000 in MySQL and insert them into a table: CREATE TABLE numbers (num INT); DELIMITER $$ CREATE PROCEDURE insert_numbers() BEGIN DECLARE i INT DEFAULT 1; WHILE i <= 10000 DO   INSERT INTO numbers (num) VALUES (i);   SET i = i + 1; END WHILE; END $$ DELIMITER ; CALL insert_numbers(); In this example, a table named numbers is created with a single column num of type INT. Then, a stored procedure named insert_numbers is created which uses a loop to generate the sequence of numbers and insert them into the numbers table. Finally, the stored procedure is called to generate the numbers and insert them into the table. Thanks

Ваше сообщение
Имя*:
EMail:	Для отправки новых сообщений в текущей нити на email укажите знак ! перед адресом, например, !user@host.ru (!! - не показывать email). Более тонкая настройка отправки ответов производится в профиле зарегистрированного участника форума.
Заголовок*:
Сообщение*:	> Here's an example of how to generate a sequence of numbers from > 00001 to 10000 in MySQL and insert them into a table: > CREATE TABLE numbers (num INT); > DELIMITER $$ > CREATE PROCEDURE insert_numbers() > BEGIN > DECLARE i INT DEFAULT 1; > WHILE i <= 10000 DO > INSERT INTO numbers (num) VALUES (i); > SET i = i + 1; > END WHILE; > END $$ > DELIMITER ; > CALL insert_numbers(); > In this example, a table named numbers is created with a single > column num of type INT. Then, a stored procedure named insert_numbers > is created which uses a loop to generate the sequence of > numbers and insert them into the numbers table. Finally, the stored > procedure is called to generate the numbers and insert them into > the table. > Thanks
	Введите код, изображенный на картинке: