| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 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 : OFF Directory : /www/server/mysql/mysql-test/std_data/ |
Upload File : |
select * from mysql.user as t1, mysql.user as t2, mysql.user as t3; use test; drop table if exists t1; create table t1 (x int); drop table if exists t2; create table t2 (y int); drop procedure if exists p1; create definer=root@localhost procedure p1() select * from t1; call p1(); drop procedure p1; create definer=root@localhost procedure p1() insert into t1 values (3),(5),(7); call p1(); drop function if exists f1; create definer=root@localhost function f1() returns int return (select count(*) from t1); insert into t2 set y = f1()*10; drop view if exists v1; create definer=root@localhost view v1 as select f1(); insert into t2 (y) select * from v1; create trigger trg1 after insert on t2 for each row insert into t1 values (new.y); insert into t2 values (11), (13); drop procedure p1; drop function f1; drop view v1; # # Bug#23240 --init-file statements with NOW() reports '1970-01-01 11:00:00'as the date time # CREATE DATABASE IF NOT EXISTS init_file; CREATE TABLE IF NOT EXISTS init_file.startup ( startdate DATETIME ); INSERT INTO init_file.startup VALUES ( NOW() ); # # Bug#43587 "Putting event_scheduler=1 in init SQL file crashes mysqld" # SET GLOBAL event_scheduler = 'ON'; CREATE EVENT ev1 ON SCHEDULE EVERY 1 DAY DISABLE DO SELECT 1; DROP EVENT ev1; SET GLOBAL event_scheduler = 'OFF';