MySQL is an open-source, relational database management system.
0
votes
1answer
17 views
Update a table in Mysql using a form
I'm building a simple bug tracker tool.
When you've created a project, you can select a project status (open, in progress, finished).
You can change this status on the project page with this select ...
0
votes
0answers
9 views
Use PhantomJs, Nodejs and MySQL
Is there a way to use PhantomJS to scrape the data then parse the results with nodejs XPath and DOM then save into MySQL?
I've installed both PhantomJS core and also PhantomJS Node module but trying ...
0
votes
2answers
18 views
Get new post count for each topic according to user last view
I cant figure out how to do the mysql query for it.
I have mysql table for topics (id,name) and posts (user,topic,post,time) and user last topic views (topic,user,time)
I need to get the new post ...
0
votes
0answers
19 views
Check Message If read and unread
Hi this my update procedure for message read/unread.
rcp_id_in i wants update based on rcp_id_in .in front end level this id did't get..how to pass this id to conroller..And same thing If i read the ...
0
votes
1answer
18 views
how to combine result of two queries in one resultset
I have a table named 'rating'
it has two fields 'cab_id' and 'rating' which stores id for cabs and its rating as either 1 or 0.
I want to retrieve values as up or down as sum of counts as 1 or 0.
I ...
0
votes
1answer
15 views
Get the most recent row for each order ID, after a join?
I have 2 tables:
sms_send has following columns:
created_at, order_id, sms_id, mobile, msg
sms_msg has following columns id, short_desc.
sms_id corresponds to id in sms_msg.
sms_send can have ...
-2
votes
3answers
24 views
converting array in two dimension
i have this result as a mysql_fetch_row function which return rows from database...
Array
(
[firstname] => abc
[lastname] => xyz
[password] => abc
[gender] => female
...
-3
votes
0answers
29 views
How to Multiply of two arrays [on hold]
I am trying to do multiply the values of two arrays. These are the arrays I have:
$p = array(0.05, 0.06);
$a = array(500, 500, 500, 500, 500, 500, 500, 500, 500, 500, 500, 500);
I want output ...
-1
votes
0answers
11 views
‘error: ‘EXAMPLE_FUNCTION’ was not declared in this scope ’ happend when I complie mysqlc++ connector1.1.3 examples
I am trying to install mysqlc++ connector1.1.3 to my ubuntu os by compiling source code,but it reported "error: ‘EXAMPLE_FUNCTION’ was not declared in this scope " when I compling the example. Is ...
2
votes
5answers
43 views
select min value of range [0,44) not in a column
I have a table with an int valued column, which has values between 0 and 43 (both included).
I would like a query that returns the min value of the range [0,44) which is not in the table.
For ...
0
votes
0answers
17 views
Rails Mysql to Postgresql Float
I'm transferring my database from mysql to postgresql.
I have a latitude and longitude column for one of my models:
t.float :latitude
t.float :longitude
I'm using mysql2psql gem to load the ...
-3
votes
1answer
22 views
Mysql query - couldn't add single quotes within the another single quotes
SET @pid = "$memberID = getLoggedId();
$iPid = $GLOBALS['MySQL']->getOne('SELECT `Pid` FROM `Profiles` WHERE `ID` = '.$memberID.' LIMIT 1');
if($iPid==1){
echo '<div id=# style=margin:10px ...
0
votes
1answer
11 views
how to use SUBSTRING_INDEX function in mysql procedure
I have create a mysql Procedure. here its code
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE a , b, d TEXT;
DECLARE c INT Default 0;
DECLARE cur1 CURSOR FOR SELECT id, school_id FROM ...
0
votes
1answer
12 views
Best method to add pagination to a gallery
I have clients website that is getting overloaded with images in his gallery. I was wondering if I could get some advice and see what you guys/girls think would be the best way to handle this current ...
0
votes
0answers
8 views
org.hibernate.exception.JDBCConnectionException in tomcat 7
I am using struts2 spring hibernate for eCommerce application with mysql as backend server. the application stop working after few hours by giving below exception.
...
