Jon Miller wrote:
This is the configuration file in use.
/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
[mysql.server]
user=root
basedir=/var/lib
[safe_mysqld]
err-log = /var/log/mysqld.log
pid-file= /var/run/mysqld/mysqld.pid
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 process what will be the best equivalent of Pro*C in MySql.
Ans also need to use XML, for the above environment what are the best langauge suit
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 process
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
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
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 then
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
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 ..
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;
--
mack /
--
MySQL General Mailing List
For list
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--it
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
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
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
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
BRITISH ACCENT By Jove! I think he's got it! /BRITISH ACCENT
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
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,
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
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
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,
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
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).
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 need
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
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
single
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
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
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');
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
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
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/
__
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.
--
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
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/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
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 =
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
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:
-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 userid = 4
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]
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 tablename
statement.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
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
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
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
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,
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
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
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
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:
- 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 tables that
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='localhost'
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
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 PROTECTED]
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
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
- 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 use beefier
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 a
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
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
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
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
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
- 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 the
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
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 :)
snipped
Any suggestions as to how to do this more efficiently/faster? Or how to
increase the buffer space for
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
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
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
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
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
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
- 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 fine,
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 Administration
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 logs in
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
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
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 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,
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
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
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()
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
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
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 ?
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
[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,
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
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.
86 matches
Mail list logo