Đã Đóng

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

Kĩ năng: SQL, MySQL, Relational Databases

Xem nhiều hơn: 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

Về Bên Thuê:
( 56 nhận xét ) Darmstadt, Germany

ID dự án: #26470449

31 freelancer đang chào giá trung bình $24 cho công việc này

tutulsoft

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

$30 USD trong 1 ngày
(17 Nhận xét)
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 Thêm

$20 USD trong 7 ngày
(1 Nhận xét)
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 trong 1 ngày
(7 Nhận xét)
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 trong 1 ngày
(8 Nhận xét)
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 Thêm

$56 USD trong 1 ngày
(5 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(5 Nhận xét)
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 trong 1 ngày
(4 Nhận xét)
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 Thêm

$20 USD trong 7 ngày
(3 Nhận xét)
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 Thêm

$20 USD trong 1 ngày
(3 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(3 Nhận xét)
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] Thêm

$20 USD trong 1 ngày
(1 Nhận xét)
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 Thêm

$15 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$25 USD trong 2 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0
malathyrajkumar

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

$25 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$20 USD trong 2 ngày
(0 Nhận xét)
0.0
(0 Nhận xét)
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 trong 2 ngày
(1 Nhận xét)
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 trong 5 ngày
(0 Nhận xét)
0.0