This isn't exactly what I was looking for, but it works like a charm for
both my needs and the sys admins.
Go figure everyone is happy now!
Many Thanks!
-Tyler
Kishore Jalleda wrote:
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehen
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from around campus.
Specifically our MailLogs tables.
What I'm having a hard time with is we have metadata such as:
CREATE TABLE mail00 (
host varchar(32) default
Hello!
> another simpler solution :
> ...
Thanks, Mathias!
You helped me greatly!
Now my program works as desired.
--
Good luck!
Vladimir
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list
Hello!
Many thanks to everybody who tried to help me!
> N.B. you should have only one pnid to make your query work (UNIQUE pnid),
> or LIMIT the result of the subquery by LIMIT 1.
I need to do the following:
Get one or more than one "pnid" from vt_partition and then make queries to the
"vt_pni
Hello!
MySQL v. 4.1.11.
I'm trying to write a subquery, MySQL says "Error".
select num, theme, intro
from vt_(select pnid from vt_partition where pnid regexp '^[0-9]{11}$')
order by date desc, timer desc;
describe vt_parition:
+--+--+--+-+--+
Last week we upgraded from mysql 4.0 to 4.1.7. Since then some queries
on newly created tables (ie created since the upgrade) are failing with
the error:
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='
I have been doing a lot
* * * * * * * * * * * * * * * AntiVir ALERT * * * * * * * * * * * * * * *
AntiVir has detected the following in a mail from your address:
Worm/MyDoom.AE
The mail was not delivered.
Please remove any potential malicious software from your computer before
sending a new mail with attachm
I compiles a C application which uses mysql library on two RedHat 9.0 machines.
Both machines are using the same GCC and the same MySQL 4.0.16 :
MySQL-client-4.0.16-0
MySQL-server-4.0.16-0
MySQL-devel-4.0.16-0
MySQL-shared-compat-4.0.16-0
gcc-3.2.2-5
gcc-c++-3.2.2-5
libgcc-3.2.2-5
In the MACHINE
[EMAIL PROTECTED] wrote:
Did you perform a stack trace?
No, how do I do that?
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can someone help me find out what caused this crash?
My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz
with 2.5G ram. 3 disks in raid 5.
The MySQL database is 4.0.17
040212 19:27:36 read_const: Got error 126 when reading table
./exp4/sql_cache
Number of processes running n
Ah that's sheer genius!
Thanks muchly, I never figured in to being able to use SQL with it's own
"variables" so to speak - I'm sure I'll find more than one use for this new
ability!
Much appreciated Ed :)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PR
Hi all, I'll just get straight to the problem (simplified):
Say I have the following table/columns:
ID, Score, Rank
1, 20, 0
2, 50, 0
3, 10, 0
4, 5, 0
5, 97, 0
Is it possible, in a single query (using sub-queries if necessary), to give
all of these "ID's" the correct rank... ie if such a thing ex
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me :)
c.
> - http://friendfinder.com/go/p40688
>
>
> -->-Original Message-
> -->From: Admin-Stress [mailto:[EMAIL PROTECTED]
> -->Sent: Tuesday, November 11, 2003 11:44 AM
> -->To: [EMAIL PROTECTED]
> -->Subject: After installing MySQL 4.0.16 (rpm), i
Hi,
My server is using RedHat 9.0.
I just CHANGED the mysql from 3.23.58 (rpm) to 4.0.16 (rpm).
What I did :
# rpm -e
# rm -rf /var/lib/mysql
then install the 4.0.16 (rpm)
# rpm -i MySQL-server MySQL-client ... MySQL-devel ... MySQL-shared-compat
After this,
I can start the
I have a table called TRANSACTION, it has some fields :
REGDATE - date of the transaction
WHAT - a string (NOT UNIQUE)
CUSTOMER - customer code
I want to query all WHAT that the date of the transaction was 15 days before.
So, my sql query is :
SELECT WHAT FROM TRANSACTION WHERE REGDATE < Now()
I have a numeric table field, named "CREDIT".
How can I add a number (+50) to that field for all the table record ?
is this correct?
UPDATE ThisTable SET CREDIT=CREDIT+50
Please help,
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuar
Hiya,
Is there any way to do a hexadecimal search via MySQL? I've found that the
data I uploaded from text files has some end-of-line characters in it, and
its causing my data to break in mid-line when spitting out a text file.
Would be cool to search the table for offending characters if possibl
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk cachi
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days ago and class = 1?
thanks
__
D
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited from the regular table.
Doesn't look like thats the case with MySQL
>
> In MySQL, I need to do a multi table join in the context of a left
join. Have three
> tables: NAME, ADDRESS, and COUNTRY. Address contains a country code
(ie
> "CAN") and COUNTRY contains the translation (ie Canada). What I'd
like to
> do is get all NAMES, all datat from ADDRESS if it e
Hi,
I am new to mySQL, so I need some help.
I have a table, which has record structure like this:
- customer
- name
- register_date
- expired
Every day, I add some records, new customers. The field 'expired' is just a flag,
either '1' or
'0'.
If register_date is 3 months ago then expired = 1.
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
Hi,
I finally established a connection to my db after I realized that it was
located in a different directory than that which I kept placing my php
files. As some would say, "D'OH!"
The code below is intended to select and display all 1300 names from the
NAMES_TBL but is only returning the fir
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed automatically?
void error(int code) {
printf("error: %d\n", code);
exit(0);
}
int main() {
...
error(-255);
...
}
How to pass the mysql database connector to a function? is
Hi,
I wrote a simple CGI application using mysql. What it does is really simple :
connect to mysql database
... do something ...
update a field
... do something again ...
close mysql
The update is like TOTAL = TOTAL + AMOUNT.
If let say, 1000 users accessing my CGI in the same ti
>Description:
When running mysql-test-run the test aborts with the following message:
Installing Test Databases
Removing Stale Files
Installing Master Databases
021124 1:25:15 Warning: Can't create thread to handle bootstrap
021124 1:25:15 Aborting
021
Hi,
After I installed mysql, I noticed there is an open port now, port 3306.
Can I restrict this so only from localhost can connect? I meant to close port 3306.
But without using firewall :( I dont have knowledge about this.
If there is no way to do this without firewall, then I will learn it.
I
After playing around with 'test' database, then I would like to create my own database.
I logged in into mysql using root account and created a database.
But, when I logged in using regular user, I got his error :
ERROR 1044: Access denied for user: '@localhost' to database 'card'
What necessar
Hi,
I am just a starter. Anyone can suggest me good web resources for learning SQL command
that I can
use (compatible) with mySQL ?
I read from www.mysql.com documentation, but it's not complete ...
Well, if you have collection for beginner, please :)
Thanks,
kapot
__
Hello all,
I have came across a pretty peculiar problem and am hoping someone can help
me out.
Each time I try to connect to a MySQL server on my network, I receive the
following error:
Lost Connection to MySQL Server during query
It isn't just one server that is giving me this problem, it is
s not in their documentation.
So ... I am going to bypass the hosts administrative interface and find
my own way in, see if that works (yea, one more thing to do) and maybe
do a positive binary dance or some chanting. If I don't make progress
on this in the next day I&
ent on my master database on replicated tables
it is not replicated to the slaves (even though the statement is replicated
to the relay log on the slave servers).
>Fix:
Unknown
>Submitter-Id: miguelryan
>Originator:MySQL admin account
>Organization: freelan
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:FR/I/*KO_TBD// Admin Apache
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priorit
Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql serv
can MySQL run as cluster under the platform of IBM AS/400 also??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Can MySQL or PostgreSQL build up a cluster for failover or improve the
database performance just like Oracle or Sybase ones?
If can, where we can get such setup documentations?
-
Before posting, please check:
http://www.mysql
Hi,
Thx for all your help, I can export the tables in exportSQL scripts.
But how to make the procedure of inserting data more easy instead of
using mysql daemon od MySQL GUI?? Both of them need to use Sql language to
insert data. Any software or tools like Microsoft Access or Lotus Approach
How to migrate Microsoft .mdb Database into MySQL under Unix
environment?? Who can tell me?? Any Doc??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi.
You forgot "" around temp example:
mysql>select datetime,temperatura from temperatura where
datetime="2002-02-08 09:30:00" and temperatura="15.8";
Regards
/PM\
Miguel Figueiredo wrote:
>
> Hello all,
>
> I have a (probably dumb) question.
> My table "temperatura" has two fields described b
Hi.
I prefer doing like this
$query = "CREATE TABLE query ";
$query .= "tabledef for col a,";
$query .= "tabledef for col b,";
$query .= "lots more table defs,";
$query .= "welcome to line 400";
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wro
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql->connect(undef,"database","username",'password');
$sql = "select blah from blah";
$sth = $dbh->query($sql);
@arr = $sth->fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is ot
Hi.
You forgot "" around temp example:
mysql>select datetime,temperatura from temperatura where
datetime="2002-02-08 09:30:00" and temperatura="15.8";
Regards
/PM\
Miguel Figueiredo wrote:
>
> Hello all,
>
> I have a (probably dumb) question.
> My table "temperatura" has two fields described b
Hi.
I prefer doing like this
$query = "CREATE TABLE query ";
$query .= "tabledef for col a,";
$query .= "tabledef for col b,";
$query .= "lots more table defs,";
$query .= "welcome to line 400";
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wro
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql->connect(undef,"database","username",'password');
$sql = "select blah from blah";
$sth = $dbh->query($sql);
@arr = $sth->fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is ot
the BDB
tables as well,is that using '--with-berkeley-db=./bdb' enough?
I'm waiting for your replying and thank you for that!
admin
[EMAIL PROTECTED]
-
Before posting, please
Hi.
I would type museum: department or likewise in name field
if its not so many it would work nicely.
But thats just me:)
/PM\
"David S. Jackson" wrote:
>
> Hi,
>
> I came across a relationship between entities that I hadn't
> counted on, and I'm trying to adjust my database tables to handl
Hi.
Seems the paths are missing so try running locate mysql or find -name
mysql
from basedirectory.
/PM\
Stephane Pinel wrote:
>
> I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
>
> Everything seems to be OK (the server runs) but I cannot connect to it using
> mysql client
Hi.
Not only that you also sent it to the wrong person:)
It was david that asked the question anyway i cc it to the list and him.
sometime i will experiment with that also but time is to short:)
Regards
/PM\
Ed Lazor wrote:
>
> doh... I should go to bed... I just reread what I wrote and it da
Hi.
I would do a simple read file,search database,input record script in
perl
and transfer the files using scp (ofcourse i asume this is in
linux/unix)
put it all under cronjob and it should work fine.
On the other hand i am sure others have better ideas:)
/PM\
David Shields wrote:
>
> Hi,
SNIPSNIP:)
> > I agree. If they are a seriuos company they should build it after the
> > customers wishes
> > i.e if you want mysql the company should build it with mysql.
> >
> > For 18,000 euro i could build the system myself:)
> >
> > My two cents
> > /PM\
>
> What about the customer who asks
Jeremy Zawodny wrote:
>
> On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
> >
> > Hello all!
> >
> > We've requested a database from different companies, and
> > specifically said we wanted MySQL or PostgreSQL because of the open
> > source angle and we're a library.
> >
> > One
Julian,
The "as" field is just setting the name of the field or column. For example
in PHP, if you don´t use the "as somename", you must use array[2] (I just
use 2 as an example) instead of array['datefield'] to get the information.
Regards,
Ingvar G
Web accounting & CRM
us.logiledger.com
Thanks Richard and you others for good input concerning "Annoying article",
I myself have nothing but good experience from using the MySql database but
reading articles like this one and another one on the same web talking about
"when you outgrow MySql, then you must change to the more advanced d
I was just reading an annoying article from a user who was moving from MySql
to Postgres because of stability problems and because of problems restoring
"large" MySql data-dumps. I checked his site and it does not have the
appearance of a very heavy loaded site so I am not sure what he means by
la
Dear support officer,
The followings are generated by the mysqlbug script:
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: yuzh
To: [EMAIL PROTECTED]
Subject: [50 char
I am working on a project for a client that got roped into MsSQL7 by her
last hosting company. I am looking for a good way to convert a MsSQL7
Database to MySQL. Anyone know of a piece of software that will convert the
Database files or atleast suck from one database to the another.
Thanks in adv
Hi Nicole,
I guess the first issue is to be certain that you have the
correct password and a MySQL account set up. If you have a
shell account try something like mysql -u[your user
name] -p[your password]. Sometimes ISP's will use different
passwords for MySQL than the standard log in, we often
Hello,
I'm contacting you because we have recently released a new web development platform,
EO, that I would like for you to try out for use in building dynamic sites.
EO is a portable, flexible yet robust system that you can use to quickly build
interactive sites, plus it has features that p
sorry im a mysql newbie...how do you bind mysql to two particular ip
addresses? i have it bound to my loopback but would like to bind it a
private ip but it doesn't seem to like the bind-address directive more than
once.
-
Befo
Hi,
I recently had some questions about converting files and
haven't had the chance to work further with it or thank
everyone for the help. So thanks a lot.I found that my
application
needed to have a dedicated MySQL installation. There is
another version of MySQL running on this machine (Red
Hi Paul,
Thanks for the help. I was hoping to accomplish this with MySQl, but in the
end a script works just as good and this is just the first of several I am
using. For what it's worth I ended up using sed. Here is is if somone else
could use it:
sed "s/ /|/g"
^This is a tab,
Hi,
Being new to MySQL, I am having a problem getting output from it to the
shell that is formatted the way I need. I need a table to be written to a
file with a delimiter.
something like :
#!/bin/sh
mysql -uroot -ptest database < sql
Then I run that script like this:
./script.sh > output.txt
wrote:
>
> - Original Message -
> From: "System Admin." <[EMAIL PROTECTED]>
> To: "Àä·ç" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 11, 2001 9:31 AM
> Subject: Re: 3.23.36 in solaris8 x86
>
>
> Hi,
> Did you get the pre-comp
Hope this works:
I'm VERY new to php and mysql - ANY information on setting up and running php scripts
with mysql are greatly appreciated.
V
Jez & Vlad
GothNetwork & The Underworld
http://www.gothicunderworld.com
http://www.gothnetwork.com
http://www.theblackpath.com
http://www.thewebchain.ne
66 matches
Mail list logo