176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL stored procedure expert
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Sep 26, 2012
  • Time Left: Closed
  • Location: China
  • Client prefers freelancers from:
    China

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hi, everyone

Following code is stored procedure.
DELIMITER $$

USE `procedure_test`$$

DROP PROCEDURE IF EXISTS `InsertUserInfo`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `InsertUserInfo`(
IN userid BIGINT(20),
IN session_token VARCHAR(200),
IN p_longitude FLOAT(10,6),
IN p_latitude FLOAT(10,6),
IN altitude VARCHAR(45),
IN heading DOUBLE,
IN speed DOUBLE,
IN altitude_accuracy VARCHAR(45),
IN location_accuracy VARCHAR(45),
IN time_stamp DATETIME
)
BEGIN

SET @g = 'POINT(lati longi)';

INSERT INTO tbl_userlocation (userid,
session_token,
longitude,
latitude,
location,
altitude,
heading,
speed,
altitude_accuracy,
location_accuracy,
time_stamp) VALUES(
userid,
session_token,
p_longitude,
p_latitude,
GEOMFROMTEXT('POINT(p_latitude p_longitude)'),
altitude,
heading,
speed,
altitude_accuracy,
location_accuracy,...

Sign in or Register to see more

Job ID: 33850991
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Argentina  |  
Winner
Computer engineer with more than 10 years of work experience. * Highly skilled with SQL, and I have worked using Microsoft SQL Server and MySQL...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33852486  |  Submitted: Sep 26, 2012 10:45 ET 
Delivery
Within 1 day
$20.00

 China  |  
INVITED
I am an IT consultant with more than 10 years experience on global IT infrastructure implementation and management. I have worked for several...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33851512  |  Submitted: Sep 26, 2012 10:07 ET 
Proposal SEALED

Matech      
One or more team members at  are verified.  Learn More
 Pakistan  |  
INVITED
Financial Platform , Equity , Forex , Commodities, MVC, ASP.net , Magento Enterprise, SQL Server , Oracle , Business Intelligence Experts,
3
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 33851254  |  Submitted: Sep 26, 2012 09:57 ET 
Proposal SEALED

 India
INVITED
Having 15 yrs experience as professional and have the capability to take full responsibility on my shoulder for any project work.Try to maintain...
5
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33851151  |  Submitted: Sep 26, 2012 09:53 ET 
Proposal SEALED

 India  |  
INVITED
I have a good team with developer, designer and seo. So I really bound on you to give best quality of work, we have use latest technologies on any...
6
  |  
 4.5   |  Private   |  19 Jobs
Bid ID: 33851150  |  Submitted: Sep 26, 2012 09:53 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »