Re: Beginners Query

Try logging on as root. - Original Message - From: LinuxTech Inc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 14:16 Subject: Beginners Query hi I am new user to mysql I want to create a new database on my machine where mysql is installed at linux platform

Delete if fields are older than x months

Hello, I've a messageboard. Now, I want to delete all messages older than 3 months. Can I use a MySQL query to delete all messages or do I have to use mktime()? Thanks, Wilko Miletic - Before posting, please check:

RE: Delete if fields are older than x months

DELETE FROM mbtable WHERE timecolumn DATE_SUB(NOW(), INTERVAL 3 MONTH); Hello, I've a messageboard. Now, I want to delete all messages older than 3 months. Can I use a MySQL query to delete all messages or do I have to use mktime()?

Delete in many tables

Hi, I have a problem when I shall delete some records (more than one) from a couple of tables which has relations between each other. One whay to do this and it's to select all elements I want to delete from the primary table and then delete from the secondary table and then later on delete

MySQL + Linux

Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide they say that it's done by typing '/usr/local/bin/mysqladmin -u root -p password new-password', but how would i know the old passsword? Am i mising anything? Thanks for helping! By the way, i'm

rename table

hallo i want to change the name of a table. what must i do? -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] -

Re: rename table

In the last episode (Jun 27), Michael Ott said: hallo i want to change the name of a table. what must i do? http://www.mysql.com/doc, enter rename table, hit search: http://www.mysql.com/doc/R/E/RENAME_TABLE.html Before posting, please check: http://www.mysql.com/manual.php (the

RE: rename table

Try this; ALTER TABLE old_table_name RENAME TO new_table_foobar \david -Original Message- From: Michael Ott [mailto:[EMAIL PROTECTED]] Sent: den 27 juni 2001 09:19 To: MySQL-Mailing-List Subject: rename table hallo i want to change the name of a table. what must i do? --

question about PHP4 setup on Win98...

greetings, any advice on setting up PHP4 in collabaration with MySQL on Win98? thanx... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: lower_case_table_names issue

From my experiance, you cant, you can use all table names lowercase, but that will mean you will have to refer to them in lowercase when issuing queries. unix, unlike windows, tends to operate in a case sensitive manner on everything -Original Message- From: Rui Rosa [mailto:[EMAIL

RE: MySQL + Linux

The password starts off as nothing i.e on a fresh install you dont need to supply a password, another way to set the password is to log in , switch to the mysql database (use mysql;) and issue these queries UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES;

RE: MySQL + Linux

Hi! Does anybody know how do i change the 'root' password for mysql server? I installation guide they say that it's done by typing '/usr/local/bin/mysqladmin -u root -p password new-password', but how would i know the old passsword? Am i mising anything? Leave out -p

ResultSet Problem

I am giving a query to MySQL which contains order by RowNo.When i give this query on mysql prompt it gives me resultset in ascending order,but when i give the same query through java program(servlet) it gives me resultset in descending or any random order. before yesterday everything was

Re: More questions about Fulltext searching.

Hi I have posted this before. You can do an AND search by using the IF() function. Its messy in the query but it works. Here an example of my select query - 3 inputs are checked as AND: SELECT author, title, year, recommend, copy, publ_desc, publ_loc, CEILING(IF(MATCH author AGAINST (

Mysql via ODBC

Hi, I am trying to access a mysql unix database from Clarion. Setting up the database throgh ODBC Administrator and then accessing through Clarion is Fine. However depending on selections mad by the User we need to connect to a different MySQL database. Claion suggessted creating a file DSN to

problem administering mysql database (urgent!!)

dear sir, i am a new user to mysql database. i want to write command in mysqldump for backing up of my database named -testDB.But this .exe quits off automatically before i write command.will you please give me suggestions? regards, mukul from singapore.

[Bug report] Databases disappear from the server - (vi.recover)

Description: - This morning we were unable to access our databases from our applications. After a closed check in the mysql-server, I found out that all the databases had disappear. A show databases returned only ONE DB named vi.recover , Is the first time I see this DB in our server.

reindexing table

Hi, How can I reindex any table in mysql. Thanks Mucahit

New version and release of MySQLGUI

HI! Sub releast 1.5-1 of mysqlgui in the form of static binaries for Linux and Windows has been upload on it's page on our site. What follow is from readme for this sub-release. This is a stable version of the MySQLGUI version 1.7.5-1 This sub-release has just some bug fixes, especially

[PATCH] fix float parser for 1.1E1

Please send me comments also to my e-mail address because I'm not on the list. Regards. -- Cristian Paslaru http://devel.iasi.ro cut diff -ruN mysql-3.23.39.orig/sql/sql_lex.cc mysql-3.23.39/sql/sql_lex.cc --- mysql-3.23.39.orig/sql/sql_lex.cc Tue Jun 12 22:07:26 2001

RE: HELP NEEDED: Problems with SELECT in combination with HAVING

Hey Hans - it didn't work (damn) but thank you for your reply and sorry about the accidental mail you got. The result that was produced had the correct time but it was not attatched to the correct row. It was instead attached to the first row that MySql found in the RobotRun table. I have found

install service on nt

i've been trying to install mysql as service on nt... mysql is currently working fine without it installed as a service... mysql is installed in D:\mysql tried the following in vain... 1. mysqld-nt --basedir=d:\mysql --install -- not valid 2. copy and edit c:\my.cnf and set basedir=d:\mysql\

Re: PLEASE READ: Porting Windows VC++ MySQL Proggie to Linux\Unix

David Ayliffe writes: I appreciate that this might be a bit off topic but any help would be appreciated. I need to port this program (attached) to the Linux environment. This is the first program I have attempted to port. Has anyone ever had to port from Windows to Linux\Unix, and if so

RE: HELP NEEDED: Problems with SELECT in combination with HAVING 2

Hey Hannes - it didn't work (damn) but thank you for your reply and sorry about the accidental mail you got. The result that was produced had the correct time but it was not attatched to the correct row. It was instead attached to the first row that MySql found in the RobotRun table. I have

Single-user `MYSQL.DLL' server

On MySQL manual one reads: Here are some open issues for anyone who might want to help us with the Windows release: * Make a single-user `MYSQL.DLL' server. This should include everything in a standard *MySQL* server, except thread creation. This will make *MySQL* much easier to

Re: COnversion from Btrieve to MySQL

Marchetti, Peter writes: Has anyone ever attempted, or succeded in converting a Btrieve database to a MySQL database? Peter Marchetti Media Visions, Inc. [EMAIL PROTECTED] You will have to make CREATE TABLE statements yourself. For the data use butil to get comma delimited file.

Re: Got timeout reading communication packets

Seth Northrop writes: But.. why would the console be reporting this? Ie, I'm getting the same result (same error in the error log, same truncation) when I manually pipe the query to the mysql console. (Note that the errors are coming from localhost; the actual script is run from a

Re: install service on nt

Try using forward (/) instead of back (\) slashes ... d:/mysql instead of d:\mysql - Original Message - From: Maria Aurora VT de la Vega [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 1:33 PM Subject: install service on nt i've been trying to install mysql as

RE: install service on nt

2. copy and edit c:\my.cnf and set basedir=d:\mysql\ and try mysqld-nt --install and then net start mysql -- specified file not found error I think you need to use / instead of \ in your path as per the documentation. ie: basedir=d:/mysql/

Re: auto-increment sequence question

thank you all for your help, this was the explanation I needed, LAST_INSERT_ID() with an argument creates a value that can be treated just like it's an AUTO_INCREMENT value. That means you can call LAST_INSERT_ID() without an argument later in the current session to retrieve the value you

[PATCH] fix float parser for 1.1E1

The case for this patch is that you can do sql queries with 1.1e+1 to say, or 1.1e01, but if you try 1.1e1 will give you an error. I try it on MySQL 3.23.39 and 3.23.33. I think this is a very old and not seen bug. Regards. -- Cristian Paslaru http://devel.iasi.ro cut

Re: Delete in many tables

Johan Nilsson writes: Hi, I have a problem when I shall delete some records (more than one) from a couple of tables which has relations between each other. One whay to do this and it's to select all elements I want to delete from the primary table and then delete from the secondary table

Re: More questions about Fulltext searching.

--- Colin Faber [EMAIL PROTECTED] wrote: Ok, The message set that I noticed this morning sparked my interest in this. Currently I'm developing a search engine that will utilize mysql's fulltext match technology. The problem that i've run into is, I can't seem to find any

Quotation Marks

What is the best way to deal with both single and double quotation marks ' when using php and mysql? I seem to be generating a lot of errors due to these special characters. Pieter De Temmerman [EMAIL PROTECTED] - Before

Re: [PATCH] fix float parser for 1.1E1

Why do you think that this patch is necessary ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/

Re: Single-user `MYSQL.DLL' server

Tiago Luchini writes: On MySQL manual one reads: Here are some open issues for anyone who might want to help us with the Windows release: * Make a single-user `MYSQL.DLL' server. This should include everything in a standard *MySQL* server, except thread creation. This will

Re: Perl Script: MySQL Slow Query Log Parser

You'll find mysqldumpslow (in the mysql distribution) does all that and much much more It's a pity that it's not mentioned in the online documentation since it's a _very_ useful tool. Tim. On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote: I wrote a perl script that will parse

delay times, threads

Running Unix, Apache, MySQL and PHP, should I worry about delay times, and will the server always present the user with the latest database update (after a possible delay)? Suppose a user can add a new row to a database in a PHP page with a form, and after submit, the next page he will see is

Re[2]: databases disappear...

In any case, the problem is not with Mysql - perhaps if you were to enquire on the PHP list with a code sample? Also, it is a good idea to shut down mysql and restart it to see changes written to disk, which is fine to recover memory leaks unde Win, too. I wrote a batch cd c:\mysql\bin

Re: install service on nt

At 19:33 27/06/2001 +0100, Maria Aurora VT de la Vega wrote: Hola, Verifica primero si en el SCM ya existe el servicio llamado mysql instalado. Si existe, entra en el prompt del DOS, y remueválo con el comando: d:\mysql\bin\mysqld-nt --remove Después de eso, edita el archivo my.cnf de la

databases disappear...

[No David, the result set that suddenly goes to 0 is, or should not be empty, it is the result of a SELECT with no WHERE - and there were no deletes yet] For the first time developing a PHP-MySQL system, I am experiencing strange things. Perhaps it is the off-line mode (Localhost) I am

Re: Repairing Tables

Use a backup powersupply and shutdown software to gracefully shutdown after a power fail. Yaw Ofori-Adjei wrote: I have used MySQL for about 2 years nowand I love it. My only problem is that I am in africa were power fluctuations are rampant. I usally get table handelr error 127 after every

Re: [PATCH] fix float parser for 1.1E1

Cristian Paslaru writes: The case for this patch is that you can do sql queries with 1.1e+1 to say, or 1.1e01, but if you try 1.1e1 will give you an error. I try it on MySQL 3.23.39 and 3.23.33. I think this is a very old and not seen bug. Regards. -- Cristian Paslaru

Re: question about PHP4 setup on Win98...

i've never had any problem... Le Wed, 27 Jun 2001, stompbot : greetings, any advice on setting up PHP4 in collabaration with MySQL on Win98? thanx... - Before posting, please check: http://www.mysql.com/manual.php

RE: Perl Script: MySQL Slow Query Log Parser

any idea where any sort of documentation/tutorial can be found? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 1:45 PM To: Nathanial Hendler Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Perl Script: MySQL Slow Query Log Parser

Re:innobase bug w/ 3.23.29???

Monty, there is an SQL optimizer deficiency if a two-column index is used. (Added later: actually not, see the end of this email.) Ryan does the following query, for which there is a very good index on (parentmsgid, clean). But from the printout below we see that though MySQL uses the right key,

RE: DISTINCT

Hannes... The last scenario is exactly the problem i have... when i try to use your example i get an error with the sql when creating the table do i have to specify the data type or anything like that or should it be as simple as CREATE table distinct_records SELECT field_1, field_2, field_3

RE: DISTINCT

Actually I now realise that im solving the wrong proplem. here is a simplified version of my dilema * NAMEEMAIL AGE tom tom@mail23 dicktom@mail76 petepete@email 54 davecool@mail

Re: MySQL 'locking up'

Perhaps the tmp directory used by MySQL was full. Dawn H wrote: Occasionally, MySQL seems to lock up on the Linux box and just sit there. It did it today for three hours before we realized it. When this happens, the only thing we know of to do is restart it, and this time it wouldn't shut

Re[2]: Perl Script: MySQL Slow Query Log Parser

You'll find mysqldumpslow (in the mysql distribution) does all that and much much more Sorry, not on my server (MySQL 3.22.32). It's a pity that it's not mentioned in the online documentation since it's a _very_ useful tool. http://www.mysql.com/udmsearch/search.php?q=mysqldumpslow shows

Visual Foxpro

Tengo una base de datos en Mysql pero programando en visual foxpro no me regresa la informacion no se, si hay que hacer algo en especial ?? el codigo en que hace la conexion es el sig. STORE SQLCONNECT('Sipaae') TO db_conec IF db_conec = 0 = MESSAGEBOX('Falla al Conectarse al

Re[2]: question about PHP4 setup on Win98...

What exactly is the problem? There are some tutorials out there, for example http://sourceforge.net/projects/phptriad/ any advice on setting up PHP4 in collabaration with MySQL on Win98? thanx... -- Herzlich Werner Stuerenburg _

Re: Quotation Marks

What is the best way to deal with both single and double quotation marks ' when using php and mysql? I seem to be generating a lot of errors due to these special characters. use functions addslashes and stripslashes when inserting and retrieving, resp. See

Re: delay times, threads

Suppose a user can add a new row to a database in a PHP page with a form, and after submit, the next page he will see is a page displaying part of the same database, hopefully with his new row on top. Questions: A) will he always see the new data which he entered just a second before? Yes.

permissions and table creation

mysql fans, I'm very new to mysql and adminstration of database software in general. I'm not clear as to how the permissions of mysql work, specifically, there is a root user (on the database, not the system) which has special privileges to perform certain tasks. If I understand correctly,

Re: Perl DBI Error 19

Your inner loop usage of $sth overwrites the result set of the outer loop. Use a different variable. Hannes Niedner wrote: I am having trouble with DBI. I wrote a little script that should update fields in one table (uid_test) based on values in another table (merge). I updates one row and

Re again: More questions about Fulltext searching.

Hello Matthew, I posted this earlier today but maybe you didnt get the message. This definitely works for me, and its definitely an AND search (example): SELECT author, title, year, recommend, copy, publ_desc, publ_loc, CEILING(IF(MATCH author AGAINST ( 'Adams') 0, IF(MATCH title AGAINST

Host is not allowed to connect to this MySQL Server

Hi, When I try to connect from another machine (using MySQL Front) I'm getting the following error message: == Error Connection failed 1130 - Host is not allowed to connect to this MySQL Server == I

RE: DISTINCT

Well, I can say that the problem is becasue of GROUP BY clause. I'd say its use in that query is void isn't it? Correct me if I'm wrong, but as far as I know, there should be summary functions in your select, which I cannot see in yours. So it should give you an error -sherzdoR On Wed, 27 Jun

RE: DISTINCT

Try this: CEATE TABLE new_table SELECT DISTINCT NAME, EMAIL, AGE FROM whatever_table On Wed, 27 Jun 2001, tom harrow wrote: Actually I now realise that im solving the wrong proplem. here is a simplified version of my dilema * NAME EMAIL

Re: Creating Table with a Default Datetime field

TIMESTAMP is not the solution to his problem; he wants the date to default to now() when the record is created, not updated. There's currently no way to do this in MySQL; default values must be constants. --Pete hi. check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column

Undefined symbol

When i install php3 module in apache server i see this: /usr/www/bin ./apachectl configtest Syntax error on line 22 of /usr/www/conf/httpd.conf: Cannot load /usr/www/libexec/libphp3.so into server: Undefined symbol _uncompress in httpd:/usr/local/mysql/lib/mysql/libmysqlclient.so.10.0 OS:

Undefined symbol _uncompress libmysqlclient.so.10.0

When i install php3 module in apache server i see this: /usr/www/bin ./apachectl configtest Syntax error on line 22 of /usr/www/conf/httpd.conf: Cannot load /usr/www/libexec/libphp3.so into server: Undefined symbol _uncompress in httpd:/usr/local/mysql/lib/mysql/libmysqlclient.so.10.0 OS:

multiple database issue on winNT4.0

Hi, Can I connect to multiple databases on a 4.0 NT box? I created a test database on the same box that has the pre-production ddb, and I can not connect to it using the same PHP scripts [I redirected the scripts to look to the new test ddb] and all I had is my PHP trap statment Unable to connect

MySQL Installation Help Requested.

is there anyone who icq and who has a few minutes that might be willing to help me out with the mysql install? i have been having some trouble, so i figured i would check and see if there was anyone who could help a newbie out. Jason

mysql++

Hi! downloaded mysql++-1.7.9 tar ball from www.mysql.com and attempted to set it up..this is th eoutput when doing automake in the mysql++-1.7.9 directory, as said in the README [root@171 mysql++-1.7.9]# automake automake: Makefile.am: required file `./INSTALL' not found automake: Makefile.am:

Re[2]: DISTINCT

* NAMEEMAIL AGE tom tom@mail23 dicktom@mail76 petepete@email 54 davecool@mail 21 steve steve@mail 17 marycool@mail 89 thomas tom@mail

Does MYODBC not support Lotus Approach

I can't get it to work... does MYODBC not support Lotus Approach Regards Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Creating Table with a Default Datetime field

Sorry, for quoting the manual but this might be just another example where it could have the answer right away: Hannes http://www.mysql.com/doc/D/A/DATETIME.html The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date

Re: Creating Table with a Default Datetime field

I, c. Then you just have to INSERT INTO it NOW() manually, that works On Wed, 27 Jun 2001, Pete Harlan wrote: TIMESTAMP is not the solution to his problem; he wants the date to default to now() when the record is created, not updated. There's currently no way to do this in MySQL;

Re: DISTINCT

On 6/27/01 8:48 AM, Sherzod Ruzmetov [EMAIL PROTECTED] wrote: That should work without errors and was one of my suggested ways (can still be seen down below). The group by query works for me the same way like the distinct query, given that all selected fields give you a unique combination (so

Re: Creating Table with a Default Datetime field

Well, almost true. On insert, all timestamp fields are updated. On update, only the first timestamp field is updated. So, If you have two timestamp fields, you can get the result you want. Pete Harlan wrote: TIMESTAMP is not the solution to his problem; he wants the date to default to now()

RE: Creating Table with a Default Datetime field

hi. an alternate solution is to have a table like this: Create table( UpdatedDatetimestamp(14), CreationDatetimestamp(14), Infovarchar(100) ); as mysql only automatically updates the _first_ timestamp column in a table. hth. -ravi. -Original

Re: HELP NEEDED: Problems with SELECT in combination with HAVING

Thomas You might want to consider to post a sample select from the table, some things become apparent just then. Hannes On 6/27/01 3:35 AM, Thomas Michael Koch [EMAIL PROTECTED] wrote: Hey Hans - it didn't work (damn) but thank you for your reply and sorry about the accidental mail you got.

RE: Creating Table with a Default Datetime field

Wait, I didn't get the following: an alternate solution is to have a table like this: Create table( UpdatedDatetimestamp(14), CreationDatetimestamp(14), Infovarchar(100) ); as mysql only automatically updates the _first_ timestamp column in a table.

Re: MySQL Installation Help Requested.

i originally tried to do it with the /stand/sysinstall on bsd, and it installs it fine, but i am using the program MySQLFront to try and access it, and it keeps coming up Host perm202-202.ij.net is not allowed to connect to this mysql server the host name perm202-202.ij.net is host of my

Re: Host is not allowed to connect to this MySQL Server

I guess if you are updating user columns directly, you need to restart mysqld in order for changes to take effect... I think, that was a case with me... - Original Message - From: Juan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 5:24 PM Subject: Host is not

RE: Creating Table with a Default Datetime field

hi. assuming all inserts and updates never specify a value for UpdatedDate or CreationDate, on the initial insert: mysql insert into table (Info) values ('blahblahblah'); they will both be set to '20010627125429' or something. any subsequent updates: mysql update table set Info='somethingelse'

host.ISM

Hello, I just updated MySQL 2.22 to 2.23 and when I went to restart the server, I got this error message in the /var/lib/mysql/err.log file: 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno: -1) mysqld ended on Wed Jun 27 11:19:22 PDT 2001 I've never seen this and can't

RE: Creating Table with a Default Datetime field

Thanks, ravi. Have I missed that in the documentation? If it is not there, could you guys include it please. I think It's a good one -sherzodR On Wed, 27 Jun 2001, Ravi Raman wrote: hi. assuming all inserts and updates never specify a value for UpdatedDate or CreationDate, on the initial

natural sort

How many people would be interested in this feature? On Wed, Jun 27, 2001 at 01:46:05PM +0300, [EMAIL PROTECTED] wrote: Brannon King wrote: Any plans for a natural sort? A query to the effect of ORDER BY [~] NATURAL ASC or ORDER BY [~] NATASC etc. That would be

Re:innobase bug w/ 3.23.29???

Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Monty, Heikki there is an SQL optimizer deficiency if a two-column index is used. Heikki (Added later: actually not, see the end of this email.) Heikki Ryan does the following query, for which there is a very good Heikki index on

Re: Creating Table with a Default Datetime field

Only the first timestamp is updated by MYSQL. Create two timestamp fields. MySQL will maintain the first one. Set timestamp2 to null when the record is created. Regards, Rich At 10:54 AM 6/27/01 -0500, Pete Harlan wrote: TIMESTAMP is not the solution to his problem; he wants the date to

redhat 7.1 setting up mysql

I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the past I've had problems with the setup. I had a person come in and setup mysql on redhat 6.0 ( 2 1/2 days later he had it running) the program has been riddle with bugs. The questions are: ( note: mysql is not

Re: Host is not allowed to connect to this MySQL Server

I guess if you are updating user columns directly, you need to restart mysqld in order for changes to take effect... I think, that was a case with me... I find a mysqladmin flush-hosts fixes it for me. WHY, no one ever has figured out why. When one or more of the systems decides it

Re: Mysql via ODBC

Short answer: yes, there is a way to set it up programatically. Also, by specify the driver, server, connect paramters, etc, you ca sometimes do a DSN-less connection. I do that with an ODBCDirect connection under Access. It doesn't work, however, when I try to attach tables. Look on

Resource temporary unavailable

Hi, I have problem running MySQL on RedHat 6.2 machine. After few hours of work I get message: fork: resource temporary unavailable and only rebooting helps. CPU utilisation is very low (more than 90% idle), so I think there is something wrong with the memory usage. I have about 120

Re: multiple database issue on winNT4.0

At 11:25 AM -0500 6/27/01, Pete Kuczynski wrote: Hi, Can I connect to multiple databases on a 4.0 NT box? I created a test database on the same box that has the pre-production ddb, and I can not connect to it using the same PHP scripts [I redirected the scripts to look to the new test ddb] and

deleting data from a table

Hi everyone I know its very simple to delete or modify table's but what if someone is swearing in your message board and your filters still let him in and its being displayed in your board and you want to delete his post how do you do that? Mark ([EMAIL PROTECTED])

Re: Host is not allowed to connect to this MySQL Server

At 9:23 PM +0200 6/27/01, Oscar E. Salninch wrote: I guess if you are updating user columns directly, you need to restart mysqld in order for changes to take effect... I think, that was a case with me... Or issue a FLUSH PRIVILEGES query. - Original Message - From: Juan [EMAIL

select query for duplicate records

Hi, How would a word a select statment, to search a database for duplicate entries in one field. For example, the fields: device, hostname, IP, comments I want to find all instances where there my be two devices with the same hostname. Thanks! Pete -- ___

Re: Re:innobase bug w/ 3.23.29???

snip Heikki Well, mystery solved :). Except that why MySQL uses hours to Heikki sieve away the extraneous rows in the first query. To be able to answer the question why: SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0 Is slow, I would need to get an EXPLAIN for this query. mysql

Re: host.ISM

I just updated MySQL 2.22 to 2.23 and when I went to restart the server, I got this error message in the /var/lib/mysql/err.log file: 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno: -1) mysqld ended on Wed Jun 27 11:19:22 PDT 2001 See

Table Creation

Hi, I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98, I seem to be missing components? 1. I can only create Databases not Tables? 2. I'm don't know which source editor/compiler I can use? Can anyone help? Thanks.Get more from the Web. FREE MSN

Re: redhat 7.1 setting up mysql

wkd [EMAIL PROTECTED] writes: 1. (*) text/plain I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the past I've had problems with the setup. I had a person come in and setup mysql on redhat 6.0 ( 2 1/2 days later he had it running) the program has

Re: deleting data from a table

On Wed, 27 Jun 2001 16:06:36 -0500, Mark Wakim [EMAIL PROTECTED] wrote: Well depending how your tracking this person, and message related to him, I would image some sort of an ID value assigned to the poster would be the easiest means. something like: DELETE FROM table_posts WHERE userid =

Duplicate entry

I get Duplicate entry errors quite frequently. As a rule in these cases, I check whether a record with this key exists, and in case it does not, take action and insert the record. So there is a minimal time lag, where by chance someone else may have inserted exactly that record. Am I right?

Bug in Like with longblob

Hi, I suppose I found a bug :-) According to LIKE in a SELECT-query is case-insensitive. In fact, it is, when using it on varchars. But with a longblod, it is not. So if the table has column test longblob and there is a colum where test is set to xxAbcdx, the query SELECT * FROM

Re: host.ISM

Werner Stuerenburg wrote: I just updated MySQL 2.22 to 2.23 and when I went to restart the server, I got this error message in the /var/lib/mysql/err.log file: 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno: -1) mysqld ended on Wed Jun 27 11:19:22 PDT 2001

Re: select query for duplicate records

Peter, That comes pretty close to the distinct -thread in this mailinglist. You might want to try: SELECT device, count(hostname) FROM your_table GROUP BY device HAVING count(hostname)1; This would display all devices with at least 2 (or more) hostnames. If you always have the same IP address,

  1   2   >