Suljettu

Looking for SQL Statement

Hello All,

I need a sql statement, which select all user profile from a table within a Database where a certain condition is matched. When that condition is matched we add 2 new parameters to the user profile and set each value to “1”. The primary key of a profile is “UserID”.

In other words, a user will be added 2 parameters with value “1” each.

Here the explanation in pseudo code:

SELECT * FROM `table` WHERE `meta_key`="user_transactions_counter" and `meta_value`!=0

FOREACH (user_id) {

CHECK

IF ("bitstamp_account_activated" does not exist OR == NULL) {

THEN INSERT COLUMN (user_id, umeta_id, bitstamp_account_activated)

SET "umeta_id"++

SET "bitstamp_account_activated" = 1}

ELSE

DO NOTHING

THEN

CHECK

IF ("bitstamp_Account_verified" does not exist OR == NULL) {

THEN INSERT COLUMN (user_id, umeta_id, bitstamp_Account_verified)

SET "umeta_id"++

SET "bitstamp_Account_verified" = 1}

ELSE

DO NOTHING

}

Cheers

Taidot: SQL, MySQL, Relational Databases

Näytä lisää: need sql statement oracle show number decimal places, sql server 2005 active primary connection, sql duplicate entry key primary, hello i need a logo for my site details in private, hello i need urgent typist you just have to write in notepad from image i, hello our webapp specializing in tendering automobileservices needs some facelifting, i am looking for a bookkeeper to trial balance in johannesburg, i am looking to hire a computer hardware engineers in nyc, im looking for a sales and marketing specialist in travel, looking at someone to market our business in the fitness industry, looking for a business grant proposal writer in silver spring maryland, looking for a computer programmer will compensate in credit nyc put an add up, looking for a layout designer retail shop in kuala lumpur, looking for a part time marketing person in the dallas ft worth area, looking for a typist or word processor in oakland county mi, looking for freelance german interpreter currently residing in singapore, looking for freelance japanese to english interpreter in singapore, looking for freelances that do autocad drawings in cape town, looking for html5 javascript c developers based in munich, i need sql database help opencart

Tietoa työnantajasta:
( 56 arvostelua ) Darmstadt, Germany

Projektin tunnus: #26470449

31 freelanceria on tarjonnut keskimäärin 24$ tähän työhön

tutulsoft

-- I can solve your issue easily and perfectly ... you can communicate ---thank you ---------------------------------

$30 USD 1 päivässä
(17 arvostelua)
5.1
freelancepraful

I can create sql query and create in lowest cost ever, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated agai Lisää

$20 USD 7 päivässä
(1 arvostelu)
4.2
TEKSCENT

hi I have around 10 years of professional experience in sql development and worked in more than 200 database project'[login to view URL] discuss your requirement

$40 USD 1 päivässä
(7 arvostelua)
3.8
achrafchiboub

Hello, I m a developer I have 4 years of experience. I alreay did similar projects. Ping me for more details..............................

$20 USD 1 päivässä
(8 arvostelua)
3.7
aap31374

I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way. I Lisää

$56 USD 1 päivässä
(5 arvostelua)
3.3
kietlt10988

Dear employer, Your requirement is not a big deal to me. I can complete it within an hour for sure! I am expert in sql. I have done many projects like this and all my customer happy with the result. Please refer to th Lisää

$30 USD 1 päivässä
(5 arvostelua)
2.9
DBhut

Hello Sir, Iam a database architect with many years of experience. I understand your requirement. I will write a 100% neat code. Please ping me in chat we dn discuss and take it fwd. Thanks

$16 USD 1 päivässä
(4 arvostelua)
2.9
NoSonforhim

Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C#, and MS SQL server I will Lisää

$20 USD 7 päivässä
(3 arvostelua)
2.3
stepanbohanov

Hi, sir! i checked your requirement and saw the screenshot. I am an experienced Laravel/React developer with the skills necessary to do this. You can handle the project as you like. You can start immediately. I will g Lisää

$20 USD 1 päivässä
(3 arvostelua)
2.2
ShafirR

Hi, In my current Professional Database Administrator role, I have extensive experience with Creating Procedures, Queries ,Indexes, Views. as well as Administration of on SQL Server versions 2000-2019, MySQL, SQLIte I Lisää

$30 USD 1 päivässä
(3 arvostelua)
1.8
masadmajid

I am professional web developer. I have created many sites. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lisää

$20 USD 1 päivässä
(1 arvostelu)
1.2
shreerupaghatak

Hello, I have a total IT experience of more than 3.5 years working with databases in Multi national companies. I will be able to provide you quality service in a short amount of time working very effeciently. Looking f Lisää

$15 USD 1 päivässä
(0 arvostelua)
0.0
bg1201

Hello, Thank you for the pseudo code. Would you mind giving a chance to a hands on data professional who is new to this platform? I have quite good experience in SQL as well as database coding, worked for many companie Lisää

$25 USD 2 päivässä
(0 arvostelua)
0.0
ChandrimaAtWork

I am working with a big client to write several SQL queries , so it seems it would be easier for me to take up this work.

$50 USD 7 päivässä
(0 arvostelua)
0.0
malathyrajkumar

I am interested to work on SQL database development and queries ,. please share the detail statement

$25 USD 1 päivässä
(0 arvostelua)
0.0
shanaveeth

hi I have understood your requirement and I assure that I can complete that work in few hours. You can hire me as I have * 4 years of experience in sql * Expert in writing complex queries * Expert in writing pro Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
hboukhezra

Hello,I hope you’re doing fine! I have read your project requirement and I believe that am the perfect fit for the job I am an expert in databases and sql i can guarantee you a good work that will be delivered on time Lisää

$20 USD 2 päivässä
(0 arvostelua)
0.0
(0 arvostelua)
0.0
Jayant222

Hi there, I am an expert in SQL. I have gone through the description on your project and will be able to finish before the deadline. Thanks Jayant

$20 USD 2 päivässä
(1 arvostelu)
0.0
sun2meg

Sir, I am a certified ORACLE database administrator which in-depth hands-on experience. I would appreciate if I'm offered this job. Thanks as I look forward to a positive response.

$25 USD 5 päivässä
(0 arvostelua)
0.0