Ken,
That worked! THanks very much.
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: den 26 mars 2002 21:25
> To: Philip Semanchuk
> Cc: [EMAIL PROTECTED]
> Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why?
>
>
> Hi Philip,
> before running your
Hi, Harpreet:
You should use MySQL C API mysql_escape_string(...) to convert that
description field into a legal SQL string before load data infile.
B.R.
budingc
- Original Message -
From: "Harpreet Kaur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 4
~!
> Ok here's what I trying to do. I am trying to design a little
browser/ip
> tracking page and I need an SQL statement that will allow me to group
IPs
> that hit the site in 5 minute intervals (well I just want the interval
thing
> to work cuz I'll prolly want to make this like 30 minutes or
Can anyone tell me how to grant connect to a database. I'm using MySql on an
NT server. Most clients can connect to the database but one PC can't, that
pc is running linux. Can anyone help?
Thanks,
Neil
-
Before posting, please
Hi
I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel.
I have a /var partition (ext2) with 6.5 gb total space.
One of the tables are almost running out of space, it is almost 4 gb. is it
the filsystem that prevents files larger than 4 gb, or is it mysql that
should be tweaked ?
Svend,
Wednesday, March 27, 2002, 12:30:28 PM, you wrote:
SEHJ> I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel.
SEHJ> I have a /var partition (ext2) with 6.5 gb total space.
SEHJ> One of the tables are almost running out of space, it is almost 4 gb. is it
SEHJ> the filsyste
Hello Swapna,
>I'm trying to upgrade my MySQL 3.22 version to 3.23 or 4.0 version on Linux
>flatform, but I don't know the procedure. Could any one please tell me the
>procedure how to do it. And if I upgrade to the higher version do I lose
>any of my data.
There are a lot of info about MySQL up
Neil,
Wednesday, March 27, 2002, 12:12:37 PM, you wrote:
ND> Can anyone tell me how to grant connect to a database. I'm using MySql on an
ND> NT server. Most clients can connect to the database but one PC can't, that
ND> pc is running linux. Can anyone help?
You should to allow your Linux box to
Hi,
has anyone used DRDB (http://www.linbit.com/) instead of the standard MySQL
replication?
DRDB implements a virtual disk mirrored across a local disk and a disk in a
remote stand-by server.
On first thought, it adds some complexity to setup, but it can also
replicate information not written to
How do i import MS Excel Data into MySQL Tables??
T. Edison jr.
=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***
Hi,
I'am using autoincrement field with innodb table.
(Mysql 3.23.47-log on Linux ppc)
Two questions
1_ how to set a range ?
Is the only solution chosing betwwen tinyint, smallint, ..., bigint
I over words :
I want a range from 1 to 999 for example , how can I do ?
2_ Wha
We've got a RedHat 6.2 system here, and every so often it fails to commit
an INSERT to the database, (using BDB table type). Apart
from that the system works fine.
I was wondering if this is a symptom of the kernel 2.2.14 problem that's
mentioned on the download page.
Anyone got any views on th
Well, if i'm usin ext2 with a blocksize on 4 kb, then the largest file
should be about 4 gb, right ?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: 27. marts 2002 12:16
To: [EMAIL PROTECTED]
Subject: Large datafiles
Svend,
Wednesday, March 27, 2002, 12:30:28 PM,
Hi Guys,
http://www.mysql.com/doc/R/e/Replication_Features.html
... states that last_insert_id() will be replicated "correctly". However I
don't think this is always the case, for instance:
INSERT INTO TABLE tab1 (field1) values ("Test");
INSERT INTO TABLE tab2 (somefield) values (last_insert_
My Server is Redhat 7.2 OS and MySQL Server.
I've deleted the "mysql" system table in MySQL Server.
I can't connect to MySQL Server from any Client.
I would like to know the structure of it in order to recreate it.
Help me, please!
Thank you very much
__
[EMAIL PROTECTED] writes:
> >Description:
> mysqlgui crash caused by infinite loop in
> mysql_read_default_options because strcend
> never returns 0
> >How-To-Repeat:
>
> >Fix:
>
> --- libmysql/libmysql.c.orig Thu Feb 14 18:30:17 2002
> +++ libmysql/libmysql.c Tue
noat,
Wednesday, March 27, 2002, 2:49:16 PM, you wrote:
nnn> My Server is Redhat 7.2 OS and MySQL Server.
nnn> I've deleted the "mysql" system table in MySQL Server.
nnn> I can't connect to MySQL Server from any Client.
nnn> I would like to know the structure of it in order to recreate it.
You
We are looking at using replication between two MySQL servers. In our
situation, there might be a firewall between the two servers and we will
need to permit the traffic between the two through the firewall.
From what I have read, it sounds like the Slave connects to the Master (in
stead of t
At 3:58 -0800 3/27/02, Thomas Edison Jr. wrote:
>How do i import MS Excel Data into MySQL Tables??
One way: save it as a tab-delimited file, then import it
with mysqlimport.
If you don't want to mess around pointing and clicking to save
an Excel file as a tab-delimited file, try using this Perl
try GROUP BY (UNIX_TIMESTAMP(tVH.vDateTime) -
MOD(UNIX_TIMESTAMP(tVH.vDateTime, 300)))
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Date Interval Grouping
> Date: Tue, 26 Mar 2002 19:13:44 -0700
>
> Ok here's what I trying to do. I am trying to design a little browser/ip
> tra
Oops meant to include the list on that one :)
Begin forwarded message:
Date: Wed, 27 Mar 2002 14:11:54 +
From: Chris Wilson <[EMAIL PROTECTED]>
To: Benji Spencer <[EMAIL PROTECTED]>
Subject: Re: Replication Connection: Slave -> Master?
On Wed, 27 Mar 2002 07:21:11 -0600
Benji Spencer <[EMA
Being in Italy, we use apostrophes in our fields constantly!
MySQL itself has no problems with them at all.
As you say, you're using ASP as your front end, and standard
SQL statements to add, edit and delete records.
For ASP I'm not sure, but in our PHP code it works to simply
add a backslash be
Hi
Will MySQL run on a Cobalt RaQ4 server ?
Denis Croombs
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Yes, my hosting providers use raq servers and I have mysql databases on
all of my domains
-Original Message-
From: Denis Croombs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:30 AM
To: Mysql (E-mail)
Subject: MYSQL on a Cobalt RaQ4
Hi
Will MySQL run on a Cobalt RaQ4 ser
Hi Denis,
According to its datasheet, the RaQ4 is a 450MHz Intel compatible machine
running Linux 2.2 so I can't see any problems installing and running MySQL
on it.
Regards,
Chris
> -Original Message-
> From: Denis Croombs [mailto:[EMAIL PROTECTED]]
> Sent: 27 March 2002 14:30
> To: M
Hi everyone
My problem is as follows. I need a c program to run a query on the mysql
database and then write the results into a text file. I am running the
mysql on a Linux machine.
I am new to mysql and according to another source there is an example
program in the mysql source code? I check
Hi,
I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the
mysqld.log grows very rapidly.
Is there a way to turn it off ?
Logrotation is not really an option in this case, the only
possibilities are not logging or delete it every day.
Any hints ?
JvD,Netherlands
---
Did you try installing a new copy of MySQL and then simply copying the
appropriate files from mysql/data/mysql over to your damaged installation?
Just an idea.
joe
> -Original Message-
> From: noat naut - nart [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 27, 2002 5:49 AM
> To: [EM
Hi,
RTFM see at "INTO OUTFILE"
Adib.
Isak Badenhorst wrote:
> Hi everyone
>
> My problem is as follows. I need a c program to run a query on the mysql
> database and then write the results into a text file. I am running the
> mysql on a Linux machine.
>
> I am new to mysql and according to a
Isak,
Wednesday, March 27, 2002, 4:49:01 PM, you wrote:
IB> My problem is as follows. I need a c program to run a query on the mysql
IB> database and then write the results into a text file. I am running the
IB> mysql on a Linux machine.
IB> I am new to mysql and according to another source th
Thanks Paul,
I figured that was the answer. Do I need to perform a second and third
query from my related tables with a join back to the 'main' table?
Example:
select main.id, main.description, maincat.name, subcat.name from main LEFT
JOIN maincat ON main.maincatid=maincat.id LEFT JOIN subcat
Does anybody have an idea how to select data from a local database into another
host server ?
For information, I'm currently using mySQL 3.23.
Eric Huwaert
Kind regards - Bien cordialement - Vriendelijke groeten - Mit freundlichen
Grüßen ,
---
At 04:30 AM 3/27/2002, you wrote:
>Hi
>
>I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel.
>
>I have a /var partition (ext2) with 6.5 gb total space.
>
>One of the tables are almost running out of space, it is almost 4 gb. is it
>the filsystem that prevents files larger than 4 g
I don't like the set type as I can't use it on other databases (even
though I do not foresee changing databases, I like to keep the option
open). The bit method is what I'll probably use.
Thanks for the help :-)
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Sent: Wedne
We have Solaris 2.8 running Mysql 3.23.49. We are building a
database with an Access 2002 front end on Win98/95 or Win2000,
which would run over the internet. My problem is, how do we
encrypt the communications between the front-end and the back-end
(mysql)? Mysql supports SSl but Access does not.
Hello SQL Gurus
I am trying to write an sql statement that will return a row which contains
vendor info, how much he owes, total payments and balance due.
The results should look like this :
ABC,VENDOR ONE,333.33,199.98,133.35
DEF,VENDOR TWO,333.33, 0.00,333.33
The statement uses 3 tables and
> Using apache 1.3.23 for win32
> WinXp and Perl 5.6 and Mysql 3.23.44-nt
> The localhost test page by apache runs correctly
> The perl script runs from the command line, the Browser url line and just
by
> clicking it in the dir.
>
> Trying to launch this perl-dbi script from the brow
Thanks
That was all I needed. Just a push in the right direction.
Your friendliness was must appreciated.
Isak
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 17:01
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Write query to text file
Hello everyone.
I am trying to extract the data from MySQL based on the month, and day of
the item, and post them on a page.
Something similar to "Today in History"
Here is a partial list of my table:
CREATE TABLE ANNOUNCEMENT (
AnnouncementID bigint(20) unsigned DEFAULT '0' NOT NULL,
Title va
From: Soheil Shaghaghi <[EMAIL PROTECTED]>
> SELECT AnnouncementID,Title,DateShown FROM ANNOUNCEMENT WHERE
> DateShown=NOW() ORDER BY DateShown DESC
> ...I only want to look at the month, and the day
SELECT AnnouncementID,Title,DateShown
FROM ANNOUNCEMENT
WHERE substring(DateShown,6,5
Soheil,
Wednesday, March 27, 2002, 6:45:38 PM, you wrote:
SS> I am trying to extract the data from MySQL based on the month, and day of
SS> the item, and post them on a page.
SS> Something similar to "Today in History"
SS> Here is a partial list of my table:
SS> CREATE TABLE ANNOUNCEMENT (
SS>
From: Bob T <[EMAIL PROTECTED]>
> The browser displays a new page which displays the perl source code.
> How do I run the perl script from the browser
This means that Apache isn't executing your code, instead he's just reading in the
text of "myperlscript" and sending it to the browser. You nee
Hi,
from my experience
CREATE TABLE message (
id int(10) NOT NULL auto_increment,
parent_id int(10) NOT NULL default '0',
parents varchar(255) NOT NULL default '',
level tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY parent_id (parent_id),
KEY parents (parents)
)
Sorry to bring this up again, but I haven't received any helpful
responses. Does anyone have any clues about this or is this something I
should report as a bug? I can't imagine it is.
Thank you,
Leonard
At 12:43 AM 3/26/2002 -0800, you wrote:
>Hello,
>
>I have been attempting to get repli
You might want to look in the crontab to see if rotatelogs is rotating
the logs for mysql. If it is, the mysql database is bounced. The easy
thing to do is just to check the connection and make sure it is open
before using it.
i.e.
if (conn.isClosed()) {
conn=db.getConnection()
}
On Wed, 200
hello again list
i've been trying to install the mysql dbd module on a cobalt-linux box and with some
help from this list, i was able to pass most of the tests on the install... only 3
remain and i don't know why it's failing. could someone please look at this output
and tell what's wrong? o
Leonard,
This is pretty clearly (IMHO) a permissions issue. Make sure the
username you use to replicate with, has a '%' in the Host field of the user
table.
mysql> use mysql
mysql> select * from user where user = '' \G
*** 1. row ***
--- Steven Gearhart <[EMAIL PROTECTED]> wrote:
> The easiest way to add a column is to get somebody
> else to do it.
>
> Seriously, Use the "ALTER TABLE TableName ADD COLUMN
> Company_id INT UNSIGNED
> NULL" command.
Yes. But also, the company_id field probably should be
reset 'not null' AFTER t
Hrm, I'll take a stab at it, since I've got replication working atm...
Have you tried basic connectivity tests between the slave and master? (
Just making sure.. ie - can you telnet to port 3306 on the master, from
the slave? )
Did you flush the privileges after adding the repl user?
Here's my
I have a query like this
select * from PROFILES where UCASE(DESCRIPTION) like '%A%'
the result of this will be a set in which any member contains at least an
"A",
but I'd like to sort them so as the result set becomes like this
first: "A"
second: "AAA"
third: "any string containing an A"
and
Walter
Try adding to your select statement:
ORDER BY DESCRIPTION ASC
David
-Original Message-
From: Walter D. Funk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: How can I Sort by Relevance?
I have a query like this
select * fro
At 15:05 -0300 3/27/02, Walter D. Funk wrote:
>I have a query like this
>
>select * from PROFILES where UCASE(DESCRIPTION) like '%A%'
>
>the result of this will be a set in which any member contains at least an
>"A",
>but I'd like to sort them so as the result set becomes like this
>
>
>first: "A"
From: Walter D. Funk <[EMAIL PROTECTED]>
> ...I'd like to sort them so as the result set becomes like this
What language, if any, are you working in, other than SQL?
---
Rodney Broom
Programmer: Desert.Net
-
Before posting,
I have a Raq4 running with MySQL + php no problem.
Save yourself a great deal of time by loading the packages available
from:
http://pkgmaster.com/
These Cobalt support team guys maintain security update and misc.
packages which, for the Raq 3 and above, happen to include PHP and
MySQL. I hig
Try looking up the Nested Set Hierarchy structure, which is mainly discussed
by Joe Celko.
There are a number of discussions on usenet (groups.google.com) about it, by
him. Also, here's a URL which gives his description. It's a good
structure, and with modification, looks like it can fit about a
Anti-SPAM: mysql, query
Gurus
I'm new to replication. Set it up this weekend and has worked
flawlessly for several days. Then I used the command:
TRUNCATE TABLE tbl;
That worked in master, but was not replicated in slave.
No mention of this in manual. Using version 3.23.49 on
master and slav
> I have a column that is VARCHAR(32). I use it to store MD5 hash values.
MD5 hashes are always 32 byte.
So use char(32) instead. I do.
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:30 PM
To: Tino Didriksen
Cc: [EMAIL PROTECTED]
Subject: R
Just an aside, the "like" comparison is case insensitive -- so you don't
need the "UCASE" in this example.
like '%A%' will match both "A" and "a".
--jeff
- Original Message -
From: "Walter D. Funk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 10:05 AM
Sub
4.8.5 mysqldump, Dumping Table Structure and Data
Utility to dump a database or a collection of database for backup or for
transferring the data to another SQL server (not necessarily a MySQL
server). The dump will contain SQL statements to create the table and/or
populate the table.
I
Can someone tellme the problem in this query??
Is there any problem updating two tables in the same query???
update alumno, alumnocurso
set
alumno.nombre='Blas',
alumno.apellidos='Martinez Maertinez',
alumno.nacimiento='1990-09-12',
alumno.telefono = '6',
alumnocurso.incorpora
At 21:03 +0100 3/27/02, Javier Armendáriz wrote:
>Can someone tellme the problem in this query??
>
>Is there any problem updating two tables in the same query???
Do you find that syntax to be allowed anywhere in the MySQL manual?
There is work on this kind of thing being done for MySQL 4.1.
You cannot update multiple tables in a single UPDATE.
Did you read the manual?
-Original Message-
From: Javier Armendáriz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 2:04 PM
To: MySQL
Subject: What is wrong in this query???
Can someone tellme the problem in this query??
sql,query
What are all the cipher strings possible using the GRANT command
and the CIPHER clause? The docs only give one example.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hi all
How do I get the sum of all values in a column 'col' of a table 'tab'
I am using CGI-Perl and mysql.
Thank you.
Aman
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
---
select sum(col) from tab;
On Wed, 2002-03-27 at 13:32, Aman Raheja wrote:
> Hi all
> How do I get the sum of all values in a column 'col' of a table 'tab'
> I am using CGI-Perl and mysql.
> Thank you.
> Aman
>
> _
> Send and receive
I hope that someone can help me with this. I understood that if I do an
update on a row in a table, I could use the SET row=row+1 and that would
take what was in that row/column and add a 1 to it. For some reason, it is
doubling it. My end result is always twice what it should be. Can anybo
What is the fastest way to check if a table exists?
Do a select and catch the error?
Try to create the table, and catch the error?
Other options?
Thanks,
Ken
sql,query
-
Before posting, please check:
http://www.my
You can do a couple of things..
Are you using any other language besides SQL? ( perl, PHP? )
If you're just looking for a way to do it with sql.. you can try -
show tables like "tablename";
It'll either give an empty set, or return the tablename.
--
sh
On Wed, 2002-03-27 at 14:29, Ken Anders
java. 'show tables like' is what I needed.
Thanks,
Ken
Steven Hajducko wrote:
>
> You can do a couple of things..
>
> Are you using any other language besides SQL? ( perl, PHP? )
>
> If you're just looking for a way to do it with sql.. you can try -
>
> show tables like "tablename";
>
> It
Loretta,
Your syntax appears to be correct. Below is an example of what we do (with
some bits cut out) and it works.
strSQL = "INSERT INTO tblTempConsolidation SET " & _
"customerId = " & intCustomerId & ", "
..
Just to let everybody know. I found my stupid problem. I was executing
the statement twice.
Thanks
Steve
At 03:58 PM 3/27/2002, you wrote:
>I hope that someone can help me with this. I understood that if I do an
>update on a row in a table, I could use the SET row=row+1 and that would
>tak
Hey All,
I am having problems working on a script and need some advise. Here's my
problem. I have two tables with teh following variables:
rahs table:
name, number, team, position
stats table:
name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date
and I need to make it so u
If you need to do a join:
http://www.mysql.com/doc/J/O/JOIN.html
However I don't see much logic in what you're doing. Stats should not
include information that exists in another table, such as name and team.
You need to decide what information will be unique (such as player
number) or come up
Look in the mysql manual on joins.
http://www.mysql.com/doc/J/O/JOIN.html
There is also some articles on this subject at
http://www.onlamp.com/onlamp/general/mysql.csp
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 20
At 13:29 26/3/2002 +0100, =?us-ascii?Q?Xavier_Prelat?= wrote:
Hi,
>Even if you are using the CFServer 5.0 you will not be able to edit any
>MySQL DSN with the ColdFusion DSN web admin tool.
A clarification here. Is possible ColdFusion to create DSN on the fly
using a custom DLL. I did a DLL some
>Description:
After setting the TZ environment variable to a different timezone, then
using the UNIX_TIMESTAMP(...) function on a mysql timestamp string brings back the
correct time, but a date that is a day out, but only for certain dates. It seems that
the date becomes the original date plus t
> >Description:
>After setting the TZ environment variable to a different timezone, then
>using the UNIX_TIMESTAMP(...) function on a mysql timestamp string
>brings back the correct time, but a date that is a day out, but only
>for certain dates. It seems that the date becomes the original date
Thanks Steven,
I can telnet to port 3306 of the master system just fine. A (likely
unimportant and useless) test I did was to telnet to 3306 on the master and
then run "netstat -an" on the master to see if the connect was made. Yes
it was...
tcp0 0 10.0.0.10:3306 10.0
Thanks Scott. It looks like permissions could be the issue, but checking
out the table shows that I have all of the correct permissions setup
exactly as you have listed them below.
If you have any other ideas, I'd appreciate them.
Thanks,
Leonard
At 12:49 PM 3/27/2002 -0500, you wrote:
>Le
Leonard,
What command are you using to start the slave server? I was thinking
maybe it wasn't reading the correct configuration file?
This one is pretty strange. Have you thought about upgrading the slave
mysql version, just to disregard that it might be a problem between the
two versions?
On
On Thu, 2002-03-28 at 12:15, Paul DuBois wrote:
> > >Description:
> >After setting the TZ environment variable to a different timezone, then
> >using the UNIX_TIMESTAMP(...) function on a mysql timestamp string
> >brings back the correct time, but a date that is a day out, but only
> >for certa
hey guys,
this mysql line doesn't seem to work:
SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON
s.name = r.name WHERE (s.position = '$position')
why not? is there somethign wrong with my syntax? it says this error:
"Supplied argument is not a valid MySQL result resource"
I would check the value of $position to make sure it's what you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "Ron Jamison" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 9:14 PM
Subject: Re: SELECT frmo two tables
> hey guys,
>
>
At 20:14 -0600 3/27/02, Alex Behrens wrote:
>hey guys,
>
>this mysql line doesn't seem to work:
>
>SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON
>s.name = r.name WHERE (s.position = '$position')
>
>why not? is there somethign wrong with my syntax? it says this error:
>"Su
This is the code I'm using and I'm a newbie so this is still a lil
challenging for me:
$numberquery = mysql_query("SELECT SUM(s.groundballs) AS grounders FROM
stats s LEFT JOIN rahs r ON s.name = r.name WHERE (s.position =
'$position')");
while($number=mysql_fetch_array($numberquery)){
printf
In addition to Paul's suggestion of using mysql_error to check to see if
it was successful, when I'm having trouble I like to print the query in
the output for testing and then try to run the query from the MySQL CLI.
print "SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs
r ON
In my experience, this is frequently the result of a failed connect. Did
you verify that the connect statement succeeded? If not, and it didn't,
the select will fail, of course, and this is the error you'll get.
Mike's advice, checking the value of $position, is also good.
By the way, you ask
At 21:53 -0600 3/27/02, Alex Behrens wrote:
>This is the code I'm using and I'm a newbie so this is still a lil
>challenging for me:
>
>$numberquery = mysql_query("SELECT SUM(s.groundballs) AS grounders FROM
>stats s LEFT JOIN rahs r ON s.name = r.name WHERE (s.position =
>'$position')");
As I su
Hi,
I have set up a user call FooBar and I have set up the host that FooBar can
access from %, but everytime I go to a different machine I get an error that
FooBar can't access mysql from that machine IP address. Why isn't the
wildcard (%) working?
I am using 3.23.44 with mysql-max. Any clues wo
At 23:37 -0500 3/27/02, Chuck \"PUP\" Payne wrote:
>Hi,
>
>I have set up a user call FooBar and I have set up the host that FooBar can
>access from %, but everytime I go to a different machine I get an error that
>FooBar can't access mysql from that machine IP address. Why isn't the
>wildcard (%)
I have read the mail archives and am still confuessed.
mysql version 3.23.49-5 running under debian kernel 2.4.12
I cannot connect to the mysql server from the outside world.
I have added a host permission to allow anyone to any database.
Can someone assist ?
Regards
Paul
--
In a table, I declared a column which is an integer unsigned.
After calling mysql_fetch_row, I need to convert the value of the column
(i.e. row[0]) to a string.
I tried to solve it doing this:
char var[11];
sprintf (var, "%u", row[0]);
, but it doesn't work.
Is *row[0] an unsigned int?
Can
Do what Paul DuBois just suggested a few minutes ago on this very list:
"Delete the records from the user table that have blank User fields:
DELETE FROM mysql.user WHERE User = '';
FLUSH PRIVILEGES;
Then try again."
That might help. Is your mysql server box behind a firewall? If it is, you
mi
At 5:09 + 3/28/02, Federico Halperin wrote:
>In a table, I declared a column which is an integer unsigned.
>
>After calling mysql_fetch_row, I need to convert the value of the
>column (i.e. row[0]) to a string.
According to the manual, *all* column values are returned as strings.
I'd say you
Hey all, we have a new subscriber here :)
I'm working on a MySQL permissions problem, and would welcome some
suggestions and/or comments, or to be pointed in the right direction. The
goals I have are:
a) Limit users to specific db's (no access to mysql.*/etc.)
b) Eliminate anony browsing of d
I need some newbie help...
I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with
it,
the installed MySQL did NOT have InnoDB support;
I then d/l off mysql.com
MySQL-Max-3.23.49a-1.i386.rpm
I installed it using:
rpm --install MySQL-Max-3.23.49a-1.i386.rpm
(I think
Honestly, I don't know what was wrong, but I have managed to get this
problem fixed. It was one of two things...
I upgraded the MySQL slave server to 3.23.49a.
I also deleted the master.info file based on something I read in the
release info for all of the releases in between the release tha
> hi,
>
> Is it possible to run the MySQL Server from the remote machine..??
> Mysql provides a Api's for shutting down the server from the remote
> place i.e. ( mysql_shutdown(mysqlhadler))
> but I can't see any api for starting the Mysql server from the remote
> machine.
>
> Does it mean that
All Hi!
I am a developer of My SQL, and I am developing an application use unicode
so I would like to ask you which version that support Unicode and where can
I get it.
Now I am using My SQL version 3.23.49
thanks alots
-
Before
hi,
I think u don't need to convert it in to string...
all the column values comes out in string only...
or even u need to use atoi() Function for getting the Int ot unsigned
int...
I have used it...
Chetan Lavti
-Original Message-
From: Federico Halperin [mailto:[EMAIL PROTECTED]]
Se
1 - 100 of 105 matches
Mail list logo
