MySQL Question

Hi there, I have installed MySQL 3.23.37-sun-solaris2.7-sparc. Some times the server starts and when i try to connect it using my password it hangs. It doesn't allow me in. Neither does it say anything about the password or about the connection. How do i solve this. This is the second time it is

MySQL Question

Hi there, I have installed MySQL 3.23.37-sun-solaris2.7-sparc. Some times the server starts and when i try to connect it using my password it hangs. It doesn't allow me in. Neither does it say anything about the password or about the connection. How do i solve this. This is the second time it is

Re: perl DBD::mysql question: SOLVED

colorparam0100,0100,0100/paramHello Jeremy, list, I asked: After a select .. insert .. the mysql client returns something like: Query OK, 11393 rows affected (0.47 sec) Records: 11393 Duplicates: 0 Warnings: 0 Is it possible in perl/DBI to fetch the count of duplicates and

Re: perl DBD::mysql question

On Thu, Jan 24, 2002 at 01:48:58PM +0100, Paul van den Berg wrote: Hello list, the regular mysql-client returns some useful information after batch-inserts like: Query OK, 11393 rows affected (0.47 sec) Records: 11393 Duplicates: 0 Warnings: 0 I can fetch the number of effected rows

perl DBD::mysql question

Hello list, the regular mysql-client returns some useful information after batch-inserts like: Query OK, 11393 rows affected (0.47 sec) Records: 11393 Duplicates: 0 Warnings: 0 I can fetch the number of effected rows in perl/DBI with $sth-rows, but is it possible to fetch the count of

Re: MySQL question (bug?)

Hi! Unfortunately, I get too many e-mails to handle help requests which are sent directly to me. If you have purchased MySQL support, you may write to [EMAIL PROTECTED], and will get an answer quickly. If you would like to purchase support, please see the Support section of our web site:

Re: Mysql question and sql request. Are they the same?

Hi. On Tue, Nov 20, 2001 at 02:23:31PM +0100, [EMAIL PROTECTED] wrote: Hei I asked this question sometime ago but I did not get any answer :-( I think the problem is that people are not sure what you are referring to (includes me). and I can not find any explanation of this in the

Mysql question and sql request. Are they the same?

Hei I asked this question sometime ago but I did not get any answer :-( and I can not find any explanation of this in the mysql manual. Could anybody explain me the different between a question and a sql-request in mysql?. F.example: If I send a sql-request to mysql: select * from Table

Re: mysql question

I don't know how to remove users other than directly removing them from mysql.user table This may be very obvious but being a new mysql admin user how do I do what you say above, to delete the user from the user table. There doesn't appear to be any examples of this in the docs.

Re: mysql question

Jim Chivas wrote: Greetings: I saw a reply you sent to a mysql user about setting up new users to mysql. I am hoping you can clarify some questions for me. I referenced the url you gave out at the mysql.com/documentation/. It was suppose to show how to setup users but does not give

RE: mysql question

: mysql question On Fri, 2 Nov 2001, Mark Maunder wrote: Jim Chivas wrote: snip.. I checked this site and it appears to match other docs I have. There are still no examples of removing users just revoking grants. What commands would tell me what users have what rights to what databases

RE: mysql question

] Subject: Re: mysql question On Fri, 2 Nov 2001, Mark Maunder wrote: Jim Chivas wrote: snip.. I checked this site and it appears to match other docs I have. There are still no examples of removing users just revoking grants. What commands would tell me what users have what rights

RE: mysql question

This may be very obvious but being a new mysql admin user how do I do what you say above, to delete the user from the user table. There doesn't appear to be any examples of this in the docs. You have a database named mysql. In there, there is a table named user. It's just a normal table,

MySQL question.

Hello, I am using phpMyAdmin which is MySQL database to create database. My OS is windows 2000. For example, I have a table City. It generates for me 3 files: City.frm, City.MYD, City.MYI My question is how I can connect to this table to do query, insert.by using Java or Visual basic. Thanks

Re: MySQL question.

I am using phpMyAdmin which is MySQL database to create database. My OS is windows 2000. For example, I have a table City. It generates for me 3 files: City.frm, City.MYD, City.MYI My question is how I can connect to this table to do query, insert.by using Java or Visual basic. For

Re: PHP/MySQL question - need help with fputs, mysql statements

Dave Lake wrote: Hi Folks I have used MySQL for some time and am just getting my head around PHP. I looked across a number of PHP sites for some input on this but failing to find an answer thought I would ask some MySQL users (surely many of you are using PHP right? ;-) ) for help. I

MySQL question - tables

Hi everyone! I am fairly new to this list, and a new MySQL user. The software company I work for just developed a new product which uses MySQL to house its data. But we are experiencing a strange problem, so I thought I would toss it out there... We have a product that reports text data files

Re: MySQL question

I thought about that after I sent it. First I will start with what my OS is. I am running Redhat 7.1. Kernel version 2.2.16-22(I believe). I used the i386 release. I did a rebuild of the src.rpm. then installed the rpm. I tried to set the root password as it told me but it said something like

Re: MySQL question

Have a look at what the error logs say. If that doesn't help, post the command used and error messages/logs (if relevant) to the list. - Original Message - From: MIKE TURNER [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 2:05 Subject: MySQL question I

Re: Mysql question (access rights)

may need to double quote the % sign. trav On Thu, 5 Jul 2001, Chris M wrote: I've got a question. In the otherwise-excellent Paul DuBois book, on page 427 or so it talks about how you can do this: GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt; So I tried something

Mysql question (access rights)

I've got a question. In the otherwise-excellent Paul DuBois book, on page 427 or so it talks about how you can do this: GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt; So I tried something similar: mysql GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY dirt; ERROR 1064: You have an

Re: Mysql question (access rights)

At 9:20 PM -0600 7/5/01, Chris M wrote: I've got a question. In the otherwise-excellent Paul DuBois book, on page 427 or so it talks about how you can do this: GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt; So I tried something similar: mysql GRANT SELECT ON *.* TO mysql@%

snort plug-in database: mysql question

Hi, I have installed mysql version 3.23.38 on solaris 2.7and then installed and configured the snore to have mysql as the plug-in database. I created a database 'snort' for snort and a user 'snort' that has privileges to INSERT and SELECT on that database. I then built the structure of the

PHP + MySQL question

Here is my db hierarchy: Database: xtopsites Table: Categories idName 1Name1 2Name2 3Name3 4Name4 5Name5 6Name6 I would like the user to get to a sign up form and have all the names of the categories displayed.is this possible to do using fetch_array? If it

Re: PHP + MySQL question

Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and associated documentation... ?php //assuming the db is already connected $query = select id,name from Categories; $res = mysql_query($query,$dbh) or die (bad query); while($row = mysql_fetch_array($res)) { echo

Re: PHP + MySQL question

you can use fetch_array: $data = mysql_query(select * from Categories); $aux=select name=categorie; while ($row = mysql_fetch_array($data)) { $aux.=option value=,$row['id']..$row['Name']./option; } $aux.=/select; echo $aux; this code will print in html a combobox with the options, in php,

Re: php/mysql question

Hello Adrian, Friday, June 08, 2001, 8:59:51 AM, you wrote: ADC Hi, ADC I am not sure whether this relates to this list or the (not working) php ADC list. ADC For simplicity: I have a form that displays data from a table. I will ADC take just one field that displays a name ADC input

Re: php/mysql question

- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form

php/mysql question

Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when

Re: php/mysql question

Did you try the following code $updtStmt = update vusers set orgname=\$tname1\ where id=$tid; Should do the job. Regards P. Miquet - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:59 AM Subject: php/mysql

Re: php/mysql question

On Fri, 8 Jun 2001, Gabriele Bartolini wrote: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; It all depends on these 2 variables settings: magic_quotes_gpc= On magic_quotes_runtime= Off I

Re: php/mysql question

On Fri, 8 Jun 2001, Rolf Hopkins wrote: - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list

Re: php/mysql question

- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 17:47 Subject: Re: php/mysql question On Fri, 8 Jun 2001, Rolf Hopkins wrote: - Original Message - From

Re: php/mysql question

On Fri, 8 Jun 2001, Rolf Hopkins wrote: What you wrote here and what you wrote below are not the same update vusers set name=Adrian D'Costa where id=3; update vusers set name='Adrian D\'Costa' where id=3; will both work. Look up the section on escaping special characters in the mysql

Re: Re: php/mysql question (fwd)

database,sql,query On Fri, 8 Jun 2001, Gabriele Bartolini wrote: magic_quotes_gpc = On ; magic quotes for incoming GET/POST/Cookie data And, what about: magic_quotes_runtime ? Off. Adrian

Mysql question

How would I login to mysql in telnet and create tables Regards,Terrell Johnson Dedicated support Technician Catalog.com, Inc. http://www.catalog.com ICQ#113201638

Re: Mysql question

Subject: Mysql question How would I login to mysql in telnet and create tables Regards,Terrell Johnson Dedicated support Technician Catalog.com, Inc. http://www.catalog.com ICQ#113201638 - Before posting, please check

Re: MySQL question

: MySQL question hi-- firstly, I am relatively new to mysql. I am having a problem getting text I enter into a perl script (for reasons of parsing and sending to my mysql database) to consistently get entered into the database. the perl script takes a mail message and makes the body

RE: MySQL question

hi-- firstly, I am relatively new to mysql. I am having a problem getting text I enter into a perl script (for reasons of parsing and sending to my mysql database) to consistently get entered into the database. the perl script takes a mail message and makes the body of the message $body. It

RE: Another MSSQl to mysql question.

It doesn't currently. Currently, you can't use subselects. Cal http://www.calevans.com -Original Message- From: Michael Blood [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:12 AM To: MYSQL Subject: Another MSSQl to mysql question. does any one know how mysql can handle

Re: MySQL question

We pay for support here. In the last two years, I have only needed tor resort to it once, because the mailing list is very effective. When I needed to resort to my support contract, it was a real problem that the list would not have been able to solve. The problem was resolved within 24 hours.

MySQL question

Hello, I am developing a web database for a new small-time real estate company, and I have been reading into using MySQL. I have read that there is minimal email support for MySQL problems, unless one pays for one of your 5 support packages. What I would like to know is, if they decide to use

Re: MySQL question

I don't know how you define 'minimal' but approximately 100+ emails per day from the user list and a response time from 5 minutes to 24 hours should be adequate for the average "small-time real estate company" as you call it. Coming to "What will you guys answer and not answer", I guess there

MySQL question to ask

Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name Income Out Balance Data1

Re: MySQL question to ask

select Name,Income,Out,(Income-Out) as Balance from tblname On Mon, 26 Feb 2001 [EMAIL PROTECTED] wrote: Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2

Re: MySQL question to ask

Hi Jason! Give this a try for the required table you want to produce below... SELECT Name, Income, Out, (Income - Out) AS Balance FROM tablename; Sam. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 26, 2001 1:45 PM Subject: MySQL

Re: MySQL question to ask

[EMAIL PROTECTED] a crit : Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name

Re: MySQL question to ask

His balance is a running balance... Joseph, you will have to keep the running balance in some thing that you write to get the query.. you can't do a running sum in SQL directly. You can only use the examples people provided to get the net per line. Joseph Bueno wrote: [EMAIL PROTECTED] a

Antwort: MySQL question to ask

On 26.02.2001 14:45:50 Dart wrote: Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name

MYSQL Question

Does MYSQL support the CREATE PROCEDURES command, or have stored procedures? If so, how do I access them? Thank you, Jim Colleary

Re: MYSQL Question

On Sun, Feb 18, 2001 at 08:24:47PM -0500, J Colleary wrote: Does MYSQL support the CREATE PROCEDURES command, or have stored procedures? If so, how do I access them? Nope. This is documented in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

Win NT/2000 mySQL question

Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The

RE: Win NT/2000 mySQL question

Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with

Re: Win NT/2000 mySQL question

15:52 Betreff: RE: Win NT/2000 mySQL question Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS

RE: Win NT/2000 mySQL question

Hi Marc, Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Yes, although not prominent, we've had this on your site for a while:

<    1   2