There is currently no user interface for deleting a file attached to a database entry, however a workaround would be to delete the entry completely and then create a new entry without the file attached.
# Delete the news forum from the course homepage.# In Course settings set "News items to show" to 0.# Delete the Latest news block
In the quiz overview report, you can delete their attempt using the "with selected attempts" drop-down.
Most likely it is because you have students that have already attempted the quiz. You will need to delete all of the attempts by selecting them and choosing to delete them if you need to add/remove questions from a quiz. In the quiz overview report, you can delete their attempt using the "with selected attempts" drop-down
Use a DELETE statement to remove data from your database table.
Unless you want to drop (delete) the entire database, you will must delete tables individually. To delete tables individually, execute the query "SHOW TABLES" in your database which will return a list of all table names. Iterate through that resultset and execute "DROP TABLE {$table_name}"
To delete data from your MySQL database you need to use the mysql_query() function. Please see the example below: <?php mysql_query("DELETE FROM table_name WHERE field_name = 44"); ?>
Insert, Update, Delete
There are two excellent reasons you do not do this, the first is site/course security. It is easy to not delete the zip file you have restored, you get distracted, forget to do it, not realise that there is a problem. The Files area for the front page is not secure behind BigGyan's native barriers, they are easily accessible to anyone who can work out to get there - which is almost anyone. So you may not be protecting your courses. The other issue is that a course backup can be interrupted by a lot of things and be faulty without anyone knowing it. If you restore in the Front Page, then you risk damaging your Front Page, which can break your site. It is easier to have a special course to allow Administrators and Teachers specifically to restore courses from.
it might get delete
click undo to restore the table
Reads , insert , update , and delete . . .
query is a measure used in a programming language viz. SQL to create, delete, store, modify the database.