|
编辑
|
复制
|
删除
DELETE FROM `proc` WHERE `proc`.`db` = \'test\' AND `proc`.`name` = \'AddGeometryColumn\' AND `proc`.`type` = \'PROCEDURE\' | test |
AddGeometryColumn |
PROCEDURE |
AddGeometryColumn |
SQL |
CONTAINS_SQL |
NO |
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
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-24 22:42:53 |
2015-11-24 22:42:53 |
| | latin1 |
latin1_swedish_ci |
latin1_swedish_ci |
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
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 |
NO |
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
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-24 22:42:53 |
2015-11-24 22:42:53 |
| | latin1 |
latin1_swedish_ci |
latin1_swedish_ci |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
begin
set @qwe= concat( 'ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|