Count by styles instead of colors

MySQL
'SELECT count(`houses`.`color`) AS `count`, `houses`.`color` FROM `user_houses` JOIN `houses` ON `houses`.`id` = `users_houses`.`hous...
5 months ago

How do I use a form to change the SQL query to only display registered dates between a specific range?

MySQL
The code below is what I have so far, if anyone has any knowledge of how BETWEEN works and could point me in the right direction I would really apprec...
5 months ago

dbConnect- Does cleaning data in R change data values in the real database

MySQL
I am doing research on MySQL data. I used the dbConnect function to connect to the database and used dbReadTable to read a table. My question is: if...
5 months ago

Suggestions for speeding up LEFT JOIN in MySQL

MySQL
I have a tabled named usr_data with 40,000 or so records that I want to left join with the user's organization data (roughly 1000 records) via a selec...
5 months ago

Rearrange Column Order in Navicat

MySQL
in navicat you can arrange the order of the columns but i have yet to find a way to sync the changes with the database. i saw a similar question here ...
5 months ago

MongoDB high storageSize

MySQL
I've just switched from mysql to work with mongoDB and it's pretty awesome but I'm struggling with the db datasize.. I have about 700 documents per d...
5 months ago

PHP & MySQL - not inserting into database

MySQL
I've got an problem in my code. The insert is not working. The code is below. HTML: <form action="staff.php" method="post" class="center" enctype...
5 months ago

MySQL Insert Data into Table1 when a matching record is found in Table2

MySQL
I have two tables data1 and data2. Data1 contains contains 2 columns, emailaddress and name, but the name column is empty. emailaddress name email...
5 months ago

Use a range of values with a variable

MySQL
I have the following queries; $sel_referrals1="SELECT t1.referree AS GEN1, t2.referree as GEN2, t3.referree as GEN3, t4.referree as GEN4, t5.referree...
5 months ago

MySQL huge tables, performance improvement with migration to NoSQL?

MySQL
We have few very big tables (3 tables, each 2 ~ 5 GB) in our MySQL DB. We are running logistic applications where we combine entities like route,sche...
5 months ago

PHPExcel library get date

MySQL
Using PHPExcel, I a trying to fetch data from Excel file and save it in MySql database using the following code: $sheet = $objPHPExcel->getSheet(0...
5 months ago

trouble creating table using foreign key

MySQL
create table department ( dept_name varchar(20), building varchar(20), budget numeric(12, 2), primary key(dept_name) ); This is table that i crea...
5 months ago

how to get week of month?

MySQL
I want an array of containing weeks of current month, How can i get this? I have tried different methods but none of them is working for me.. $month ...
4 months ago

Fetch specific data from Database for a product

MySQL
I'm using WooCommerce and I need to fetch data from my woocommerce database: I know, I can get the regular price of an item with this code: $regPric...
4 months ago

Laravel query builder where and or where

MySQL
I want to build a query something like this: select * from users where id=1 AND address="USA" AND (status="active" OR status="pending") how can i d...
4 months ago

Can't create table in MySQL [error 150] when use foreign key

MySQL
I have designed schema with MySQL workbench. But it couldn't complete Database Synchronize.It can create tables with out foreign keys. I copied SQL ...
4 months ago

BIGINT UNSIGNED value is out of range

MySQL
I am getting the error BIGINT UNSIGNED value is out of range in '(1301980250 - mydb.news_articles.date)' When I run the query SELECT *, ((1 / ...
4 months ago

MySQL - DATE_ADD month interval

MySQL
I face a problem with the function DATE_ADD in MySQL. My request looks like this : SELECT * FROM mydb WHERE creationdate BETWEEN "2011-01-01" AND ...
4 months ago

login form php code

MySQL
I have created a form with username and password and login button in html. I have created code for php but it is not able to check the condition for l...
4 months ago

MYSQL Join 2 tables with 2 relations table

MySQL
Hi I need to get data from a database but I can't figure out how do do it as is... They have "boutiques" tables and "boutiques_categories" and a rela...
4 months ago