lind@psi0 : ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 145
Server version: 5.0.38-Ubuntu_0ubuntu1.1-log Ubuntu 7.04 distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use psi
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> use psi;
Database changed
mysql> select * from comments;
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
| id | wiki_key | user_id | timestamp | comment | edited_timestamp |
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
| 43 | sandkasse | 9 | 1178981368 | Flere kommentarer... nu med \'\'\'wikisyntaks\'\'\', nemlig ja... ~psikiwiki~ | 1179583642 |
| 52 | Indsaet_Kommentarer_i_Artikler | 9 | 1179165885 | Jeg synes kommentarbokse er svedige :)... Og s� kan man ogs� bruge wiki-syntaks...
Det \'\'sk�ve t�rn i Pisa\'\' er \'\'\'fedt\'\'\'...!?!?
Ligesom man kan benytte LaTeX [tex]$\\Psi r q l$[/tex]... | 1179165902 |
| 54 | psikiwiki/indsaet_kommentarer_i_artikler | 9 | 1192618055 | Oh�j... dette er en kommentar | 0 |
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
3 rows in set (0.01 sec)
mysql> delete from comments where id=52
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from comments;
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
| id | wiki_key | user_id | timestamp | comment | edited_timestamp |
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
| 43 | sandkasse | 9 | 1178981368 | Flere kommentarer... nu med \'\'\'wikisyntaks\'\'\', nemlig ja... ~psikiwiki~ | 1179583642 |
| 52 | Indsaet_Kommentarer_i_Artikler | 9 | 1179165885 | Jeg synes kommentarbokse er svedige :)... Og s� kan man ogs� bruge wiki-syntaks...
Det \'\'sk�ve t�rn i Pisa\'\' er \'\'\'fedt\'\'\'...!?!?
Ligesom man kan benytte LaTeX [tex]$\\Psi r q l$[/tex]... | 1179165902 |
| 54 | psikiwiki/indsaet_kommentarer_i_artikler | 9 | 1192618055 | Oh�j... dette er en kommentar | 0 |
+----+------------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+
3 rows in set (0.00 sec)
mysql>