Hello,
I have problem with my update query.NO error & not updating. Here is my code plz tell me whr i went wrong.
Here is the query
UPDATE `hotel_facility` SET `has_valet_parking` = ‘N’,`has_continental_breakfast` = ‘N’,`has_in_room_movies` = ‘N’,`has_sauna` = ‘N’,`has_whirlpool` = ‘N’,`has_voice_mail` = ‘N’,`has_24hour_security` = ‘N’,`has_parking_garage` = ‘N’,`has_electronic_roomkeys` = ‘N’,`has_coffee_tea_maker` = ‘N’,`has_safe` = ‘N’,`has_video_checkout` = ‘N’,`has_restricted_access` = ‘N’,`has_interior_room_entran (more…)
You can use \G instead of ; for tables with lots of fields.
mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)
This small script will animate a series of blocks of HTML, scrolling them up, down, left or right dynamically and then pausing before starting the next scroll. The script will also pause on mouseover, and resume scrolling on mouseout. Since it scrolls HTML instead of just images, you can include just about anything that can be ordinarily placed in a static HTML document: links, images, graphics, tables, backgrounds, etc. (more…)
Retina.net is an O/R Mapper for the .NET Framework that appears to be active once again on CodePlex.
(more…)
If you are interested in Castle ActiveRecord, The NHibernate FAQ has a new tutorial on getting started with Castle ActiveRecord.
(more…)
