I'm a bit new to this and I receive a few errors and only 4 tables appear in my database(phpmyadmin). Could you please assist here? #@(#) script.ddl DROP TABLE IF EXISTS collect; DROP TABLE IF EXISTS build; DROP TABLE IF…
I am exporting a table from DB in csv format. I have numbers starting with 0, such as 04596 or 059438. If I open this csv in LibreOffice or Excel, the 0 will be thrown away and numbers are shown…
I start on Xammp Apache and MySQL but when I click on admin instead of opening the phpmyadmin page I see this writing: Composer detected issues in your platform: Your Composer dependencies require the following PHP extensions to be installed:…
I am trying to create a table in a database in phpMyAdmin and I keep getting the "a symbol name was expected" error and I cannot figure out what is going on. Is my syntax wrong? I am new to…
Here is an image of my current code This is what my current code outputs when I enter it This is what I need my code to be outputting
I'm trying to delete duplicate rows in a table. The email field needs to be be unique in the table for the code after it to run. Here's my code: DELETE FROM deleteRequests WHERE Email NOT IN ( SELECT MAX(Email)…
I have been able to select this data, using these two sql queries Query 1: SELECT article_id, amount_required, amount_sold FROM products_articles,sales WHERE sales.product_id = products_articles.product_id Query 2: SELECT * FROM articles What I want to do, is go through the…
"mytest_people" and "mytest_hobbies": PK FK <--- PK +----+------+------+------+ +----+-----------------+ | Id | Name | Age | H_ID | | Id | Hobby | +----+------+------+------+ +----+-----------------+ | 0 | Pete | 100 | 0 | | 0 | Reading News |…
I see this error in phpmyadmin: The number of joins that do not use indexes but I never use join in my code. Now I want get a list of query that do not use indexes. How can I get…
I'm sure there's a logic to this, but I do not understand it date_format(date, '%m.%d.%Y') // Output: 03.05.2021 date_format(date, '%D.%m.%Y') // Output: 5th.03.2021 date_format(date, '%e.%m.%Y') // Output: 5.03.2021 But date_format(date, '%d.%m.%Y') // Output: 28.02.2021 There seems to be an issue…