on is the one i was using until now :).
Eric Butera wrote:
> On 7/6/06, Santiago del Castillo <[EMAIL PROTECTED]> wrote:
>
>> Hi, i'm having a bit of a headache with PHP and MySQL, i've some
>> questions:
>>
>>
>> 1) I've a database in UTF-8
Hi, i'm having a bit of a headache with PHP and MySQL, i've some questions:
1) I've a database in UTF-8 and when i connect to it with mysql_connect,
and exec a query with mysql_query, the results are in latin1. (i proved
this with mysql_query("show variables like 'char%'");
2) Is there any way t
Hi, thanks for answering!
I am using MyISAM tables.
So, based in your answer i assume that is usual to have a lot of HD
Writing, isn't it?
Thanks!
Santiago
mos wrote:
At 06:55 PM 6/24/2006, Santiago del Castillo wrote:
Hi, is usual to have a lot of HD writing on a MySQL server
y log-type (binlog, queries log or slow queries log)
activated.
An extra question:
Which scale of MaxBytes should i use for my HD Writing MRTG config? i'm
using "MaxBytes[hd-write]: 2400" right now. The Disk is a 80 GB SCSI disc
with RAID 1
If you need more information just ask :
I have this 2 queries:
SELECT COUNT(DISTINCT(LEFT(p.prod_num,5))) FROM products p, tlines l,
prod_line pl WHERE l.Line = 'Solaris' AND l.id=pl.line_id AND pl.prod_id =
p.id_product
SELECT DISTINCT(LEFT(p.prod_num,5))as prod_num, p.description AS
description,l.Line as line,l.Content as content FRO
MySql. Also, if
you are the author of this book, notice that the link
hcp://www.kitebird.com/mysql-perl/
no longer works. What is the new web site compagnon for the book?
Thanks
Fandango
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Fandango del Morro" <[EMAIL PROTECTED]>,[EMAI
Hello,
I'm new in this list and I also a newbie with MySql. I have a big problem
with autoincrementing with an initial value. For example:
use Database Business;
create Table Clients(Client_ID int not null primary key auto_increment=10,
Full_Name varchar(30));
Each time I assign an initial valu
Hello,
I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000.
I create a new database in Mysql and a user with all the privileges on it
(using GRANT ALL privileges...).
I create a User DSN in the windows Control Panel and when I test the
connection (in the same DSN panel) I get the follow
i can help you if you want
tel me what do you need exactly
On Fri, 24 Jan 2003 08:55:04 -0500
"Doll Hargrove" <[EMAIL PROTECTED]> wrote:
> Looking for someone who is willing to write a mysql script(?) for a
> website database.
>
> The database has been created. Just need someone to write the
elog can be found at the following url:
http://www.mysql.com/products/mysqlcc/changelog.html
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ /
ering in the text editor.
For more information read the "Changelog.txt" file included in the
distributions!
You can download MySQL Control Center from the following url:
http://www.mysql.com/downloads/gui-mycc.html
Regards,
Jorge
--
For technical support contracts, visit https://order.mys
with the flush command.
Any ideas of why that happens?
Best Regards,
Hector
Del
ngelog: http://www.mysql.com/products/mycc/changelog.html
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \
support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
archy values ('X','F','C');
insert into table hierarchy values ('X','B',NULL);
insert into table hierarchy values ('X','D','B');
insert into table hierarchy values ('X','E','B');
T
Enterprise
Sybase Adaptive Server Anywhere
Thanks,
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:42 PM
Subject: RE: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTE
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
i
.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
> -Original Message-
> From: Manish Mehta [mailto:[
I'll fix this for 0.8.2.
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /
gards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
> -Original Message-
> From: Charles Burnett [mailto:[EMAIL PROTECTED]]
> Sent: Th
Hello, im wondering if anybody can tell me how can i tune up my sql so that
can run smoothly... if there is any packet i should install...
i have a debian linux in a pentium 3 800 mhz with 256.
thanks
Hernan
-
Before posting,
Hi,
As always, the best version of MySQL to work with is the latest stable
release 3.23.46 :)
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTEC
nical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql
https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
-Original Message-
From: Tom Cruickshank
der.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
he contents of a file through the console, you
would do something like:
Prompt> mysql --user=USER --password=PASSWORD DATABASE < WI_UPUSER.sql
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
lt;< "Name: " << (char *) Row[1];
This works because all you're doing is a casting to char *
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
mysql> SELECT price
-> FROM a
-> HAVING price=MAX(price);
+---+
| price |
+---+
| 19.95 |
+---+
1 row in set (0.01 sec)
mysql>
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/
://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
-Original Message-
Fr
ts, go to https://order.mysql.com/
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Mat
; from the command prompt.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
---
Hi,
I would go for a CGI
As Sinisa has already stated, it would make your data-retrieval front-end
faster and more OS independent.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTEC
t ActiveX, there is at
least one COM object that I know of that can connect directly to MySQL
without using MyODBC. Such component is called MySQLX and can be found in
http://www.scibit.com .
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / J
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
-
Before posting, please check
Hi,
This is covered in the manual in section "Table is full".
http://www.mysql.com/doc/F/u/Full_table.html
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
and get yourself a good C/ C++ book !
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, M
Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 11:39 P
Hi,
Yes, you can install MySQL in Win95 but keep in mind because of bugs in
Win95 MySQL may not perform as expected.
Win95 leaks memory each time a client connect to MySQL.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde
Greetings,
I re-booted my server that a database resides oni started mysql
(bin/safe_mysql --user=del &)
However i think that the desired database is not loaded..not being a
database guru, what is the proper way of starting mysql so that i can
specify the proper database..?
th
eam
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Vasu Thirumalai" <[EMAIL PROTECTED]>
om some non-official
mirror.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<_
Hi,
the version mysql that I am using supports the transactions but these
are not recognized from the DBD.
How can I resolve the problem?
Thanks
--
Brunella del Sorbo
Officine Digitali Srl
Idee Tecnologie & Soluzioni per il Web
Via Ferrarese 219/7 4
inued development of MySQL.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: &
default I think) ..
Read section 21.3 in the manual for having several servers running on
different ports on the same machine.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTEC
Hi,
at a "@" before the command where you want to supress the error message:
I.E.
@mysql_connect("host",..);
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/
Hi,
Could this be some kind of TCP / IP error or hardware malfunctioning ?
Try upgrading to the latest (stable) 3.23.33 release.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTEC
del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Rashid Zolqarnain" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mo
that fixed it!
thanks!!!
donnie
>This depends on your OS. On SCO OpenServer or UnixWare this is needed.
>
>LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/local/mysql/lib/mysql:/usr/local/BerkeleyDB.3.2/lib
>LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:
>
>export LD_LIB
go and get gtar (GNU tar)
donnie
At 10:28 AM 2/10/2001 +0800, 163 wrote:
>Dear sir:
>I downed mysql-3.23.32.tar.gz,
>first i extrat mysql-3.23.32.tar from gz file,then I use command "tar
>-xvf mysql-3.23.32.tar ", an error occured, I copy the last 3 line to you!
>My OS platform is UnixWare 7.
Greetings,
I get this error msg::
Installing all prepared tables
ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or
directory
Killed
Installation of grant tables failed!
however /usr/local/lib/lib.z.so.1 does exists...and I did NOT create the
mysql:mysql user...
Any sugge
Hi,
Check that you have zlib installed and then just add -lz to the libraries
you will be linking with.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
Hi,
It looks like if no C / C++ compiler is installed and if it is, it's not in
your path. Please tell us what OS is this and also send us the output of
the PATH environment variable.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorg
ySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "MacDonell, Denn
w to Row[0] and see if that works!
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
elopment Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Juergen Leeb" <[EMAIL PROTE
Hi,
You can use the function mysql_insert_id(MYSQL *mysql) and add 1 to the
result.
If you want an SQL approach, you might want to use SELECT MAX(your_auto_inc)
FROM your_table
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde
pment Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Steen Rabol" <[EMAIL PROTECTED]>
To: &
sqld from anywhere on the system
c) provide full paths to safe_mysqld and mysqld.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http:
ment Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "Charlie Scott" <
all of the records to another table.
Keep in mind that if you use HEAP tables and mysql crashes, you will loose
all the data.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
Make sure you have zlib installed and add -lz to your linking options.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mys
orORDER BY col
ortable_options
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City,
;$sth->{NAME}->[0]: $sth->{NAME}->[1]\n";
while (($name, $phone) = $sth->fetchrow_array) {
print "$name: $phone\n";
}
warn $DBI::errstr if $DBI::err; #checks for problems that may have
terminated the fetch.
$sth->finish;
Regards
Jor
67 matches
Mail list logo
