Closed

Simple MySQL Query - Write me the solution | QUICK CASH

chatRooms

---------

chatRoomId bigint

UUID varchar(36)

type varchar(25)

niceName varchar(25)

chatRoomParticipants

--------------------

chatRoomId bigint

userId bigint

My app integrates private chat messaging. Whenever an user (userId) wants to send a private message to another user, I have to perform a query to find the chatRoom of type "PRIVATE_CHAT_ROOM" of which both and ONLY TWO of the users are participants - and if the chatRoom does not exist, it needs to be created.

So let's assume userId 83 wants to send a message to userId 84, I need to extract the chatRoomId 213 of type PRIVATE_CHAT_ROOM:

chatRooms

---------------------------------------------

chatRoomId 213

UUID 923ifds-1239u1d-3128ufdk-21asd

type "PRIVATE_CHAT_ROOM"

niceName Private chat with %s

---------------------------------------------

chatRoomParticipants

---------------------------------------------

chatRoomId 213

type 'PRIVATE_CHAT_ROOM'

userId 83

---------------------------------------------

---------------------------------------------

chatRoomId 213

type 'PRIVATE_CHAT_ROOM'

userId 84

---------------------------------------------

Don't forget that userId 83 and userId 84 MIGHT both be participants in other PUBLIC chatRooms, or be engaged in other private chat rooms. There will never be a case where two users would belong to two different chatRooms of type PRIVATE

Skills: MySQL

See more: simple mysql import, simple mysql php show data dropdown, simple mysql php rss feed, simple mysql, simple mysql gallery, java mysql read write, simple mysql rating script, ajax simple mysql, simple mysql database, simple mysql search, simple mysql updater, simple mysql checkbox, mysql php real estate quick search, script run mysql query write results csv file, simple mysql query view script, simple mysql query, lost connection mysql server query php solution, simple mysql query tool

About the Employer:
( 7 reviews ) Piazza Armerina, Italy

Project ID: #27449649

24 freelancers are bidding on average $25 for this job

sumon355

Hello, As an expert in SQL, i can write the required query to find the private chat room if available for those users. Looking forward to have a positive response from you. Thanks

$29 USD in 1 day
(50 Reviews)
6.2
imTuyen

Hello Sir. I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. More

$30 USD in 1 day
(22 Reviews)
5.2
(17 Reviews)
4.7
dnplugins

I can create a single query to extract the chatroom ID of which only both are the participants at the same time the type will be "PRIVATE_CHAT_ROOM", the query would not create the chatroom though that should be a sepa More

$25 USD in 1 day
(24 Reviews)
4.1
rrgamit

Hello, I have checked your project requirement and understood project needs. I read your project description and understand about work that needs to Planer App. I have similar kind of work experience in your project , More

$20 USD in 1 day
(24 Reviews)
4.0
BizzCreator

sir, I read all description I can understood your project,it would be great if we have further communication on this project for better understanding. please sir, come into chat I am a Full Stack Web apps dev with ext More

$20 USD in 3 days
(2 Reviews)
3.3
NovaSofts

Hello Sir/ Ma’am We are a group of Software Engineers (Programmers) having 10+ years of experience. Expert in JAVA, C, C++ , C# , Python, MATLAB. Done 700+ projects here on FREELANCER.COM. The bid is negotiable an More

$20 USD in 1 day
(2 Reviews)
3.9
wanqing525

****Database and database converting program developer**** Hi, there. I am a creative and professional Database and database convert application developer having more than 5+ years of professional experience as a senio More

$40 USD in 1 day
(4 Reviews)
3.6
SqlDevelopment

I can develop a needed sql scripts to implement a private chatting messages. I am Senior SQL Developer with 10+ years experience and can handle a sql tasks of any complexity.

$35 USD in 1 day
(8 Reviews)
3.3
mabmojo

Hi client, I am very interested in this project. I have a lot of experience in Mysql Query for over 10 years. If you have any questions or concerns don't hesitate to let me know. I hope to hear from you. Best regar More

$30 USD in 1 day
(3 Reviews)
2.3
bobrovpavelwork

@@@ Fast-Speed &&& High-Quality @@@ Hello, How are you? Here is a MySQL expert. I have 5+ years of rich experience in Web Development using these skills. So I'm very confident in your project. If you hire me, you'll ge More

$30 USD in 1 day
(1 Review)
2.4
hareshchauhan566

Hi There. i am expert in mysql i can make you query asap. I am a full stack web Developer & Designer. My Skill in PHP, Laravel, CodeIgniter, Ajax, Jquery, CSS3, Bootstrap, MySQL, HTML5, wordpress, web hosting. I have 3 More

$15 USD in 1 day
(3 Reviews)
2.0
valerykrapiv

hello, I can help you very well. This is very easy for me. I'll provide you good result in 1~2 hour. please let me know Regards. Valery.

$25 USD in 1 day
(3 Reviews)
3.7
touseefawan1819

*** Available to start NOW *** Hello I am ready to BUILD YOUR QUERY. MESSAGE ME to discuss more, so that we start right now. I am a senior software Engineer and i have 4 years experience in this Field. Moreover, More

$15 USD in 1 day
(1 Review)
0.3
mdgolamrabbani00

Hello, I'm expert and 5+ year working experience about MySQL. I can solve your problem right now. I wait for your response. Thank you

$20 USD in 1 day
(0 Reviews)
0.0
KashifZaman

Dear Sir, hope you are doing well! My name is Kashif Zaman, I am an experienced full stack developer, having 12 years of experience in Web Design and Development and extensive work in Object-oriented Design and Develo More

$20 USD in 7 days
(0 Reviews)
0.0
JadSamadi

Hey there, Your proposal has caught my attention, I have 4+ years of professional web development experience, Portfolio: Software Engineering course - Designed and Implemented A University Management System. - Designe More

$30 USD in 1 day
(0 Reviews)
0.0
sergeymalih

-query1 select * from chatRooms where chatRoomId = '213' and type = "PRIVATE_CHAT_ROOM" if the query1 returns 0 result, do query2 -query2 INSERT INTO chatRooms VALUES (213, '923ifds-1239u1d-3128ufdk-21asd ', 'PRIVATE_C More

$20 USD in 1 day
(1 Review)
0.0
serhiihashenko

Hello. I offer high-quality and affordable web development and design services, providing customized solutions that best fit your business's unique needs. Having over 8 years of experience in the software industry, I h More

$20 USD in 1 day
(0 Reviews)
0.0
shahkishan20

Hi I hace read your description and I can write you the mysql query easily. Do connect with me for more details.

$15 USD in 1 day
(0 Reviews)
0.0