368 reputation
210
bio website reynierpm.com
location Caracas, Venezuela
age 30
visits member for 2 years, 3 months
seen yesterday

Jul
24
comment Get tp.address_from and tp.address_to from travel_point table
@jynus can you take a look at my edition? I tried with LEFT OUTER JOIN but editor remove any time I save the view don't know why
Jul
24
revised Get tp.address_from and tp.address_to from travel_point table
deleted 51 characters in body; edited tags; edited title
Jul
21
asked Get tp.address_from and tp.address_to from travel_point table
Jul
4
accepted Understanding how relationship sides works
Jul
4
asked Understanding how relationship sides works
Jul
2
awarded  Curious
Jul
2
accepted Get devices with not driver assigned
Jul
2
asked Get devices with not driver assigned
Mar
19
accepted Generate INSERT statement from SELECT query
Mar
19
comment Generate INSERT statement from SELECT query
I modified a bit the query and now looks like INSERT INTO courrier_city (country, state, created, modified) SELECT "VE", IF(id_estado<10, CONCAT("VE.0", id_estado),CONCAT("VE.", id_estado)), NOW(), NOW() FROM zoom_city but I get this error any time I try to run it [Err] 1062 - Duplicate entry 'VE-VE.01-' for key 'PRIMARY' why is that?
Mar
18
asked Generate INSERT statement from SELECT query
Feb
27
comment Error 1005: Can't create table can't find where the problem is
@ypercube add the CHARACTER SET and COLLATE in all tables fix the problem, thanks all of yours
Feb
27
accepted Error 1005: Can't create table can't find where the problem is
Feb
27
revised Error 1005: Can't create table can't find where the problem is
added 1065 characters in body
Feb
27
asked Error 1005: Can't create table can't find where the problem is
Feb
27
comment Execute SQL query after execute TRUNCATE in a table
@Up_One I want to run first TRUNCATE and after the SQL sentence
Feb
27
asked Execute SQL query after execute TRUNCATE in a table
Apr
24
awarded  Notable Question
Apr
17
awarded  Yearling
Mar
21
comment Database and query optimizacion
You're right I accept the answer and made modifications later to suit what I need