All Questions
Tagged with mysql phpmyadmin
10,796
questions
0
votes
2
answers
42
views
there can be only one auto column and it must be defined as a key
I'm trying to install this 4chan clone: https://github.com/Ro0ul/4Chan-Clone
I'm executing one of the queries on the sql folder on phpmyadmin:
CREATE TABLE comment(
id INT AUTO_INCREMENT,
...
0
votes
0
answers
13
views
Column value wrong [duplicate]
I have a big gap from id 50653, it jumps right on 80001, is there any easy way to make them consecutive or do I need to edit them one by one manual ? Someone changed one ID to ID 80000 and now it ...
0
votes
1
answer
65
views
Why would Mysql return "error Column cannot be null"?
We recently moved our mysql version to mysql 8 but we are facing a really strange behavior some (valid) queries that would work before like a charm stopped working (sometimes) for no reason and mysql ...
0
votes
2
answers
113
views
XAMPP Not Working After macOS 15 Update: Apache Won't Start
I've recently updated my Mac to macOS 15, and since then, my XAMPP installation has stopped working. Specifically, Apache won't start, and I can't seem to figure out why. Has anyone else encountered ...
0
votes
2
answers
74
views
MYSQL Table having 150000+ rows responding too slow even in phpmyadmin
I am facing strange Slowness some times it says #1205 - Lock wait timeout exceeded; try restarting transaction & in my specific MYSQL table.
I have below table which have id and TBO_code as index ...
0
votes
0
answers
16
views
MySQL float does not work for comma-separated decimal values [duplicate]
I have a text file full of comma separated decimal numbers.
When loading the data into a table using
LOAD DATA INFILE ...
it truncates each and every one of them at the comma, and only saves their ...
0
votes
0
answers
16
views
Empty Values shows in Database
I have a database with all 'required' fields.
But still database accepts and fill with empty values as shown in the below screenshot.
How to avoid inserting blank values in database?
0
votes
0
answers
19
views
Database created by cli not showing up on phpmyadmin
I created a database using CREATE DATABASE db7. And then I imported a sql file I had using mysql -u root -p db7 < dbsqlfile.sql. The import was successful, however it took some time. I can see the ...
0
votes
0
answers
35
views
Can't access phpmyadmin on nginx
I am trying to have "/phpmyadmin" on my website. I am using nginx as a reverse proxy, fastapi with guvicorn on the backend, and MySQL. OS: Ubuntu 22.04.4
I can't seem to find any info on how ...
0
votes
0
answers
21
views
problem in different datatype when using varchar as foreign key in database mysql xampp phpmyadmin
I have primary key subject in table teachers. I want to use subject as primary foreign key in table marks. Subject is varchar(50). And the attribute I want to apply the foreign to it called ...
0
votes
0
answers
38
views
problem the concat isn't working properly in trigger in phpmyadmin mysql database xampp
I want to create new column from concating two columns. So I created a trigger to do that before inserting new row.
ex:
student_type
student_id
student_username
student
1
student_1
the type column ...
0
votes
0
answers
40
views
XAMPP - phpmyadmin will not start any more / MYSQL issue
Please don't notice red messages in pictures. They are not important for specific picture (it's the message of the issue before)
If I try starting XAMPP Apache and MySQL, MySQL will not start under ...
0
votes
0
answers
39
views
I cannot assign migration to MySql database in C-Panel?
I have no problem when migrating to the MySql database in my locale, but I cannot migrate to the MySql database in C-Panel. After creating the database, I assign a user and set the connection string ...
0
votes
0
answers
63
views
phpmyadmin database collation issue for utf8mb4
I am using phpmyadmin mysql version 8.0.31
Default Server Connection Collation in phpmyadmin of new server is shown = utf8mb4_unicode_ci
When I download mysql database from old server with mysql v 5.7....
0
votes
0
answers
17
views
Copy mysql db field to another field [duplicate]
I have a database table with thousands of products. Each product have various fields. There is a field (field1) on each product that contain a link, I need that link to be copied to another product ...