| 编辑 | 复制 | 删除 DELETE FROM `proc` WHERE `proc`.`db` = \'test\' AND `proc`.`name` = \'AddGeometryColumn\' AND `proc`.`type` = \'PROCEDURE\' | test |
AddGeometryColumn |
PROCEDURE |
AddGeometryColumn |
SQL |
CONTAINS_SQL |
DEFINER |
catalog varchar(64), t_schema varchar(64),
t_name varchar(64), geometry_column varchar(64), t_srid int
| |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
| @ |
2015-11-25 06:42:53 |
2015-11-25 06:42:53 |
| latin1 |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|
| 编辑 | 复制 | 删除 DELETE FROM `proc` WHERE `proc`.`db` = \'test\' AND `proc`.`name` = \'DropGeometryColumn\' AND `proc`.`type` = \'PROCEDURE\' | test |
DropGeometryColumn |
PROCEDURE |
DropGeometryColumn |
SQL |
CONTAINS_SQL |
DEFINER |
catalog varchar(64), t_schema varchar(64),
t_name varchar(64), geometry_column varchar(64)
| |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
| @ |
2015-11-25 06:42:53 |
2015-11-25 06:42:53 |
| latin1 |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|