Hi All,
I am running Mysql version 2.23.42 on Mac OS X version 10.1.
I need to upload few files in Mysql which are in MacRoman Text Encoding. My
default installation does not support the MacRoman Encoding.
Currently I need to convert the file into ISO-8859-1 encoding before I can
run the LOAD D
Hi,
I am puzzled not to see a funciton like initcap of oracle in
mysql. Perhaps it is already there.
Here is on (ugly) work around :
Update table set name =
replace(replace(replace(replace(replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(replace(replace(repla
Tri Tran wrote:
>
> I never run mySQL on this Linux box before and now it keep saying that
>
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>
> when I try to run mysql or run mysqladmin, now to reset the password ?
Hello,
run mysqladmin -u root password '' -p (a
I never run mySQL on this Linux box before and now it keep saying that
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
when I try to run mysql or run mysqladmin, now to reset the password ?
-
Before pos
shell# myisamchk -v -c -m -B -r -d -S /usr/local/var/pcdocrx/temp.MYI
MyISAM file: /usr/local/var/pcdocrx/temp.MYI
Record format: Packed
Character set: latin1 (8)
File-version:1
Creation time: 2001-12-03 10:31:16
Status: open,changed
Data records:
Well, according to several subsequent messages, including
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:67549:ololjemolklapaobokil;
that does NOT appear to be the problem, as it also happens on other distros,
with other environments and compilers...
Any ideas from any MySQL developers listening?
Be struggling with this all day, try to figure out why when using the 'load data
infile..' all it loads is the first line for the text file and that's it!
Table structure:
CREATE TABLE `retailtag` (
`prodid` smallint(4) NOT NULL default '0',
`tagnumber` varchar(10) NOT NULL default '',
`cod
hey,
I was wondering if you had any plans to port mysql to os-390, and the open
edition environment there. I think it would be
a really cool idea, considering that most shops that have a IBM mainframe
are looking for ways to leverage it in the unix world without spending
mega-bucks on IBM propri
Okay, so if it won't work with more than one space, are thos records
"doomed" to upper only or First letter capitalized?
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 11:10 AM
To: 'Gill, Vern'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Cha
I'm new to mysql, so there may be a simple explanation of this that I'm not
aware of. I have a field set to type blob. When viewing this field within
the database, the correct text that has been inserted appears. When I pull
it into a page within tags, I get a string of odd alphanumeric
character
Hello all !
I'm creating a program that let the user do any
query (select, update, insert) on a connection...
But I think that when we store() the query, the
function returns different values based on the type
of query (insert, select..). How can I retreive the
number of row updated (If it is an
Hi.
On Mon, Dec 03, 2001 at 08:51:27PM -0500, [EMAIL PROTECTED] wrote:
> Hi all !
>
> Why do I get an unhandled exception errror
> in VC++ 6.0 When I try "res.size()"... ? This
> is only happening when the query is an insert
> or an update.
It seems, because inserts and updates have no result s
You know, in spite of all the good advice I've received, I think that's
what I'll have to do. I say "have to" because inserting another field
into the table creates some complications (long story... related to the
web admin tool I made for editing the tables). Actually, come to think
of it, th
Hi all !
Why do I get an unhandled exception errror
in VC++ 6.0 When I try "res.size()"... ? This
is only happening when the query is an insert
or an update.
Thanks !
-
Before posting, please check:
http://www.mysql.com/man
Hi.
On Mon, Dec 03, 2001 at 06:16:26PM -0700, [EMAIL PROTECTED] wrote:
> The problem is, if I sort by the price field, the ordering of the series
> gets mixed up (since low-end models in higher-end series cost more than
> some higher-end models in lower-end series (confused?? I am :-) If I
>
From: René Fournier <[EMAIL PROTECTED]>
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann <[EMAIL PROTECTED]>
Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code that is presenting a challenge:
-
Hi.
On Mon, Dec 03, 2001 at 06:24:14PM -0500, [EMAIL PROTECTED] wrote:
>
> I try to do an Oralce query in mySQL
>
> insert into geoTable select '011852','HK' from dual where not exists
> (select * from geoTable where geoID = '011852')
>
> In Oracle, this query will check the new geoID is not e
Hi.
Because you said, Rene, that you already know how to sort according to
one of both criteria, I presume ordering the series column is not the
problem (e.g. because it is an enum or something alike).
Then the solution would simply be to do something like
SELECT * FROM my_table WHERE ... ORDER
Hi.
I remember this beeing reported once before. The answer supposed that
it was a problem with the compiler shipped with Red Hat. The mail is:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67476:ololjemolklapaobokil
(and the next in thread).
If this is indeed the case, a simple fix is to use th
Hi.
On Mon, Dec 03, 2001 at 09:30:41PM -0800, [EMAIL PROTECTED] wrote:
> I have the following situation
>
> Three tables
>
> 1) players
> 2) teams
> 3) team_player
>
> 'players' holds player records and player_id is auto_increment primary key
> 'teams' holds team records and team_id is auto_i
Hi.
Without the real data, it looks like the table design could use some
normalization work: it seems there is too much data repeated in table d.
But yes, in the situation on hand, GROUP BY is a reasonable use.
Alternatively use DISTINCT, which will result in the same:
SELECT DISTINCT c.c1,c.c2
Hi.
On Mon, Dec 03, 2001 at 09:39:22PM +0800, [EMAIL PROTECTED] wrote:
> Hello,
>
> I want to know does MySQL 3.23.46 is good for work with Red Hat 6.2 ?
You keep asking this question (which MySQL version to use with RH)
again and again and several people already answered on the list and
privat
PLEASE read the manual before posting.
Have you tried mysqldump? Should be in the same directory as the other mysql
binaries. /usr/local/mysql/bin on my machine, your machine may vary.
j- k-
On Monday 03 December 2001 14:33, Jonathan Hilgeman wrote:
> Just wondering if there's a bui
Just wondering if there's a built-in or distribution utility that comes with
MySQL (like mysqlhotcopy) that will output a file with SQL commands to
recreate a database. phpMyAdmin has a tool for doing this but I don't know
if there's something else built-in already that has that functionality.
-
Hi.
On Mon, Dec 03, 2001 at 01:22:30PM +0100, [EMAIL PROTECTED] wrote:
> Dear List reader and especially list writer,
>
> I usually get around the missing of subselects, but now i really
> don't know how to do without whats impossible at the moment.. In a
> rather big query involving 7 tables,
Hi,
I try to do an Oralce query in mySQL
insert into geoTable select '011852','HK' from dual where not exists
(select * from geoTable where geoID = '011852')
In Oracle, this query will check the new geoID is not exist before
inserting into the table.
In mySQL, I do
create temporary table tmp1
Hi.
On Mon, Dec 03, 2001 at 03:58:42PM +0530, [EMAIL PROTECTED] wrote:
>
> Where can I find the list of errors generated by MYSQL and th explanation
> for the same (not the perror command).
[...]
I don't think that such a list exists, but I am not 100% sure. Some
common errors are explained in
This would be pretty ugly, but you could adapt a trick that was posted to
the MySQL list back in Sept.
select * from ... where series != "Baby", series != "Genesis", series !=
"Super", etc.
Like I said, ugly, and I don't know how efficient it would be (probably
not very), but it would get the
Hello I'm currently developing a plugin interface for a development tool
(www.runrev.com) which allows access to various databases including mysql
on Mac, Win, Unix. However there seems to be no Codewarrior compatible
client libraries for OSX..and the release data is approaching, can
anybody help
Well I think mysql doesnt allow you to do this that simple as mysql
doesnt know how you want to sort it exactly. So my suggestion would be to
give a value to each series, eg. Baby = 1,
Genesis=2,Super=3,Predator=4,Millennium=5 and then order by series.
Cheers
Siim Einfeldt
> One more thing
> Now, I know how to structure my MySQL Select statment such that the rows
> it pulls from the table will be either sorted by Price OR by Series, but
> not both, in the way I'd like. Does anyone know if it's possibly to do
> this in the Select statement itself? (I'd rather do it that way, tha
One more thing, very important: I want to specify the Series sort order,
not alphabetically, but by a non-obvious way
(Baby>Genesis>Super>Predator>Millennium)...
--
I want to select about 25 rows from a table, and sort them by two
criteria. First, by each row's Series field ("Baby", "Gene
I want to select about 25 rows from a table, and sort them by two
criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
"Predator", "Millennium" are the various Series, and the order I'd like
the rows in the array). Within each Series, I'd like the rows sorted by
their Price
At 11:12 PM +0100 12/3/01, P.Ruijters wrote:
>Hello,
>
>Does any body know how I can connect Java to mySQL on Linux system?
Use a MySQL JDBC driver, for example, the one at:
http://mmmysql.sourceforge.net/
>
>Regards Pierre
>
>
>
>---
Tim,
I *really* want to do the same thing, and I'm currently playing with the embedded
server to see if that will help me. Unfortunately even the embedded example doesn't
really help much as it relies on having another 'mysqld' server process running to
connect to
(AFAICT).
It should be possib
>Description:
After installing mysql-3.23.46-sgi-irix6.5-mips (precompiled binaries), and
getting the safe-mysql to start the daemon successfully, I can't connect to the
server. Every command I try to execute dies with the following message:
./mysqladmin: connect to server at 'localhos
Hello,
Does any body know how I can connect Java to mySQL on Linux system?
Regards Pierre
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
Nick,
If you are able to add records, then your connection string is correct, at
least for viewing the table.
Need to see the code where you actually loop through and display each
record.
Greg
> -Original Message-
> From: Nick Boldt [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 4 Decem
Here is your problem:
MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;"
No space between Id;pwd
Unless that is what happened when you copied and paste it
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Nick Boldt [ma
Here is the connection code I use to view record information from a
table. I'm using Dreamweaver Ultradev 4 to help with some of the basic
coding. I am using MyODBC.
<%
MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;"
set ship_address = Server.CreateObject("ADODB.Recordset")
I would be more than happy to. Could you point me in the direction
of the binaries? The ones that I have found have been 32bit DBs.
IW.
On Dec 3 Sinisa Milivojevic was rumored to have written:
>
> GCC 3.* is not fully tested on Solaris.
>
> Why don't you just use our binaries. They
Hi,
I'm trying to view the records of a table in on a webpage, but nothing
is showing up. I can add records to the table from the page but cannot
view, update or delete them.
I'm using Windows 2000 and IIS 5.0
I'm new to MySql and would greatly appreciate any help anyone can give
me.
Nick Bol
Did you Flush your table when you changed permissions?
> Hello everyone,
>
> I'm trying to grant rights to several user accessing my database.
> Right now I'm using their individual IP addresses to grant them
> privileges. Which works fine. This way I have to assign user name and
> password to e
Hello everyone,
I'm trying to grant rights to several user accessing my database.
Right now I'm using their individual IP addresses to grant them privileges. Which
works fine.
This way I have to assign user name and password to each and everyone of them.
What I want is to enable everyone withi
Hi,
Try myisamchk'ing you mysql tables.
Regards
Quentin
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Monday, 3 December 2001 5:40 p.m.
To: [EMAIL PROTECTED]
Subject: SHOW TABLES; show nothing
mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12
Hi,
> -Original Message-
> From: Matthew Dougherty [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 03, 2001 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: Problem making myodbc on Solaris 8
>
>
> make fails with mksh: Fatal error in reader: = missing from replacement
>
> macro refer
Hi,
I have added the mysql server as a linked server in MS-SQL7.0. How do i run
distributed queries against the mysql server from MS-QL query analyzer. Is
it possible and if so how is it done?
regards
bala
-
Before posting, plea
Try the following 2 queries.
UPDATE table SET name=concat(ucase(left(name,1)), lcase(SUBSTRING(name,2)));
UPDATE table SET name=concat(left(name, INSTR(name, ' ')),
ucase(mid(name,INSTR(name, ' ')+1,1)), substring(name FROM INSTR(name, '
')+2)) WHERE INSTR(name, ' ') > 0;
The first query will ca
make fails with mksh: Fatal error in reader: = missing from replacement
macro reference
Current working directory
/opt/perlModules/MyODBC-2.50.37
I have ODBC working for SQL Server.
If I do a make -V is leads me to a bad set of lines in Makefile:
DEPS_MAGIC := $(shell m
Bennett Haselton wrote:
> NOT NULL doesn't mean that the column doesn't have a default, it just
> means that the default is not null.
In other, more conventional (:-)), databases, NOT NULL means simply "NOT
NULL", and implies nothing about defaults - that's a MySQL-ism. (Thus, a
NOT NULL
On Mon, Dec 03, 2001 at 05:25:38PM -, [EMAIL PROTECTED] wrote:
: Hi
:
: We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes
: appear to have been hacked on Friday last and MYSQL client just hangs
: when connecting to the localhost MYSQL server.
:
: MySQL is running on both boxes an
Been there too.
Sounds like a 'script kiddy'.
You should check your hosts.allow/deny, then firewall
software configuration (ipchains?) files. That MIGHT get
you into a functional situation.
Also, programs like 'ls', ps, netstat ,etc have been replaced on your
system, and you won't be able
Hi there,
I feel for you. Been there myself before I installed a firewall router.
(Very useful, BTW, to restrict access to only your customers IPs instead of
the whole world.)
There isn't really enough info provided here to know for sure, but it might
be that when you were hacked, your inetd.co
Hi
We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes
appear to have been hacked on Friday last and MYSQL client just hangs
when connecting to the localhost MYSQL server.
MySQL is running on both boxes and suffer the same problems.
We also have to use kill -9 pid number to kill the s
This isn't the same piece of code, either. The code you posted was for
creating a piece of HTML code for an containing the variable
$sort.
The code you're showing us now is for a MySQL query. MySQL is looking for
the characters %20, not a space, in the field you're searching through.
That's why
Hi!
Ok, the problem the user had probably was calling the wrong Perl function.
>From the MySQL manual:
"
insertid
If you use the AUTO_INCREMENT feature of MySQL, the new auto-incremented
values will be stored here. Example:
$new_id = $sth->{insertid};
As an alternative, you can use $dbh->{'my
Sorry to repost this, but I have no idea what to do about this problem,
which is making our systems almost unworkable. Does anyone have any
suggestions about what to do about this, or at least tests I could try to
narrow down the possible causes. Would it help to upgrade MySQL to a later
version o
The GUI is built in Delphi and uses a grid and a TDBImage and when you
scroll through the Grid or Search I need to be able to retrive the image
that goes with the persons name.
The Web thought has me thinking since I use PHP to do this with my web site
it might be easy to do.
But I would rather
tryt constructing a URL like file:///images/110101/yourpic.jpg out of
the location...
[EMAIL PROTECTED] wrote:
>Either the coffee is flat or someone switched to decafe on me.
>
>What is the proper way to retrive an image that is stored as a path in a
>field name with SQL?
>
>My path would be so
Try this query:
UPDATE table SET phone = concat("(",left(phone,3),")
",mid(phone,3,3),"-",mid(phone,6,4));
It should convert 00 to (000) 000-.
Take a look at this page if you want details on how it works:
http://www.mysql.com/doc/S/t/String_functions.html
- Jonathan
-Original Me
I have an existing database with ISAM tables that I would like to convert to
MyISAM tables. Using phpMyAdmin, I can change the table type using a
drop-down box, however I do not know the repercussions of the table type
conversion.
Any advice,
Steve Osborne
Database Programmer
Chinook Multimedia
Try adding a line right below $sort:
$sort = urlencode($sort);
It should add the %20s for you.
- Jonathan
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 02, 2001 8:35 PM
To: Paul Markov
Cc: [EMAIL PROTECTED]
Subject: RE: Netscape ignores %20 with $so
Either the coffee is flat or someone switched to decafe on me.
What is the proper way to retrive an image that is stored as a path in a
field name with SQL?
My path would be something like Table=YPEOPLE field=pictures with the path
like this c:\images\110101\yourpic.jpeg
Also is there a way to
I'm not sure, but you'd be in big trouble if your system lost power!
-- Erik
On Monday, December 3, 2001, at 10:50 AM, Banach, Timothy P wrote:
> Hello,
>
> Can mySQL be configured to run entirely "in-memory"? That is, can one
> configure it so that all the tables, data, etc. remain residen
I have the following situation
Three tables
1) players
2) teams
3) team_player
'players' holds player records and player_id is auto_increment primary key
'teams' holds team records and team_id is auto_increment primary key
'team_player' is a table which holds records for
"which player belongs
Banach, Timothy P writes:
> Hello,
>
> Can mySQL be configured to run entirely "in-memory"? That is, can one
> configure it so that all the tables, data, etc. remain resident in memory
> and are never written to disk?
>
> TIA,
>
> Tim Banach
>
Hi!
Take a look at our HEAP table type.
--
Reg
Hello,
Can mySQL be configured to run entirely "in-memory"? That is, can one
configure it so that all the tables, data, etc. remain resident in memory
and are never written to disk?
TIA,
Tim Banach
-
Before posting, please ch
On Sunday 02 December 2001 01:12 pm, Ian Moss wrote:
> I'm trying to run mysql 3.23 on suse linux.
Ian:
We need some more info to be able to help you.
What SuSE version?
Please also post a full report about your system with mysqlbug...
--
MySQL Development Team
For technical support contract
Good day to you all.
This is not a problem so much as checking that I am not missing
something obvious, before I change the way my mind deals with this type
of situation in MySQL.
I have two tables
Table c:
+-+-+
| c1 | c2 |
+-+-+
| 1 | foo |
| 2 | bar |
+-+-+
Ta
I'm trying to switch from myisam to InnoDB. I've edited my.cnf (see below).
When I try to start mysql-max:
[root@db1 mysql]# safe_mysqld --skip-bdb
Starting mysqld-max daemon with databases from /home/dbclnbs/mysql/
011203 15:00:00 mysqld ended
Error log:
011203 14:59:54 mysqld started
InnoD
Does anyone know if there is any 16 bit code at all in mySQL. Ever since
installing mySQL for evaluation I've had a rash of NTVDM.EXE's running
around my machine and twice have had so many it brought it to almost a
stand still. I didn't have this problem before the installation of
mySQL.
Tim
--
Dear All,
I have Mysql server installed at remote site which i need to connect to.
I have tried this from my local computer but didn't work;
c:\mysql\bin>mysql -h myhost -u myusername -pmypassword
I will also like to use LOAD command to load a text file from my local
computer to the database o
Hello,
I want to know does MySQL 3.23.46 is good for work with Red Hat 6.2 ?
My means is the version ( 3.23.46 ) no any bug with RH 6.2 ?
Is there a new version 3.23.47 / 48 will be producted ?
Thank for your help !
Edward.
-
Corey Kaye writes:
> I'm wondering what is the best way to update one table based on another. Can joins
>be performed for an update?
>
> update table1 set table1.field2 = table2.field2 where table1.field1 = table2.field1;
>
> The alternative seams to be:
> select table2.field2 from table2;
> u
lets says the column your_column holds hte data to be changed.
then:
update your_table set your
column=concat(substring(your_column,1,4),-,substring(your_column,5,8),-,subs
tring(your_column,8,12));
this should work,
if i am wrong please someone correct me
cheers )
- Original Message -
Fro
Hi,
> how would I change in all rows data that is;
> 00
It goes something like this:
> to 000-000-
update my_table
set my_field = concat(left(my_field, 3), '-', mid(my_field,4,3), '-',
right(my_field,4));
> or (000) 000-
update my_table
set my_field = concat('(', left(my_field
Dear List reader and especially list writer,
I usually get around the missing of subselects, but now i really don't know how to do
without whats impossible at the moment..
In a rather big query involving 7 tables, one of the tables has to meet 5 conditions.
Can somebody tell me how to do this
Ian writes:
> Greetings,
>
> I am having some trouble getting a 64bit mysql (built with gcc)
> to work correctly. I am able to build and start mysql, but it crashes
> anytime I try to manipulate a table with some data in it. This is
> using mysql-3.23.42.
>
> Thanks in advance,
>
>
> I
Hi Jason and Heikki,
Heikki Tuuri writes:
> Jason,
>
> SELECT LAST_INSERT_ID() seemed to work from the mysql client. That is a
> workaround. I forward this message to Sinisa and Venu, so that they can
> check the Perl interface.
>
> >From the manual page of mysql_insert_id() I found the
how would I change in all rows data that is;
00
to
000-000-
or (000) 000-
Can this even be done with mysql?
Thank you in advance...
Vern H. Gill
State Director
Director of Marketing
Conejo Valley Jaycees
http://www.conejovalleyjaycees.org
Hello MySQL developers
please add a
ALTER TABLE xyz eternal_auto_increment=1;
that forces the auto_increment column to increment regardless of which
table type I use and how I delete my columns. As long as there is a way
to reset the column somehow (by setting it to -1 or so) I would fin
Hi,
Where can I find the list of errors generated by MYSQL and th explanation
for the same (not the perror command).
rgds,
Kusuma
***Confidential Notice
This e-mail communication may contain information that is
confidential and privileged. The informatio
Hello,
I have a database with tables getting bigger and bigger (log tables).
Thus every month I make an archive and then compress it with myisampack.
I have a problem though. It seems that without a FLUSH TABLES, the
tables don't appear correctly as compressed and can't be read until
the end. I'
Hello, I've made a app (in c) that uses mysqlclient to connect to MySQL.
I'm having problems when calling sql_exit, which on linux-2.2 works
fine, but on linux-2.4 I get a "Unable to handle NULL pointer
dereferance" message from the kernel..
I've tried to recompile the latest stable mysql with bo
> I tested this with 3.23.38 and was not able to reproduce the
> problem. The UPDATE works as supposed for me.
>
> Did you compile the server yourself? If so, try an official binary. If
> not, please post more information, like where you got your binary
> from, which version it is and so on. Use
85 matches
Mail list logo
