Return to BSD News archive
#! rnews 2747 bsd Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.cs.su.oz.au!kettle.magna.com.au!nsw.news.telstra.net!act.news.telstra.net!psgrain!iafrica.com!uct.ac.za!quagga.ru.ac.za!howland.erols.net!EU.net!news-peer.gsl.net!news.gsl.net!news.mathworks.com!uunet!in2.uu.net!newsfeed.internetmci.com!news.sprintlink.net!news-stk-200.sprintlink.net!news.sprintlink.net!news-stk-11.sprintlink.net!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: Mon, 16 Sep 1996 13:16:01 +0200 Organization: Contrib.Net Berlin Lines: 67 Message-ID: <323D36F1.15FB7483@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