Using !important rules can be a dangerous way to style your webpage that usually means you are forcefully doing this, but they exist for some reason. The paragraph will be colored red, even there is a ID selector that has higher priority. So, the this rule overrides all the particular property. An !important rule works […]
This below content gives you an idea how to make cross-browser compatible rounded corners with CSS. Example of Rounded Corners: <!DOCTYPE html> <html> <head> <style> .roundCorner{ background: #C2C2C2; border-radius: 25px; border: 3px solid #C2C2C2; padding: 15px; width: 150px; height: 150px; } </style> </head> <body> <div class=”roundCorner”>Rounded corner div!</div> </body> </html>
Here you will learn how to manage triggers like modifying, removing etc. To display the trigger use following sql: SELECT * FROM Information_Schema.Triggers WHERE Trigger_schema = ‘database_name’ AND Trigger_name = ‘trigger_name’; To view trigger: SHOW TRIGGERS; To drop a trigger: DROP TRIGGER tbl_name.trigger_name
In MySQL you can add an event to a database that runs in a interval to automate database tasks. You can wait for intervals and check the table to see the changes. By default, the event scheduler thread is not enabled in the database. You need to enable this: SET GLOBAL event_scheduler = ON; Or […]
Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement. Let’s see an example of Create Trigger: For example we have two tables i.e. users and userhistory. users: userID firstName lastName userhistory: userID last_update Read Also: INSERT … ON DUPLICATE KEY UPDATE Now we will […]
MySQL triggers are nothing but a SQL statement stored in the database. When any event associate with a table is fired i.e. insert, update or delete a trigger is executed. TRUNCATE statement delete the all data in a table but does not execute the triggers associated with this. The different between trigger and stored procedure […]
Using jQuery you can search and highlight text within a div from array of elements and wrap a highlight span around each word. Example to search and highlight text: <script type=”text/javascript”> var regex = /(Rubbish|Like|Rough|Raw|Doggie|Billy)/ig; $(‘#divID’).each(function() { var $this = $(this); var text = $this.text(); if (regex.test(text)) { $this.html( $this.html().replace(regex, ‘<span>$1</span>’) ); } }); </script>
Using MySQL you can COMMIT a statement and ROLLBACK to manage transaction. While adding a data into two or more tables where one primary key for one table is the foreign key of another table it may happen sometimes that after adding data into first table MySQL failed to add data into second table due […]
Using MySQL Table Locking you can lock a table explicitly for preventing other sessions for a interval. Releasing a table lock can be granted for a client session only but not for other sessions. Here is a simple format for Table Locking: LOCK TABLE tbl [READ | WRITE] LOCK TABLE tbl READ To release a lock […]
Using ‘replace’ you can find and replace text of a column in a table. Example of Replace text: UPDATE `tbl` SET `field_name` = replace(field_name, ‘old_text’, ‘new_text’);