I have 3 tables name as- blogs, comment, and replies. I have a primary key blog_id(in blog table).
In comments table I have the following column- comment_id(int(11)), comment_viewer_id(int(11)), comm_blog_id(int(11)), comment_message(longtext), comment_on(datetime).
In replies table I have the follwoing column- reply_id(int(11)), reply_viewer_id(int(11)), reply_blog_id(int(11)), reply_comm_id(int(11)), reply_message(longtext), reply_on(datetime).

When outputting phpinfo(); does not show the MySQLi section, but only the mysqlnd driver, what should I do in this case? How to connect MySQLi? In php.ini extension = mysqli the line is uncommented,windows 11.

i have a table in mysql like this : | id | user | value | 1 | 1 | 2 | | 2 | 1 | 2 | | 3 | 1 | 2 | | 4 | 1 | 1 | | 5 | 1 | 2 | | 6 | 1 | […]

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 continues from there. I want to make the IDs after 50653 to continue consecutevely.

On both my local (Windows) machine and live server (Linux) there is a table set up as InnoDB with utf8mb4_unicode_520_ci collation. The column is a varchar. Sometimes the text enterred in the field contains the UK Pound symbol (e.g. Reduced to £6 for one week).
If the text is displayed using webpage on my localhost the pound sign displays correctly. From the live server the replacement character (diamond with question mark) displays. On both systems the pound sign entered as text in HTML page displays correctly. All HTML/PHP pages have the <meta charset="UTF-8">.

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 return an error but if we re-run it sometimes it works.

I have a MySQL table that is constantly being fed rows. It’s a big table with more than 40k rows.

I am trying to follow the suggestions made in this post I want to set a combination of (skiposttag_skipost_id and skiposttab_tag_id) as primary key. In this case it will guarantee that a tag can be mentioned only once for the given article.

I am facing strange Slowness some times it says #1205 – Lock wait timeout exceeded; try restarting transaction & in my specific MYSQL table.

I got this in my homework and can’t figure it out, please help.