Surpassing MySQL's TIME value limit of 838:59:59

MySQL
The title might be a bit confusing so allow me to explain. I'm using a table to record my work logs. Every day I'll create an entry stating from what ...
5 months ago

Show most recent topic in forum category with PHP MySQL JOINS

MySQL
I'm currently making a forum section in my website and I have a categories page that show the different categories that you can post in, in a table. O...
5 months ago

How to add multiple rows using "Insert ... ON DUPLICATE KEY UPDATE" using knex

MySQL
so I've been playing around with knex lately, however I found myself on a situation where I don't know what to do anymore. so I have this query: kne...
5 months ago

Mysql - Adding Dynamic Column From Two Different Query

MySQL
I have two database. The first database named ydepotras_estimator, which is I have a table named repair_estimate. mysql> DESC ydepotras_estimato...
5 months ago

Failed to instantiate SLF4J LoggerFactory

MySQL
So, I'm working from this example BONECP: package javasampleapps; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLExcepti...
5 months ago

Error when checkbox not checked in php mysql form

MySQL
The checkbox in my form works to put in a true value (1) when the checked and otherwise, the value for the column is false (0).. however, when I run t...
5 months ago

How to create mysql table with many hasMany association in CakePHP?

MySQL
I'm defining a completely new database. I have now faced a problem which I would describe as "usual" but still could not find good information from we...
5 months ago

DELETE results in 'Query Interrupted' MySQL Workbench?

MySQL
I can successfully delete records manually by click-selecting & deleting row(s) using the GUI so I don't believe it's a permissions issue but type...
5 months ago

MySQL - Left join order being ignored

MySQL
I'm attempting to order a join table by it's primary key DESC and pull out only that record to add to the dataset. Structure ws_results ResultID (...
5 months ago

MySQL: how to prevent deletion?

MySQL
Once a record is entered in a particular table, I think I don't ever want it to be deleted. The records are there to keep track of things for historic...
5 months ago

One sub-category can belong to many category

MySQL
This is a diagram of the category-subcategory table (adjacency model). Now, a sub-category like printer paper can have more than one category (off...
5 months ago

SQL query make an union and an order by random in only the second section

MySQL
I'm making a SQL query to get the billboard on my site. I need a specific billboard to arrive first and the other to be order randomly. So I need the ...
5 months ago

Why do I get an error when I try to use Perl's DBD::mysql?

MySQL
I am trying to write data to a MySQL database using Perl. However, when I run my script I get the error below: Can't locate loadable object for modu...
5 months ago

SQL Query To Select From Either Or 3 Tables

MySQL
Am building a document manager, where a file can belong to many folders(When copied action is being performed from front-end) and a folder can belong ...
5 months ago

PHP Edit databse entries not updating

MySQL
Making something so you can edit the database entries using a form but it's not updating, the first one with ID 0 doens't work at all but don't worry ...
5 months ago

MySQL: Selecting rows ordered by word count

MySQL
How can I order my query by word count? Is it possible? I have some rows in table, with text fields. I want to order them by word count of these text...
5 months ago

MySQLi Query issue using OR and AND within the same query

MySQL
I am looking to create a simple query that shows all the products where the category ID matches the 'category' or 'category_2' columns within the data...
5 months ago

Joining 4 tables in mysql giving me duplicate records

MySQL
I want to join below 4 tables (leads, categories, sales_persons, website_assigns) in mysql query : Required : i need lead id and lead record but its...
5 months ago

MySQL update only Hour in Date-time field

MySQL
I want to update a DateTime column where it will change the hours only without modifying anything else. I can't use to add an interval as the values a...
5 months ago

How to select from whereIn clause using Laravel Eloquent ORM or Query Builder?

MySQL
I'd like to get value by the following MySQL using Eloquent ORM. MySQL Query - select * from users where is_super_admin = 1 or is_partner = 1 or ...
5 months ago