This is my query:
UPDATE methane
.planning
SET mz
=1 WHERE import_date
=‘5/10/2011 12:00:00 AM’ AND lng
=‘-118.291’ AND lat
=‘34.0618’;
import_date is a VARCAHR(1024);
mz is a BOOLEAN
lat & lng are FLOAT
If I go into MySQL Workbench and find that record it looks like this:
‘248’, ‘05/05/2011’, ‘ZA-2011-1137-ZV-ZAA-SPR’, ‘3150 W WILSHIRE BLVD 90010’, ‘10’, ‘Wilshire’, ‘CONTRUCTION OF A NEW MIX USED PROJECT INCLUDING 2 HIGH RISE TOWERS WITH GROUND FLOOR RETAIL PUBLIC 11860 OPEN SPACE AND 913 PARKING SPACES 464 APARTMENT UNITS 41000 SQ. FT. RETAIL SPACE.’, ‘ZV-ZONE VARIANCE ZAA-AREAHEIGHTYARDAND BUILDING LINE ADJMNTS < 20% (SLIGHT MODIFICATIONS) SPR-SITE PLAN REVIEW’, ‘KACY KEYS (323)857-5546’, ‘5/10/2011 12:00:00 AM’, ‘34.0618’, ‘-118.291’, NULL
THIS UPDATE WILL NOT UPDATE ANYTHING AT ALL. IT DOES NOT SET MZ TO 1 AND IT IS DRIVING ME MAD!!! PLEASE HELP!!!