I am using laravel 6.I have created a table called 'student', where the value increment of the 'id' column is supposed to happen but is not happening. This is my migration file: <?php use IlluminateDatabaseMigrationsMigration; use IlluminateDatabaseSchemaBlueprint; use IlluminateSupportFacadesSchema; class…
I am doing an online course from coursera where they tolm me to install phpmyadmin. NOW I am a total beginner in this thing so I am not able to do much research upon that and now somehow, after I…
I want to upload a big db to my localhost(docker with apache). The first problem was that I can't upload a big file than I add a uploads.ini and add it to the docker-compose.yml. Now you can see in phpMyAdmin…
I have hosted my Laravel project on Shared hosting. Everything works fine on local but my main problem is in Phpmyadmin when i imported my sql file into it. In my local i every table has primary key, auto increment…
I designed a database model on MySQLWorkbench. Then, I export the model to generate a SQL script. Finally, when I import it in MariaDB PhpMyAdmin it raises errors like : #1067 - Invalid default value for 'created' MariaDB version :…
I want to change date format in my PHP MySQL but could not change. echo ($row->PasscreationDate);?> PasscreationDate is the date I want to change it appear default as YYYY-MM-DD HH-MM-SS, I want to change that date format as DD-MM-YYYY.
I have a MariaDB query that I am using in my Laravel application and I would like it to return 7 columns. When I dump the resultant array with PHP it seems to only be returning 4. However when I…
I am not sure why this query is taking forever and freezing the entire server. When I remove one coulmn value and Join form below its working. May I know if SQL has something like maximum number of join can…
I'm trying to get the phpMyAdmin front page to show the "Server Charset" as "UTF-8 Unicode (utf8)". Currently, it is displaying as "cp1252 West European (latin1)". Is there a config.inc.php setting that I need to change to do this? I…
I encountered a problem in my xampp phpmyadmin i search for it but didn't find solution here is a screenshot of it.