Write 2 MySQL queries

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

Hello,

I need help to build two MySQL queries

The first one:

I have a table like that:

1 entity_type varchar(128)

2 bundle varchar(128)

3 deleted tinyint(4)

4 entity_id int(10)

5 revision_id int(10)

Entity_id have several duplicates, I want to keep only one, the one with the biggest revision_id

The second one:

I have 4 tables, each table with a foreign key:

Table 1 and Table 2 share a key

Table 2 and Table 3 share another key

Table 3 and Table 4 share another key

I want to merge all this table into one

Thank you for your interest

MySQL

Nº del proyecto: #15334347

Sobre el proyecto

13 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

sunnysmile911

Hi. Dear. Here is the MySQL expert. If you hire me, you can get the result within 30 mins. Please contact me. Thanks XingJun.H Relevant Skills and Experience MySQL Proposed Milestones $20 USD - Let's discuss later

$20 USD en 1 día
(9 comentarios)
5.8

13 freelancers están ofertando un promedio de $22 por este trabajo

hoangvandungbk

hello, i can help you create 2 query same you require, please contact with me to start, i will complete for you very fast. kind regards Relevant Skills and Experience mysql Proposed Milestones $20 USD - total

$20 USD en 1 día
(155 comentarios)
6.6
jayprakashyadav

I have read the job description and I will join all the tables Relevant Skills and Experience Mysql,PHP Proposed Milestones $35 USD - mysql query

$35 USD en 1 día
(8 comentarios)
5.5
stivens

Hello, I can help you get this queries for you. I have more than 7 years of experience working with MSYQL,. Please let's chat to get more details about the project. Thank you. I am available right now Stay tuned, I'm Más

$20 USD en 1 día
(19 comentarios)
5.1
ihshsl

. Relevant Skills and Experience . Proposed Milestones $15 USD - . .

$15 USD en 1 día
(8 comentarios)
3.9
chali5

Hello Sir! i have read your description, i can create two which will first one drops your entity id's with low revision_id and second one will merge all your 4 tables. Contact me for quality work. Relevant Skills and Más

$30 USD en 1 día
(2 comentarios)
1.5
renjith007

Hi there, If you give to me it will finish with in 10min

$10 USD en 1 día
(2 comentarios)
1.1
jorgeiwano

A proposal has not yet been provided

$30 USD en 7 días
(0 comentarios)
0.0