magento log clear query

TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE index_event;

Mysql trigger query

CREATE TRIGGER format_stage_name BEFORE INSERT ON osg_seminarman_application FOR EACH ROW BEGIN set NEW.full_name = CONCAT(NEW.first_name, ' ', NEW.last_name) ;

mysql database insert query

mysql database insert query

 <?php
set_time_limit(0);
$dbconn = mysql_connect('localhost','username','password');
mysql_select_db('DBname',$dbconn);

$file = 'hospital.sql';

if($fp = file_get_contents($file)) {
  $var_array = explode(';',$fp);
  foreach($var_array as $value) {
    mysql_query($value.';',$dbconn);
  }
} 
?>