Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
3answers
16 views
mysql delete query with sub query not working
I try to create mysql event that should delete duplicate rows of table.
This is my query
DELETE FROM locations
WHERE id NOT IN (SELECT id
FROM locations
GROUP BY ...
0
votes
0answers
14 views
Trying to UPDATE and running into errors
Alright, I've been trying to do this all day. I know this question has been asked and answered before, but I haven't been able to wrap my head around how to make this work.
UPDATE ...
0
votes
0answers
8 views
Creating composite foreign key
I am using this script in Mysql:
CONSTRAINT `customer_contact_geolocation_id_fk` FOREIGN KEY(`customer_contact_geolocation`, `customer_contact_company_id`)
REFERENCES `geolocation` ...
0
votes
0answers
12 views
Rest Web service Method invocation Errors in java.Please Help what is the error?
2013-10-02 20:01:01,662 (http-0.0.0.0-7611-13) [ JavaEventHandler.java:101:ERROR] ---- error report -------------------------------------------------------------- Problems Processing Event Exception: ...
0
votes
2answers
10 views
Android Webservices - “poke” the webservice
I'm trying to make my mind up in what's the most efficient way to approach my problem with webservices.
My situation: I'm developping an Android app which is storing and retrieving data from a mysql ...
android
0
votes
0answers
5 views
Facing issue with Case sensitive search in django-tastypie-mysql
I am facing problem on Case Sensitive search. I am using the following environment:-
Database: MySQL
Collation/Character Encoding: utf8bin
Framework: Django-Tastypie
This collation/Character ...
0
votes
0answers
3 views
Jelastic- Host '' is not allowed to connect to MySQL server
I have created a new environment in Jelastic using Glassfish 3.1 and MySQL 5.5.32. I am trying to make connection to MySQL server from a local client computer using ./mysql -u root -p*** -h ...
0
votes
0answers
8 views
need solution for create mysql-view with parameter
this is my first table t1
| code | month | value |
-----------------------------
| 101 |august | 1 |
-----------------------------
| 101 |September | 3 |
...
-3
votes
0answers
23 views
Nested Comment System PHP and MySQL
I want to make a nested commenting system. there have any tutorials which I can use for learn the nested comment system structure.. :D
I am confusing with nested comment system. so help me guys!
I ...
0
votes
0answers
16 views
CSV Export from MySQL via PHP with fixed row
I have checked several thread of stackoverflow.com against my problem. Let me describe the my problem.
I have generated a query to get available stock based on serialno cross checking between stockin ...
0
votes
1answer
27 views
How to get value from unknown object property?
I have an issue with extracting value from object.
I want to check if my SQL table have the asked row:
var checkRow = function(connection,chekedColumn,chekParam, checkVal){
...
0
votes
1answer
19 views
Facebook Share doesn't display image
What I'm planning is that a user has an option to share his/her uploaded image.
I am retrieving the image name in my MySQL DB.
Here's my simple MySQL SELECT Query :
$gallery_select = ...
facebook
-4
votes
1answer
42 views
Android : If statement being skipped even if condition is corrrect
I am new to android and am creating a registration page. Since android doesn't support mysql , i created a php based script which gives out integer values for different queries.
2 --> successful ...
0
votes
5answers
38 views
Ms Sql Function for list
I have varchar values like below
72,73,74
I try to split as a comma after that i want to convert to int above values.Than i want to match Id with my User Table.
CREATE FUNCTION ...
0
votes
1answer
13 views
unexpected end of input in MySQL when creating stored procedure
got error at two places
CREATE PROCEDURE p2()
BEGIN
DROP PROCEDURE IF EXISTS temp_table; // unexpected end of input
CREATE TEMPORARY TABLE temp_table (count int);
insert into temp_table select ...
