mysql> use akonadi 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> show tables; +----------------------------------+ | Tables_in_akonadi | +----------------------------------+ | collectionattributetable | | collectionmimetyperelation | | collectionpimitemrelation | | collectiontable | | flagtable | | mimetypetable | | parttable | | parttypetable | | pimitemflagrelation | | pimitemtable | | pimitemtagrelation | | resourcetable | | schemaversiontable | | tagattributetable | | tagremoteidresourcerelationtable | | tagtable | +----------------------------------+ 16 rows in set (0.00 sec)
mysql> DELETE FROM parttable WHERE name = 'GID'; ERROR 1054 (42S22): Unknown column 'name' in 'where clause' mysql> desc part partTypeId parttable.data parttable.external parttable.partTypeId parttable.version parttypetable.id parttypetable.ns parttable parttable.datasize parttable.id parttable.pimItemId parttypetable parttypetable.name mysql> desc parttable; +------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+----------------+ | id | bigint(20) | NO | PRI | NULL | auto_increment | | pimItemId | bigint(20) | NO | MUL | NULL | | | partTypeId | bigint(20) | NO | MUL | NULL | | | data | longblob | YES | | NULL | | | datasize | bigint(20) | NO | | NULL | | | version | int(11) | YES | | 0 | | | external | tinyint(1) | YES | | 0 | | +------------+------------+------+-----+---------+----------------+ 7 rows in set (0.00 sec)
mysql> select * from partable; ERROR 1146 (42S02): Table 'akonadi.partable' doesn't exist mysql> Bye
Yeah, I'm at the limit on this one.
mysql> use akonadi
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 ------- ------- ------- ------- + ------- ------- ------- ------- + butetable | yperelation | emrelation | urcerelationtab le | ------- ------- ------- ------- +
mysql> show tables;
+------
| Tables_in_akonadi |
+------
| collectionattri
| collectionmimet
| collectionpimit
| collectiontable |
| flagtable |
| mimetypetable |
| parttable |
| parttypetable |
| pimitemflagrelation |
| pimitemtable |
| pimitemtagrelation |
| resourcetable |
| schemaversiontable |
| tagattributetable |
| tagremoteidreso
| tagtable |
+------
16 rows in set (0.00 sec)
mysql> DELETE FROM parttable WHERE name = 'GID'; partTypeId parttable.version parttypetable.id parttypetable.ns ------+ ------- -----+- -----+- ----+-- ------- +------ ------- ---+ ------+ ------- -----+- -----+- ----+-- ------- +------ ------- ---+ ------+ ------- -----+- -----+- ----+-- ------- +------ ------- ---+
ERROR 1054 (42S22): Unknown column 'name' in 'where clause'
mysql> desc part
partTypeId parttable.data parttable.external parttable.
parttable parttable.datasize parttable.id parttable.pimItemId parttypetable parttypetable.name
mysql> desc parttable;
+------
| Field | Type | Null | Key | Default | Extra |
+------
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| pimItemId | bigint(20) | NO | MUL | NULL | |
| partTypeId | bigint(20) | NO | MUL | NULL | |
| data | longblob | YES | | NULL | |
| datasize | bigint(20) | NO | | NULL | |
| version | int(11) | YES | | 0 | |
| external | tinyint(1) | YES | | 0 | |
+------
7 rows in set (0.00 sec)
mysql> select * from partable;
ERROR 1146 (42S02): Table 'akonadi.partable' doesn't exist
mysql> Bye
Yeah, I'm at the limit on this one.