mysql table creating error #1089

SQL
We want to create a table in mysql DB but it's not working properly. Error message showing: #1089 -Incorrect prefix key; the used key part isn't ...
3 years ago

How do I open up my MySQL on my Raspberry Pi for Outside / Remote Connections?

SQL
I have a Raspberry Pi that stores temperature data for homebrewing activity. I am making a Spring MVC application on my computer and I want to tap the...
3 years ago

SQL Server join and retrieve data

SQL
I have the following database diagram. How can I get all the movies and their respective audio format ? ...
3 years ago

Get a value based on last and current row according to a group of conditions

SQL
I need to get a Quantity value in a Upgrade column based on the calculation condition on the column Type, then compare to previous year for different ...
3 years ago

You have an error in your SQL syntax ...near '''

SQL
Here is my table. Trying to make a "forgot password form." Getting the same error over and over. Need your help. You have an error in your SQL s...
3 years ago

Python connect to MySQL failed with error "dh key too small"

SQL
I'm trying to connect to the company's MySQL database. The policy was that I am to connect only using SSL. I am provided the username, CA certificate...
3 years ago

Execute immediate statement

SQL
I'm trying to insert data into table using execute immediate statement. But I get an error FROM keyword not found where expected Could anyone take...
3 years ago

How to connect MySQL from VC++ on MS Visual Studio 2008?

SQL
How to connect with MySQL from Visual C++ Microsoft Visual Studio 2008 ? I tried googling and found solutions all of which ended with fatal errors lik...
3 years ago

String Aggregation in ORACLE 10g with three columns

SQL
This is a sample table data Date | Fruit | Number ----------------------- 1 | Apple | 1 1 | Apple | 2 1 | Apple | 3 1 | ...
3 years ago

extracting last name from a name string in ORACLE DB

SQL
I am writing a small query to extract all last names from a bunch of Author name database. Names on file will contain first and middle name, or just f...
3 years ago

Entity Framework - How to check if table exists?

SQL
I'm using the Entity Framework with Code First approach. The base class DbContext has functions to create and delete the database as well as to check ...
3 years ago

Can MySQLdb on client machine connect to a database on a server machine?

SQL
I am not a network/web/internet programmer so please excuse my noobness in this area. I have gotten a website using a free hosting service. They inclu...
3 years ago

How to group by one field when the other field rows are different

SQL
I have the result set i am looking for, but now i am trying to trouble the rows by Order ID, but i am having a hard time figuring out how to do this. ...
3 years ago

SELECT all N between @min and @max

SQL
I need to select all numbers N (integers) between @min and @max Is there any way to achieve that without using a loop of some sort? Example: Let's sa...
3 years ago

MySQL Query to find users still inside room

SQL
Below is my database table, where I will have Check In and Check Out entry records for attending the conference room. id registration_id roomno day ...
3 years ago

How to check if a column is already a foreign key?

SQL
I have table named Person and column named ID how to check if ID is already FOREIGN KEY cause I want to make it with this code: ALTER TABLE Person AD...
3 years ago

Buttons and repeater control

SQL
I am using ASP.NET, C#, Sql Server 2005 for my project and I'm using the repeater control to form a table of users that are a member of a site and a b...
3 years ago

MySQL: SELECT + SUM() only returns one record

SQL
Input data: "Card" table: cardID Name 1 A 2 B 3 C "Quantity" table (can have multiple entries for each card, depend...
3 years ago

PostgreSQL delete with inner join

SQL
DELETE B.* FROM m_productprice B INNER JOIN m_product C ON B.m_product_id = C.m_product_id WHERE C.upc = '7094' AND B.m_pricelist_versio...
3 years ago

How to SUM two fields within an SQL query

SQL
I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. ...
3 years ago