PHP
- 2 ответа
- 0 вопросов
2
Вклад в тег
shell_exec("mysql -uroot --password='' -h localhost -D cart_open < F:/OSPanel/domains/test/db_migration/0000_base.sql")
илиshell_exec("mysql -uroot -h localhost -D cart_open < F:/OSPanel/domains/test/db_migration/0000_base.sql")
CREATE TABLE IF NOT EXISTS `shop` (
`id` int(11) NOT NULL,
`utime` int(11) NOT NULL,
`cost` float NOT NULL,
`wtf` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `shop`
ADD PRIMARY KEY (`id`);
ALTER TABLE `shop`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;