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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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...
3 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. ...
3 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 -...
3 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...
3 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( '...
3 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...
3 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...
3 months ago