| |
thread by: PayPal |
last post Aug 9 '05 by: PayPal
<html>
<head>
<title>Paypal-Account Alert</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="http://images.paypal.com/en_US/i/logo/email_logo.gif"></td>
|
thread by: sunny076 |
last post Aug 8 '05 by: Bill Karwin
Hi,
I am confused with the syntax for NOT in MYSQL where clause and wonder
if an expert in MYSQL can enlighten me. There are possibly two places
NOT can go in:
select * from employee_data where NOT employee_id LIKE 'A%'
select * from employee_data where employee_id NOT LIKE 'A%'
|
thread by: Jarn.Pritchett |
last post Aug 8 '05 by: Jarn.Pritchett
Hello,
We sent you an email a while ago, because you now qualify
for a much lower rate based on the biggest rate drop in years.
You can now get $327,000 for as little as $617 a month!
Bad credit? Doesn't matter, ^low rates are fixed no matter what!
Follow this link to process your application and a 24 hour approval:
|
thread by: Wells Fargo |
last post Aug 8 '05 by: Wells Fargo
<html dir=3D"ltr">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dwindows=
-1252">
<title>New Page 1</title>
</head>
<body>
|
thread by: siliconmike |
last post Aug 8 '05 by: Bill Karwin
How to find:
1. total size of data in bytes, in a record
2. total size in bytes of a record (including MySQL's own header bytes)
Mike
|
thread by: Wells Fargo |
last post Aug 7 '05 by: Wells Fargo
<html dir=3D"ltr">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dwindows=
-1252">
<title>New Page 1</title>
</head>
<body>
|
thread by: Lucas Gump |
last post Aug 7 '05 by: Bill Karwin
Is it possible to add primary keys to a table one-time and there are
already
multiple primary key defined?
I have to change sp_id, so_id as primary keys to the existing primary
keys
dn_slot_id and dn_mm_id.
I tried several times but all failed:
1. alter table debit_slot_detail add primary key (sp_id, so_id);
|
| |
thread by: Jay Vollmer |
last post Aug 7 '05 by: Bill Karwin
Hi everybody.
Can I use DBI to interface Perl with mysqld running locally rather than
with a 'true' MySQL server?
If not DBI, how can I do this?
aTdHvAaNnKcSe
--
|
thread by: zaphod |
last post Aug 7 '05 by: zaphod
Using MySQL Connector/ODBC 3.51, I set the port to a non-default value
(3309), under 'Connection Options' to connect to a remote machine running 2
versions of MySQL. 'Test' is successful but when I close the Connector/ODBC
window on XP the port setting is not saved so the DSN doesn't work.
Garry
|
thread by: hsifelbmur |
last post Aug 7 '05 by: hsifelbmur
does anyone know a product equivelant to MS SQL Server Reporting
Services, but for MySQL or PostGreSQL?
|
thread by: oeryavuz |
last post Aug 7 '05 by: oeryavuz
would be pleased if you help me solve my little problem.
i installed mysql (one of last versions) and startup.bar and shutdown.bat files dont exits in bin folder..
Do you have any idea what might be reason?
(no java compiler is installed on machine, jdk is installed.)
thank you
|
thread by: john.leonard.ireland |
last post Aug 6 '05 by: john.leonard.ireland
Hi all,
I don't know what I'm missing here, but if anyone could help me out I'd
really appreciate it. Basically, everything is fine, compiles,
installs, server runs, but the interactive mysql client breaks.
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to
install the binaries recommended on MySQL. However, when I...
|
thread by: HomerCritic |
last post Aug 6 '05 by: HomerCritic
I'm aware of the recent mysqldump change, in that it now by default
enables some optimizations.
One of those optimizations is to use single insert statements, instead
of separate insert statements, each on their own lines.
I'm also aware of the --skip-opt / -e / --skip-extended-insert
But what I'd like is a combination of having a single...
|
thread by: Tja.Bateman |
last post Aug 5 '05 by: Tja.Bateman
Hello,
We sent you an email a while ago, because you now qualify
for a much lower rate based on the biggest rate drop in years.
You can now get $327,000 for as little as $617 a month!
Bad credit? Doesn't matter, ^low rates are fixed no matter what!
Follow this link to process your application and a 24 hour approval:
|
thread by: Newsscanner |
last post Aug 5 '05 by: Newsscanner
Hello,
When trying to set up programs (dbQwikSite, Adobe Designer) to work with
ODBC databases, I encounter the following during setup of the programs:
"it connects, but if I set the initial catalog to any database it says:
"Test connection failed because of an error initializing provider.
Catastrophic Failure."
But when I connect with...
|
| |
thread by: Ken Massey |
last post Aug 5 '05 by: Gordon Burditt
First let me say I'm not interested in replication.
I want to sync a target database with a source database at regular intervals (say weekly), but
in the intermediate time they may differ.
The sync process should essentially "make the remote copy of this database look exactly like the
local copy".
I have seen some tools online that...
|
thread by: August |
last post Aug 5 '05 by: August
In my continuing attempt to make a user module for my CMS work, I keep
running into errors with the folowing query, which makes no sense to me
at all:
INSERT IGNORE INTO mos_comprofiler(id,user_id) SELECT id,id FROM mos_users";
where mos_comprofiler is a new parallel User DB and mos_users is the
original database of users. This first...
|
thread by: Angus Comber |
last post Aug 4 '05 by: Bill Karwin
I have set a password for the mysql root user so when I do this:
shell> perl -MCPAN -e shell
cpan> install DBI
cpan> install DBD::mysql
install DBD::mysql fails Is there a way I can run install DBD::mysql and
supply the password as a parameter - or get it to prompt me for it?
Otherwise anyone know how I can remove the password temporarily...
|
thread by: Paradigm |
last post Aug 4 '05 by: Bill Karwin
I want to store some passwords in a MySQL table. Is there any way of
preventing someone using say COntrolcentre from viewing the passwords.
|
thread by: Lakigam |
last post Aug 4 '05 by: zeldorblat
Hello
- I have 2 identical tables in the same MySQL database
- I want to copy some content of the first one to the second one
Any idea how to do this without using INSERT the DELETE ???
Isn't there any "moving" function ?
|
thread by: BadBob |
last post Aug 4 '05 by: Gordon Burditt
I installed a new application and it over wrote my passwords. I can not get
back in to mysql. Someone suggested there is a way to set the password
without knowing the old password. Can anyone help me with this?
Bob
|
thread by: vadnala |
last post Aug 4 '05 by: vadnala
I am a newbie and struggling to get the correct Column "Type". I really
appreciate if someone can shed some light here..
I have a table XXX which has 4 columns with types char(2), varchar(5),
int(10) and int(10) respectively.
But, when I use the following code, I don't get the correct type from
MYSQL_FIELD structure!!
int nSuccess =...
|
thread by: \Old Code Dude\ |
last post Aug 3 '05 by: \Old Code Dude\
Hi,
I have installed a ILS.
Installed MYSQL
Installed PHP on my XP PRO PC.
I want to test and develop a webshop local.
BUT...I got the PHP and ILS working.
The SQL im not sure about.
When I load the OSCommers webshop it lockes in step two (The SQL db
|
| |
thread by: O.B. |
last post Aug 3 '05 by: O.B.
We're running MySQL v4.1 on RedHat Linux v3. From time to time, queries
to the MySQL database start to execute very slowly (up to 15 minutes in
some cases). When we restart the MySQL service, the queries fast again
(1 second or less).
Is there a way that I can optimize the MySQL installation such that this
restart is not required?
|
thread by: sallybonbons |
last post Aug 3 '05 by: sallybonbons
I have tried looking this up and couldn't find a straightforward
answer:
I just want to find DISTINCT records on one column, but pick the most
recent one (a date in another column).
table:
id | price | date_entered
1, 5, 2005
|