Bug #3841 | Select Data Into OutFile As Is | ||
---|---|---|---|
Submitted: | 21 May 2004 7:33 | Modified: | 15 Dec 2005 10:39 |
Reporter: | Sergei Kulakov (Candidate Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | OS: | ||
Assigned to: | CPU Architecture: | Any |
[21 May 2004 7:33]
Sergei Kulakov
[12 Dec 2005 13:11]
Valeriy Kravchuk
Thank you for a feature request. Please, try some newert version of MySQL (latest 4.1.x, for example). There are no quotes by default for integer values: [openxs@Fedora 4.1]$ bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.17 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; 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_test | +-----------------------------------+ | Acknowledge | ... | test | ... | users | +-----------------------------------+ 67 rows in set (0.00 sec) mysql> desc test; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | num | int(10) unsigned | YES | | NULL | | +-------+------------------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> select * into outfile '/tmp/test.txt' from test; Query OK, 1 row affected (0.00 sec) mysql> exit Bye [openxs@Fedora 4.1]$ cat /tmp/test.txt 4294967295 So, looks like MySQL already do exectly what you wanted.
[15 Dec 2005 10:39]
Sergei Kulakov
It was not about quotes, it was about format (binary, 4 bytes). But times have passed and I must admit I do not need this any more.