mysql – Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
/etc/mysql/mysql.conf.d vi mysqld.cnf [mysqld] innodb_log_file_size = 512M innodb_strict_mode = 0 /etc/init.d/mysql restart
/etc/mysql/mysql.conf.d vi mysqld.cnf [mysqld] innodb_log_file_size = 512M innodb_strict_mode = 0 /etc/init.d/mysql restart
$spojeni = mysqli_connect(„server“, „uzivatel“, „heslo“, „databaze“); $sql = „SELECT * FROM tabulka“; $data = mysqli_query($spojeni, $sql); if (! $data) { exit („<p>Sql: <PRE>“ . $sql . „</PRE> Chyba: “ . mysqli_errno($spojeni) . “ – “ . mysqli_error($spojeni) . „</p>“); } $zaznam_pocet = mysqli_num_rows($data); for ($i = 0; $i < $zaznam_pocet; $i++) { mysqli_data_seek…
mysql> show privileges; | Privilege | Context | Comment | | Alter | Tables | To alter the table | | Alter routine | Functions,Procedures | To alter or drop stored functions/procedures | | Create | Databases,Tables,Indexes | To create new databases and tables | | Create routine | Databases | To use CREATE…
CREATE DEFINER=`autor`@`localhost` PROCEDURE `proc_wpfb_kategorie`(IN `in_cat_id` INT, OUT `kategorie` VARCHAR(255)) begin declare loc_cat_id INT DEFAULT 0; declare loc_cat_parent INT DEFAULT 999999; declare kategorie_temp varchar (255) default “; set loc_cat_id = in_cat_id; select cat_name from wp_wpfb_cats where cat_id = loc_cat_id into kategorie; …