auto Incerment

HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra |

Re: auto Incerment

HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra |

RE: Multi-table updates in MySQL

Howdy, Multiple table updates are not available in MySQL. I had the same problem and it was driving me crazy... I suggest you try combining your nice query with some PHP code, did work for me! :) good luck, Maarten Roosen -Original Message- From: Phil Kernick [mailto:[EMAIL

Re: mysqlbug

Hi Winnie, You can run rpm -qa |grep -i mysql to see exactly what the installed packages are named. Then you should be able to uninstall (rpm -e) these packages. On the other hand, there could be some package dependencies, which means, that some other software installed will not run

sum column in mysql

Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx

Connect to Database over the Internet

Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database.

Connect to Database over the Internet

Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database.

determine value of auto-increment field after adding record - @ runtime

I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK relationship. In SQLServer I believe I recall

date field - default value = current date

Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions?

tinyInt(7) - not limited to 7 digits???

If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Thanks. Neal [sql,query]

compiling client only on SunOS 4.1.3

Hi all, Attempting to compile the mysql client only as a non-root user [install locally at $HOME/bin]. I grabbed the source from: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.52.tar.gz uname -a reports: SunOS ka 4.1.3_U1 14 sun4m configure is run as such: ./configure

RE: Connect to Database over the Internet

Bryan, Hi! Did you specify --skip-networking in my.cnf? Check if MySQL is listening on port 3306 (or the port you specified) for TCP connections. Also, I highly suspect that you forgot to set the proper privilege for connections made from hosts other than localhost. SELECT * FROM mysql.user

optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb

Hi! r == rafarife [EMAIL PROTECTED] writes: cut rAnd now, the explain selects: r 1) Slow query r explain Select Cod,Nom,Nif,Nombre_comercial from Clientes r Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642') r Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit

Re: optimizer bug in selecting fields that dont belong to the index used by mysql/innodb

Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Rafa, Heikki OR's are generally difficult to optimize. Heikki, this is true if you are using OR on different keys. MySQL can fully optimise the query when using OR on different key parts of the same key (which is the case for the

AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)

Hi! Sergey == Sergey S Kostyliov [EMAIL PROTECTED] writes: Description: Sergey Server hang when trying to test field=AES_DECRYPT(filed, key) Sergey in case when filed contain garbage. How-To-Repeat: Sergey CREATE TABLE atest( Sergey id

BUG: 'strend' function in libmysql needs to be private

Hi! Ben == Ben Goodwin [EMAIL PROTECTED] writes: Ben There are probably other functions that need to be made private, too.. but Ben this one's directly affecting me. Ben I'm writing a shared library that loads libmysqlclient; When Solaris 'csh' Ben uses said library, there's a clash between

optimizer bug in selecting fields that don´t belong to the index used by mysql

Hi! rafarife == rafarife [EMAIL PROTECTED] writes: rafarife Description: rafarife Hello, rafarife I am working with mysqld-max-nt under windows 2000 and unsing InnoDb rafarife tables. rafarife I have the following table: cut rafarifeI don´t understand why this

RE: aggregate functions producing bad data

Perhaps you should create a new table with an id column and a flag column. Select the found calls 5 or = 5 into that new table and set the flag. Then do a left join of your t_callog_calls table on the new table selecting only the rows where the flag is NULL, these should be the rows not found by

Re: date field - default value = current date

Check TIMESTAMP type in the documentation. Best regards, Mikhail. - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:32 AM Subject: date field - default value = current date Is there a wat to have mySQL auto fill in

optimizer bug in selecting fields that don´t belong to the index used by mysql

Description: Hello Monty, I have already sent to pub/mysql/secret the table definition and data (clientes.txt) and my.ini file in a compressed file named clientes.zip. You can import clientes.txt and test it. I have only then problem with InnoDb tables. I tell you my

My Replication Story

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello All, Hope somebody can shed some light on this as i think my torch is running out of batteries ;-) I have two mysql 4.0.1 servers on two 1Ghz athlon boxes (which are both running on Mandrake linux 8.2). Our main server has been bulked

Re: Japanese Charset

This is for anyone out there storing Japanese characters along with English characters. Hi. SUMMARY: The client recently requested that Japanese be stored in an otherwise standard English (Latin) MySQL database. Whereas all rows in the table used to be Latin only, now some rows store

Re: How to overwrite the /var/lib/mysql path during installation?

On Tue, 17 Sep 2002, Tam,Aaron wrote: I'm installing the mysql-max-3.23.52-pc-linux-gnu-i686 version. But I don't have the root permission, and don't have the /var/lib/ access permission. And I got the following error when I ran the ./configure commend. Do anyone know how to change the

Forgot mysql-root password

Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting

RE: Start mysqld-nt from command line with SPACES in the path, how?

But here you do not specify the --data c:\Program Files\ option. The space couldn't be handled by the mysqld-nt exe, I believe it could have something to do with the fact that it interprets the arguments as 3 strings instead of 2. Regards Tobias Tobias Eriksson ComOpt AB Michael

Forgot Mysql-Root Password

Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting

How to use Auto Increment

Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the second INSERT statement. How can I do it in

MySQL is Crashing

Hi All I have written 2 scripts the first one which will ceate the schema and second one will insert some rows into it. The table type is BDB. Scripts are something like this SCRIPT 1 DROP TABLE IF EXISTS ROLE; DROP DATABASE IF EXISTS ERECRUITER; CREATE DATABASE ERECRUITER; #Start using

Re: sum column in mysql

SELECT *,sum(Duration) as durationsum from table1 WHERE condition should work, Thomas On Wed, 18 Sep 2002 10:32:07 +0300 adi [EMAIL PROTECTED] wrote: Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE

Re: How to use Auto Increment

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I am writing a script where I will have 2 insert statements | The first insert is into a table which has an Auto_Increment field. | I want to know the value which was inserted in this Auto_increment field and | use it in the second INSERT

Re: MySQL on Redhat 7.3

I followed the advice given but get these errors: If I use rpm -Uvh MySQL-3-23-52-1.i386 I get; error failed dependencies MySQL-server conflicts with mysql-server-3.23.49-3 followed by a list of dependencies on libmysqlclient.so.10 If I use rpm -Uvh MySQL*.rpm I get: error failed dependencies

urgent! connecton errors

We have build an ASP site in Delphi which heavy relay on a handfull of .dll files (Active Server Objects) Its actualy quite hard to define our problem, but I can say that our main problem is that on simultanius user-connections the dll's appeare to die, or they don't respond. This problem

Re: determine value of auto-increment field after adding record - @ runtime

last_insert_id() - neal wrote: I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK

Re: Someone has to know something on MySQLGUI?? - PLZ HLP!

hi ,if you're on windows I would use mysqlfront. It has been discontinued but you can still get it from: http://mysqlfront.sstienemann.de/ alternatively, you could use urSQL: http://www.urbanresearch.com/software/utils/urbsql/ cheers Rich David Kramer wrote: Can anyone point me in the

RE: Connect to Database over the Internet

Hi Bryan; First I would direct you to the MyODBC mailing list, as it is generally the place where we VB programmers converse. At any rate, you need MyODBC installed (check the products heading of the MySQL web site for the MyODBC download), and your connection string is wrong. I would detail it,

Re: Forcing a sort order in a join

Did you try a straight join so MySQL won't swap the order of the tables? Philip Smolen wrote: Right. The simple example listed at the bottom of this message works great under version 4. Version 3 gave the right answer, but it was very slow. That made me upgrade to version 4. However, even

Re: Forgot Mysql-Root Password

On Wed, 18 Sep 2002, Mario Ohnewald wrote: Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how

RE: Japanese Characters in MySQL Win2k

Hi, I think Joel Rees wrote an interesting message as well. Hope you read it. I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through ASP/PHP/JSP/Perl DBI. There is no problem as far as I am concerned, it works without a hitch. If your default locale is EN, then you may see

re: determine value of auto-increment field after adding record - @ runtime

neal, Wednesday, September 18, 2002, 11:17:49 AM, you wrote: n I have a table that will auto increment it's PK field upon adding a new n record. I would like obtain that auto-increment value immedicately after n the add of that record so that I may reference it within another table ... n sort

re: date field - default value = current date

neal, Wednesday, September 18, 2002, 11:32:39 AM, you wrote: n Is there a wat to have mySQL auto fill in the current date into my n dateCreated field? n In SQLServer I would simply specify the getDate() method as a default value. n I presume I would use the analogous MySQL function curDate()

re: Re: aggregate functions producing bad data

Jay, Tuesday, September 17, 2002, 10:45:51 PM, you wrote: J On my server the MySQL database decided to die on me. So I killed it and J restarted and that didn't work. So I just rebooted the machine. Now I'm J getting this error below. J Invalid SQL: SELECT COUNT(*) AS messages FROM

re: My Replication Story

Danny, Wednesday, September 18, 2002, 1:08:23 PM, you wrote: DH mysqld got signal 11; DH This could be because you hit a bug. It is also possible that this binary DH or one of the libraries it was linked against is corrupt, improperly built, DH or misconfigured. This error can also be caused by

re: Forgot mysql-root password

Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux MO What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): MO # rcmysql stop MO # mysqld --skip-grant-tables MO Fatal error: Please read Security section of the

Re: Forgot mysql-root password

mysqld --user=mysql --skip-grant-tables Mario Ohnewald wrote: Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual

RE: Marketing materials ??

Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core functionality, are the same. The same rules of database design apply

Re: Forgot Mysql-Root Password

How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Reinstall will only work if you remove the database containing the passwords and users (mysql). Personally I would prefer the way suggested in the manual. Bye, B.

RE: Forgot mysql-root password

AH..thx a lot everybody! -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 18. September 2002 15:34 To: [EMAIL PROTECTED] Subject: re: Forgot mysql-root password Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using

Re: How to use Auto Increment

On Wed, 18 Sep 2002, Rajesh Kanade wrote: Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the

Output of DESCRIBE tbl_name wrong for unique key on NULL column

Description: The output of DESCRIBE tbl_name shows unique keys to be MUL for columns defined as NULL. The SQL shown is a minimal test case that creates a new database and two tables, both with a unique key on the column uni The first table is fine. The second table bug shows the wrong output

Manual doesn't describe output of DESCRIBE tbl_name

Description: Currently the manual contains circular references for EXPLAIN tbl_name, DESCRIBE tbl_name and SHOW COLUMNS FROM tbl_name. None of the relevant sections explains the output, they just refer you to one of the other sections. If the output of this command *is* described somewhere,

win32 and security

Hah!! Wondering if anyone could tell me of any MySQL specific security vulnerabilities on win32? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mysql LIKE number

I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance

Re: mysql LIKE number

adi wrote: I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance column1 REGEXP [0-9] -- Ralf Narozny

Re: My Replication Story

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Victoria Reznichenko wrote: | As far as I remember there was found and fixed the similar bug in | 4.0.3. Could you provide output of SHOW CREATE TABLE for testing? Hi Victoria, When you say 'SHOW CREATE TABLE' I assume you mean during the

Update database from different hosts

I must update the same table in two databases from differents remote host es: DatabaseA:tableA DatabaseB:tableA how can do ? Without using mysqldump if possible... - Before posting, please check:

Re: 4.6.3 Adding a New Character Set

Hi, Can anybody tell me source for getting information on 4.6.3 Adding a New Character Set in MySQL. I read the manual, it's not clear to me. The steps there does not give enough information to start. Thanks, Bhushan.

optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb

Hi! rafarife == rafarife [EMAIL PROTECTED] writes: rafarife Description: rafarife Hi Heikki, rafarife I'm Lourdes and I work with Rafa in the MySQL project. rafarife We have done what you have told us. We have run SHOW STATUS before rafarife the query and we have obtained the next result:

Updating a slave db not within the firewall

Hello, I would like to update my slave mysql server which is not within the firewall, however, the master is. Is there anyway I can do it without opening mysql port in the firewall. In other words, is there anyway I can make my master update the slave without slave initiating the request?

user defined functions under windows

I am trying to create a user-defined function for mysql. I am using a windows binary version of mysql and visual c++ to compile the code. I have created a dummy function call func_test that just returns 1.0. I compile this within a win32 dll project and get a file called funcdll.dll. This

Problem with install on Sun sparc solaris OS 5.8

Installed version 3.23.45 from a package on sunfreeware.com Installation was successful. Having a problem creating the priv tables and starting the myslqd server. When I try to run ./scripts/mysql_install_db, the script prepares all the tables, then dies when it is in the process of

anyone using OS X server and publishing mySQL?

I'm considering moving a mySQL dbase off an expensive ISP and in-house to host ourselves on OSX Server. Has anyone tried this? Any advice or warnings? Thanks! -Bill - Before posting, please check:

re: Output of DESCRIBE tbl_name wrong for unique key on NULL column

jwakely, Wednesday, September 18, 2002, 5:46:19 PM, you wrote: jamdc The output of DESCRIBE tbl_name shows unique keys to be MUL for columns jamdc defined as NULL. jamdc The SQL shown is a minimal test case that creates a new database and two jamdc tables, both with a unique key on the column

re: MySQL is Crashing

Rajesh, Wednesday, September 18, 2002, 9:32:29 AM, you wrote: RK I have written 2 scripts the first one which will ceate the schema and RK second one will insert some rows into it. RK The table type is BDB. RK Scripts are something like this [skip] RK If I run these scripts together

Can't Connect From Script

I've got a weird conundrum here that I'm hoping I can get some help on. I'm attempting to install a chat board system called Ikonboard (www.ikonboard.com) with MySQL as the database; setup on it went smoothly until it tried to talk to the database. No matter what I do, I get: mySQL

Re: BUG: 'strend' function in libmysql needs to be private

I was about to email bugs/lists back today to basically say I've found a reasonable workaround.. I'll respond to your message though in case you see something that needs attention ... strend() is a function we use a lot in the MySQL client code and is thus included in the libmysqlclient

Server shutdown

Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did mysql_install_db. I started the server by saying bin/safe_mysqld --user=mysql . The server started my creating mysql.sock file in the /tmp directory. Now i want to stop the server. How should

installin mysql on win 2000

I will begining to install mysql on my server in a few days. I have never done this before. Is there anything i need to know, any problems mysql has with 2000 server? Any help is appreciated. Ryan - Before posting, please

RE: Server shutdown

if all fails try killall mysqld after that you can do an lsof -i :mysql_port to see if it is still running, you have to have lsof package installed dont know if you have it by default on solaris ..never used solaris b4 :) ma 2cents cheers David Ziggy Lubowa Network Administrator One2net (U)

Re: Server shutdown

I tell you that there is a simple script under whatever/mysql/share/ that is called mysql.sever and it manages the mysql server in a very fashionable way: simply type mysql.server start or mysql.server stop. I use the script to launch the server when my linux box starts. Another posibility is to

About browscap

Hi, Finally, I installed mysql and php successfully. The mysql commands line run well and phpinfo(); gives me information. To do a test to run with php script, I wrote the following script in test.php: *** Beginning *** ?php #Le serveur auquel l'utilisateur peut accéder; $host=localhost;

RE: installin mysql on win 2000

I have it installed on my w2k w/sp3 server and I don't have any problems with it. -Original Message- From: Ryan Cavanaugh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: installin mysql on win 2000 I will begining to install mysql

Re: installin mysql on win 2000

Hello Ryan, No real problems with Windows 2000 Server and Adv. Server. Install SP3 before MySQL as the SP installation might remove the MySQL service registration in some cases. The setup process itself is an extremely straightforward one, taking just two or three minutes. The manual has good

Re: anyone using OS X server and publishing mySQL?

I'm not running on OSX Server, but I am running on regular OSX without any problems. I just downloaded v4 of MySQL and am trying to play with it on my laptop. I'm getting path errors when trying to run it, but I haven't played with it much yet. You can download v3 from www.entropy.ch, which

Queries Per Second

Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Queries Per Second

At 14:00 -0600 9/18/02, Mike Hillyer wrote: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? real time defined how, exactly? Mike -

myODBC 3.51 and OpenOffice1.0.0 doesn't work together.

I tried to use myODBC 3.51 to connect OpenOffice1.0.0 to my MySQL db on my 'Debian GNU/Linux Sarge' machine. I was able to view tables and addbut I wasn't able to add new records. I installed the 'stable' version of the myODBC driver and then it worked. (Same options/programs other myODBC

Re: Queries Per Second

In the last episode (Sep 18), Mike Hillyer said: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Request status twice, with a 1-second delay in between. -- Dan Nelson [EMAIL

Re: Queries Per Second

From: Mike Hillyer MH Is there any way to get a real time queries per second in MySQL as MH opposed to the average given when I request the server status? From: Dan Nelson DN Request status twice, with a 1-second delay in between. I think what Mike is looking for is an average across a time

Re: Thanks to MySql and it's Developers

I can only think that's because you haven't used a Windows system. My principal client's Windows system has been up for over a year. Win2K Server. I brought the server down a couple of times to update table structures etc., but the OS has never failed us. Not once. Arthur - Original Message

Creating new users

Hi all, I have MySQL server installed in Solaris 2.8. 1. How can i change the existing password for a user? 2. How can i delete an existing user? 3. How can i create a new user and associate a password for that new user? Could anyone please help? Best regards and thanks in advance, -skd

OT? mysql_init error w/ perl

Hello, I'm sorry for posting this here. I tried the msql-mysql-modules list but mine was the only message posted within the past few days, so I doubt I'll be getting any help :) I am getting the following error while trying to run a perl script to access some information. DBD::mysql seems to

Re: Queries Per Second

On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Use mytop: http://jeremy.zawodny.com/mysql/mytop/ That's partly what I wrote it to do.

Re: Creating new users

On Wed, 18 Sep 2002, Shravan Durvasula wrote: |Hi all, |I have MySQL server installed in Solaris 2.8. |1. How can i change the existing password for a user? |2. How can i delete an existing user? |3. How can i create a new user and associate a |password for that new user? I believe the

Re: Marketing materials ??

On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote: Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core

count function issue

Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Anyone run into anything

RE: Connect to Database over the Internet

Thanks for the reply: The only entry in the .ini file is Server=C:/mysql/bin/mysqld-max-nt.exe I did a telnet xx.xx.xx.xxx 3306 from the remote computer and the conection went through so my computer is accepting from port 3306 This is a dump from SELECT * FROM mysql.user. Does it look right?.

Re: count function issue

At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no

Upgrade from 3.23 to 4.03

I saw the information for upgrading MySQL 3.23 to 4.03 regarding altering table types, etc. If I am using the Windows release can I just install the binaries etc. over the existing installation? Will the new install wipe out the data directory? Thanks in advance!

Re: count function issue

OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the duplicates to determine the most popular

Problem displaying results from MySQL database

Hi I have a php script that 'should' get data from a MySQL database and display it in a web page. When I test the script using 'zend development environment' the output appears fine, all the data records, html tags and all. When I try and run it from a browser I keep getting a parse error as

Re: count function issue

At 17:26 -0500 9/18/02, McIrvin wrote: OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the

Re: count function issue

Thanks but no change. --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:41 PM Subject: Re: count function issue At 17:26 -0500 9/18/02, McIrvin wrote: OK,, I'll clarify: A query

Re: auto Incerment

Hi Well... I tried all the methodes, tried inserting with out the id, with NULL id with 0 as id. No of them seems working :-( Any other ideas?? Thanks you Arjen van der Weijden wrote: Leave out the id column in your insert-statement

Re: count function issue

No,, I dumped the table and put it on a different server and tried it there. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 6:37 PM Subject: Re: count function issue Thanks but no change. --=C And the

Re: How to use Auto Increment

At 9:30 -0400 9/18/02, Neil Mansilla wrote: On Wed, 18 Sep 2002, Rajesh Kanade wrote: Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was

Re: auto Incerment

At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote: HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null |

Re: sum column in mysql

At 10:32 +0300 9/18/02, adi wrote: Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx To display as seconds: SELECT

Re: tinyInt(7) - not limited to 7 digits???

At 1:41 -0700 9/18/02, neal wrote: If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Naw, just redefine the JAVA_HOME

Re: date field - default value = current date

At 1:32 -0700 9/18/02, neal wrote: Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for

Re: mysql and VB.NET

At 15:39 -0400 9/16/02, Fengling_Li wrote: Hi, Our company will start a new project soon. We might want to use mysql database. Now I have a question, does mysql work with VB.NET? if it does, could you tell me how ? Here's some information that may be helpful:

  1   2   >