how do I OVERWRITE the previous entry in the
table? ie. is there a SQL command to do like INSERT, but if duplicate
found, overwrite with the new value.
See REPLACE into tablename
http://www.mysql.com/doc/R/E/REPLACE.html
Take care,
seth
Hi!
I posted this last week, but, haven't seen any replies yet, and,
generally, there seems to be a lack of replies in the archives on the Got
timeout reading communication packets related issues. Here is the issue
again:
We have started doing some rather large replace intos and inserts
hi sql ppls,
if i set a field as a primary key, does it automatically make sure its
unique or should i declare a UNIQUE constraint as well? or will primary do
the job by itself.
thanks
- Josh
[EMAIL PROTECTED]
-
Before
Hello mysql,
Resently MYSQL have introduced transaction support, which at least
in INNODB allows to make consistent backup/recovery. The bad thing
about this is - MYSQLDUMP does not support anything about this, so I
had to done the same things buy hands.
The Idea is quite simple -
if i set a field as a primary key, does it automatically make sure its
unique or should i declare a UNIQUE constraint as well? or will primary do
the job by itself.
a primary key is always unique. No need to give it an extra unique index.
Greetings,
Ansgar
http://www.mysqlfront.de/
Michael Widenius wrote:
Jack Configure Command:
Jack --
Jack CFLAGS=-D_REENTRANT
Jack CXXFLAGS=-D_REENTRANT \
Jack ./configure
Jack --prefix=/opt/mysql
Jack \
Jack --with-pthread
Jack --with-named-thread-libs=-lpthread
On Fri, 22 Jun 2001, Thomas J Keller wrote:
select zip, city, county from zipcodes where zip between 68400 and 68500;
here is a portion of the garbled output:
|68442 | STELLA | RICHARDSON
|43 | STERLING | JOHNSON
|444 | STRANG | FILLMORE
|5 |
i have tables forward and mail with the auto_increment field - mid
i have the following sql queryes:
insert into mail(mid,gdate,folder,txt,html,email,subj,date,uid,size,attach,
attachbefore,
I get the following error, if I run DBI,DBD,mysql .../DBD/mysql/mysql.so:
symbol mysql_init: referenced symbol not found!
What can I do against this?
Stepan
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi Everybody!
I want to develop some database application under RedHat 7, with Kylix using MySql.
I'm using MySql 3.23.38. It uses libmysql.10, default limbysql.6.
Kylix native MySql driver cannot connect to MySql server on the same (neither
localhost, nor IP)
but MySql is Accessible from
Hello,
I have a feature request: How about adding a built-in function to convert
IP addresses from strings to INT UNSIGNED, and another function to
convert vice versa.
This makes it easier for e.g. people whose web applications log IP
addresses in MySQL; it is more efficient to store IP
You are possibly not escaping binary fields. You should use
mysql_escape_string() function on binary objects prior to inserting it
in the INSERT command, or use load_file() function.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
what are peoples recommendations on linux guis for mysql?
I've used mysqlfront on windows, but now I finally got linux onto my work
laptop, I'm looking for a nice gui for linux,
(gnome,kde, whatever, doesnt matter).
Thanks
___
Sean
- Is it possible to use mySQL for this purpose?
Yes
- Is it possible to set the database to be read-only?
If you use the compress command for your data in the database in not only
makes the files smaller is also makes them read only..
- We need to transfer the database structure/data to the new
Philip test [EMAIL PROTECTED] writes:
Hello,
I have a feature request: How about adding a built-in function to convert
IP addresses from strings to INT UNSIGNED, and another function to
convert vice versa.
This makes it easier for e.g. people whose web applications log IP
addresses in
x My problem with this is that I have no control over the versioning. I'm
x using an ISP who was gracious enough to upgrade one of the servers (hosting
x our largest clients) to 3.23 because it was having a BUNCH of other
x problems.
x So if the {mysql_insertid} thing is an issue, is there a
Hello All,
I'm current working on project, converting a flatfile system, to use MySQL,
which supports transactions w/Innobase tables. My questions is, as I'm sure many
have coded using transaction w/Perl and DBI. I understand that there as some
draw backs to using transactions when not
What does the max_connect_errors do ?
Is it : if I have that many connect errors, MySQL will stop ?
[database]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Worked the whole day with mysql ?
Want some nice relexion ?
Den ganzen Tag mit MySQL herumgeschlagen ?
Du brauchst etwas schöne Entspannung ?
Here is a site which uses MySQL as database too. ;)
Hier ist eine Seite die auch MySQL als Datenbank benutzt ;)
Register with sexportal.de
Registriere
At 3:40 PM +0400 6/25/01, Ilya Martynov wrote:
Hello All,
I'm current working on project, converting a flatfile system, to use MySQL,
which supports transactions w/Innobase tables. My questions is, as
I'm sure many
have coded using transaction w/Perl and DBI. I understand that there as
On Mon, 25 Jun 2001 07:42:39 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
Paul,
appreciate the feedback, but my question wasn't in reference to the actual
coding and how it's used, this I understand, I was referring to when a
transaction is best used, in what type of a scenario. ;)
TIA
At
Hi,
I have a feature request: How about adding a built-in function
to convert
IP addresses from strings to INT UNSIGNED, and another function to
convert vice versa.
Have you taken a look at INET_ATON and INET_NTOA functions ??
Yes, you might want to take a read of section 7.4.12,
The easiest way to work out what your connection string should be is to
create a new text file in explorer, rename it Something.UDL, and double
click it: You then get the MS Data Link editor dialog. Select the MS
OLEDB Provider for ODBC Drivers as the Provider, select your ODBC
datasource (I
What do we require to use the MySQLGUI with our MYSQL server.
We are looking to manage the users and tables over the web from an NT
machine. Can you please advise us.
I think that you may have a very large market out there is it works in the
way that i have been lead to believe.
Thanks
Hello Guys,
I have a char field, and I'd like to have select ordering it by lowercase
caracteres, uppercase caracters then special characters. I was reading about sort and
this seems to be related to charset of the server, and I dont have access to change
this.
I was thinking on
You are possibly not escaping binary fields. You should use
mysql_escape_string() function on binary objects prior to inserting it
in the INSERT command, or use load_file() function.
Thanks Sinisa for the reply!
There really isn't any binary data.. and, we are calling
mysql_escape_string..
Hi,
I have a table with several complex indexes:
(source,description,timestamp,id)
(timestamp,id)
as well as individual indexes
(id)
(timestamp)
(type)
(source)
(description)
mysql describe eventlog;
+-+--+--+-+-++
| Field |
Seth Northrop writes:
You are possibly not escaping binary fields. You should use
mysql_escape_string() function on binary objects prior to inserting it
in the INSERT command, or use load_file() function.
Thanks Sinisa for the reply!
There really isn't any binary data.. and, we
hi, new to the list so here goes!
i have mysql version 3.23.38 installed on a win98 pc running apache with php
4 installed.
i am working through the book and so have created a database called 'test'.
i have also put a server, user and password into the mysql database. i have
connected to this
James Wilkinson writes:
What do we require to use the MySQLGUI with our MYSQL server.
We are looking to manage the users and tables over the web from an NT
machine. Can you please advise us.
I think that you may have a very large market out there is it works in the
way that i have been
On Mon, 25 Jun 2001, James Wilkinson wrote:
What do we require to use the MySQLGUI with our MYSQL server.
a) myqsl server with a user configured for remote login (assuming mysql
is on one machine, GUI is on another).
b) GUI client
c) Config the client to use the appropriate user and
At a small glance, your code looks OK. Try looking at resulting string
sql in gdb or just print it out to stdout. That might catch your bug.
Thanks again for the reply. The query looks sane.. As I mentioned, I
spit it out to a file and piped it directly to mysql (after inspecting
it). At
Seth Northrop writes:
010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root'
host: `localhost' (Got timeout reading communication packets)
The above only implies that your program exited without calling
mysql_close(). Nothing to do with your problem.
But, as I told
I am new to MySQL and this may be more of a training issue on my part than
a problem. I can not seem to get the 'edit table' or 'create table'
function to work. Not sure if I don't know the sequence of things to do or
what. Please advise.
Regards
Marty Bell
As of a couple of months ago, there is a bug with DBI's implementation of
$dbh-{'mysql_insert'}. It didn't handle 64-bit IDs correctly. We converted
everything to use SELECT LAST_INSERT_ID(). It works. MySQL is fine, the
problem was in DBI.
Don't use SELECT MAX(ID) ... as that will not
Hi,
I am sorry for asking stupid questions, but I am at the end
of my trials. I simply want to setup a user who can
connect from anywhere and write some table and read from
another one. Here's what I do:
GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO
dataexport@localhost
The first that springs to mind is:
pricture 2 tables. Pocket and Store.
(Where pocket as in i have got money in my pocket, and store as in Let's
go buy some shoes in the store!.
Pocket (
money integer
) ;
Store (
money integer
);
Now, suppose you are supposed to TRANSFER 10 dollars
Richard Kurth [EMAIL PROTECTED] writes:
I am trying to reinstall mysql on a cobalt server I removed the
first version but when I go to install the new version I get this
message below saying it conflicts with another version could you tell
me how I can correct this. I have looked through
Hi:
Im using Windows 2000, and Im having problems with MySQL GUI. It
works intermittently. Sometimes it just closes out for no apparent
reason. Sometimes it will not let a known good user log in. Sometimes
it will let a known good user log in, but then will not let that user
create a
Sorry to suggest this but is it just possible that the 'data' object you are
doing a strlen on is not null terminated or in fact contains earlier null
characters which are terminating your effort. I have made this mistake several
times when using mysql_escape_string. Now to avoid it I just use
Hi All,
I'm trying to recover data from a table after all rows in the table were
accidentally deleted.
I have looked at the .MYD file and all of the information still seems to be there,
albeit, flagged as deleted (I assume).
Is there any way to recover this information, and undelete
Hi All,
sorry if this is duplicated...
I'm trying to recover data from a table after all rows in the table were accidentally
deleted.
I have looked at the .MYD file and all of the information still seems to be there,
albeit, flagged as deleted (I assume).
Is there any way to recover
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by using joins?
Thanks very much for your help.
Anna
I have been told that once deleted you can not get the data back (can some
one correct me)...
Have you got all your update logs or binary logs? If you have you should be
able to run the sql quires form there and so just recreate your data!
This mite be stating the obvious but like any data base
Marty Bell writes:
I am new to MySQL and this may be more of a training issue on my part than
a problem. I can not seem to get the 'edit table' or 'create table'
function to work. Not sure if I don't know the sequence of things to do or
what. Please advise.
Regards
Marty Bell
Arnie Miles writes:
Hi:
Im using Windows 2000, and Im having problems with MySQL GUI. It
works intermittently. Sometimes it just closes out for no apparent
reason. Sometimes it will not let a known good user log in. Sometimes
it will let a known good user log in, but then will not
On 6/25/01 9:10 AM, anna soobrattee [EMAIL PROTECTED] wrote:
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by
I have downloaded the source file mysql-3.23.39.tar.gz
But when I do
gunzipmysql-3.23.39.tar.gz
tar -xvf mysql-3.23.39.tar
I get this eror message tar: Error exit delayed from previous errors
after the tar is done
Then I
cd mysql-3.23.39
./configure --prefix=/usr
I have downloaded the source file mysql-3.23.39.tar.gz
But when I do
gunzipmysql-3.23.39.tar.gz
tar -xvf mysql-3.23.39.tar
I get this eror message tar: Error exit delayed from previous errors
after the tar is done
Then I
cd mysql-3.23.39
./configure --prefix=/usr
Just if somebody is interested:
I solved the mystery with Error 19. All I needed to do was introducing a
second statement handle for the update query.
(BTW, the script runs probably faster using '$sth = $dbh-do' instead of
'$sth = $dbh-prepare', followed by '$sth = $dbh-execute').
Hannes
On
In doc '21.19 Solving Problems with No Matching Rows' item 5 states.
5.If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you
can't use =! This problem is common in most
computer languages because floating-point values are
not exact values:
mysql SELECT
Hi...
The only cause that I´m on this list is because Blueworld is makeing Lasso
Professional 5 with built in MySQL database server.
Because I am a Mac person I´m used to the powers of text string calculation
in Filemaker pro.
The information I have got, tells me that MySQL does not have
Hi Jake,
Your problem appears similar to a problem I had but...
you aren't providing quite enough information..
Are you working as a user on the same local host or
are connecting across a network?
To eliminate a MySQL problem ( so you can concentrate
your efforts on PHP code) try to connect
To install MySQL ::
I downloaded mysql-3.23.39-hp-hpux11.00-hppa2.0w.tar.gz.
I did unzip, I have changed $MYSQL path from
mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqlaccess file.
I ran scripts/mysql_install_db command
I started database using bin/safe_mysqld
Then I got the below output :
MySQL folks,
I'm going to be giving a MySQL Server and Application Performance
Tuning presentation at the O'Reilly Open Source Convention in July.
http://conferences.ora.com/oscon/
If anyone has the time and interest, I'd appreciate it if you could
look over the slides I've prepared and see
I need to store latitude and longitude in a MySQL table. It needs to
allow human entry. Do you have a preferred storage technique for
these numbers?
Nelson Goforth
--
-
Before posting, please check:
mysql desc zipcodes;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | | PRI | NULL|
Hi, I'm a user of MySQL and I'm wondering if there's a page somewhere that
lists and describes the general basic commands in SQL. I'm particularly
interested in finding out if there's a copy command so I don't have to use
the insert command to create large records (with about 25 fields...).
HI Everyone
I am looking for a summary/examples of the syntaxes and operators one may use
in standard sql statements
For example
select name from epm_tble where name like 'abc%'
select x, count(*) from table_where_x_is_in group by x having count(*)1;
Regards
Danie Weideman
HI: I need some help on table's privileges, I've read
the manual but still don't get it working.
Background:
I'm working on a windows program which needs to connect
to a MySQL database on a linux server using MyODBC32.
I've installed and configured MyODBC and MySql as
follows:
Supposing my
What I want to do is not overly complicated (and it works the way I did
it) but I want to find out if it can be done easily using MySQL only.
Table_a: col1, col2, col3
Table_b: col1, col2, col3
Currently, to replace values in col1 in Table_a with values of col2 in
Table_b, I do the following:
http://www.mysql.com/doc/
HI Everyone
I am looking for a summary/examples of the syntaxes and operators
one may use
in standard sql statements
For example
select name from epm_tble where name like 'abc%'
select x, count(*) from table_where_x_is_in group by x having count(*)1;
Seth Northrop writes:
010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root'
host: `localhost' (Got timeout reading communication packets)
The above only implies that your program exited without calling
mysql_close(). Nothing to do with your problem.
As I've understood it mysql doesn't support sub-selects inside for example
insert statements
(apart from inset ... select).
Background-stuff:
What I'm working on is parsing logfiles and inserting them into a mysql
database through the C API,
to minimize traffic and to maximize time, I was
How can I connect to remote mySQL through ODBC using internet?
I notice that ODBC ask for IP address or host name, can I use my
IP address of my remote host and connect through internet?
Thanks
ST Ooi
Malaysia
-
Before
This is how I'd like the query to work:
insert into host (host_id, host_IP) values ((select from mail
mail_id where
mail_addr = [EMAIL PROTECTED]), '127.0.0.1')
Try:
insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail
where mail_addr = '[EMAIL PROTECTED]';
is someone abble to tell me how can i do for running an sql database with windows98
without crashing my systeme?
Also, using asp ( activex server page ), is it possible with mysql version3,23?
database,sql,query,table,mysql
The error message is :
Connection failed
Connection error 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
my program is :
#include stdlib.h
#include stdio.h
#include mysql.h
int main(int argc, char *argv[]) {
MYSQL
I've created a MySQL database and linked the tables to a MS Access front
end so that I could build the data entry forms using MS Access. Is there a
better way to create the data entry forms in a Windows environment without
using Microsoft or proprietary solutions?
What is are the most widely
The problem is that Kylix does not yet support libmysqlclient.so.10, only
libmysqlclient.so.6. You only have to replace the client libs. I used the
ones from 3.22.32 and they work fine.
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Bagi kos
Hello
I often use an html editor to create forms, use PHP4 as a cgi and enter the
data directly into MySql. This does not necessitate Microsoft, and has
worked very well for me.
-warren
- Original Message -
From: Stephen Reynolds [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
You have several options, a few of the more common solutions include: C,
C++, Delphi, Perl, PHP, HTML, CGI, etc...
Simple data entry forms can often be easily implemented using a web-based
solution (which also simplifies deployment)...
On Tue, 26 Jun 2001, Stephen Reynolds wrote:
I've
Is there some kind soul out there that can email me a
tarball og the MySQL module for an HP-UX machine? I've tried to compile the
module - but it says that I have to compile MySQL with +z or +Z, gcc
doesn't have a +z or +Z ( and mysql should be compiled with gcc ) but it
does have an -fPIC and
73 matches
Mail list logo
