Hi
How do I file a bug for mysql for Windows NT/2000/XP.
Problem:
Can not handle spaces in paths for the arguments given on the
commandline to the mysqld-nt command.
e.g. mysqld-nt --datadir=c:\Program Files\mysql\data
Is not possible, nor is
mysqld-nt "--datad
hi,
on solaris it probably a good idee to change the tmp directory from /var/tmp ->
/tmp
as /tmp is a ram disk that gives a good performance boost if tmp tables are
involved.
The sort_buffer variable the the one to look at try increasing it, as if the
result fits into
the sort buffer no tmptable
Hi,
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
I've got a perl script which creates a HELP table and
controls the maximum size via the 'max_rows=' option
to 'create table'.
When the script
hi,
Does anyone has any idea to improve this situation?
When I show my processlist, there is inner join query that having "Copying
to tmp Table" state, and it takes quite long time to finish the query. Any
idea to avoid Copying to tmp Table? I have tried to increase my
tmp_table_size however it do
Hi all!
I have built MySQL-4.0.3 with -march=k6 (gcc-2.95.3) in my CFLAGS
(everything else was as recommended in the INSTALL instructions). I did
a little testing before dumping our data into it, and it seemed OK :)
However now MySQL is crashing on one particular query only (it has been
fine f
Hi All,
This is a little OT, but I'm looking for a report writer/server for
Apache/MySQL. There are lots of report writer/servers out there, but the
ones I've found so far either 1) work only on Windoze or 2) cost a lot of
money. I'm just looking for a basic tool that allows me to design relativ
Try http://www.mysql.com/doc/en/Query_log.html
> -Original Message-
> From: Imro Benito STROK [mailto:[EMAIL PROTECTED]]
> Sent: 23 September 2002 20:04
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'; Imro Benito STROK
> Subject: SPAM *** Audit feature in MySQL ***
>
>
> Hi All,
>
>
At Mon, 23 Sep 2002 22:35:03 -0500,
Paul DuBois wrote:
> DBI is useless without at least one driver for connecting to a specific
> database.
>
> DBD:: is useless without DBI; Perl scripts don't communcate directly
> with DBD drivers. They communicate with DBI, which speaks to the database
> throu
sql,query
>>>HI sorry for the confusion.
>>>well.. I want to create a database where I can give *any* name
>>>(ofcourse, the database doesn't exist).
>>>
>>>Are you trying to say, I need to ask the root, to give me create
>>>privilege on database "xxx", even before it exist, then only I can
At 21:51 +0200 9/22/02, Thoenen, Peter Mr. EPS wrote:
>Following this conversation myself (also a perl db newbie :) ... before
>always just used php) and curious if you know definitely what db vendor you
>are going to be using (mysql in this case), any reason to use dbi; as
>opposed to just usin
Hi All,
Due to security reasons we have to implement an audit functionality in our
MySQL production databases.
Q; Is there an audit feature in MySQL. If YES can someone send me the
information how to implement this.
Thanks,
Imro Strok
StarHub Pte Ltd
Information Technology
Phone: +65 6825 5703
sql,query
At 11:49 +1000 9/24/02, vinita vigine Murugiah wrote:
>Paul DuBois wrote:
>
>>At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
>>
>>>Hi paul
>>>
>>>Paul DuBois wrote:
>>>
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>HI Egor
> OK, I want to create new
This is the mysqlbug report:
##
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTEC
I know that the "what kind of server should I buy?" question
comes up regularly here, but the various discussions in the
archives don't seem to address my issue.
My current server is an old PII desktop with 64M memory and a
6GB hard drive, running FreeBSD. Thanks to the glories of
FreeBSD and th
> I have db that has two tables that I am needing to post the same
> information
> into both tables, I can't use ID. So I am want to see if there is a sql
> statement that will let me or how I can do with a php page.
I'm not a SQL guru, but I'm pretty sure SQL doesn't allow this. (Objects in
Post
I wanted to test the mysql++ example "Loading binary file in a BLOB ..."
because I'm looking for for a solution to load several MB up to a remote DB,
without FTP or things like that. Just 1 thread in DB, so performance should
be no problem.
Therefor I try to execute and benchmark this quite famou
Paul DuBois wrote:
> At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
>
>> Hi paul
>>
>> Paul DuBois wrote:
>>
>>> At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>>>
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
G
Ok, Let's try this again, for some reason this didn't post from early today.
I have db that has two tables that I am needing to post the same information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I am sorry
Hi
I am a mysql user. I use a long blob field to store image data.
But whenever I make a deletion with my image data I find that the
hard disk availability is still intact. There is no change. What
could be the problem with my delete statement.
Please Help
Regards
Roslee AJ
---
At 16:43 -0700 9/23/02, Jan Steinman wrote:
> >From: "Moestl, Wolfgang" <[EMAIL PROTECTED]>
>>
>>Is there a defined behaviour for handling the case-sensitivety for
>>user- and hostnames?
>
>According to the specification for the Domain Name System (DNS),
>Internet hostnames are always supposed
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
>Hi paul
>
>Paul DuBois wrote:
>
>>At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>>
>>>HI Egor
>>>OK, I want to create new databases, to do that I need database
>>>create privilege.
>>>
>>>Grant CREATE ON ##
>>>to ddb@localhost I
Hi paul
Paul DuBois wrote:
> At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>
>> HI Egor
>>OK, I want to create new databases, to do that I need database
>> create privilege.
>>
>> Grant CREATE ON ##
>> to ddb@localhost IDENTIFIED BY 'passwd'
>>
>> What should go into #, is it
>From: "Moestl, Wolfgang" <[EMAIL PROTECTED]>
>
>Is there a defined behaviour for handling the case-sensitivety for user- and
>hostnames?
According to the specification for the Domain Name System (DNS), Internet hostnames
are always supposed to be case-insensitive.
Since other entities in MySQ
At 17:25 -0600 9/23/02, Derek Scruggs wrote:
> > Where might I find information about optimizing inserts to MySQL tables.
>
>In Paul DuBois's excellent "MySQL" from New Riders, there is a section about
>loading data efficiently in which he talks a little about inserts. In a
>nutshell, LOAD DATA i
> Where might I find information about optimizing inserts to MySQL tables.
In Paul DuBois's excellent "MySQL" from New Riders, there is a section about
loading data efficiently in which he talks a little about inserts. In a
nutshell, LOAD DATA is faster than INSERT, the fewer the indexes the fast
At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>HI Egor
>OK, I want to create new databases, to do that I need database
>create privilege.
>
>Grant CREATE ON ##
>to ddb@localhost IDENTIFIED BY 'passwd'
>
>What should go into #, is it a *? but I should NOT given
>permission to a
HI Egor
OK, I want to create new databases, to do that I need database
create privilege.
Grant CREATE ON ##
to ddb@localhost IDENTIFIED BY 'passwd'
What should go into #, is it a *? but I should NOT given permission
to access other databases.
Thanks
Egor Egorov wrote:
>vinita,
>M
Appears to be a database memory corruption problem. The binlog filename
had been trashed. Eventually,
mysql/innodb blew up trying to do a malloc.
We were accidentally running two copies of ibbackup at the same time at
around 6pm on 9/21 and 9/22.
We were accidentally running a third copy at ar
Hi,
I have a question. I have two tables that I want to post data too. Is there
a way to do a sql statement that lets me post data two tables at the same
time?
Thanks,
Chuck Payne
-
Before posting, please check:
http://ww
At 22:47 +0200 9/23/02, David yahoo wrote:
>Hi,
>
>I have a column that can have 850 chars at max.
>I think that I can only put this in a tinytext col type.
Probably not. The maximum size of TINYTEXT is 255 bytes. You need
at least a TEXT type. (MEDIUMTEXT and LONGTEXT will also work, but
are
At 12:10 -0700 9/23/02, j.random.programmer wrote:
>Hi all:
>
>I'm seeing a strange problem updating a field if
>that field is referenced as a FK in another table.
>
>Consider:
>
>CREATE TABLE A (
> id INTEGER NOT NULL AUTO_INCREMENT,
> name VARCHAR(20),
> PRIM
Where might I find information about optimizing inserts to MySQL tables.
I've purchased 2 books, and so far, the only optimizations I see concern
reads, not writes.
The only advice I've received so far on optimizing writes is to have my
application dump the records to a text file first, and do
Hi,
I have a column that can have 850 chars at max.
I think that I can only put this in a tinytext col type.
How can I hav an index to this col mysql refuse me to add one ?
Thanks.
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
Autodia is a tool for automatically generating Dia diagrams from source
code files. For example, it helps in building inheritance diagrams. It
handles perl, java, C++, C, and Php.
This patch adds to it a (crude) handler for SQL. It generates the UML
boxes to describe the tables. It also puts
Hi
I'm experiencing very strange innodb behavior. I'm testing the following DB
structure: stn|dt|par1|par2|par3 , where stn is 1 to N, dt 1 to M, par1,
par2, par3, par4, par5, par6 are any values and stn+dt is a primary key.
So create statement looks like
CREATE TABLE t3 (stn SMALLINT UNSIGNED NO
filter fodder: sql, query
Hi,
Hope someone can help with this.
I have a table subjects:
qsid smallint ...
name varchar(60)
The table contains eg.
Mathematics
English
Biology
... ...
I also have a table vx_students:
vxid smallint ...
pri_qskey smallint not null default 0
sec_subj smal
clarify exactly what you mean. show an example.. you
question is confusing.
cw
--- shahana qureshi <[EMAIL PROTECTED]> wrote:
> Please tell me how can I get the date and time
> values
> diffently in a single query from 'DateTime' field
> and the difference of two DateTime fields in
> HH:MM:SS
>
>Description:
While trying to run this query:
SELECT users_1.* FROM users AS users_1, users AS users_2
WHERE users_1.email_address = users_2.email_address AND users_1.id <> users_2.id
ORDER BY users_1.email_address
I got this error:
Can't create/write to file '/root/tmp/#sql107d_bdf_2.MYI' (Er
I downloaded MySQL 4.0.3beta on my XP system. I didn't find
mysql_fix_privilege_tables after installing. Am I suppose to pull it
from the unix download and do by hand?
Thanks,
Daniel
-
Before posting, please check:
http://
Hi all:
I'm seeing a strange problem updating a field if
that field is referenced as a FK in another table.
Consider:
CREATE TABLE A (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
PRIMARY KEY (id)
);
CREATE TABLE B (
id INTEGER N
Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 23, 2002 10:54 AM
Subject: optimizer bug in selecting fields that don´t belong to the index
used by mysql/innodb
> Description:
> Hello,
>
> I wrote the following text in
Hello,
We have 4000 db and 4000 user (more or less) in MySQL, each db has one
user assigned.
Some times, this is happened more often, show the next error:
ERROR: 1045 'Access denied for user: username@host (using password:
YES).
So we kill/restart the mysqld process
after th
Jose,
if this occurs in an SQL query of type
... ORDER BY primarykey DESC
then this is probably the bug which is fixed in upcoming 4.0.4.
I hope 4.0.4 will be released in a few days.
Best regards,
Heikki
Innobase Oy
- Original Message -
From: ""jesus"" <[EMAIL PROTECTED]>
Newsgroups
Hi,
I try to store japanese into mysql :
PHP seems to works great with japanese strings.
$jap=",g,rfR[fhõ^øiZQlj,SO. ";
And then it displays kanjies.
But I didnt manage to store char into the database ?
How can I do ?
Thanks.
___
Oh yes, I almost forgot... The supported type aliases aren't mentioned in
the pseudo-BNF, and they probably should be for the sake of people who are
trying to learn MySQL after having used another DB product...
or BIT
or BOOLEAN
or DOUBLE PRECISION[(length,decimals)] [UNSIGNED] [Z
Jesse Sheidlower wrote:
> How do you get the table name returned as part of the query
> results? Or am I misunderstanding how one would work with the
> results?
Try:
SELECT *,'TABLEA' FROM TABLEA
UNION
SELECT *,'OTHERTABLE' FROM OTHERTABLE
Herman
At 12:08 -0500 9/23/02, Paul DuBois wrote:
>At 9:55 -0700 9/23/02, neal wrote:
>>Thanks for the suggestion but this would actually create a new table,
>>correct (the first statement that is)? I just want a resultset with these
>>values, without writing to disk.
>
>Then you must upgrade to 4.x so
I have a table that is populated with raw data on a pass by an
extraction program. Its other fields are left NULL and a secondary
program parses through this data to fill in the other fields. I would
like to move some of this logic out of the second program and into SQL
statements, but it se
for some reason when things get busy, we get a whole ton of locked threads
(see processlist below...), and at some point when there are enough threads,
the whole thing bogs down to a crawl. EVEN after i kill the process that's
holding it all up, it still stays all stuck up. I've seen people con
At 13:16 -0400 9/23/02, Jesse Sheidlower wrote:
>On Mon, Sep 23, 2002 at 11:20:49AM -0500, Paul DuBois wrote:
>
>I had a question about the use of the UNION command in this
>context.
>
>The original poster asked about getting the name of the
>_table_ as well as some other data, which would seem to
For those of you looking for a Web browser based GUI for MySQL and/or
who might be considering going with a commercial Web application
server for connectivity to MySQL, you're cordially invited to check
out Blue World Lasso Professional 6 (LP6) which was just released
last week.
Lasso Adminis
At 10:12 -0700 9/23/02, neal wrote:
>I just presume that this will add alot of overhead to the query. The reason
>I wanted to be able to do something like a union rather than seperate
>queries is because of overhead. I dunno ... am I wrong? Is it not that
>bad?
The way to find out is to try it
On Mon, Sep 23, 2002 at 11:20:49AM -0500, Paul DuBois wrote:
I had a question about the use of the UNION command in this
context.
The original poster asked about getting the name of the
_table_ as well as some other data, which would seem to be
relatively necessary for doing many types of things
I just presume that this will add alot of overhead to the query. The reason
I wanted to be able to do something like a union rather than seperate
queries is because of overhead. I dunno ... am I wrong? Is it not that
bad?
Also, I tried the query you suggested ... can you really do this(?):
"in
At 9:55 -0700 9/23/02, neal wrote:
>Thanks for the suggestion but this would actually create a new table,
>correct (the first statement that is)? I just want a resultset with these
>values, without writing to disk.
Then you must upgrade to 4.x so that you have UNION support.
Either that, or writ
Thanks for the suggestion but this would actually create a new table,
correct (the first statement that is)? I just want a resultset with these
values, without writing to disk.
On another note, yeah youre right not a different connection object, but I
presume I would need to run two seperate que
At 9:35 +0200 9/23/02, David Bordas wrote:
>Hi list,
>
>I still have performance problem with my big MyISAM table.
>In fact, mysql keep locking my table, even for doing select :(
That's how MyISAM works -- it uses table locks for everything.
Given that fact, if it didn't lock the table for readin
At 0:23 -0700 9/23/02, neal wrote:
>Oh man!
>
>Yeah, you're right. That's exactly what I want but apparently it wasn't
>implemented until v4??!?!?!
Right.
>
>What did people do prior to version 4 when needing to query multiple tables?
>Just endure the overhead of multiple connections to the dat
Follow up question,
Well what if you have a user that you want to give permission to from any
computer in the domain.
Such as user: mysqluser with READ|SELECT|UPDATE from anywhere
in: mydomain.com
But not from any other domain.
Thanks,
Eric Lamendola
Slingo Inc.
And if not, Hey wh
At 1:13 +1000 9/24/02, Chris Barnes wrote:
>hi people,
>just a quick question.
>
>is there a way i can use the "lock tables" statement to lock all the tables
>in a database which out having to specify all tables individually?
>
>i dont really want to use a statement like:
>lock tables table1 read,
We're probably 98 percent selects. But that's part of the problem: the
selects build up at a fantastic rate when there are a flury of updates.
Hopefully, once we get to InnoDB, this won't be as likely to happen.
Cheers.
-Dana
> -Original Message-
> From: Paul DuBois [SMTP:[EMAIL PROTECT
At 9:40 -0500 9/23/02, Dana Diederich wrote:
>Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
>MyISAM to Innodb, because we have database tables that have many updates,
>inserts, deletes and selects going on at the same time. My belief is that
>InnoDB's better locking
Hello,
If you're on *NIX platform, use this:
chown mysql *
in your data directory. To make things sure, chown every data file to
mysql user (I assume you've created it during install).
On Windows, check the permissions. I apologize for being inaccurate, but
you didn't specify what operating syst
hi people,
just a quick question.
is there a way i can use the "lock tables" statement to lock all the tables
in a database which out having to specify all tables individually?
i dont really want to use a statement like:
lock tables table1 read, table2 read table3 read, table4 read, table5 read,
I don't know how you have your system configured, but mine has the root only
functional on the localhost.
Bruce
- Original Message -
From: "toby -" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 23, 2002 9:22 AM
Subject: Re: access denied
We are having a problem which seems to have appeared recently with
replication on our mysql servers.
- We have 3 servers set up with mysql 3.23.52 (they were running .49 but
we upgraded in an attempt to fix this problem, which did not work), set
up as a master and 2 slaves to the master.
- Ther
great! hope it works !
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:17 AM
To: MySQL Mailing List (E-mail)
Cc: Edward Peloke
Subject: RE: Complex SQL query problem...
FYI - this query seemed to work.
select * from nodes
left join
Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
MyISAM to Innodb, because we have database tables that have many updates,
inserts, deletes and selects going on at the same time. My belief is that
InnoDB's better locking semantics (as compared to MyISAM) will give me
be
thnx gerald
but i still dont know what to do to fix this thing up
will someone pleez enlighten me on how to
thnx a million ...
toby .
>From: gerald_clark <[EMAIL PROTECTED]>
>To: toby - <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: access denied
>Date: Mon
Hello,
Recently I have installed MySQL-Max 4.0.3 in my production server, and
in the error log I found the following message (or very similar) several
times:
"InnoDB: Assertion failure in thread xxx in file btr0pcur.c line
203"
Why takes place this crash?
NOTE: Querys associated to cra
Patrick,
Monday, September 23, 2002, 4:24:13 PM, you wrote:
PF> I'm just starting out with MySQL. How do you set permission to allow for
PF> access from a domain or IP. I found this in the docs. I this all I need?
PF> GRANT ALL PRIVILEGES ON *.* TO monty@"%" -> IDENTIFIED BY 'some_pass' WITH
Graham,
Sunday, September 22, 2002, 3:15:23 PM, you wrote:
GH> I am aware that this is an error of my own making, however . . .
GH> I am unable to install my sql because the scipt fails with
GH> a duplicate key error
GH> Preparing db table
GH> Preparing host table
GH> Preparing user table
GH>
Sherif,
Tuesday, September 24, 2002, 2:16:13 AM, you wrote:
SDM> I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
SDM> While installation it asked me to change DB root password using mysqladmin
SDM> I looked for mysqladmin and didn't find it !! not all the files were
SDM> in
andykychan,
Monday, September 23, 2002, 11:16:09 AM, you wrote:
a> I would like to know when the MySQL 4.1 will be released.
a> We are looking forwards to hearing from you.
It will come in alpha before this year ends.
--
For technical support contracts, goto https://order.mysql.com/?ref=ens
ORDER BY SentDate DESC
Ben Holness wrote:
>Hi all,
>
>I have a table with three columns:
>
>Destinationvarchar(254)
>SentDate timestamp(14)
>UserID varchar(32)
>
>I want to be able to get a list of the 100 most recently used numbers, based
>on the timestamp (Sen
It seems like MyODBC (or ODBC in general ?) cannot accept user variables.
The following query works OK when quering directly through the API but doesnt work via
MyODBC
Any suggestions to some workaround allowing the use of user variables???
SELECT id,
@s:="",
@o:=objekter.overskrift,
@p0:=POS
mysql does not own its files.
toby - wrote:
> ok guyz
>
> im lost
>
> im creating my tables and after i ve created em i tried to change two
> of the fields to FULLTEXT and this is what i get :
>
> Database zabanDb running on localhost
> Error
>
> SQL-query :
>
> ALTER TABLE `ctnt_inf` ADD
First off i am a newbie, so forgive any repatition and ideocy.
Ok i am trying to evaluate MySQL, i have a Mssql database which has been
specifically generated by my company. Therefore i have a ddl file which
will generate the tables, database name and relationships. I have poked
around mysql a
Hello,
I'm just starting out with MySQL. How do you set permission to allow for
access from a domain or IP. I found this in the docs. I this all I need?
GRANT ALL PRIVILEGES ON *.* TO monty@"%" -> IDENTIFIED BY 'some_pass' WITH
GRANT OPTION;
DBA / Unix Administrator
Patrick Fowler
Wynit, I
FYI - this query seemed to work.
select * from nodes
left join nodes as n2 on n2.parent_id = nodes.node_id
left join jobs on jobs.parent_id = nodes.node_id
left join colors on colors.parent_id = nodes.node_id
where nodes.node_id = ?
and ((n2.parent_id is not NULL) or (jobs.parent_id is not N
Hi All,
I am new to mySQL.
I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
While installation it asked me to change DB root password using mysqladmin
I looked for mysqladmin and didn't find it !! not all the files were
installed.
I looked into the documentation and it said
MySQL wrote:
> You might also consider using two integer type fields - one for the
> numerator and another for the denominator. This way storage and recovery are
> easy and the mathematics are wide open.
> _M
>
>I suspect that a float add is faster than 3 integer multiplies and
>sum.
>
Davis, Tim wrote:
>select count(*) from table1
>go
>select count (*) from table2
>go
>
>This will return 2 results, with count of each table. How would I do the
>same thing in MySQL?
>
>
I'm not sure if you can; I tried:
select count(table1.id) as table1_count, count(table2.id) as
table2_coun
hans,
Sunday, September 22, 2002, 3:48:33 PM, you wrote:
hs> trying to do my first steps with mysql, i have done the following :
hs> mysql> USE mysql;
hs> Reading table information for completion of table and column names
hs> You can turn off this feature to get a quicker startup with -A
hs> Dat
Joseph,
Thanks for the quick answer.
Very nice to know that adding an index forces a rebuild of all indices!
(Side note -- I was going to configure the database with a minimal set
of indices, and then watch to see how people use the database, and then
add indices on popular columns.)
I did
vinita,
Monday, September 23, 2002, 9:12:24 AM, you wrote:
vvM> I can create a database called test,
vvM> mysql> create database test;
vvM> Query OK, 1 row affected (0.03 sec)
vvM> BUT I can't create any other databases???
vvM> mysql> create database tem;
vvM> ERROR 1044: Access denied for user
Moestl,
Monday, September 23, 2002, 9:54:33 AM, you wrote:
MW> If you have a host having the minus character '-' in the name the mysql command
SHOW GRANTS FOR fails.
MW> Example:
MW> SHOW GRANTS FOR root@MY-COMUPTER results in the error message
MW> "You have an error in your SQL syntax near '-
Marvin,
Monday, September 23, 2002, 6:52:23 AM, you wrote:
MC> MySQL newbie seeking help and/or advice on storing data into a database.
MC> I have a poetry section I'm trying to add to my site that will allow users to
submit some of their work for public viewing. An example is located here:
htt
Moestl,
Monday, September 23, 2002, 9:49:14 AM, you wrote:
MW> Is there a defined behaviour for handling the case-sensitivety for user- and
hostnames?
MW> I did not find any information on this at the docs for the 4.0.3 MAX version which
I'm using.
MW> For example, the following database conn
Owain,
Sunday, September 22, 2002, 8:37:55 PM, you wrote:
OM> Is there an easy way to turn logging or SQL statement executions on or off without
having to restart with a changed my.cnf file? Just want to log queries to try and
sort out some performance
OM> problems.
Nope.
--
For technica
Hello,
I m using WinXP / Office XP and need odbc support to create a circular
letter.
I have installed mysql, etc. all works fine.
But I cant get Word to work with odbc drivers. They seem to work, they
get connection
To my database but word says something like this :
"couldn't obtain table lists
http://sql.kldp.org/mysql/
One good thing about this one though, they seem to be able to update theirs,
the most recent update (1.4) was on September 13th, the previous version
(1.3.12) was on June 4th. Hopefully the new version (which I haven't tried
out yet) will support some of the 4.x.x stuf
>Description:
When I issue a "SHOW VARIABLES" request using the standard command
line client, I get a "ERROR 2013: Lost connection to MySQL server
during query". The server error log reports:
"mysqld got signal 10;
This could be because you hit a bug. It is also possible t
And where would one obtain MySQL Navigator?
JMichael
"Matt Hargraves" <[EMAIL PROTECTED]>
09/22/2002 09:14 PM
To: "Arthur Fuller" <[EMAIL PROTECTED]>, "David Kramer"
<[EMAIL PROTECTED]>
cc: "mysql mailing list" <[EMAIL PROTECTED]>
Subject:Re: MySQL
Hello
I'm Gunter and I tried to compile the mysql Database on Solaris 9 for
Ultra Sparc arcitecture.
I use the precompiled gcc 3.2 compiler form www.sunfreeware.com.
This Compiler is linked to use the as and ld fom the Solaris operating
system.
Also I use the autoconf and the other gnu tools from
Hans,
You're trying to insert into the wrong table to set up permissions. You
should use the 'user' table for this. Eg:
INSERT INTO user VALUES
But I would recommend the command line command "GRANT" to do that
instead
See: http://www.mysql.com/doc/en/GRANT.html for details...
Odhiambo Washington wrote:
>Hello gurus,
>
>
>Please help. Where is my mistake?
>
>
>
>I get the following error...
>
>MYSQL: query failed: You have an error in your SQL syntax near ') < rei_ts' at line 1
>
>
>When I run the query below
>
>
> SELECT rei_ip \
> FROM relay_ip \
> WHERE
Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') < rei_ts' at line 1
When I run the query below
SELECT rei_ip \
FROM relay_ip \
WHERE rei_ip="${sender_host_address}" AND DATE_SUB(N
Chris Stoughton wrote:
> I have a table with a few million rows, wth 633 columns. I want to
> create 10 inidices on this table, six single-column and four two-column
> inidices. The database will be loaded once and remain static, and
> queried many times. Please note that this is a "small" p
--
Your message cannot be posted because it appears to be either spam or
Command 'your' not recognized.
simply off topic to our filter. To bypass the filter you must include
Command 'simply' not recognized.
one of the following words in your message:
Command 'one' no
1 - 100 of 105 matches
Mail list logo