mirror of
https://github.com/MariaDB/server.git
synced 2025-02-22 13:23:07 +01:00
21 lines
424 B
Text
21 lines
424 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
#
|
|
#
|
|
#
|
|
connection master;
|
|
SET @p=POINT(1,1);
|
|
CREATE TABLE t1 AS SELECT @p AS p;
|
|
connection slave;
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`p` point DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
SELECT ST_AsWKT(p) FROM t1;
|
|
ST_AsWKT(p)
|
|
POINT(1 1)
|
|
connection master;
|
|
DROP TABLE t1;
|
|
connection slave;
|
|
include/rpl_end.inc
|