skick writes:
>> I am havving the same problem. I even tried compiling a version. If it
>> is a window manager problem then how do I fix it. It seems like it
>> should work wiith both the kde 2.0 window manager and the enlightenment
>> window manager that is part on gnome.
>>
> Hi!
> Please
Hi, All.
Help me to understand why such different speed of two queries. These queries do the
same and differ only in superfluous information (marked by red). Speed of the first is
0.37 second. Speed of the latter is 3.95 second.
The first:
SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d
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 -FP
>
> > 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?
> >
> > Wh
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 creat
Hello, everyone:
I need your help tracking down one rather rare and difficult to repeat bug in
replication. I have had at least two users report a condition when the slave
was 13 bytes off on its position in the master. One user was able to supply
the appropriate binary log, which turned out t
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: Mo
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 [mailto:
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 u
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
#include
#include "mysql.h"
int main(int argc, char *argv[]) {
MYSQL my_connection;
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?
> 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]';
-
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 postin
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 hopin
>
> 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
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(*)>
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:
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
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'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...).
Than
mysql> desc zipcodes;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | | PRI | NULL|
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:
http://www.mysql.com/
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
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 outpu
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 d
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 "trigge
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>
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
O
> 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 --prefi
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
gma
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
> informa
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
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
>
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 th
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
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 t
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"
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 p
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 datab
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 th
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 dollar
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 IDE
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 d
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
***
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 t
> 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
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 passwor
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 hav
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
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
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 | Typ
>
> 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_stri
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
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
Ja
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
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.
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
>>A
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
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 di
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/
> 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
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
"Philip " <[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
> addre
- 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 da
[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
>
> ___
> S
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]
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 addres
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 Wind
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 (
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,
attachafter,message,flag)values(NULL,now(),1,'"+g_text+"','"+g_html+"','"+g_from+"','"+g_subject+"','
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
>
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="-
72 matches
Mail list logo