how to fix this please – Phpmyadmin
I Created the db with phpmyadmin and created 8 columns i forgot to create date column i tried to create it with this code and i got this ALTER TABLE "users" ADD "cdate" DATE 1064 - You have an error…
Create function returns double value – Phpmyadmin
I want to make some function in phpmyadmin DELIMITER // CREATE FUNCTION total_bayar (order_id char(10)) RETURNS double DETERMINISTIC BEGIN DECLARE dist double; SET dist = SELECT sum(qty * price) FROM detail_masakan WHERE order_id = order_id; RETURN dist; END// DELIMITER ;…
SQL: Set default value to NULL for all columns without default value – Phpmyadmin
The webhosting I use has enabled StrictMode for the Databases. All my php scripts now stopped working because they report I haven't defined a default value for some columns. As I have a lot of columns in a lot of…
Laravel DB:select() requires all columns in the group by – Phpmyadmin
I need to run a custom query and I have tried all these methods $sql = "SELECT acd.*, DATE_FORMAT(acd.cdate, '%d/%m/%Y') cdate_disp, GROUP_CONCAT(CONCAT_WS(', ', car.type, car.session, crd.name) SEPARATOR '<br />') rd_names, acb.booking_status my_booking_status FROM app_data acd INNER JOIN crmaccounts ca ON…
LIMIT doesn't work in MariaDB – Tried a lot of things – Phpmyadmin
$dbhost = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "igscript"; $con = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $query = "SELECT * FROM lastsearches"; $result = mysqli_query($con, $query); if(mysqli_connect_errno()) { die("DB Error: " . mysqli_connect_error() . " ( " .mysqli_connect_errno()…
MariaDB on Debian: Syntax error: How to switch unix socket authentication back to password-based? – Phpmyadmin
I just installed Mariadb on my new unix system (Mariadb server version 10.1.37 Debian 9.6). I have the following users: +------------+-----------------------+-------------+-----------+ | user | authentication_string | plugin | host | +------------+-----------------------+-------------+-----------+ | root | | unix_socket | localhost | |…
SQL insert statement with user input to Phpmyadmin isnt working
I was trying to make a site and people could sign up/subscribe and i would store their email adresses in a database. I searched online for a solution but couldnt find anything My code: <html> <?php include_once('include/html/hoofd.php') ?> <body> <h1…
MariaDB Docker container using data volume – Error 2002, can't connect through socket – Phpmyadmin
I've installed MariaDB in a Docker container and it worked just fine. I wanted to move the data directory to an external volume to separate the databases from the container lifecycle. I followed the instructions here, but when I now…
Command import table dump into new table? – Phpmyadmin
I have a 70mb table dump that I need to added back into a database. I have tried phpMyAdmin but even with increasing the time_out and other settings in php.ini and config.inc.php it keeps timing out. max_execution_time 900 max_input_time 900…
MariaDB copy rows inside table – Phpmyadmin
I have a very simple table that looks like this: It's called anni_tot and it has a single field called anni. Now, there is another table that looks like this: It is called people_emp. Now, I want to insert a…