Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump',
remove the 'redirect to' after the mysql command. This also assumes you are
logged into the localhost using the command line interface.
Your command would appear similar to the following:
mysql -u jjames -psd342 dbtheNe
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT
(0-128). Use ALTER TABLE to change it to an INT or BIGINT.
I hope this helps.
Pat...
- Original Message -
From: "Mette Møller Madsen" <[EMAIL PROTECTED]>
To: "mysql listserver" <[EMAIL PROTECTED]>
Sent: Friday, Jun
Referential integrity should be maintained by the program (programmer) using
the file handler/database.
We design all of our schemas with a Parent/Child hierarchy in mind. We
always have a unique key and there is always a column or key in common where
any relationship exists or could exist betwe
Just a quick note about RecordCount. RecordCount only returns the number of
records or rows from the recordset that have been 'seen'. Therefore it is
only reliable if you have traversed the entire recordset before calling it.
I agree, however, that direct SQL calls will generally produce a more
Your workstation may not be in the host table of the MySQL Server.
Pat...
- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:31 AM
Subject: Problem Setting up MyODBC Driver
> HI
>
> I am trying to set up an ODBC connecti
Expected behaviour, look in your Tray on the Taskbar for a stoplight icon.
Pat...
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 17, 2001 6:12 PM
Subject: Help Needed
> Hi
>
> I just downloaded MYsql for windows NT. I'm running it on Windows
If you are ftp'ing make sure your set to binary transfer method.
Pat...
- Original Message -
From: "ALICE CHIAPPETTA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:37 PM
Subject: Problem
> I have downloaded the stable release for Solaris. Everytime I t
Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Uwe Hein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:17 PM
Subject: Bug in MyODBC 2.50.36-nt ??
>
> Hi everybody,
ODBC API documentation is, of course, available from Microsoft and is
included with Visual Studio or available from their website (I'm not sure of
the exact URL). All of the MyODBC source is available from your closest
MySQL Mirror site. ODBC and JDBC are not the same. Try Sun for JDBC
specifi
I seem to get integer size exceeded error windows popping up using
winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98
Second Edition box.
Any clues?
(sorry for the vagueness, it's occurring on a machine not within my
immediate reach)
Pat...
You may have a corrupt library or mysqld. Signal 11 is a memory error
(likely overwrite). I would try deleting and reinstalling mysqld from a
fresh download.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Tu
BLOBS and TEXT columns used as indices require the length to be specifically
enumerated.
(Sec 7.26 of the manual)
CREATE TABLE foo(
id INT NOT NULL AUTO_INCREMENT,
name BLOB NOT NULL,
PRIMARY KEY(id),
UNIQUE(name(500))
);
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Mike T
- Original Message -
From: "Wojciech Spychała" <[EMAIL PROTECTED]>
To: "'Pat Sherrill'" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 7:08 AM
Subject: RE: ODBC trouble - please help
> time_stamp ???
> what is this for?
>
> -Original Mes
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an
AUTO_INCREMENT field).
Pat...
- Original Message -
From: "Wojciech Spychała" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 4:14 AM
Subject: ODBC trouble - please help
> I 've got problem
Make sure you also have at least a user (and password as appropriate) filled
out in the MyODBC Control Panel.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Jan R Andersson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 10:22 AM
Subject: Connecting
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
CR/LF conversions will take place automagically. Alternatively some linux
distributions have a utility to strip CR's from ASCII files and there is
always old reliable vi .
I hope this helps...
Pat...
[EMAIL PROTECTED]
---
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
> If I am using MS Access and link
When using a TIMESTAMP column with LOAD DATA INFILE, the TIMESTAMP must be
either set to NULL or an appropriate date within the import file or
specifically left out of the field list in the LOAD DATA INFILE statement as
follows:
LOAD DATA INFILE 'example.csv' replace into table example FIELDS
The mysql version compiled into your web server uses shared libraries and
your current version (upgrade) apparently is a statically linked version.
Recompile your web server/php/mysql executable with consistent use of
libraries i.e. either static or shared.
I hope this helps...
Pat...
- Orig
John,
To avoid the issues you mentioned, each table requires an AUTO_INCREMENT
column and a TIMESTAMP(14) column.
We have been coding with VC++ and using various third party ODBC clients,
including MS Access, pretty much since the inception of MyODBC. When using
the Jet Database Engine (MS Acce
Yes. Create a DSN to your remote MySQL Server using the ODBC control panel.
Then create a new db in MS Access using a link table (select the ODBC DSN
you previously created ).
Voila!
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "(Mr) Pekka Gaiser" <[EMAIL PROTECTED]>
To: <[EMAIL
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14)
and an AUTO_INCREMENT column.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "Gregory King" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 11:43
I would suggest developing a link (read: programmer controlled foreign key)
over columns that would have a consistent repeatable meaning. This would
allow the developer the ability to rebuild keys and relationships with
programmer developed utilities without dependence upon the underlying file
ha
I would suggest you issue an ALTER TABLE command to change your
AUTO_INCREMENT to unsigned. The concept of AUTO_INCREMENT negates the use
of negative numbers. If you are using the change from positive to negative
to flag for deletion or some other process, try adding a column for this
purpose an
Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is,
identify which workstations are failing and compare MDAC versions against
those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC
as appropriate. In any case, be sure to refresh all the link tables in MS
Acc
Try compiling with the static switch set. Check the manual for exact
syntax.
Pat...
- Original Message -
From: "Robert Hough" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 8:10 AM
Subject: Problems Installing 3.23.31
> I compilied 3.23.31 and I keep getti
You are correct, lack of primary key could be the culprit. I recommend a
TIMESTAMP(14) and an AUTO_INCREMENT in every table. Most MS ACCESS worries
then disappear.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Guy Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday,
Crystal Reports with MyODBC and MS Windows.
Pat...
- Original Message -
From: "Laurie Savage" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 9:03 PM
Subject: A report generator MySQL
> I am writing a database to store student academic records at my local
> h
28 matches
Mail list logo
