Some ideas regarding to database performance (General)

by Andreas Schneider, Wednesday, April 19, 2023, 17:49 (423 days ago) @ Auge
edited by Andreas Schneider, Wednesday, April 19, 2023, 17:55

Hi,

(my skill does not reach up to yours, but i do my best...)

the combination of
Hoster: IONOS Germany
DB: MariaDB 10.6
PHP: 8.1
Forum: 20220803.1

and this php script as a dummy test:

<?
$xtext="CREATE PROCEDURE Test5 () 
        NOT DETERMINISTIC 
        CONTAINS SQL 
        SQL SECURITY DEFINER 
                BEGIN 
                select count(*) from mlf2_settings; 
                END 
 
        ; "
 
?>

works to create a SP.
I put an include at the end of includes/admin.inc.php (just before th subtemplate is called)
for this

and a
$result = mysqli_query($connid, $xtext);

as next.

Using phpmyadmin shows syntax differences between php and the frontend of phpmyadmin.
Testing SQL code in phpmyadmin, you have to use the Delimiter field below of the input field.
Works, but only for testing.

Best
Andi


Complete thread:

 RSS Feed of thread