gui client

Hi, i'm newbee in mysql and i want to ask you 2 questions i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2. 1) Is it possible to use more than one command in mysqlgui (the end of line charachter ; is not working) 2)Can i load and execute a text file which containing

Re: UNION

Walter D. Funk writes: Thanks for your answer, I´ve created a TEMPORARY table and it seems to work well for my purpose, the only doubt I still have is, if the table gets automatically deleted when the user closes the connection, or should I do something within my script to avoid a stack

about visual basic

Sir, I use visual basic 6.0 and MySQL database I developed native connection to database by Adodc tool but there is datareport tool in VB6.0. I can't connect database for my datareport. I can do it by odbc drivers.I dont want this way. My flowchart is under this text. DataEnvironment

Re: further compile problems on Solaris 2.6

fil krohnengold writes: I wish it were as easy as a botched gcc install. But it's not. I just tried using the pre-compiled binary from ftp.ibiblio.org for 2.95.2 with identical reslts. -fil -- fil krohnengold network systems administrator american museum of natural history [EMAIL

Re: Date formating

Jesse Shy writes: I am push a couple of date fields to mysql via the myODBC driver, however the fields are in there original format as JUN01/01 and the like. Right now these fields are type CHAR and I cant do any calculations on them. Is there a built in function to make this a legitimate

Re: 3.21.33b mysql_install_db

fil krohnengold writes: Am I crazy, or should there be some CREATE TABLE statements somewhere in the mysql_install_db script? It keeps dying on me with: Starting mysqld demon with databases from /usr/local/mysql/data ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) The

Re: mysql client exits with core dump segmentation fault

[EMAIL PROTECTED] writes: Description: ##After building mysql and installing the GRANT tables I start the daemon ##and then try to run the mysql client to alter the GRANT tables to a ##useful configuration. Subcommands like connect and use seem to work ##ok, but if I try

Re: gui client

Marinos writes: Hi, i'm newbee in mysql and i want to ask you 2 questions i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2. 1) Is it possible to use more than one command in mysqlgui (the end of line charachter ; is not working) 2)Can i load and execute a text file

RE: 3.23.47 compile problems with sun's forte compiler

Hi! Quentin == Quentin Bennett [EMAIL PROTECTED] writes: Quentin Hi, From the cc(1) man page for Forte Developer 6.2 Quentin These predefinitions are valid in all modes: Quentin __sun Quentin __unix Quentin __SUNPRO_C=0x530 Quentin __`uname -s`_`uname -r` Quentin __sparc (SPARC) Quentin

Hardware Help.

We have been using mysql for some time to run and administer our dynamic content sites. During this time we have run mysql on low end intel hardware (dual PIII 900 with a gig of RAM) on linux and have discovered that a single mysql server in this configuration could not handle all the traffic

Re: Hardware Help.

Kris Saw writes: We have been using mysql for some time to run and administer our dynamic content sites. During this time we have run mysql on low end intel hardware (dual PIII 900 with a gig of RAM) on linux and have discovered that a single mysql server in this configuration could not

facing problem with NOT NULL fields

I created table using following syntax, create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According

Re: OK - Simple Timestamps problem getting the better of me!

David, My system (3.23.40-nt and MySQL-Front 1.18b as client) produces (what I think is) the desired result using both/either the NULL or NOW() alternatives - NOW (without function parentheses) is not recognised. However the INSERT statement below does not work without the addition of the

Plz help w/ php/MySQL

The following php script successfully e-mails both messages but it doesn't update in the table scr_149 the column notified. Why? ?php // file: root/adm/e_mail.php, updated: 01/05/02 $connection=mysql_connect(localhost,wagner,123) or die (No connection!); // db

Re: facing problem with NOT NULL fields

Manjeet writes: I created table using following syntax, create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user

RE: facing problem with NOT NULL fields

* Manjeet create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According to me this statement

RE: Plz help w/ php/MySQL

* Anthony Rodriguez The following php script successfully e-mails both messages but it doesn't update in the table scr_149 the column notified. Why? Try moving this line: $qry_2=update scr_149 set notified='y' where username='$username'; ...after this line: $username=$row_1[username];

Re: further compile problems on Solaris 2.6

At Sat, 05 Jan 2002 15:15:15 +0200, [EMAIL PROTECTED] wrote... : fil krohnengold writes: : : I wish it were as easy as a botched gcc install. But it's not. : I just tried using the pre-compiled binary from ftp.ibiblio.org : for 2.95.2 with identical reslts. : : -fil : : Try building a

Re: 3.21.33b mysql_install_db

At Sat, 05 Jan 2002 15:34:10 +0200, [EMAIL PROTECTED] wrote... : fil krohnengold writes: : :Starting mysqld demon with databases from /usr/local/mysql/data :ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) :The grant tables was not installed. : : Line 3 being the HERE

How to select on two tables

Hello, all I am sure the answer to the following question is well documented in the manuals, but I just don't seem to recognize it. Please point me to the relevant documentation. I have two tables in the database. Some fields are common (Author, Date) other are specific. I know how to find the

serious password problem

OK, I think I've read the docs and am doing everything right, but I simply cannot get the mysql program to accept a password for any user other than root. I'm on RedHat Linux 7.2, with MySQL version 3.23.46. I can get the root password set up fine, and I log in with it. I can even change it:

Re: serious password problem

I don't know if this is it, but -- 6.11 When Privilege Changes Take Effect When mysqld starts, all grant table contents are read into memory and become effective at that point. Modifications to the grant tables that you perform using GRANT, REVOKE, or SET PASSWORD are noticed by

Re: serious password problem

I don't know if this is it, but I don't think so; I've tried flush privileges, even though the docs don't state it's necessary for GRANT or SET PASSWORD. I've also tried stopping and restarting the mysqld process. -Rob -

Re: serious password problem

Robert A. Knop Jr. writes: ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES) mysql select * from user where user='rknop'\G *** 1. row *** Host: % User: rknop localhost is a

Re: serious password problem

localhost is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. Aha! That did the trick. Thank you very much. (Is this in the manual? If so, I didn't find it. It would

mySQL : 3 or 4?

Good afternoon. My first post to this list (and I am sure it won't be my last ;) ) In the process of biting the bullet and learning AMP, on OS X 10.1.2. Been messing with PHP for a week now, and I totally LOVE it. Coming off an 18-month project in W*/FM/Lasso... ready for a change ;)

Data dictionary as a table

Does MySQL have anything functionally equivalent to the data dictionary views of Oracle? I am thinking particularly of retrieving, via a SQL SELECT statement, a list of all my tables, or a list of all the columns of a particular table along with the columns' attributes. TIA. --Erv

SQL Server 2000

Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check:

RE: Nested Inner Joins

I am having similar nested join problems with the following: SELECT tblThread.Message_date, tblAuthor.Username, tblAuthor.Author_ID, tblTopic.Forum_ID FROM (tblForum INNER JOIN tblTopic ON tblForum.Forum_ID = tblTopic.Forum_ID) INNER JOIN (tblAuthor INNER JOIN tblThread ON tblAuthor.Author_ID =

Newbie Question: Data Type Choice

What’s the best data type to use for storing guest book comments in my database table. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com

Re: Newbie Question: Data Type Choice

From: Kevin Campbell [EMAIL PROTECTED] What's the best data type to use for storing guest book comments in my database table. The best data type would be the kevins_gb_comment data type, but I don't think that's implimented in MySQL yet. If all you are doing is storing and retrieving the

Re: SQL Server 2000

Stan: I don't know as I would call anything involving MSSQL Server 'painless, but it can be done. Do a search of the list archive (http://lists.mysql.com/), looking for 'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of years describing different ways to approach the

Re: 3.21.33b mysql_install_db

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa fil krohnengold writes: Am I crazy, or should there be some CREATE TABLE statements somewhere in the mysql_install_db script? It keeps dying on me with: Starting mysqld demon with databases from /usr/local/mysql/data

mit-pthreads needs select(2) prototype on NetBSD

Hi! Another patch for mit-pthreads under NetBSD. The newer gcc that is now used on NetBSD-current needs a prototype for select(2) to compile mysqld.cc otherwise it aborts with: mysqld.cc: In function `void * handle_connections_sockets(void *)': mysqld.cc:2314: implicit declaration of function

Newbie Question: Float Type Range

I’m using a field in a form to record money values: 0.00 – 9000.00 in my database table. I’m planning on using float(4,2). Does the 4 mean the maximum number of digits before the decimal and the 2 the number of digits after the decimal. Always an Email Away Kevin Campbell Chief Executive

Re: Newbie Question: Float Type Range

On Sat, 05 Jan 2002 11:28:54 -0800, Kevin Campbell [EMAIL PROTECTED] wrote: I’m using a field in a form to record money values: 0.00 – 9000.00 in my database table. I’m planning on using float(4,2). Does the 4 mean the maximum number of digits before the decimal and the 2 the number of digits

Mysql daemon monitoring

Hello , I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface thanks in advance @+ Fred mailto:[EMAIL PROTECTED]

Re: serious password problem

Robert A. Knop Jr. writes: localhost is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. (Is this in the manual? If so, I didn't find it. Heh, it turns out that I was

Re: mySQL : 3 or 4?

Hi If i were in your position i would use 3.23.x mainly because that's what the majority of hosting facilities use as their platform right now. It's a pain to develop something with all the latest and greatest features then realise you have to deploy your app on something not so upto date, if

Re: serious password problem

It's probably a good idea to remove the entry for ''@'localhost'. For many reasons, yes. :) -Rob (SPAMblocker food: sql table query database) -- -=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=- Help the EFF protect basic freedoms online: http://www.eff.org

Niebie again

I have a txt file with sql commands eg: drop table name CREATE TABLE NAME (KD NUMERIC(3), OO CHAR(30)); insert into name values (1,John); insert into name values (2,George); insert into name values (3,Chris); insert into name values (4,Patrick); Using mysql-max-3.23.47 for win98 how can i run

Innodb/Replication problems.

Hello mysql, I'm using mysql 3.23.47 with Innodb and trying to play around with replication. The replication options are default. I got one table content occasionally deleted on slave, and note what this did not stop the replication: The inserts are successfully passed, therefore the

Re: mySQL : 3 or 4?

On 1/5/02, regarding Re: mySQL : 3 or 4? , Girish Nath wrote: Hi If i were in your position i would use 3.23.x mainly because that's what the majority of hosting facilities use as their platform right now. It's a pain to develop something with all the latest and greatest features then realise

repost - compilile problems on solaris 2.6

[gcc version 2.95.2; mysql 3.23.47] : What was the problem you got with compiling MySQL on this platform? : If you follow the instructions in the Solaris section in the MySQL : manual, this should be very straightforward! I'm not getting any errors. My compile is getting stuck at:

help with innodb my.ini config

good day list, i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables and using a access front end w/myodc - this was easy and fun. now i'm trying to config to use innodb tables i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini and added

Re: Innodb/Replication problems.

Hi! -Original Message- From: Peter Zaitsev [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, January 05, 2002 10:35 PM Subject: Innodb/Replication problems. Hello mysql, I'm using mysql 3.23.47 with Innodb and trying to

Re: serious password problem

I see 2 possible problems: 1) syntax: I had to experiment with the mysql line a bit before it worked. Try: mysql -urknop -p password (Note no space before username, password last) 2) Your user has no permissions at all: I've never tried that, but I wouldn't be surprised if it made login

Re: help with innodb my.ini config

Hi! Your my.ini looks ok, except that you should set innodb_data_home_dir equal to an empty string if you give absolute paths in innodb_data_file_path Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the

Changing Ports

I am running MySQL (v 3.23.43) on a Win NT server and require an applet to communicate with the database. Unfortunately the ISP has blocked all access to port 3306 at the router, which I think is the cause for my not being able to load any data in the applet (Meanwhile, beans served up through

Re: mysql client exits with core dump segmentation fault

Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different model machine, but running

Ackward problem...Need help!

I have a RedHat 7.2 machine going, and I'm getting the following error when I run mysqltest after starting the MySQL Daemon... Snip mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Snip First of all, I've

RE: help with innodb my.ini config

my.ini looks like this: #This File was made using the WinMySQLAdmin 1.3 Tool #12/21/2001 6:19:15 PM #innodb code added 1/5/2002 1550CST #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120

RE: Mysql daemon monitoring

Fred, You could use something like daemontools (http://cr.yp.to/daemontools.html) or safetynet (http://www.unixpimps.org/software/safetynet/). All assuming you are using a UNIX-type platform, of course. Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Fred Taurus

Unknown compiler errors (gcc 3.0.1 / 3.1)

Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan gcc -DUNDEF_THREADS_HACK -I./../include

Descending indexes not working?

Hello all, I'm working on a photo album engine where a few MySQL queries find which thumbnails that should be around the image queried (in order of time). I ended up starting with a query to get the time, filename, etc., of the requested image, and then one query for images before and one query

Re: Ackward problem...Need help!

This very cryptic error message is what you get when you try to connect to the mysql server and it's not running. It should probably read: mysql_real_connect(): Failed because there is no server running. Run a server and try again. Anyway, if your machine is properly set up to run mysql on

Re: Quick Update

I noticed that your update says the server just stopped. Try looking in the server error logs under the mysql directory hostname.err, (replace hostname with your own), and it may help tell you what went wrong. -- Steve Rapaport World Citizen

Re: Mysql daemon monitoring

In the last episode (Jan 05), Fred Taurus said: I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface The mysqld_safe script already does

Re: Quick update...

Good try but under Red Hat 7.2 the scripts /usr/share/mysql/mysql.server and /etc/init.d/mysql differ in some respects. Try the latter script instead. Bye, Neil On Sat, 5 Jan 2002, Alexander Trauzzi wrote: Here's a quick update to the problem I posted (which I'll include just for

Re: Quick update...

No dice. I'm not thinking like that's the problem. Those two directories are identical. If anyone feels inclined to, I'll make an account that people can SSH-login into...I'm going bonkers trying to figure out what this problem is... - Original Message - From: Neil Zanella [EMAIL

Re: help with innodb my.ini config

-Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sunday, January 06, 2002 7:54 AM Subject: Re: help with innodb my.ini config Hi! MySQL does not find your my.ini. Try renaming it to my.cnf and put it to the root directory of the C: