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