RE: SELECT w/LIKE on Swedish character ö finds ], why?

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 test

Re: load data infile question

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:41

Re: Date Interval Grouping

~! 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 a

permissions

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,

Large datafiles

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

Large datafiles

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 filsystem

RE: upgrade 3.22 to 3.23 or 4.0 version

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

permissions

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

DRDB vs. MySQL replication

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

Excel to MySQL

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

auto_increment and range or highest value

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_

RedHat6.2 and kernel 2.2.14

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

Large datafiles

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,

last_insert_id() not replicated correctly (?)

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

Help me!

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

Re: mysqlgui crash caused by infinite loop

[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 Mar 19

Help me!

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

Replication Connection: Slave - Master?

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

Re: Excel to MySQL

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

Re: Date Interval Grouping

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 tracking page

Re: Replication Connection: Slave - Master?

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 [EMAIL

RE: ASP and MySQL

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

MYSQL on a Cobalt RaQ4

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,

RE: MYSQL on a Cobalt RaQ4

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

RE: MYSQL on a Cobalt RaQ4

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:

Write query to text file

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

deleting logfiles

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

RE: Help me!

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: [EMAIL

Re: Write query to text file

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 another

Write query to text file

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 there

Re: [Newbie] MATCH and INDEX question (using a JOIN in a MATCH statement)

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

Select data from local database into another host over

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 ,

Re: Large datafiles

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 gb, or

RE: binary expansion?

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:

How to use SSL on Win2000 client?

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

Calling SQL gurus

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

Re: html to perl to mysql

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 browser,

RE: Write query to text file

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

Fetching Data based on the day

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

Re: Fetching Data based on the day

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) =

Fetching Data based on the day

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

Re: [OT] html to perl to mysql

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 need to

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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 = 'your_replication_user' \G *** 1. row

RE: Adding a Column to an existing table

--- 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 the new

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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

How can I Sort by Relevance?

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 so on

RE: How can I Sort by Relevance?

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 *

Re: How can I Sort by Relevance?

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 second: AAA

Re: How can I Sort by Relevance?

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,

RE: MYSQL on a Cobalt RaQ4

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

RE: hierarchical struture into mysql

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

Replication failed: TRUNCATE TABLE command

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

RE: Enforcing Column Types

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:

Re: How can I Sort by Relevance?

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 Subject: How can

RE: Select data from local database into another host over

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.

What is wrong in this query???

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',

Re: What is wrong in this query???

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.

RE: What is wrong in this query???

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

RE: cipher strings usable under GRANT command

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)

sum of a column

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

Re: sum of a column

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

addition problem

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

Re: how to check if table exists?

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:

Re: how to check if table exists?

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

Re: how to check if table exists?

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'll either

RE: ASP and MySQL

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 ,

Re: addition problem

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 take

SELECT frmo two tables

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

RE: SELECT frmo two tables

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

Re: SELECT frmo two tables

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, 2002

RE: Coldfusion,Mysql,Myodbc

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

unix_timesamp function out by a day when using a different timezone

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

Re: unix_timesamp function out by a day when using a differenttimezone

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

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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:

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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?

Re: unix_timesamp function out by a day when using a differenttimezone

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 certain dates.

Re: SELECT frmo two tables

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

Re: SELECT frmo two tables

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, this mysql

Re: SELECT frmo two tables

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: Supplied

Re: SELECT frmo two tables

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

Re: SELECT frmo two tables

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

Re: SELECT frmo two tables

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

Re: SELECT frmo two tables

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

Why doesn't % work?

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

Re: Why doesn't % work?

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 (%)

Host permissions

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

C API question

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

Re: Host permissions

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

Re: C API question

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

Some permissions help

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

newbie installing MySQL/InnoDB on RH 7.1

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

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

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

RE: To run MySQL Server from the remote machine

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 every

Unicode problem

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

RE: C API question

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]]

Adding an index to a table

Hi, I have a MySQL database that currently is used by about 8000 users. I need to add an index to one of the fields in one of the tables to help speed up a particular query being made to the MySQL database. I am a bit nervous to do so in case I screw up. Mind you I have backed up the

RE: C API question

hi, I think u don't need to convert it in to string... all the column values comes out in string only... I have used it... Chetan Lavti -Original Message- From: Federico Halperin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:40 AM Subject: C API question In a table, I

Re: DRDB vs. MySQL replication

Hello Jens, Wednesday, March 27, 2002, 2:43:22 PM, you wrote: We have tried to use DRBD with MySQL/EXT3/NFS and some other applications. Generally it works rather good, showing rather nice performance. The only problem we had was problem with EXT3 corruption, which was in earlier (2-3 months)

  1   2   >