PL
что не так сделал
blog-yandex.
test2(
id int,
dateee datetime
AS
SELECT
ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
blog-yandex.test
ORDER BY
dateee
);
Size: a a a
2021 September 17
PL
CREATE TABLE
id int,
dateee datetime
AS
SELECT
ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
ORDER BY
dateee
);
id int,
dateee datetime
AS
SELECT
ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
ORDER BY
dateee
);
DE
Работает?
PL
нет
DE
И не должно
PL
CREATE TABLE
dateee datetime) AS
SELECT ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
ORDER BY
dateee
blog-yandex.test3 (id int, dateee datetime) AS
SELECT ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
blog-yandex.test ORDER BY
dateee
PL
отработало
PL
PL
🙂спасибо
DE
CREATE TABLE test3Попробуй так
AS
SELECT
ROW_NUMBER() OVER (ORDER BY `dateee`) AS `id`,
*
FROM
`blog-yandex`.`test`
ORDER BY
`dateee`
PL
CREATE TABLE
dateee datetime) AS
SELECT ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
ORDER BY
dateee
blog-yandex.test3 (id int, dateee datetime) AS
SELECT ROW_NUMBER() OVER (
ORDER BY dateee
) id,
dateee
FROM
blog-yandex.test ORDER BY
dateee
PL
это работает!
DE
Нет я говорю про это
DE
Имя таблицы поменяй
DE
И больше ничего не трогай
PL
PL
нет
DE
А если стереть всё до слова SELECT?
PL
PL
нет