ERROR 1114: The table 'SQLb07dc_0' is full
Hi, I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full I can execute other queries without problems but when I want to execute the query : SELECT DISTINCT person.* FROM person, training, cursus where training.BRANCH_ID=101 and training.CURSUS_SID=cursus.CURSUS_SID and cursus.STUDENT_SID=person.PERSON_SID; there is always the same error message. How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ? Regards
table history or tracabitity
Hi all ! I have a problem : I have a table "my_table". desc my_table : FieldType NullKeyDefaultExtra mytable_sidint(11) auto_increment value double (6.2) this is the table sturcture 2 weeks ago Today the table structure is this one : FieldType NullKeyDefaultExtra mytable_sidint(11) auto_increment value int(11) I would like to know when the fields value has been changed and by wich user ? Does it exist a trace or an history of the tables in mysql database ? If yes, how do do it ? regards jv