While I was away from the Internet, it struck me that the problem has to do
with a "python egg", not, as you mention, with MySQL.
Thanks,
Pat
Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
> First up, the sites were working fine until the old server went buggy. I
> h
mysqluser localhost mrtableclo 9210 Sleep
So, apparently it's asleep. How do I wake it up ;)
TIA,
Pat
Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Pat Singer wrote:
> Hi;
> I just built out a new server and transfered my databases. I use Zope to
> server m
that seems to be fine. It
connects to the database. However, when I go to look at the pages from served
the database, the browser hangs. Any ideas how to troubleshoot this?
TIA,
Pat
-
Shape Yahoo! in your own image. Join our Network Research Panel today!
erver version for the right
> syntax to use near 'update COMPANY_NUMBERS_tmp_Mikhail c join
> tmp_HEMSCOTT_MKTVALUES t on c.ticker =' at line 1
>
Explain only works with tables and SELECT queries:
http://dev.mysql.com/doc/refman/4.1/en/explain.html
--
Pat Adams
Digital Darkness
.html describes
the pitfalls of running multiple servers on the same machine about
halfway down the page in the bold 'Warning' paragraph.
--
Pat Adams
Digital Darkness Promotions
Dallas Music Wiki http://digitaldarkness.com
--
MySQL General Mailing List
For list archives: http://lists.m
> more of a problem with subselects because how does one alias it?
> Servlet sql:
>
> sql = "SELECT " +
> "u.id as user_id, " +
> "u.first_name as fname, " +
You're aliasing it as fname
ame index defined
twice. Since the leftmost column in your primary key is referer, you do
not need it as its own index.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas Music Wiki http://digitaldarkness.com
signature.asc
Description: This is a digitally signed message part
On Mon, 2006-06-12 at 13:32 -0400, Jesse wrote:
> > Um, did anyone actually answer Jesse's question?
>
> The consensus seems to be that the correct way to pronounce it is My S-Q-L,
> Not My Sequel. So, that's the way I'm going to pronounce it. Actually,
> most of the people I say the name to h
inst NPTL.
>
> This appears on my config.log session:
>
> --enable-threads=posix
> Thread model: posix
>
> Is that NPTL? I know NPTL is POSIX, but maybe this should say Thread
> model:
> NPTL.
NPTL stands for Native POSIX Thread Library, so yeah, it's using NPTL.
the correspoinding action
> id,
> they should be 456 and 431 instead...
If you don't include id in either an aggregate function or the GROUP BY
clause, MySQL 'helps' you by choosing a seemingly-random value to stick
in the id field.
--
Pat Adams
Digital Darkness Promoti
her precedence, so the expression is
interpreted as (t1, (t2 JOIN t3)). This change affects statements that
use an ON clause, because that clause can refer only to columns in the
operands of the join, and the change in precedence changes
interpretation of what those operands are."
--
Pat Ada
On Thu, 2006-04-20 at 19:15 -0400, fbsd wrote:
>
>
> can someone please just send me or post a example of editing feilds
> of a
> mysql database within an html form and then updating the values
> thanks alot
These should tell you everything you need to know.
http://www.php.net/manual/en/ref.mys
ition not taken?
Try print($result[0]) or print($result['logon_id']); $result is a handle
to the result set, not something you can print. It's the same thing as
if you tried to print out the return value of mysql_connect, which
should return a resource id. There wasn't an error
n the
> answer here. Does it mean that the price for both
> MySQL Developer Exam I & II are US $200? ie US $200
> cover the two exams
$200 for the core certification, and $200 for the Professional
Certification.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas M
rl-DBI RPM without src in the
filename.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas Music Wiki http://digitaldarkness.com/tiki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e tables from being destroyed."
If you take away the FILE privilege they won't be able to write out the
filesystem.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
st
have similar internal data types inside InnoDB so that they can be
compared without a type conversion. The size and the signedness of
integer types has to be the same."
You've got an INT in comments table and an int(10) unsigned in the
journal table. They need to match in signedness.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
On Fri, 2005-08-12 at 09:30 -0600, Duke, Brian wrote:
> Like crashing, auto-rebooting, memory leaking, program cost, etc...
>
> -Original Message-
> From: Pat Adams [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 12, 2005 9:21 AM
> To: mysql@lists.mysql.com
>
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote:
> [snip]
> Same machine, any performance difference?
> [/snip]
>
> Yes. Linux will consistently outperform Windows in many areas.
Except for those areas that it doesn't.
--
Pat Adams
Applications Programmer
SYSCO Foo
rom the
least significant part of a UNIX timestamp would be sufficient to seed a
RNG randomly enough for average web applications, but it's not truely
random, since a web log will show what time the user hit the
application, and you can figure out what the RNG was seeded with at that
point.
--
cryptographically secure random
number generators can be predicted under absolutely identical
circumstances.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
| sort -u
run in a database directory on a *NIX box (or Windows with Cygwin) will
print out the tables that contain search_string. It takes a while, but
it gives you the information you're looking for. I probably wouldn't run
that on my tables if they're being written to, but I
ed mysql.com a question through "official"
channels. I'm waiting their response.
--
Pat Ballard
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL General
Might be PostgreSQL if
either/or it's faster in my particular case or more
liberally licensed than MySQL (which are things I'm
still investigating). Might be something else.
--
Pat Ballard
__
Do you Yahoo!?
Yahoo! Small Business - Try ou
top of the php-mysql module provided by Red Hat.
The end-user has no direct visibility to the database,
in fact, the end-user might never know it's MySQL -
all that is visible is the PHP interface, via Apache.
In this case, what's the license? Is MySQL still free
bout 10 minutes to crunch
through the data.
If you're going to do something like this make sure you understand the
security ramifications of running shell scripts with user input and how
to secure it in your language of choice.
--
Pat Adams
Applications Programmer
SYSCO Food Services
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 2:17 PM
> To: Adams, Pat 006; [EMAIL PROTECTED]
> Subject: RE: Lost connection during query when using SSH tunneling
>
> I am not sure of Putty as I am using plink.e
gory of the configuration for
Seconds between keepalives. It's set to zero (off) by default. If you
set it to > 0 number, putty will send a null packet at the server to try
and keep the connection alive. Have you tried that?
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
s always true to the main part of
the SQL statement so that you can just tack on more clauses
conditionally.
$sql .= "SELECT PostStart, JobTitle, Industry, LocationState, VendorID "
. "FROM VendorJobs"
. "WHERE 1 = 1 ";
if ($s_Ind) {
$sql .= "
"
. "FROM cia_people C, famarea2 F "
. "WHERE (C.Nationality is not null) AND (F.IDArea = 'eur') "
. "ORDER BY {$_POST['order']}, {$_POST['direction']}";
Notice that you need to put the variables in curly braces whe
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
-+
| id | int(11)
Thnks a lot
Patrizio
-Messaggio originale-
Da: Egor Egorov [mailto:[EMAIL PROTECTED]
Inviato: lunedì 21 luglio 2003 14.02
A: [EMAIL PROTECTED]
Oggetto: Re: myisamchk -R
"PaT!" <[EMAIL PROTECTED]> wrote:
>
> I need a hint how to use myisamchk
>
> I use t
Hi,
I need a hint how to use myisamchk
I use this syntax in a shell but it doesn't work
myisamchk -R=ID \mysql\data\db\mytable.myi
ID is the index name I want to use to sort the table
I'm using mysql 4.0.13 on Win 2K server
Thanks for help
Patrizio
Exactly that's the problem!
how can I rewrite the query syntax avoiding the multiplication?
Thanks
Patrizio
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: giovedì 26 giugno 2003 22.15
A: [EMAIL PROTECTED]
Oggetto: Re: sum() problems - I don't understand
On
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2 sum1):
The first query gives me back the correct result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1,
Dear All,
I have this two queries
The first one gives me the right result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'),
SUM(ordini.totale),
SUM(ordini.quantita),
ordini.codcliente,
:-) didn't pay enough attention
Thanks
PaT!
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: venerdì 6 giugno 2003 19.08
A: [EMAIL PROTECTED]
Cc: PaT!
Oggetto: Re: UPDATE doesn't work
On 6 Jun 2003 at 19:00, PaT! wrote:
> mysql> UPDATE o
--+
4 rows in set (0.02 sec)
Why the values didn't update?
The same query applied on a single row works perfectly.
Any help is appreciated
PaT!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
how can I write a select where I have a limit result of records but
random.
Something like
SELECT * FROM table1 LIMIT RAND(10);
I know this syntax is wrong I need to know the right one
Thanks.
PaT!
mysql
I didn't change anything
I tried to delete and recreate user and again it can access from the
shell but not from the winmysqladmin
Because I was using MySQL 3.23.53 I decided to upgrade to 4.0.13 hoping
something 'broke' could be fixed but unfortunately nothing changed
Help is apprecia
Hi,
I need to change a column name.
I wonder if there's any faster and simpler way to do it than:
ALTER TABLE table_name
CHANGE old_column_name
new_column_name create_clause;
Thanks for the support.
Patrizio Pino
Roma - Italia
sql
---
ng the one just added.
If I want to display the last message first
SELECT * FROM messages WHERE subject='$subject'ORDER BY ID DESC
Then the last couple of messages are always missing!
--
Best regards,
code (hopefully reducing the latency of
updating each time they change).
I like the idea of having it saved on disk as it would allow for persistent
values during outages, so long as the system as a whole doesn't take too
much of a performance hit.
What exactly is feature sponsoring?
-
Is it possible to observe Handler_read_next and Handler_read_key on a per
table basis? If not, could this feature be added?
I'm not subscribed to this list, please cc all replies back to this email
address.
- Pat We
ql -u jjames -psd342 dbtheNetee <
/Library/WebServer/web1/book/install/netsloth.dump
Remove the trailing semi-colon from the command line.
I hope this helps...
Pat...
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, Ju
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT
(0-128). Use ALTER TABLE to change it to an INT or BIGINT.
I hope this helps.
Pat...
- Original Message -
From: "Mette Møller Madsen" <[EMAIL PROTECTED]>
To: "mysql listserver" <[E
e keyboard over simplifies the process and itself imposes data
integrity questions.
Pat...
.
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 9:28 PM
Subject: Re: Relati
ask: do I need to convert it
somehow or can I just read it directly?
Thanks for any assistance you could spare.
--Pat
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
produce a more
predictable result
Sorry for the interruption...
Pat...
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Simon Abolnar" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 7:21 AM
Subject: Re: ADO
Your workstation may not be in the host table of the MySQL Server.
Pat...
- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:31 AM
Subject: Problem Setting up MyODBC Driver
> H
Expected behaviour, look in your Tray on the Taskbar for a stoplight icon.
Pat...
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 17, 2001 6:12 PM
Subject: Help Needed
> Hi
>
> I just downloaded MYsql for windows
o restore if they are not
removed before hand. Has anyone experienced this? What can I do to remove
these characters from the file? (they are control-a's not "hat" + a)
Thanks,
Pat Wendorf
-
Before postin
If you are ftp'ing make sure your set to binary transfer method.
Pat...
- Original Message -
From: "ALICE CHIAPPETTA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:37 PM
Subject: Problem
> I have downloaded the stable re
Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Uwe Hein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:17 PM
Subject: Bug in MyODBC 2.50.36-nt
JDBC
specifications.
Good luck...
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Fernando Rodríguez Sela" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:53 AM
Subject: ODBC Driver documentation request (aga
I seem to get integer size exceeded error windows popping up using
winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98
Second Edition box.
Any clues?
(sorry for the vagueness, it's occurring on a machine not within my
immediate reach)
You may have a corrupt library or mysqld. Signal 11 is a memory error
(likely overwrite). I would try deleting and reinstalling mysqld from a
fresh download.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "Mysql"
BLOBS and TEXT columns used as indices require the length to be specifically
enumerated.
(Sec 7.26 of the manual)
CREATE TABLE foo(
id INT NOT NULL AUTO_INCREMENT,
name BLOB NOT NULL,
PRIMARY KEY(id),
UNIQUE(name(500))
);
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "
It is the
manner in which Jet approaches 'dirty' and 'unique' as opposed to the ODBC
and MyODBC interface.
A simple ALTER TABLE command added an AUTO_INCREMENT column and a
TIMESTAMP(14) column will relieve your headache.
I hope this helps...
Pat...
[EMAIL PROTECTED]
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an
AUTO_INCREMENT field).
Pat...
- Original Message -
From: "Wojciech Spychała" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 4:14 AM
Subject: ODBC trouble - please help
Make sure you also have at least a user (and password as appropriate) filled
out in the MyODBC Control Panel.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Jan R Andersson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 10:22
r "bug" lies in the libraries or in mysql is a more
difficult question.
>Submitter-Id:
>Originator:Pat Verner
>Organization:
Isis Information Systems
>MySQL support: none [none | licence | email support | extended email support ]
>Synopsis: m
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
CR/LF conversions will take place automagically. Alternatively some linux
distributions have a utility to strip CR's from ASCII files and there is
always old reliable vi .
I hope this helps...
Pat...
[EMAIL
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
le example FIELDS
TERMINATED BY ',' (id,name);
otherwise TIMESTAMP will be set to the appropriate zero value
('00').
I hope this helps...
Pat...
[EMAIL PROTECTED]
BTW I would recommend against using 'timestamp' as a column name since it
is a reserved
The mysql version compiled into your web server uses shared libraries and
your current version (upgrade) apparently is a statically linked version.
Recompile your web server/php/mysql executable with consistent use of
libraries i.e. either static or shared.
I hope this helps...
Pat
Access) the ability to recognize uniqueness of a
record/row is paramount. Adding the aforementioned columns assures
uniqueness.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "John Jensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 20
Yes. Create a DSN to your remote MySQL Server using the ODBC control panel.
Then create a new db in MS Access using a link table (select the ODBC DSN
you previously created ).
Voila!
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "(Mr) Pekka Gaiser" <[EMAIL PROTECTED]
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14)
and an AUTO_INCREMENT column.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "Gregory King" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
handler or database.
Just my opinion...
Pat...
[EMAIL PROTECTED]
BTW I believe you would need to roll your own auto increment to accomplish
your desire.
- Original Message -
From: "Viken Nokhoudian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, Ja
and not messing with the AUTO_INCREMENT column. ALTER TABLE can be
executed on a production database.
I hope this helps...
Pat...
- Original Message -
From: "Enea Mansutti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 2:44 AM
Subject:
Access. If some workstations still fail, delete the link tables in MS
Access and set up link tables again.
I hope this helps...
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "John Jensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24
Try compiling with the static switch set. Check the manual for exact
syntax.
Pat...
- Original Message -
From: "Robert Hough" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 8:10 AM
Subject: Problems Installing 3.23.31
> I com
You are correct, lack of primary key could be the culprit. I recommend a
TIMESTAMP(14) and an AUTO_INCREMENT in every table. Most MS ACCESS worries
then disappear.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Guy Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Crystal Reports with MyODBC and MS Windows.
Pat...
- Original Message -
From: "Laurie Savage" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 9:03 PM
Subject: A report generator MySQL
> I am writing a database to store student aca
75 matches
Mail list logo
