JvdW writes:
> I'm having a bit of a problem importing a dumpfile to mysql. When doing a
> ERROR 1064 at line 11: You have an error in your SQL syntax near '(15),
> surname TEXT(15),
> The first part of the dump file is:
> --cut--
> #
> # mSQL Dump (requires mSQL 2.0 Beta 5 or newer)
Ther
http://www.xxx-porns.com/index.shtml?wmid=mailer10&pop=yes";>
http://www.xxx-porns.com/index.shtml?wmid=mailer10&pop=yes";>NO
CREDIT CARD NEEDED!
http://www.xxx-porns.com/index.shtml?wmid=mailer10&pop=yes";>NO
CREDIT CAR
Hi Everyone.
I'm having a bit of a problem importing a dumpfile to mysql. When doing a "
mysql -u database_mgr -p -h host.domain database < file.dump " I get this
error:
--cut--
ERROR 1064 at line 11: You have an error in your SQL syntax near '(15),
surname TEXT(15),
company TEXT(20),
em
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jason Parker" <[EMAIL PROTECTED]>
Sent: Monday, September 24, 2001 2:19 PM
Subject: Re: Fw: mySQL
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must i
Thanks for your reply.
Use database to restore file is the requrement of our project ,So I must
find the way of problem.
As you said ,I trust the problem is beacuse of mysql protocol that is the
filed must be send as a single packet. I have same test in postgresql ,In
postgresql the blob type
Robert,
you are a genius in finding bugs :).
The bug has been reported by two users before you.
Since CHECK TABLE says ok, the table is probably
ok now.
The bug may be in purge in multiversioning: it removes
a secondary index record too early. Or it may the
in a lock wait.
Can you describe wha
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Can we do the moving.
I so a
Hi Stephen,
- Original Message -
From: "Stephen Faustino" <[EMAIL PROTECTED]>
> We are encountering two issues when using MySQL with large tables
> (by large, we're talking > 1 million rows). Our application is written in
> Java and we are using the mm.mysql JDBC driver. We run our
> a
hello all, I use ADO to connect to mysql database. I get an ADO
recordset to show datas and update the modified records with SQL
statement. So I shall resync the recordset and the database myself. But
when I call the method Resync I get an error which code is 80004005 and
the meaning is such as "d
At 11:36 PM 23/09/2001, Neil Zanella wrote:
>It is possible and not very hard at all.
>But why would you need expect? Why not
>just use a shell script?
Because the task I need the script to do is best done using Expect (its
interfacing with a serial port doing things with some data pulled out o
In answer to your question - your statement does not work becuase mysql does
not allow joins in update statements.
imho, the fact that mysql does not support joins in UPDATE and DELETE
statements is by far its greatest weakness. I have posted a couple of
messages to this group to see what creati
I am assuming from your email that the field ID allows duplicates. In that
case, use the SELECT DISTINCT syntax ... that will get you back the 1 row
you are looking for. However, if the (ID,CompetitorName) tuple is unique,
SELECT DISTINCT will NOT help.
Hope this helps
Raj
At 06:12 PM 9/23/200
I guess thats a no. I wasn't sure if it was hidden in some other
documentation file. Is there a page that details things that can be
done in MS SQL Server and not mySQL?
Ack, at 9/23/01, Will French said:
>rtfm.
>
>Excerpt from mySQL manual.
--
Sincerely,
Rosyna Keller
Technical Support/Holy
On Sun, Sep 23, 2001 at 07:54:59PM -0500, Deryck Henson wrote:
>
> Sooo, when does this highly anticipated version of mysql get released?
> Supposed to have union tables :).
In about a week or too, based on what Monty said earlier today. :-)
Jeremy
--
I am having problems getting an update to work correctly. Assume that I have two
tables, employee and office. Employee has two fields, employee_id and employee_name,
and office has three fields, office_id, office_number, & employee_id.
I have been using inner join to link the tables together
Hi Sandeep,
I assume you are installing your MySQL in Linux environment. So be cautious
on case sensativity. Remember to type 'MySQL' and not 'mysql'.
First, run command :
[admin]# rpm -qa | grep MySQL
MySQL-client-3.23.38-1
MySQL-3.23.38-1
This will show all the related packaged in your box.
R Talbot wrote:
> R Talbot wrote:
>
> > R Talbot wrote:
> >
> > > Michael Widenius wrote:
> > >
> > > >
> > >
> > > > The problem is probably that your tar program doesn't use user-names
> > >
> > > > but user-ids, in which case the files may be owned by 'anyone.
> > >
> > > > What output do you
It is possible and not very hard at all.
But why would you need expect? Why not
just use a shell script?
Neil
On Mon, 24 Sep 2001, Chris Aitken wrote:
> Hi,
>
> Just a quick query. I haven't been able to locate any documentation on it,
> but has anyone ever used an expect script to connect to
rtfm.
Excerpt from mySQL manual.
=
6.5.1 CREATE DATABASE Syntax
CREATE DATABASE [IF NOT EXISTS] db_name
CREATE DATABASE creates a database with the given name. Rules for allowable
database
names are given in Section 6.1.2 [Legal
> At 11:55 23/09/01 +1000, you wrote:
> Thanks Will for the suggestion, however as per my private email to you, it
> didn't work successfully to any degree. Actually it knocked out ONE date
> from the "same" group and that was one of the Available dates.
I'll take my foot out of my mouth now
As I am still a newbie to mysql I am sure that some of the problems that I
am coming accross are created by myself, and others are probably so simple
that they are staring me in the face. I do, however, seem to be having some
problems with the below statement.
I would like the result of the que
Hi,
Just a quick query. I haven't been able to locate any documentation on it,
but has anyone ever used an expect script to connect to a MySQL database
and pull out a bunch of data for use further in the expect script ?
Any directions would be appreciated.
Cheers
Chris
--
Chris Ait
Does mySQL not support this syntax?
CREATE DATABASE newDB ON
(
NAME = 'newDB',
FILENAME = '~/newDB.mdf',
SIZE = 10MB,
MAXSIZE = 20MB,
FILEGROWTH = 1MB )
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
---
Sooo, when does this highly anticipated version of mysql get released?
Supposed to have union tables :).
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Er, a little embarassed that I did not check the bugfixes page before
reporting that. Anyhow, here is the check table to go with that report:
+--+---+--+--+
| Table| Op| Msg_type | Msg_text |
+--+---+--+-
Hello
I have problems building the mysql package for the Debian distribution on
powerpc. More infos below. Feel free to contact me for further details.
bye,
-christian-
make[3]: Entering directory `/home/ch/debian/mysql-3.23.42/sql'
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_H
Hello,
I checked my .err file today and found these:
-
InnoDB: error in sec index entry update in
InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER
InnoDB: tuple 0: len 7; hex 616d626a6f7267; asc ambjorg;; 1: len 8; hex
1d1b; asc ;;
InnoDB: record RECORD: info bits 0 0: le
Setup :
MySQL 3.23.42
Perl 5.6.0
DBI 10.32
I’m trying to do a few different queries where the table name needs to be
dynamic. I’ve tried the following :
$dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where
somedata=?”);
$dbquery->execute($tablename,$somedata);
But I keep gett
I know you can set a column in each table that will update itself with the
current ctime every time that row is modified, but I haven't found a per db,
or per table variable yet. (I believe mSQL has something like this, but not
mysql.
---
Jason H. Frisvold
Senior ATM Engi
On 23-Sep-2001 Neil Silvester wrote:
>
> How do I convert (or create from scratch) a table who's AUTO_INCREMENT
> column would be a, b, c, d, e and so forth up to z?
> At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
> be able to make good use in my queries if this co
Hi,
I attached a wrong file in my last email. I should have sent you
config.log file. Here it is.
Sorry for the mistake.
Thanks again.
Huai Liu
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:813: ch
Neil Silvester writes:
> How do I convert (or create from scratch) a table who's AUTO_INCREMENT
> column would be a, b, c, d, e and so forth up to z?
> At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
> be able to make good use in my queries if this column was alphabe
Hi,
I am trying to install MySQL in my own account on Sun Sparc
solaris2.7. I am an EE student trying to finish a project. Here
is my problem:
I downloaded source MySQL file to my home directory. As I am not
root user, I failed to run "groupadd mysql" and "useradd -g
mysql mysql". After I g
How do I convert (or create from scratch) a table who's AUTO_INCREMENT
column would be a, b, c, d, e and so forth up to z?
At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
be able to make good use in my queries if this column was alphabetical
instead.
Thanks.
Neil Si
Hi all,
I'm having a problem where the optimiser seems to take a *very* long time to
work out which indexes to use.
Although I'm using a lot of joins, it takes around 10 minutes to give an
EXPLAIN of the query shown below. The actual query takes only a second or
two (or so it appears).
linklist
Hello,
Can someone who has successfully created a MySQL database for a virtual
hosting account show me how to connect! I can always
connect as root ... but when I try to connect as the user its get a
permission error. I went to the database and gave the user of that virtual
account all premisions
R Talbot wrote:
> R Talbot wrote:
>
> > Michael Widenius wrote:
> >
> > >
> >
> > > The problem is probably that your tar program doesn't use user-names
> >
> > > but user-ids, in which case the files may be owned by 'anyone.
> >
> > > What output do you get for:
> > >
> > > ldd bin/mysqld
> > >
Hi
Take a look at the following links, which guides you step by step in
managing the user accounts:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
Regards, venu
--
For technical support contracts, go to https://order.mys
I suggest downloading/installing the MySql ADO library (available from a
link off mysql.com downloads). Then you can write ASP pages (using ado
objects) to interact with your mysql database.
Before my suggestion catches the ire of all the php/linux snobs, I must
point out that our friend wants t
http://www.devshed.com/Server_Side/MySQL/Access/page2.html
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 9:31 AM
To: Kamesh P S; [EMAIL PROTECTED]
Subject: RE: user creation in mysql
Here a good place to go through this step by step.
Good luck
Hi,
I've been checking out MySQLGUI 1.7.5-2 for win 32. I've been able to
create a database, but, I can't seem to get it to create a table using
"Commands/Tables/Create tables".
Is it safe to assume that this is a know issue?
Thanks,
Steve.
--
.
Dear List-Members,
As I am EXTREMELY new to mysql and my connection to my ISP is a
pay-per-minute one, doing the endless testing (koff, kofff Ok, farffing
around, getting lost, tired and emotional) with mysql can cost some dosh
over time. I've only recently arrived at this work-station
Here a good place to go through this step by step.
Good luck and happy MySQL'ing
M;)
-Original Message-
From: Kamesh P S [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 6:40 AM
To: [EMAIL PROTECTED]
Subject: user creation in mysql
me too facing the problem
in creating users
Hi!
On Sep 23, cajmilfo wrote:
> Is there anybody willing to help me?
>
> I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine,
> looks like it's not funcitonal very well(maybe my mistake).
> I had created example database for fulltext as written in manual, inserted
> about 10M
me too facing the problem
in creating users and granting permission
please help me
Hi,
We are facing problem with mysql on linux.
We are unable to give the password for admin user.
Can you please give all the list for installation and
user creation as well as for uninstalling?
Thanks,
K
Is there anybody willing to help me?
I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine,
looks like it's not funcitonal very well(maybe my mistake).
I had created example database for fulltext as written in manual, inserted
about 10Megs of text files.
When I try to do match "s
46 matches
Mail list logo
