375 reputation
210
bio website reynierpm.com
location Caracas, Venezuela
age 30
visits member for 2 years, 4 months
seen Aug 20 at 16:51

Aug
20
accepted Need some help with this query or some ideas for change it to better model
Aug
20
asked Need some help with this query or some ideas for change it to better model
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