How i will find the same value in my row and put it in CASE

MySQL
hi can you help me guys in my sql CASE statement or how i will manipulate the data. i was trying to find the same value of my row value .. and if they...
11 months ago

MySQL/PHP Admin: Foreign key constraint is incorrectly formed

MySQL
I have a table called reservation which stores the reservation details. When I try to create the table it gives me the error; Foreign key constrai...
11 months ago

mysql BETWEEN equivalent in MongoDB

MySQL
In PHP & MongoDB, i am trying to read all instances of events for a specific calendar and a specific period. Each event has start and end date. Th...
11 months ago

How to select and echo MySQL data (one to many) using PHP

MySQL
This is my current code, it works fine with one problem. $stmt = $conn->prepare("SELECT * FROM tmdb_movies JOIN genres ON genres.genres_tmdb_id=tm...
11 months ago

How to select one to many relationship data in PHP PDO

MySQL
I have total 3 tables in PHPMyAdmin: Movies: tmdb_movies Cast: cast. Foreign key is cast_tmdb_id for table tmdb_movies column tmdb_id screenshot Gen...
11 months ago

Compare table rows, big data amount

MySQL
I have a quite interesting task. But I don't know how to call it in one word in order to search for related topics. Even this topic title might not re...
11 months ago

Joining columns from same table twice causes unknown column issue

MySQL
So interesting thing happening here, i'm using MySql DB and trying to make a join based on the same column from the same table (which i've selected un...
11 months ago

form input value text truncated

MySQL
The text that i try to show inside a form input is truncated when there is an apostrophe. Here is the code i use to insert data inside database (insid...
11 months ago

MySQL - Usage of 'Allow NULL'

MySQL
Does usage of NULL to fill empty cells on my tables make searches / queries faster? For example is this 90 2 65 2011-04-08 NULL NULL 134...
11 months ago

When is tuple length too long?

MySQL
Here is a logical schema for my largest relation: {(id, uName, supplies, score, playerType, storageSupplies, supplyDrop, barracks, armourDepot, hanga...
11 months ago

How update table with duplicate primary key?

MySQL
I trying to update a table with another table of other database, I the last updated I created a function to save more than one category in one product...
11 months ago

Am I doing nested joins incorrectly?

MySQL
Folks! I am scratching my head on this one. Right when I add UserRole part in last join I start seeing this error. What am I doing wrong? Is there a l...
11 months ago

Is the primary key stored implicitly in other keys in mysql myisam engine?

MySQL
My problem: imagine a table with millions of rows, like CREATE TABLE a { id INT PRIMARY KEY, column2.., column3.., many other columns.. .. INDEX (col...
11 months ago

Database for monthly schedule and appointments

MySQL
I am trying to create a small system with appointments between doctors and patients. Here is my database(until now). I have two questions: 1) When the...
11 months ago

Only one key from composite primary key as foreign key

MySQL
In this database, key1 & key2 make up the composite primary key of table4, but i'm able to add a foreign key to table3 that comprise just key1. ...
11 months ago

mySQL query using join

MySQL
I have 2 tables - 'cityname' and 'citymoisture'. 'cityname' has 2 columns: -city_ID <- integer and primary key that increments automatically -...
11 months ago

what is the difference between := and = mysql assignment operator

MySQL
What is the difference between := and = assignment operator in MySql? And which place is it stable to use these two? Is it the same or just an alter...
11 months ago

Where do we give the table-name?

MySQL
I am learning to connect an android app to a sqlDatabase with the help PHP scripts and this is what the php scripts basically look like define( '...
11 months ago

MySQL complex merge of two tables with different date format

MySQL
I have a MySQL table like this fiddle here: http://sqlfiddle.com/#!2/4ae5c/15 And the other has different from an API: http://sqlfiddle.com/#!2/b7946...
11 months ago

jquery-the output is always in the first item only

MySQL
I am trying to create a web store and I use Jquery in radio button for selecting a category but the output is always on the first item only not in eac...
11 months ago