Como posso apagar o que está dentro deste SELECT?

blogers · 16/03/2016

Mostrando filas 0 - 29 (total de 90652, La consulta tardó 0.1043 seg)

Alguien que me heche la manita

PHP:

SELECT node_revision.nid, node_revision.vid, node_revision.uid, node_revision.title, node_revision.log, node_revision.timestamp, node_revision.status, node_revision.comment, node_revision.promote, node_revision.sticky, node_revision.vuuid FROM 
node_revision AS node_revision
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid
LEFT JOIN node_revision AS node_node_revision__node_revision ON node_node_revision.vid = node_node_revision__node_revision.vid
WHERE (( (node_node_revision__node_revision.title IS NULL ) ))

Vittey · 16/03/2016

Seria algo asi
DELETE campos
From tabla
y demas sentencias.

blogers · 16/03/2016

Es que es un JOIN lo ando compactando asi

PHP:

SELECT node_revision.nid, node_revision.vid, node_revision.uid, node_revision.title, node_revision.log, node_revision.timestamp, node_revision.status, node_revision.comment, node_revision.promote, node_revision.sticky, node_revision.vuuid FROM 
node_revision AS node_revision
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Vittey disse:
Seria algo asi
DELETE campos
From tabla
y demas sentencias.

Vittey · 16/03/2016

blogers disse:

Es que es un JOIN lo ando compactando asi

PHP:

SELECT node_revision.nid, node_revision.vid, node_revision.uid, node_revision.title, node_revision.log, node_revision.timestamp, node_revision.status, node_revision.comment, node_revision.promote, node_revision.sticky, node_revision.vuuid FROM 
node_revision AS node_revision
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Lo has intentado al menos ?
puedes intentar usando una subconsulta.

blogers · 16/03/2016

PHP:

SELECT *
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Mas compactado

estoy tratando con esto

PHP:

DELETE  FROM node_revision   JOIN (SELECT *
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) )) 

);

Me sale error

Vittey disse:
Lo has intentado al menos ?
puedes intentar usando una subconsulta.

Vittey · 16/03/2016

blogers disse:
PHP:

SELECT * );

Me sale error

veo que andas mal con la sub consulta.
Intenta, primero, eliminar sin join.
O hacer una subconsulta, sin usar join, y eliminar
paso seguido, intenta con join, por ahi tienes el problema.

blogers · 16/03/2016

listo asi de simple checa

PHP:

DELETE  node_revision
 FROM 
node_revision 
LEFT JOIN node AS node_node_revision ON node_revision.vid = node_node_revision.vid

WHERE (( (node_node_revision.title IS NULL ) ))

Vittey disse:
veo que andas mal con la sub consulta.
Intenta, primero, eliminar sin join.
O hacer una subconsulta, sin usar join, y eliminar
paso seguido, intenta con join, por ahi tienes el problema.

Vittey · 16/03/2016

bien ahi.
Claro, x lo que veo has eliminado tabla completa? no?

paninigol · 16/03/2016

tienes que adaptar esta sentencia

DELETE FROM table_name WHERE some_column = some_value

espero te sirva, un saludo!

Como posso apagar o que está dentro deste SELECT?

blogers

Vittey

blogers

Vittey

blogers

Vittey

blogers

Vittey

paninigol

Tópicos similares