*BSD News Article 78248


Return to BSD News archive

#! rnews 2605 bsd
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.mira.net.au!vic.news.telstra.net!act.news.telstra.net!psgrain!iafrica.com!uct.ac.za!quagga.ru.ac.za!howland.erols.net!EU.net!Austria.EU.net!01-newsfeed.univie.ac.at!02-newsfeed.univie.ac.at!news.ecrc.de!news.space.net!news.b-1.de.contrib.net!news
From: Stephanie Coriat <coriat@jacobson.contrib.com>
Newsgroups: comp.unix.bsd.freebsd.misc
Subject: FreeBSD and msql
Date: Fri, 13 Sep 1996 14:30:13 +0200
Organization: Contrib.Net Berlin
Lines: 67
Message-ID: <323953D4.41C67EA6@jacobson.contrib.com>
NNTP-Posting-Host: jacobson.contrib.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.0b6Gold (X11; I; FreeBSD 2.2-960323-SNAP i386)

Hi,

I've installed the latest version of msql, and I have big problems with
the INSERT query.
It sometimes return "Query OK", but do NOT insert the new
record, or insert strange values.

Version Details :-

        msqladmin version       1.0.16
        mSQL connection         Localhost via UNIX socket
        mSQL server version     1.0.16
        mSQL protocol version   6
        mSQL TCP socket         1112
        mSQL UNIX socket        /dev/msql
        mSQL root user          root
        Host Architecture       FreeBSD-2.2-960323-SNAP-i386

Table    = domain_reg

 +-----------------+----------+--------+----------+-----+
 |     Field       |   Type   | Length | Not Null | Key |
 +-----------------+----------+--------+----------+-----+
 | domain_nr       | int      | 4      | Y        | Y   |
 | date            | char     | 8      | N        | N   |
 +-----------------+----------+--------+----------+-----+




mSQL > select * from domain_reg
    -> \g

Query OK.

17 rows matched.

 +-----------+----------+
 | domain_nr | date     |
 +-----------+----------+
 | 1         | 19950715 |
 | 3         | 19640912 |
 | 14        | 19960612 |
 | 15        | 19960612 |
 | 16        | 19960612 |
 | 17        | 19960612 |
 | 18        | 19960612 |
 | 19        |          |
 | 20        | 19960617 |
 | 142       | 19960710 |
 | 22        | 19960618 |
 | 23        | 19960618 |
 | 24        | 19960619 |
 | 25        | 19960625 |
 | 36865     | NULL     |
 | 36097     | NULL     |
 | NULL      | NULL     |
 +-----------+----------+

Have anyone had the same problem ???

Thanks,
Stephanie.
-- 
Stephanie Coriat                            coriat@jacobson.contrib.com
                                            scoriat@cs.tu-berlin.de
http://www.cs.tu-berlin.de/~scoriat/        scoriat@ifhamy.insa-lyon.fr