Opened by Froschpopo at 2008-08-07 23:56
User since
2005-01-17
14788 Artikel
Admin1
![[Homepage]](/battie/theme/default/homepage.gif)
2005-01-17
14788 Artikel
Admin1
Seltsam, was du da treibst.
Ein Test mit der Datenbank test sowohl auf MySQL 4.1 als auch 5.1 ergibt bei mir:
Ein Test mit der Datenbank test sowohl auf MySQL 4.1 als auch 5.1 ergibt bei mir:
Code: (dl
)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
~ mysqlshow.exe --port 3306 -u test -p test test
Enter password: ****
Database: test Table: test Rows: 2
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| id | int(10) unsigned | NULL | | PRI | | auto_increment | select,insert,update,references | |
| longitude | float | NULL | YES | | 0 | | select,insert,update,references | |
| azimuth | float | NULL | | | 0 | | select,insert,update,references | |
| location_name | varchar(128) | latin1_swedish_ci | | | | | select,insert,update,references | |
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
~
~
~
~ mysqlshow.exe --port 3309 -u test -p test test
Enter password: ****
Database: test Table: test Rows: 0
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
| id | int(10) unsigned | | NO | PRI | | auto_increment | select,insert,update,references | |
| longitude | float | | YES | | 0 | | select,insert,update,references | |
| azimuth | float | | NO | | 0 | | select,insert,update,references | |
| location_name | varchar(128) | latin1_swedish_ci | NO | | | | select,insert,update,references | |
+---------------+------------------+-------------------+------+-----+---------+----------------+---------------------------------+---------+
~