| Server IP : 104.21.38.3 / Your IP : 162.158.170.47 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/ndb/r/ |
Upload File : |
drop database if exists mysqltest; create database mysqltest; create table mysqltest.t1 (a int primary key, b int) engine=ndb; use mysqltest; show tables; Tables_in_mysqltest t1 drop database mysqltest; create database mysqltest; use mysqltest; show tables; Tables_in_mysqltest drop database mysqltest; create database `mysqltest.db`; create table `mysqltest.db`.t1 (a int primary key, b int) engine=ndb; alter table `mysqltest.db`.t1 algorithm=copy, add column c int; alter table `mysqltest.db`.t1 algorithm=inplace, add column d int column_format dynamic; drop table `mysqltest.db`.t1; drop database `mysqltest.db`; create database newdb; create table newdb.t1 (a int primary key) engine=myisam; drop table if exists newdb.t1; create table newdb.t1 (a int primary key, b1 blob, b2 blob, b3 blob, b4 blob, b5 blob, b6 blob, b7 blob, b8 blob, b9 blob, b10 blob, b11 blob, b12 blob, b13 blob, b14 blob, b15 blob, b16 blob, b17 blob, b18 blob, b19 blob, b20 blob, b21 blob, b22 blob, b23 blob, b24 blob, b25 blob, b26 blob, b27 blob, b28 blob, b29 blob) engine = ndb; drop database newdb; create database newdb; use newdb; show tables; Tables_in_newdb create table newdb.t1(a int primary key) engine=ndb; show tables; Tables_in_newdb t1 drop table t1; drop database newdb;