Hello, I need help.
I want to create a table with a numeric primary key as index in my sql. I
want this
index will be automatic. I've tried an auto_increment column, but if insert
a non-correlative value then all new entries continue from this
non-correlative value (1,2,3,4,1026,1027,...). It is
hello list,
libmysql.c: In function `mysql_real_connect':
libmysql.c:1348: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1348: too few arguments to function `gethostbyname_r'
libmysql.c:1348: warning: assignment makes pointer from integer without a
cast
Hello,
How can I change my error language in SQL (MySQL)? Have I to introduce a new
set-variable in my.ini?
Thanks
___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
i think i am replying to this post abit late ..but go through this doc it
will probably help you
http://gurulabs.com/ext3-reiserfs.html
cheers
David Ziggy Lubowa
Network Engineer
One2net (U)
web: www.one2net.co.ug
Tel: +256 41 345466
-Original Message-
From: Nicholas Gaugler
HI all
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where condition . give
me the Nth result;
I hope someone can help me.
TIA
Bye
Alx
hi guys i was wondering if sub selects were possible in mysql 4 ? more
specifically , whenever i do a join , i sometimes require a distinct select on
the field in the first table and the second table may have many rows therefore
returns the same value more than once from the first table which
Hi,
select * from table where condition LIMIT N,1
More details at:
http://www.mysql.com/doc/en/SELECT.html
Regards,
Joseph Bueno
alx wrote:
HI all
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where
will a LIMIT start,end work ?
= Original Message From alx [EMAIL PROTECTED] =
HI all
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where condition . give
me the Nth result;
I hope someone can help
* [EMAIL PROTECTED]
I've been a member of this mailing list for quite a long time and very
thankful that most of my difficulty in creating queries are being answered
by just reading responses to questions. Right now I have a problem in
creating a query (in fact I'm not sure if this is
Hi,
select * from table where condition LIMIT HOW_MANY_RESULT_YOU_WISH;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message
Vicente,
How can I change my error language in SQL (MySQL)? Have I to introduce
a new
set-variable in my.ini?
In the [mysqld] section of my.cnf / my.ini, type:
language=spanish
Alternatively, you can start mysqld with the --language=spanish option.
Regards,
--
Stefan Hinz [EMAIL
Hi there, I tried installing MySQL on Windows Server 2003 (RC1) for eval
and it doesn't seem to be able to start the mysql service.
Thanks for your hints
Gilles
-
Before posting, please check:
http://www.mysql.com/manual.php
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where condition . give
me the Nth result;
SELECT * FROM table LIMIT N,1 ;
Alec
Hi,
I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section
Variables, language has this value yet 'c:\mysql\share\english'
- Original Message -
From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
To: Vicente Valero [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday,
There are a couple of things you can try, first make sure your process is
started. /etc/rc.d/ mysql start should do the trick.
TDA
- Original Message -
From: Pedro Leite [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 26, 2003 11:04 PM
Subject: mysql.sock is missing
Hi,
Steve,
Exactly, the lcreceive has multiple records that match
an id in lcopen. I use mysqldump to create an
enclosed file - wood.sql for your reference. The
database name of my file is wood, it contains 2
tables lcopen and lcreceive. lcopen contains
the letter of credits (L/C) I have opened,
Hello all,
I suppose that there is a bug in the mysqlcc version 0.8.9-beta (Windows)
and previous versions 0.8.7 and 0.8.8.
The bug is repeatable in different constellations:
1.1) Connecting to a localhost server (version 3.23.39-max-nt) as user
'',
1.2) Trying to open e second connection to
Greetings
Does anyone know the exact syntax to dump all mysql databases, but some of
them have blob columns. When I execute mysqldump --all-databases mysqldump
doesn't work properly whein it reaches these blobs. So I need only syntax to
backup everything and restore everything back without having
Hello
Please can someone tell me how to run a SELECT between databases on a
network.
I want to SELECT some data from a mySQL server named PC1 to a table on a
second mySQL server named PC2.
Thanks in advance.
Isaac Anietye Inyang
Systems Engineer
Cooperative Information Network
Obafemi Awolowo
Hi
I am having trouble with a query to return only one instance of a name
in a table.
For instance:
id nametowndate
1 jacktown1 2002-12-12
2 johntown2 2002-12-13
3 jacktown4 2002-12-21
4 jacktown5 2002-12-30
5 johntown2
Hi!
Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes:
Jeremy Is anyone else seeing it take 4-8 hours for mail to get thru this list
Jeremy recently?
Normally emails should be delivered quickly; We do however have a
problem in that if there is some problems with the Internet line for
some
On Mon, 20 Jan 2003, Ed Reed wrote:
Does anyone have a list of manufactures of financial packages that will
run with MySQL?
Gnucash 1.7.8 has a PostgreSQL interface. It's about time that someone
adapts the package to MySQL.
Thomas Spahni
--
filter: SQL query
int
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
Any more help would be much appreciated.
TIA
- Original Message -
From: TdA [EMAIL PROTECTED]
To: Pedro Leite [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, January 27,
We have been receiving this error frequently
from our mysqlser about our webserver.
1129: Host 'ip-adress' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
This is getting anyoing.
Can someone tell me if there is a way
to disable this feature for a certain
Duncan Maitland wrote:
I am installing MySQL 4.0.9 on a server running Red Hat 8.0 but am
running into some showstoppers. I seem to have success compiling - no
warnings are raised - but mysql_install_db will crash when installing
the grant tables.
Initially I thought it may have been the
Hi
Sorry if I'm just being feeble minded here but I can't get this to work.
First I take a copy of my database using:
mysqlhotcopy --allowold --noindices db_name /path/path
using the '--noindices' since it says
--noindices
Don't include full index files in copy to make the backup smaller and
* Petre Agenbag
I am having trouble with a query to return only one instance of a name
in a table.
SELECT DISTINCT name FROM table
For instance:
idnametowndate
1 jacktown1 2002-12-12
2 johntown2 2002-12-13
3 jacktown4 2002-12-21
4 jack
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no other processes active, says SHOW
PROCESSLIST. The table (myISAM) has
Hi all,
Sorry to bother the list, since I'm pretty sure the answer is no, but
I'm trying to figure out if it's possible to prevent a user from
dropping some tables in a database while allowing him/her to drop
others. I've seen requests on the list for something similar, but not
a solution.
Hi,
For the moment you can't.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Isaac Anietye Inyang [EMAIL
Heikki:
1. I am reading Managing and using MySQL from O'Reilly.
The book suggests (page 74) to use the -opt option, but that will make
the db go offline for all practically purposes.
Could I just use:
$ mysqldump --flush-logs mydb /opt/backup/mydb
and have complete recovery and my users
Vicente,
I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section
Variables, language has this value yet 'c:\mysql\share\english'
Does this look Spanish to you?
1064: Algo está equivocado en su sintax cerca '' en la linea 1
Maybe you didn't restart your MySQL server. Another
Obafemi,
Please can someone tell me how to run a SELECT between databases on a
network.
With MySQL, this is not possible. AFAIK there are no plans to implement
this in the near future, or to implement this feature at all.
Customers using MS SQL Server asked me the same thing, as MS SQL Server
At 12:42 27/01/2003 +0100, Gilles Antonetti wrote:
Hi,
Hi there, I tried installing MySQL on Windows Server 2003 (RC1) for eval
and it doesn't seem to be able to start the mysql service.
Thanks for your hints
Gilles
I ran the mysqld service on Windows NET Server without problems,
now I going to
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a. Doorstop II) is now available.
Information is available at the companion web site, including
a page indicating what's new, links for downloading the
I am pretty new to mysql and have been teaching myself slowly how to use it.
I am however stuck on a problem. I login to mysql as user root and created a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO dmiller@%
IDENTIFIED BY password;
The command
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no
Greetings,
I would like to set up cron jobs on my servers to make backups of my
databases:
1. The reference manual recommends mysqlhotcopy over mysqldump. Any
opinions?
2. What format does mysqlhotcopy save in? sql files? csv?
3. Anyone else doing this with cron? I'd like to see a
Very unlikely. I'm only using 7% of the disk capacity.
gerald_clark wrote:
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
Hi all,
How do i undo the last transaction in mysql?
Thanks for any suggestions.
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Anybody have an idea about the following error (Errcode: 13)? I am simply
trying to add one more field in the table timesheet.
My phpMySQL version is 3.23.55-nt
Thanks.
-Dhanashri Peramanu
Anne,
- Original Message -
From: Anne [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, January 27, 2003 7:35 PM
Subject: Recover mysql database from hotbackup. This is Urgent!!!
Hi,
We are performing daily hotbackup of the mysql database using the
script which uses
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a. Doorstop II) is now available.
Information is available at the companion web site,
At 14:38 -0800 1/27/03, Jeremy Zawodny wrote:
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a. Doorstop II) is now available.
Information
At 15:03 -0500 1/27/03, Devin Miller wrote:
I am pretty new to mysql and have been teaching myself slowly how to use it.
I am however stuck on a problem. I login to mysql as user root and created a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
a few lines from /etc/mysql/my.cnf
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
Devin Miller wrote:
I am pretty new to mysql and have been teaching myself slowly how to use
it.
I am however stuck on a problem. I login to mysql as user root and created
a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO dmiller@%
IDENTIFIED
Devin,
GRANT ALL PRIVILEGES
ON devin.*
TO dmiller@%
IDENTIFIED BY password;
The command returns a Query ok and 0 rows affected. However, when I
try to
login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied
error.
With mysql -u dmiller -p, the hostname will be localhost (the
Please can someone tell me how to run a SELECT between databases on a
network. I want to SELECT some data from a mySQL server named PC1 to a
table on a second mySQL server named PC2. Thanks in advance.
Hi,
As long as you have a valid logon for each of the databases on each of the
servers, you
Hi!
Over the past 2 years several users have complained about optimization of
queries of type
... WHERE col x;
... WHERE col = x;
... WHERE col x;
... WHERE col = x;
and, indeed, there was a major bug in the InnoDB query estimator. The fix
appears in 4.0.10 and 3.23.56.
[2003/1/28 ¤W¤È 07:51:[EMAIL PROTECTED]]
mysql0a01/2807:51:08
³nÅé¦v°tºô01¤ë27¤é·|û§ó·s³qª¾
-
¥»«H¥ó¥Ñ¨§¨§Às¤u§@«Ç¥Nµo,½Ð¤Åª½±µ¦^«H,³o¼Ë§ÚÌ·|¦¬¤£¨ìªº
¦p¤£·Q¦¬¨ì,½Ð¤Wºô§iª¾,§ÚÌ·|±N§Aªº¦W³æ§R°£ªº
- Original Message -
From: Devin Miller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 9:03 PM
Subject: Adding a user problem
I am pretty new to mysql and have been teaching myself slowly how
to use it. I am however stuck on a problem. I login to mysql as user
Assuming you logging in from the same server on which mysqld is
running, you need a dmiller@localhost user. The % wildcard is valid
only for tcp connections. This is thoroughly explained in the MySQL
manual, chapter 4.3.5.
hth,
Doug
On Mon, 27 Jan 2003 15:03:35 -0500, Devin Miller wrote:
I am
At 14:21 -0700 1/27/03, Mike Doanh Tran wrote:
Hi all,
How do i undo the last transaction in mysql?
If you've committed it, you don't. The point of COMMIT is that it
won't be undone.
If you haven't committed it, use ROLLBACK.
Thanks for any suggestions.
Mike
If I manually shut down mysql, I usaully use the mysqladmin shutdown
command. However, I noticed that the red hat way of stopping mysql in
its init scripts is by issuing a kill command to the pid. U, is
this wise? What about if the tables aren't written to disk? Isn't the
proper way to
Any help from good samaritans? I have no idea to solve this mess!
TIA
- Original Message -
From: Pedro Leite [EMAIL PROTECTED]
To: TdA [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 10:23 AM
Subject: Re: mysql.sock is missing
Hi, I'm getting the same error
On Mon, 2003-01-27 at 11:23, Pedro Leite wrote:
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
Any more help would be much appreciated.
TIA
That's the directory where it should be.
You can also start with
service mysql
-- this is a resend, its been over an hour, and the 1st hasn't shown up on
the list yet. i'm assuming my mail server dropped it --
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
a few lines from
On Mon, Jan 27, 2003 at 04:52:40PM -0600, Paul DuBois wrote:
Maybe I should work up a snappy slogan like: 65% more pages, but
only 25% more thickness!
I guess that's not too snappy. But a'm glad they used thin enough paper
that it didn't turn into a completely giant book.
If there had
On Mon, Jan 27, 2003 at 02:21:18PM -0700, Mike Doanh Tran wrote:
Hi all,
How do i undo the last transaction in mysql?
ROLLBACK
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.8: up 0 days, processed 329,766
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
...
% backing up my MySQL databases on a Win2K box at home to a Linux box in
...
% hand, I have only 128 MBit upstream from my Win machine, and maybe you
% will have a faster network
I am running mysql 3.23, and want to know if I can set the default value
of a column to to_days(now()), or the equivelant. I have tried this,
and the default gets translated to 0.
Thanks
Carlin
-
Before posting, please check:
At 4:52 PM -0600 1/27/03, Paul DuBois wrote:
At 14:38 -0800 1/27/03, Jeremy Zawodny wrote:
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition
*Please respond before Wednesday, January 29, 2003, if at all possible. *
I am using a PowerMac G4, Mac OS Version 10.2.1. I wanted to learn mySQL so I brought
a book entitled, SQL Weekend Crash Course. Allen G. Taylor is the author and the
ISBN # 0-7645-4901-4. It has a CD-Rom (the
64 matches
Mail list logo
