Skip to main content

Delete duplicute entry in a table

DELETE t1 FROM mdl t1, mdl t2 WHERE t1.userid=t2.userid AND t1.fieldid=t2.fieldid AND t1.id < t2.id

Comments

Post a Comment

Popular posts from this blog

Reading Large JSON file through PHP Script

 <?php /* cat mexico.geojson | wc sed ':a;N;$!ba;s/\n/ /g' mexico.geojson  > mexico.geojson_out1 cat mexico.geojson_out1 | wc http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out1 sed -E 's/\{ "type": "FeatureCollection", "name": "mexico_administrative_osm_province_boundaries", "crs": \{ "type": "name", "properties": \{ "name": "urn:ogc:def:crs:OGC:1.3:CRS84" \} \}, "features": \[//g' ./mexico.geojson_out1  > mexico.geojson_out2 http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out2 sed -E 's/(\[|\{|\}|\])/ \1 /g' ./mexico.geojson_out2 > ./output/mexico.geojson_output http://localhost/Utility/cord/largefile.php?filename=output/mexico.geojson_output */ ini_set('max_execution_time', '500'); //300 seconds = 5 minutes ini_set('memory_limit', '1G');   //ini_set('max_execution...
Post a Comment
Read more

Run zenity or any other GUI based program through cron.

 a shell script file like and following code and then add shell script in cron. Cron Entry * * * * * /var/www/html/runcron.sh Shell Script #!/bin/bash touch /var/www/html/tfile dbus_session_file=/home/suntec/.dbus/session-bus/$(cat /var/lib/dbus/machine-id)-0 if [ -e "$dbus_session_file" ]; then   . "$dbus_session_file"   export DBUS_SESSION_BUS_ADDRESS DBUS_SESSION_BUS_PID   dbus-send … fi zenity --error --text='Fill Time sheet' --display=:0.0
Post a Comment
Read more