Hi,
I've a situation where I want to put an ascii file as a set of rows in a
table (one per line), whereas it may appear that some do already exist.
In either case, I'm looking for 1 command that just puts the set of rows in
the table. Is that possible in MySQL?
In normal behavior, this
* Pushkar Pradhan
I'm trying to enforce one column of my table to contain strictly 6 chars.
string. However I've some columns of type VARCHAR (e.g name, etc.) so
mysql silently changes the column to VARCHAR.
Right.
Is there any way I can force the column to contain only 6 chars.
Yes, you
* Pushkar Pradhan
I'm trying to enforce one column of my table to contain strictly 6 chars.
string. However I've some columns of type VARCHAR (e.g name, etc.) so
mysql silently changes the column to VARCHAR.
It is ok for MySQL. You can find some info here :
Oleh,
SELECT t1.id, Max(t2.data)
FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
GROUP BY t1.id
HAVING Max(t2.data) IS NULL;
As temporary solution try to use next query:
SELECT t1.id, Max(t2.data) as MaxData
FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
GROUP BY t1.id
Hallo,
Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner
Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden.
Vielen Danke.
hi
i have the same problem with converting CDS ISIS to any other dbms
but i know that CDS ISIS can export data in ISO format , the question here ,
can MySQL import ISO file , and how ?
Thanks
regards
USAMA*
_
Join the worlds
Hello mysql,
In case of repliacation circle (A-B-A) query 'flush log' on any of
this servers create endless loop, with creating new binary log file
on each iteration. (about 30 new files every second in my case)
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
To whom it may concern,
I had a bad starts!!!
I was trying to start working with MySQL with Windows 98 so I downloaded
the file myodbc-21.50.39-win95.zip to install the drivers for ODBC, after
unzip this file (obviously) I executed the file SETUP.EXE receiving the
following message:
Hi,
Please write in English to this mailing list, or go to a German one.
Vielen Danke, :-)
Bye
Daniel
At 11:04 2002.08.15. +0200, you wrote:
Hallo,
Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
Ausserdem wie vermeide ich, dass meine Festplatte bei der
Hello,
I have a mysql database latest version from the freebsd ports running on a
350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server.
I have a database with 5.5 million record in say 1 table. We use this
read-only.
It seems that when i do a select and the result is minimal
Reinier,
It seems that when i do a select and the result is minimal it uses the
index(fast about 3 sec), but when the result is much more it is not using
the index. this results in a lot of disk io and taking to much time.
It is correct, because
everytime i submit a query, it closes the connection to my (remote)
database - why?
Jan
Jan Davies
animonkeyweb design, animation interactive media
07 808 120 310
-
Before posting, please check:
Ivo,
Thursday, August 15, 2002, 9:55:25 AM, you wrote:
IBin I've a situation where I want to put an ascii file as a set of rows in a
IBin table (one per line), whereas it may appear that some do already exist.
IBin In either case, I'm looking for 1 command that just puts the set of rows in
IBin
Mary,
Wednesday, August 14, 2002, 7:23:47 PM, you wrote:
MS here is is ...
MS 'check to see if agent/dist code are already in temp table
MS sSql = SELECT * _
MS FROM TempSap _
MS WHERE ProducerID='
Chugh,
Tuesday, August 13, 2002, 2:40:54 PM, you wrote:
CS We are in the process of transferring our databse from Oracle to MYSQL.
CS Oracle has some triggers to insert into the table on some events. How can we
CS handle this dynamic insertion of triggers in MYSQL.
CS Also what is the
Devore,
Thursday, August 15, 2002, 12:05:13 AM, you wrote:
D I'm having trouble with a vbulletin database running mysql as the back end.
D It's running on linux server. Basically we had some weird problems and was
D hoping someone else has seen this. First the boards went down because
D
Daren,
Wednesday, August 14, 2002, 11:49:22 PM, you wrote:
DC My Linux installation only has about 1gb in the /var
DC partition, so I need to relocate my databases to the
DC /home partition. I'm pretty sure the following
DC commands will shutdown mysql, move the data directory,
DC create a
Will,
Wednesday, August 14, 2002, 2:07:04 AM, you wrote:
WK These questions may sound kinda basic, but here goes...
WK 1.) What if I want to print (on paper) the contents of my MySQL database,
WK then how do I do it?
You may put data in the text file and print the contents of those
file. Use
Tab,
Wednesday, August 14, 2002, 11:06:36 PM, you wrote:
TA Is there a tool out there for Windows that will let me monitor how many
TA connections to my MySQL database are currently open at any given moment?
Use SHOW PROCESSLIST command:
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Reinier,
Thursday, August 15, 2002, 1:13:32 PM, you wrote:
RvH I have a mysql database latest version from the freebsd ports running on a
RvH 350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server.
RvH I have a database with 5.5 million record in say 1 table. We use this
RvH
Mike,
Thursday, August 15, 2002, 12:45:06 AM, you wrote:
MH Hi there,
MH I posted this a few days ago and recieved no responses, so I thought I would
MH post it again:
Mike, I answered you yesterday.
MH Hi All;
MH I am working on a front end to my database, but I am running into a bit of
MH
John,
Wednesday, August 14, 2002, 12:26:29 PM, you wrote:
JMH data chunk below.
Description:
JMH Bug in SQL parser.
JMH --BEGIN CUT--
JMH
eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj
JMH
On Thu, 15 Aug 2002 [EMAIL PROTECTED] wrote:
Hallo,
Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner
Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden.
Vielen
Well, that's strike one for me! I sent my first post
to the list and accidently ONLY sent it to one member
of the list (who was kind enough to respond anyway!)
My problem is that I am unable to change data in an
existing table. I use the UPDATE function and it
continues to tell me that I am
On Thu, 15 Aug 2002, Benjamin Pflugmann wrote:
Let me try to explain.
snip
Last, an introduction into LEFT JOINs:
snip
Benjamin,
this was a very good explanation. I would love to see an edited version of
your post included in the Tutorial section of the very fine manual.
Regards,
Thomas
Art,
Thursday, August 15, 2002, 7:12:40 AM, you wrote:
AF Having a hard time coming to grips with the password setup for mysql in
AF windows. I follow the instructions below from the documentation.
AF C:\ C:\mysql\bin\mysql mysql
AF mysql DELETE FROM user WHERE Host='localhost' AND User='';
AF
Our server seems to think it is a slave. It has a slave thread rnning,
whose only action is to complain once a minute about not being able to
connect to master . This just started one day, when we took the server
down and brought it right back up.
I'd like to get rid of the slave thread, but I
Hi,
It's my first time for using MySQL.
I would know, why does it generate such giant temporary files. And what should i do to
save my disk from getting
filled by these files.
Regards
Semia
-
Before posting, please check:
Hi,
It's my first time for using MySQL.
I would know, why does it generate such giant temporary files. And what should i do to
save my disk from getting
filled by these files.
Regards
Semia
-
Before posting, please check:
ok , but I have now just programmed around the error
to meet my deadline...
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: null
Mary,
Wednesday, August 14, 2002, 7:23:47 PM,
* Jones Tyler
My problem is that I am unable to change data in an
existing table. I use the UPDATE function and it
continues to tell me that I am using an Unknown
Column.
That's right, you are... :)
When I do a DESCRIBE on the table, I clearly see the
column.
Since I can see the column
I have the mysqlgui installed on my machine which has Win NT. The db is on
another machine, which I connect to using Telnet, and then the mysql command
to connect to the db. That works fine. I want to however connect with the
gui to the db on the other machine which I connect to using Telnet
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri
es=$log_dir
That is all I have changed and re started mysql. but no slow_slog.log file
has been
Artem,
Thursday, August 15, 2002, 12:06:07 PM, you wrote:
AVR In case of repliacation circle (A-B-A) query 'flush log' on any of
AVR this servers create endless loop, with creating new binary log file
AVR on each iteration. (about 30 new files every second in my case)
Thanks for bug
samia,
Thursday, August 15, 2002, 3:45:27 PM, you wrote:
s It's my first time for using MySQL.
s I would know, why does it generate such giant temporary files. And what should i do
to save my disk from getting
s filled by these files.
MySQL uses temporary tables in some queries. So, if you
Still could not get it to work so I uninstealled and reinstalled. Will use
the anonymous login etc util I figure out this security system. Is there a
document that explains the password system in laymans terms?
Art
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Elna,
Thursday, August 15, 2002, 4:16:59 PM, you wrote:
EM I have the mysqlgui installed on my machine which has Win NT. The db is on
EM another machine, which I connect to using Telnet, and then the mysql command
EM to connect to the db. That works fine. I want to however connect with the
EM
Bill,
Thursday, August 15, 2002, 3:43:03 PM, you wrote:
BE Our server seems to think it is a slave. It has a slave thread rnning,
BE whose only action is to complain once a minute about not being able to
BE connect to master . This just started one day, when we took the server
BE down and
-Original Message-
From: DRISSI,SAMIA (Non-A-hsgGermany,ex1)
Sent: Thursday, August 15, 2002 4:06 PM
To: [EMAIL PROTECTED]
Subject:
Hi,
Bei running one application on MySQL, the server generates a giant temporary file.
At the same time i call the application again, and keep all old
HI,
MySQL keep the temporary files until it's closed down.
Is there somme possibility to remove them as soon as they are no longer needed??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi people,
I ´ve converted from an ISIS database to Mysql. The opposite also is
possible. As you know an ISIS tech database could not be relational. Perhaps
you want to make some normalization first. I have done this using ISIS_DLL
from VB, firs created an Access Database, exported to text
The mysql user needs write permission on the directory
/usr/local/mysql-3.23.51/var
Mark Gillett wrote:
Having done some further work (I re-built using 3.23.51) I have managed to
have the server startup and run, however I am still experiencing the :
020814 15:25:48
Thanks for the reply Egor.. This helps, but what I'm really hoping to
find is a GUI that updates itself on the fly, kind of like the Win2k
Task Manager processes tab. Anybody got anything like this?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August
I got an error while executing myisamchk -rq on compressed table. Here's the
output:
[root@db prod_rel5_1_0]# myisampack buyer
Compressing buyer.MYD: (3687550 records)
- Calculating statistics
- Compressing file
62.69%
Remember to run myisamchk -rq on compressed tables
[root@db prod_rel5_1_0]#
...I'm really hoping to
find is a GUI that updates itself on the fly, kind of like the Win2k
Task Manager processes tab. Anybody got anything like this?
I am really happy with this one http://www.anse.de/mysqlfront/
It can do that and a lot of other nice features.
Best regards,
Mikhail.
-- Forwarded Message --
Subject: I cannot get mysql to run.
Date: Thu, 15 Aug 2002 11:02:08 +0100
From: Barry Schofield [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all
-- Forwarded Message --
Subject: Cannot run any I configure
Date: Thu, 15 Aug 2002 11:08:26 +0100
From: Barry Schofield [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [I have tried rpm's and 4.0 version and your
Is the MySQL serving a web site? If yes, wrap show processlist in perl
or php and have it generate an auto refreshing page.
On Thu, 15 Aug 2002, Tab Alleman wrote:
Date: Thu, 15 Aug 2002 11:01:44 -0400
From: Tab Alleman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: View current
Did you check your error logs?
Does mysql have write permissions to /home/admin ?
John Wards wrote:
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file
Does anyone know if version 4.x has/will have warnings if data being inserted
is too large for a column?
sql,query
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
If it's not broketweak it
Hello,
Is there a compile option or startup option to make mysql ignore table name
case? So that the tables security and Security would be seen as the same
table?
-James
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801
Typically when using the C API, when you do a Select, MySQL hands
back a virtual table where the fields (columns) are marked with
various kinds of info - their name and source table, as you might
expect, but also stuff like whether this field is the primary key for
its table.
So for example
Answer is No.
Case-sensitivity of table names depends on operating system you are
running mysql on.MySQL stores table definitions in TABLENAME.* files. So
it will always be case-sensitive on *nix and case-insensitive on
windows.
Nilesh
-Original Message-
From: James Kelty
At 9:59 -0700 8/15/02, James Kelty wrote:
Hello,
Is there a compile option or startup option to make mysql ignore table name
case? So that the tables security and Security would be seen as the same
table?
--set-variable=lower_case_table_names=1
But you should rename your tables to lowercase
Well, I guess that ISN'T really the case.
http://www.mysql.com/doc/en/Name_case_sensitivity.html
Sorry that I asked the question at all, but thanks for the replies.
-James
-Original Message-
From: Nilesh Shah [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:20 AM
To: James
Hi Eduardo,
I found the solution the left outer join + aggregate problem I had earlier
faced.
the query should be
SELECT p.nm_project, sum( dl.hours)
FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project =
dl.id_project
I have been using the following code and have been getting warnings:
LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY
'\t' LINES TERMINATED BY '\n' (myfields);
Query OK, 206 rows affected (0.13 sec)
Records: 206 Deleted: 0 Skipped: 0 Warnings: 14
How do I find out what the
I have been using the following code and have been getting warnings:
LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY
'\t' LINES TERMINATED BY '\n' (myfields);
Query OK, 206 rows affected (0.13 sec)
Records: 206 Deleted: 0 Skipped: 0 Warnings: 14
How do I find out what the
I have a database called test
in the mysql database db table it is listed as
test and test\_%
what is the significance of two record that have all the Y/N entries the same?
.
-
Before posting, please check:
On 15 Aug 2002, at 10:45, Brian Fahey wrote:
How do I find out what the warnings are? I haven't been able to find
anything about what they are.
Paul DuBois has a Perl script, load_diag.pl, that could answer your
question:
http://www.kitebird.com/mysql-cookbook/
Or you could export the
I downloaded and built mysql-3.23.49 on my BSDI 4.1 system. It configured
and built fine, but it hangs whenever I do more than the most trivial
operations.
It is my dim recollection that there have been problems with the thread
libraries in the past. Does this ring a bell?
(I can't use the
filter fodder: sql, query
Hi all,
I feel like I am probly being amazingly stupid, but here goes nothing.
I have 3 tables:
students
undergrads
postgrads
students holds all common info. eg dt_matric, dob, religion, etc.
undergrads hold eg. degree, subject
postgrads holds eg. transfer_date,
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 include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply
I am having some problems getting multiple joins to work. I have the
following code:
mysql select customers.customer_id, last, first, company,
count(work_order.work_order_number) as WO
- from customers left join work_order
- on (customers.customer_id=work_order.customer_id)
- where
Hello Everyone,
We are attempting to use a Perl script to access MySQL on Red Hat Linux
release 7.2 (Enigma) Kernel 2.4.7-10 on an i686
Unfortunately, the below error keeps appearing:
-
install_driver(mysql) failed: Can't locate loadable object for module
DBD::mysql in
Hej
I have several databases with several tables in them and all works fine
except for one database that loses data.
I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB.
The problem is as follows:
Table B references table A by a foreign key. I've filled table A with all the
data I
Hi everyone!
I'm fairly familiar with the table locking methods in MySQL but I have a
problem I can't solve.
I have two main tables which are read simultaneously by many clients. The
clients only do reads, but they do it very extensively and for 30 secs each.
The two main tables needs updates
I am used to working in MySQL, and am now working with MS SQLServer :(
I'm hoping someone else has been in this unfortunate situation before and can help me
out.
I'm looking to do pagination of some resultset in JSP.
in MySQL I would have used something like:
SELECT * FROM mytable ORDER
Hi,
I don't know MSSQL well, but what about TOP ?
Regards,
Jocelyn
- Original Message -
From: Michael Marano [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 10:37 PM
Subject: LIMITing result sets - Spoiled by MySQL
I am used to working in MySQL, and am now
Well, I am not sure about MS, but in Oracle you have to use the rownum
pseudocolumn and a pseudocolumn, an example:
SELECT * FROM (SELECT * FROM mytable ORDER BY somedatefield) WHERE rownum
20 AND rownum 30;
or something like that. It may be similar for MSsql, I am not sure.
Mike
P.S. my
Hi,
in the piece of code given below
---
$qid = mysql_query(
SELECT *
FROM 1_nodedata
WHERE id = $edit_id
);
$frm = mysql_fetch_array($qid);
---
i get the follownig error:
Warning: Supplied argument is not a valid MySQL result resource in
Anna,
please check with
SHOW VARIABLES
if InnoDB is enabled in mysqld.
Also check with
SHOW CREATE TABLE tablename
that your tables really are of the InnoDB type. Error 127 means the 'table
is crashed', and I think only MyISAM type tables can return that error
number.
An upgrade to 4.0.2
is there a way to give certain users rights to create and drop mysql
databases
without being administrators?
I'd like to create a new database every time a user runs my code on a
new set of data.
thanks
Josh
-
Before
Anil,
You never created a connection.
mysql_connect()
Regards.
Thursday, August 15, 2002, 1:12:21 PM, you wrote:
Hi,
in the piece of code given below
---
$qid = mysql_query(
SELECT *
FROM 1_nodedata
WHERE id = $edit_id
);
$frm = mysql_fetch_array($qid);
---
hi,
m sorry i dint mention that its just a part of code.
i am able to delete entries from the database .so i think mysql_connect is
not the reason.
please tell if u have some more ideas
regards
anil
- Original Message -
From: SteveH [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
create table EAP (eapID int auto_increment primary key,
Name varchar(60),
Addr1 varchar(50),
Addr2 varchar(50),
City varchar(30),
State varchar(2), index state_ind(state),
please how can i set Sql command on connect to be able to connect to
mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still
couldn't connect.help please. i have tried with both static and
semi-static files.
thanks.
Hi,
try :
$qid = mysql_query(
SELECT *
FROM 1_nodedata
WHERE id = '$edit_id'
);
$frm = mysql_fetch_array($qid);
(what does echo edit_id : $edit_id; display ?)
Regards,
Jocelyn
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
In the last episode (Aug 15), Anil Garg said:
Thursday, August 15, 2002, 1:12:21 PM, you wrote:
Hi,
in the piece of code given below
---
$qid = mysql_query(
SELECT *
FROM 1_nodedata
WHERE id = $edit_id
);
$frm = mysql_fetch_array($qid);
hi,
m sorry
yes..it echos $edit_id fine.
i am also feeling strange why its not working!
regards
anil
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Anil Garg [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 5:40 PM
Subject: Re: Supplied argument is not a valid
Let's try this :
$qid = mysql_query(SELECT * FROM 1_nodedata WHERE id='$edit_id') or
die(mysql_error());
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 11:42 PM
Subject: Re: Supplied
can u plz tell me how can i check that?
regards
anil
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Anil Garg [EMAIL PROTECTED]
Cc: SteveH [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 5:41 PM
Subject: Re: Supplied argument is not a valid MySQL result
Jacob,
- Original Message -
From: Devore, Jacob [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 12:20 AM
Subject: RE: Losing data
can one change a table from MyISAM tables into something else on the fly?
ALTER TABLE tablename TYPE = sometype
At 8/15/2002, you wrote:
Hi everyone!
I'm fairly familiar with the table locking methods in MySQL but I have a
problem I can't solve.
I have two main tables which are read simultaneously by many clients. The
clients only do reads, but they do it very extensively and for 30 secs each.
The two
Well, I am not sure if anyone has experienced the same problem, or if this
problem has been documented, but this is what I have noticed:
After one of my data table was full, I started to delete old records from
the table to allow new data to be inserted. Since then, the LIMIT function
stop
At 8/16/2002, you wrote:
Hi,
in the piece of code given below
---
$qid = mysql_query(
SELECT *
FROM 1_nodedata
WHERE id = $edit_id
);
$frm = mysql_fetch_array($qid);
---
i get the follownig error:
Warning: Supplied argument is not a valid MySQL result resource in
Hey all,
I've been given the task of adding a few hundred, and later a few thousand,
new records to my database that currently exist in (ugh...) an excel
spreadsheet. I was able to very quickly and efficiently deal with the
initial insertion of the main data to the main table, but am having
I have a column defined in a table as type date. I desire to include a date
comparison in the WHERE clause of the following statement. The following
statement is not working correctly, I suspect that there is a formatting
issue. The statement returns true even if USER.elig_date has an earlier
Hi,
What version of MySQL are you using ?
Regards,
Jocelyn
- Original Message -
From: Song, Jay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 11:57 PM
Subject: Is this a known issue?
Well, I am not sure if anyone has experienced the same problem, or if
I'm using MYSQL Ver 3.23.49a.
Thanks.
Jay Song
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 6:20 PM
To: Song, Jay; [EMAIL PROTECTED]
Subject: Re: Is this a known issue?
Hi,
What version of MySQL are you using ?
Regards,
what dir is mysql.sock in?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
Michael,
I do not believe there is a real equivalent. SQL Server supports the
'TOP' statement. It is like using the one-argument variation of
MySQL's LIMIT clause. It looks like:
SELECT TOP 20 foo FROM BAR
The obvious problem is that this is pretty much useless for
pagination,
Hi friends:
I try to grant privileges to a user named 'glen' but not succeed. Here is
the script:
-#
mysql update user set Password=password('tidbs1') where User='glen';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1
Hi friends:
I try to grant privileges to a user named 'glen' but not succeed. Here is
the script:
-#
mysql update user set Password=password('tidbs1') where User='glen';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1
I'm working on building an online scheduling system. I want to be able
to select all the users who don't have any scheduled commitments on the
next weekend and then sort based on when the users next scheduled spot
is. I have a few problems however. First of all I have a set of users
who don't
To anyone who can help,
I'm still struggling to build a working 4.0.2 libmysqld.a library on
the Compaq Tru64 (formerly Dec OSF) platform. I now have access to the
Compaq C++ compiler, but any libraries that I build still crash in the
thread functions, as follows:
Program terminated
Hi all
I have Mysql Version: 3.23.49a at RadHat 7.2
I read the documentation about automatic startup/shutdown
but when I start the script it wait for a ENTER
then it doesn't work at boot
I always need do manual startup
anybody have any hint ??
ats
Paulo
Does anyone know of a solution that would allow me to setup faxing into a
MySQL database, preferably GNU?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I have expereience the same behaviour when using the ppm from
activestate. Try using the one below, seem to work for me...
ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14,
Anyone know of an email marketing software suite that works well with MySQL
on the
backend?
I've seen stuff that works with ODBC db connectivity but I'm not interested
in moving to MS SQL or Access.
Any feedback is appreciated
Thanks
Mark
1 - 100 of 121 matches
Mail list logo