I need to get the list of users who have previously been sent message (MySQL)
Issue I am making an instant messaging web page, I have assembled the entire database and made 100% of the…
Category: MySQL
Rename a MySQL table using SQL statement
Issue I want to rename an existing table using SQL statement: I have already tried: mysql_query(“RENAME ‘$renameFolder’ TO ‘$newName'”); mysql_query(“ALTER…
masking the id of an employee in a select query
Issue I have an ID which I want to mask the last 4 digits of that id. example: my_id =…
How to combine Duplicate data into single Data MySql
Issue I was wondering if what is this called or is this even possible in MySql, or what should I…
MySQL how to create a custom id column formatted with character, date and number
Issue CREATE TABLE customers ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT… I need the sequence to go like so:…
Unable to connect to online mysql database using javaFX
Issue I recently made a project which involved connecting to a mysql database online using Swing in java. I then…
MySQL – Merging two queries that have different conditions and limits
Issue I’m implementing a Tag System for my website, using PHP + MySQL. In my database, I have three tables:…
MySQL – trying to select a range from the first day of previous month at midnight, to the first day of the current month at midnight
Issue I’m working with MySQL, and attempting a specific time range query. For example if it’s august now, I’m attempting…
MySQL function with query inside it
Issue I used this mysql function to retrieve the sum of a column’s data with passing three parameters. Function return…
cannot access a disposed object mysql workbench
Issue When attempting to connect to a database requiring SSL, but SSL set to ‘No’ in WorkBench, I pressed cancel…