This all strikes me as somewhat odd, since there is a --ssl flag which one
can use to build DBD::mysql with SSL support. Unfortunately, I've never
personally figured out how to actually utilize it, but maybe others are more
knowledgeable...
Issac
- Original Message -
From: "Joshua J.
Hello, hope this is the right list
I created a table with the following code
CREATE TABLE jspCart_products (
ProductID int primary key,
CategoryID int,
ModelNumber varChar(75),
ModelName varChar(250),
ProductImage varchar(250),
UnitCost decimal(9,2),
Description BLOB,
);
The CategoryID has dupl
[EMAIL PROTECTED] wrote:
The anonymous account IS a security risk and should be deleted as soon as
you are capable of managing "real" logins. It's basically there to let
newbie administrators get up to speed with as few problems as possible.
Now that you are comfortable with the MySQL privileges
Monet wants to append something to the current value, so I think CONCAT() is
needed:
UPDATE temp
SET ReviewComments = CONCAT(ReviewComments, ', WHC')
WHERE ... ;
Michael
[EMAIL PROTECTED] wrote:
Yes, UPDATE ... SET... is exactly what you would use. Just set the column
to be the combined va
In the last episode (Aug 26), Alistair Gusmao said:
> I inherited a database with all MyIsam tables. In one of the tables,
> there was two indexes on the same column. Everything about the two
> indexes is the same (except the index name of course!). I think this
> is crazy ? What is your opinion ?
I inherited a database with all MyIsam tables.
In one of the tables, there was two indexes on the same column.
Everything about the two indexes is the same (except the index name of course!).
I think this is crazy ? What is your opinion ? Should I remove one of them ?
Thanks
Alistair
--
MySQL
awesome. thank you!
[Wed, Aug 25, 2004 at 06:27:38PM -0700]
This one time, at band camp, David Perron said:
>
> Are you assuming that all months have 30 days? You can use the same syntax
> with INTERVAL 1 MONTH
> I would also format the date comparison to use the same precision that the
> DAT
David Perron wrote:
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
True.
I would also format the date comparison to use the same precision that the
DATE_ADD function outputs.
Why would you do that? The date column contains a DATE. CURDATE() retur
Redmond Militante wrote:
hi
i need advice on a query i'm trying to do. i'm trying to find
entries with that are about to expire. entries expire if their date
of submission is older than 60 days. i want to find all entries with
a date of submission greater than 30 days, or those that are going to
Hi Ken..
this might not solve your problem..
but, did you really have to do this
create table raddata (
granIDinteger not null,
scanIDtinyint unsigned not null,
fpID tinyint not null,
c1smallint,
c2
hi there
this might be an extreme solution.. but i thought you could come up
with just one query instead of 20 temp tables.. if you dont mind to
write it :)
select id,
max(if(datetype='entered_date',date,'')) entered_date,
max(if(datetype='modified_date',date,'')) modified_date,
max(if(datetype='
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
I would also format the date comparison to use the same precision that the
DATE_ADD function outputs.
So,
DATE_ADD(table.date, INTERVAL 1 MONTH) <= DATE_FORMAT(CURDATE(), '%Y-%m-%d')
I might be off
hi
i need advice on a query i'm trying to do. i'm trying to find entries with that are
about to expire. entries expire if their date of submission is older than 60 days. i
want to find all entries with a date of submission greater than 30 days, or those that
are going to expire within a mont
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a "free
floating" database that nobody (except root) has permission to access
until you issue the grant statements to make someone "own" it. But
nobody actually owns
You rock!! Worked perfectly
On Aug 25, 2004, at 4:31 PM, Rhino wrote:
- Original Message -
From: "David Souza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
So I have all of this years apache access lo
In the " 4.0.20-standard-log" version of mysql, will the " FLUSH TABLES WITH READ
LOCK" statement work to quiesce a database consisting of Innodb tables?
Thanks,
---
Kato D. Haws
Arizona State University; Database Administrati
- Original Message -
From: "David Souza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
> So I have all of this years apache access logs in a huge DB table, most
> of what I wanted to get out is working
So I have all of this years apache access logs in a huge DB table, most
of what I wanted to get out is working fine, but I am trying to get top
10 requests (hits) by day inside a certain section of the hierarchy,
but I can't seem to get the correct results.
I have been trying many different
V. M. Brasseur wrote:
How about...
SELECT foo FROM bar WHERE LCASE(this) = "that";
Although there are always other ways to do it, of course.
Cheers,
--V
Schalk Neethling wrote:
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE
Shawn -
Maybe terminology here...but I think of a "crosstab" query as one which
yields sums or averages or
some such tabulation.
What I need to do is just "pivot" from rows to columns.
The way I've come up with is this:
ORIGINAL TABLE:
columns = id date datetype
there are about 20 datetypes
Greetings All,
A seemingly strange problem.
If I go to the mysql prompt on a linux server - mysql version 3.23.14-alpha.
I can issue the command create database .
I can then issue the command use .
No problem.
However, if I type use mysql for the mysql database.
If I do a select
How about...
SELECT foo FROM bar WHERE LCASE(this) = "that";
Although there are always other ways to do it, of course.
Cheers,
--V
Schalk Neethling wrote:
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE is skipping this one
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE is skipping this one
and I imagine '=' will do the same?
--
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Development.Multimedia.Branding
em
Ken Gieselman wrote:
Hi Folks --
I'm running into some issues with large prepared statements, and would love some
feedback about approaches or tweaks that I might have overlooked :)
Any suggestions as to how to do this more efficiently/faster? Or how to
increase the buffer space for the prepar
is there a simple way to automate read queries for replication above the application
level? we have a huge amount of disparate systems with all their own queries, and we'd
like to be able to set up the reads to go to our slaves, and the writes to go to our
master without having to change every a
- Original Message -
From: "Ronan Lucio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 5:12 PM
Subject: Query Help
> Hi,
>
> I sorry for I neither didn´t find the information that I need in
> the documentation nor found the correct words for a search
> in
I have a logging table where I insert a large number of rows every 5
minutes. For performance reasons this occurs in bulk inserts of about
5000 rows at a time. (ie. INSERT INTO table VALUES(...), (...), (...))
One of the fields in the table is an id that connects it to another
table. It is p
Hi,
I sorry for I neither didn´t find the information that I need in
the documentation nor found the correct words for a search
in the mailing archivers.
I have a query like this:
SELECT cod, descr
FROM table
WHERE AND cod != 7
AND cod != 10
AND cod != 13
AND cod != 14
Too funny! I'm slowly coming to grips on the M2M. I
decided not to opt for it in this situation as I still
believe it would not address my issues.
My problem, or a better to phrase it , my solution is
that I am not supplying titles. They are, to the user
, blank fields , left to them to supply t
Hello All,
Ran into a small problem. I was developing code under the 4.1.x series
of mysql and but discovered that the production server is 3.23.x. Some
of my queries made use of the very handy str_to_date() function. Is the
only solution (besides upgrading production server) to preformat the
d
The anonymous account IS a security risk and should be deleted as soon as
you are capable of managing "real" logins. It's basically there to let
newbie administrators get up to speed with as few problems as possible.
Now that you are comfortable with the MySQL privileges, dump it and hope
it ne
An integer column can hold rather large numbers, why not go ahead and use
the ones that are <100? They are as valid as any other number, aren't
they?
I think you are confusing how things "look" with what they "are". If you
need really BIG numbers so that you can identify MANY rows of data use
- Original Message -
From: "Stuart Felenstein" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 4:41 PM
Subject: Re: Could this be dangerous :Values and Labels
> The other idea I had aside from mnemonic (that was
> yours) was to
Yes, UPDATE ... SET... is exactly what you would use. Just set the column
to be the combined value of the two values.
Please read: http://dev.mysql.com/doc/mysql/en/UPDATE.html
UPDATE tablename
SET fieldname = 'new list of values that you wanted'
WHERE _where_conditions_
Shawn Green
Database Adm
Stuart,
You need to begin to divorce these two processes from each other: STORAGE
and INPUT/OUTPUT. What your user's see on a web page doesn't need to look
anything at all like your database structure. A user interface (UI) is
designed for ease of use. The other is designed for query and stora
The other idea I had aside from mnemonic (that was
yours) was to use beefier numbers. I started listing
them from 1. I am thinking of 3 digits maybe.
Stuart
--- Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Stuart Felenstein" <[EMAIL PROTECTED]>
> To: <[EMAIL PR
I like the mnemonic idea. I wish it was as simple as
airlines though. [Orbitz if your out there listening,
don't worry I'm not coming after you!]
Well to ponder.
Yes, regarding AI keys , I have them for transactions,
new regs, etc. For longer static's we'll see. The
rest I can type in.
Thanks
Date: Wed, 25 Aug 2004 19:30:04 +0300
To: [EMAIL PROTECTED]
From: Egor Egorov <[EMAIL PROTECTED]>
Subject: Re: anonymous localhost user in mysql user grant table
"rusty" <[EMAIL PROTECTED]> wrote:
> What's the purpose of the entry in the user table where it has
> host='local
- Original Message -
From: "Stuart Felenstein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 3:36 PM
Subject: Could this be dangerous :Values and Labels
> Or maybe just bad practice. Thought before I go any
> further I'll ask.
>
> I have a few static table
If you do not use the GRANT, REVOKE, and DROP USER statements to create
and destroy user accounts, you must manually FLUSH PRIVILEGES. It's all
documented in the manual:
http://dev.mysql.com/doc/mysql/en/GRANT.html
and in even more detail here:
http://dev.mysql.com/doc/mysql/en/User_Account_M
MySQL has several functions for dealing with date and time values, many of
which exist only as of 4.1.x. Which ones are available to you depend on
your version. Please read:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Actually, I believe that the formula you wrote is almost t
You will have to call the last_insert_id() function in order to obtain the
autoincrement value.
-Original Message-
From: dan orlic
To: [EMAIL PROTECTED]
Sent: 8/25/04 2:26 PM
Subject: autoincrement question
question:
I have an insert statement that has a null for the value of the
pr
Or maybe just bad practice. Thought before I go any
further I'll ask.
I have a few static tables that list out "items" and
the primary key is an "assigned" ID. Meaning I did
not set auto-increment. As I add items I will add the
associated ID number.
Now to the transactional tables. While the
question:
I have an insert statement that has a null for the value of the
primary key, id, since that value is also a
auto-increment field. The problem i am running into is I need that Id
further down the road for map tables, but I have no idea
what the id is, since it is in fact, autoincremen
Hi,
I'm using a few variables to do some calculations in the select list
of a query but I don't like those columns ( the ones performing the
calc's ) to be shown in the result. for example:
Set @var1=0;
Set @var2=1;
Select Col1, as 'C1'
Col2as
I'm running Windows 2000 and MySQL 5.0.1. When I tried to restart the
service, it won't start up again, error message saying to try again in 30
minutes. After waiting for 30 minutes, it still bring up same error message.
What might be the cause?
Scott
--
MySQL General Mailing List
For list arc
FYI, DBD::MySQL does support SSL. See
http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm
and search for mysql_ssl. You'll need to provide
mysql_ssl_client_key
mysql_ssl_client_cert
mysql_ssl_ca_file
as part of the DSN on the perl side, and set ssl-ca,
ssl-key, and ssl-cert on the se
> What command should I use to find out a table's constraints?
If you're talking about Foreign Key constraints, you
can have a look at them via the
SHOW CREATE TABLE
statement.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Up
What command should I use to find out a table's constraints?
Thanks,
:-)
Néstor Alberto Flórez Torres
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: frecvent table corruption
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT query FROM namedqueries WHERE user
Something else to check out is Stunnel. It creates SSL tunnels between hosts
without requiring logins (basically port redirection). Also, MySQL has built
in SSL now, so you might want to look at that.
j- k-
On Wednesday 25 August 2004 08:10 am, [EMAIL PROTECTED] said something like:
>
SciBit is happy and proud to announce the 2004.1.1 release of MyCon.
If you already have a registered copy, upgrading your current version is free and you
can download the new MyCon Pro version (or for trial purposes):
http://download.scibit.com/software/mycon/mcp.exe
FreeMyCon is completely f
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT query FROM namedqueries WHERE userid = 4 AND name = '(Default
> query)': Got error 127 from table handler at globals.pl line 276. "
[EMAIL PROTECTED] egor]$ perror 127
Error code 127: Unknown error 127
127 =
Please download MySQL official binaries and install. Then check if
the problem disappears.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor
"rusty" <[EMAIL PROTECTED]> wrote:
> What's the purpose of the entry in the user table where it has
> host='localhost' and user='' (blank) and all of the permissions set to N?
You may want to look at
http://dev.mysql.com/doc/mysql/en/Privilege_system.html
and
http://dev.mysql.com/doc/mysql/
"Yusdaniel Rodriguez Espinosa" <[EMAIL PROTECTED]> wrote:
> I have a db with table "usuarios" I erased all data in this table but "Id"
> is a autoinc and he have the value of the last value.
>
> How I can Reset the field "ID"
See http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html at the very end
"Jens Bierkandt" <[EMAIL PROTECTED]> wrote:
> you might want to try this:
> DBDesigner from FabForce.
This seems to be what I'm looking for. Thank you!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Something else I have done in the past was to use Cygwin to create an SSH
session with the remote computer and use the remote computer's MySQL
client/tools.
If you are used to working in a "Terminal Server" session (I think they
now call it "Remote Desktop Connectivity") it will feel very famil
Hi Joe,
> I want to create a stored procedure that I pass a date variable and two
> database names. I can not seem to figure the correct syntax to utilize
> these variables in the procedure. I think I might need to build a
> sqlstring and use an exec command to execute the string. Here is my
>
>Could you send the output of an EXPLAIN for your query?
Sure, pretty sure the index is fine though:
mysql> EXPLAIN SELECT COUNT(*) FROM product_fulltext WHERE MATCH (search_text) AGAINST
('black');
+--+--+---+-+-+--+--+
Could you send the output of an EXPLAIN for your query?
--V
[EMAIL PROTECTED] wrote:
Have you checked the "Optimization" section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
Oh yes, as I've attempted to configure the my.cnf file for best performance. The query is c
I want to create a stored procedure that I pass a date variable and two
database names. I can not seem to figure the correct syntax to utilize
these variables in the procedure. I think I might need to build a
sqlstring and use an exec command to execute the string. Here is my
procedure code:
>Have you checked the "Optimization" section of the manual yet?
>http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
Oh yes, as I've attempted to configure the my.cnf file for best performance. The
query is correct. The fulltext index is correct as I built the fulltext index on the
singl
Thought earlier that I could get by on just plain SQL.
> Php needed. I'm getting a parse error on the "if"
> line.
> This is supposed to be a trigger then before
> transaction counts the number of rows , id already
> inserted, if exceeded , kick back error message , halt
> transaction.
> Not s
Thought earlier that I could get by on just plain SQL.
Php needed. I'm getting a parse error on the "if"
line.
This is supposed to be a trigger then before
transaction counts the number of rows , id already
inserted, if exceeded , kick back error message , halt
transaction.
Not sure where I nee
Have you checked the "Optimization" section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
It's probably the best place to start.
Cheers,
--V
[EMAIL PROTECTED] wrote:
I'm running into a problem with some queries running on a dedicated mysql server (2.0
GHz, 2GB RAM).
I think you'll find that 'create procedure' and 'create function' don't
appear until version 5.0 of MySQL.
Which is why you get a syntax (are you sure you have the right version?)
error.
Regards
Terry
- Original Message -
> Hi!
> Anybody knows how to use CREATE PROCEDURE and CREATE FU
Marti:
Stored procedures are new in version 5.0.
Best Regards,
Boyd E. Hemphill
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
-Original Message-
From: Marti Quixal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2
Hi!
Anybody knows how to use CREATE PROCEDURE and CREATE FUNCTION in
4.1.1-alpha-Max.
I keep trying the CREATE PROCEDURE and CREATE FUNCTION examples found in
the MySQL web documentation, but there's no way to make it work. It
always prompts problems with syntax. Is "delimiter" a function worki
Is there any way to not sending the result of a user variable assignment to
the client?
I.e. Suppress the result of;
SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1
...since I only use @temp in my next statement to produce the actual result.
Also, is there a equivalence t
Mark,
Yes its close and thank you. The problem I am having is I am able to
generate the correct ranking.id for that particular user but I can't
seem to make it equal the ranking.rating.
ID ranking.rating
9 = 5.6 (example)
Here's my query:
SELECT routes.user_id, ranking.rating, ROUND(A
By Jove! I think he's got it!
BTW - Rhino, that was an EXCELLENT response.
Stuart, I believe you have seen the light. What you figured out, thanks to
Rhino and your own intuition, is basically how to normalize your data.
Normalization is critical to database performance, scalability, and
st
MYSQL new feature
The aggregating functions std and variance calculate
the population standard deviations and variance. I
work extensively with datasets doing statistical
analysis. Many times it is faster and more efficient
to perform the basic univariate statistics on the
server but I need the
You could simply run your query then use your programming language's
facilities to scroll down the result set looking for the item in question.
When you found the right record, you would know what it's ranking was
based on how many rows of your results you had to scan through before you
found i
I'm running into a problem with some queries running on a dedicated mysql server (2.0
GHz, 2GB RAM). Fulltext searching really exemplifies this as most MATCH, AGAINST
queries are taking 5-20 seconds. Performance was excellent for some reason one day
(0.2 - 0.75 seconds) but it was only fast fo
At first, I thought it was a low memory problem. I
reduced my buffers in my.cnf and run the test
again. The master still hung and this is a
screenshot of "top" command just before it died:
http://choonkeng.hopto.org/temp/replication-hang.gif
There are still plenty of memory and no disk
swapping w
On Tue, Aug 24, 2004 at 11:57:05AM +0200, Thomas Spahni wrote:
> Jesse,
>
> mysql> SHOW INDEX FROM mytable;
>
> gives you all indexes for `mytable`; you can process the results with
> perl.
Thanks very much. This works fine, and since I don't care about the
return value--just that there is one--
> where ID = count() <= 5 , if ..
>
> In other words Count wouldn't be looking for an ID
> with a value of 5, but the number of records the ID
> has in the table .
SELECT count(*) AS users_records_number
FROM table
WHERE user_id = 5;
--
--
MySQL General Mailing List
For list archives
I want to , need to, have a way to check how many
records a user can insert into a table.
I thought it would be a, and maybe it is , a statement
using count(). Can count be used though if I want to
check by the user's ID ?
In other words, something like:
where ID = count() <= 5 , if ..
Hi there,
I have trouble with a SQL statement that uses too much load on our
server due to heavy traffic. MySQL uses temporary files and filesort, so
I narrowed the problem down to this one here:
TABLE A:
ID INTEGER PRIMARY KEY
TEXTVARCHAR(10)
TABLE B:
ID INTEGER P
Never mind, finally figured it out on my own.
Sorry , i think out loud sometimes!
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Trying to figure out how this gets done. Let me
> explain first. By the way I hope this is not off
> topic
> as perhaps it is more towards application the
My tounge spoke too early, sorry!
Sebastian Haag said:
> Hello,
>
> is it possible to import data into a MySQL-DB from a text-file which does
> not have separating characters (like a comma, semicolon or tab)?
>
> I have a .csv-file in which each column has a different constant lenght
> (so many ch
Hello,
is it possible to import data into a MySQL-DB from a text-file which does
not have separating characters (like a comma, semicolon or tab)?
I have a .csv-file in which each column has a different constant lenght
(so many characters or digits) that I need to import.
For example:
00721617
Give a look to SQLyogs ODBC Import Tool. It can be
found at http://www.webyog.com
Regards,
Karam
--- [EMAIL PROTECTED] wrote:
>
> Hi,
>I have to migrate oracle 7.3 database to
> MySql , for oracle used Pro*C.
> In the front end used Java, JNI, RMI and Pro*C.
> In the migration proce
84 matches
Mail list logo
