resetting mysqladmin status

Hi, If I run mysqladmin status it shows uptime, no of questions etc. Can I reset these values to zero without stopping and starting the server. thanks Scott - Before posting, please check: http://www.mysql.com/manual.php

Re: resetting mysqladmin status

On Wed, Aug 22, 2001 at 09:40:13AM +0300, scott.alexander wrote: Hi, If I run mysqladmin status it shows uptime, no of questions etc. Can I reset these values to zero without stopping and starting the server. FLUSH STATUS as described here: http://www.mysql.com/doc/F/L/FLUSH.html

Re: mysqlctl configtest?

On Sat, Aug 18, 2001 at 11:55:52PM -0400, Philip Mak wrote: In Apache web server, the command used to start/stop the web server also has an option called configtest. One can type apache configtest and it will tell you if the configuration file has a valid syntax. This is to save you from the

Re: counting relevance? and error output?

On Wed, Aug 22, 2001 at 12:40:05AM -0600, Camilo Rostoker wrote: Hi, I'm trying to create a search engine that sorts the results by relevance. Relevance means the number of times the tuple was selected during the search phase. How can I check table if a tuple exists (ie: has the same

Re: replace/insert into ... 150,000 -plus rows

On Mon, Aug 20, 2001 at 11:38:57PM -0400, Network wrote: The problem= The 'addy1' column or field (in attdata) is tainted with incorrect data entries ... e.g. 'addy1' should only have addresses stored however, some bright person(s) have managed to input company names in the address/addy1

Re: libmysql - secure connection

Hi thanks I'm glad there's hope! This is proving to be extremely difficult! Regards Elizabeth -Original Message- From: Jeremy Zawodny [EMAIL PROTECTED] To: Elizabeth Alderton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 21 August 2001 23:31 Subject: Re: libmysql -

myODBC on Irix 6.5 follow-up

Hi all, I have now managed to execute the configure script without any errors. However, the Makefile generated still contains errors? Again, has anyone ever managed to build and install myODBC under Irix? Any thoughts is appreciated... thanks! bypass spam filter: sql, mySQL, table,

´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

Hi! How are you? I send you this file in order to have your advice See you later. Thanks ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.pif - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Antigen found =*.pif file

Antigen for Exchange found ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.pif matching =*.pif file filter. The file is currently Removed. The message, ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë, was sent from Zusky and was discovered in IMC Queues\Inbound located at ALBUQUERUQE CONVENTION AND VISITORS BUREAU/ABQCVB/ACVBNT01.

´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

Hi! How are you? I send you this file in order to have your advice See you later. Thanks ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.comType: MS-DOS Application

Is it possible to group by an interval?

Hi, Is it possible for me to do a SELECT COUNT(*) and GROUP BY the answers based on a INTERVAL e.g. HOUR? the e.g. data: ++ | id | time | ++ | 1 | 08:30 | | 2 | 09:30 | | 3 | 09:31 | | 4 | 09:32 | ++ The answer I want from the e.g. data above if using

VIRUS on the list

I got this Virus warning concerning this person: Original message header is included below. Received: (qmail 10967 invoked by uid 7797); 22 Aug 2001 07:42:01 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help:

RE: Is it possible to group by an interval?

On 22-Aug-2001 Johan Nilsson wrote: Hi, Is it possible for me to do a SELECT COUNT(*) and GROUP BY the answers based on a INTERVAL e.g. HOUR? the e.g. data: ++ | id | time | ++ | 1 | 08:30 | | 2 | 09:30 | | 3 | 09:31 | | 4 | 09:32 | ++ The

Re: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

Colin Faber wrote: Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.comType: MS-DOS Application

Re: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

sendmail++ Van wrote: Colin Faber wrote: Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com

Startin MySQL upon boot in Win2k

Since I like my hard drive more tidy than my house, I've put MySQL in C:\Program Files\MySQL. This means that I currently have to start MySQL using a .bat file, since the mysql-daemon won't find the MySQL-directory if I install it as a Service: --- MySQL.bat --- cd C:\Program Files\MySQL\bin

LAST_INSERT_ID()

Hi, in the manual there is this LAST_INSERT_ID() and it is what I actually need but there is some confusion over how to use it in many tables. exerpt http://www.mysql.com/doc/O/D/ODBC_and_last_insert_id.html Or, if you are just going to insert the ID into another table, you can do this:

SV: Is it possible to group by an interval?

Is it possible for me to do a SELECT COUNT(*) and GROUP BY the answers based on a INTERVAL e.g. HOUR? the e.g. table data: ++ | id | time | ++ | 1 | 08:30 | | 2 | 09:30 | | 3 | 09:31 | | 4 | 09:32 | ++ The answer I want from the e.g. data above

mysqldump ?

When I am on machine A and my database is on machine B can I force mysqldump to dump the data to files on machine A. When I try from machine A and use mysqldump it dumps to a directory in machine B. thanks Scott - Before

Re: Startin MySQL upon boot in Win2k

try mysqld-nt --install instead of your own batch script. After run the command, it will install mysql as NT/2000 service among user right. You can check it at Control Panel, System Admin Tool, Service to see its status. MySQL server will then run as a background service whenever

Problems with my.ini in Windows NT

Hi all. I've installed mysql-max 3.23.41 in a Windows NT machine with Service Pack 6. I didn't installed mysql y the default directory (C:\mysql) and also changed the data directory to another directory y another drive (I moved the mysql and test directory of the data directory too). The

Re: Setup own DB for each user?

Ulv Michel schrieb am Mittwoch, 22. August 2001, 11:53:01: Hi all, I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are hosting a small amount of virtual servers, allowing our customers to user php and mysql. My problem is that every user sees every other users

Re: How to get all of mysql error message

½ÉÃ溸 schrieb am Mittwoch, 22. August 2001, 11:50:05: Hi. I examined mysql/Docs/mysqld_error.txt. But this file has error information from errno 1000 to 1175. I want to know all of error numbers and messages I can see when programming mysql access code. From the shell, use perror

Re: Symbol File

Andy Yates writes: Is there a symbol file for the mysqld in MySQL-3.23.41-1.i386.rpm? If so where is it? MySQL keeps crashing and I'm trying to look at the stack trace. Thanks! Andy No, there is no symbol file, but mysql should produce a stack trace in `hostname'.err file. --

Re: LAST_INSERT_ID()

Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 11:31:01: Hi, in the manual there is this LAST_INSERT_ID() and it is what I actually need but there is some confusion over how to use it in many tables. exerpt http://www.mysql.com/doc/O/D/ODBC_and_last_insert_id.html Or, if you are

Re: Startin MySQL upon boot in Win2k

Mikkel Gravgaard schrieb am Mittwoch, 22. August 2001, 11:16:47: Since I like my hard drive more tidy than my house, I've put MySQL in C:\Program Files\MySQL. This means that I currently have to start MySQL using a .bat file, since the mysql-daemon won't find the MySQL-directory if I

Query optimization issue.

Hello mysql, I was trying to load very huge (5GB 45mil rows) to the text dump in sorted order (according to primary key). The problem is mysql somehow does not wants to scan the table by primary key to produce sorted output row by row, but prefers to use filesort which would take

Re: Looking for Info on

[EMAIL PROTECTED] schrieb am Dienstag, 21. August 2001, 21:07:24: Also I am looking for and examples on building a MySQL Manager in Delphi as well. There is one out there already: http://mysqlfront.de See also http://anse.de/ -- Herzlich Werner MySQL in Deutschland: Anpassung,

Re: Problems with my.ini in Windows NT

Iago: Your my.ini file appears to be correct. Check to see if there is a my.cnf in the root of the C: drive ... there should not be one. Am I correct to assume you installed the service before attempting to start it? Check the WinNT Service Control Manager in the Control Panel. Make sure you

Re: Mysql Installation

Jaitly, Rajiv (Contractor) schrieb am Dienstag, 21. August 2001, 10:14:33: I installed the latest release of MYSQL on windows 2000 environment (non networked). I would like to add the mysql server start up as a service at system startup. Could anybody tell me how to do this. From my

Problem with user rights

I wanted to install MySQL under Windows 2000 with default-charset=latin2. I cannot use binary distribution because it is not compiled with this charset. So, I loaded and compiled source for MySQL 2.3.41 under Cygwin (Win32, POSIX compatible). I received no errors. My problem is, that I can run

Re: Query optimization issue.

Peter Zaitsev wrote: Hello mysql, I was trying to load very huge (5GB 45mil rows) to the text dump in sorted order (according to primary key). The problem is mysql somehow does not wants to scan the table by primary key to produce sorted output row by row, but prefers to use

Re: mysqldump ?

Date |Wed, 22 Aug 2001 13:08:20 +0300 (EEST) From |scott.alexander [EMAIL PROTECTED] Hello! S When I am on machine A and my database is on machine B can I force S mysqldump to dump the data to files on machine A. S When I try from machine A and use mysqldump it dumps to a directory in S

Re: A couple of questions about connections

Date |Tue, 21 Aug 2001 10:01:30 -0500 From |Tony Wells [EMAIL PROTECTED] Hello! TW Hi all, TW I'm running MySQL Ver 3.23.32 for -freebsd4.2 on i386, With PHP4 TW compiled statically into Apache 1.3.17. All connections to the database TW are non-persistent connections. It's a pretty busy

Re: Help! problems installing mysql-client and mysql-devel rpms on RedHat

Date |Tue, 21 Aug 2001 13:33:18 -0700 From |Steve Vu [EMAIL PROTECTED] Hello! SV I downloaded the MySQL-client and MySQL-devel rpms but get the following SV errors (I was able to install MySQL from a tarball): SV [root@localhost svu]# rpm -U *.rpm SV error: MySQL-client-3.23.40-1.i386.rpm

Re: LAST_INSERT_ID()

At 13:19 22.8.2001 +0200, you wrote: LAST_INSERT_ID() should return the last autoincrement value of the last insert Yep it sure did, managed to get to machine and test it out. Total mess. but; $query = SELECT LAST_INSERT_ID(); $result = mysql_query($query); if ($result) { $nrows =

Re: counting relevance? and error output?

Jeremy Zawodny wrote: On Wed, Aug 22, 2001 at 12:40:05AM -0600, Camilo Rostoker wrote: Hi, I'm trying to create a search engine that sorts the results by relevance. Relevance means the number of times the tuple was selected during the search phase. How can I check table if a tuple exists

Re: LAST_INSERT_ID()

Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06: At 13:19 22.8.2001 +0200, you wrote: LAST_INSERT_ID() should return the last autoincrement value of the last insert Yep it sure did, managed to get to machine and test it out. Total mess. but; $query = SELECT LAST_INSERT_ID();

Re: Query optimization issue.

Rafal Jank wrote: Peter Zaitsev wrote: Hello mysql, I was trying to load very huge (5GB 45mil rows) to the text dump in sorted order (according to primary key). The problem is mysql somehow does not wants to scan the table by primary key to produce sorted output row by

RH Linux 7.1 Binary Install Configure and Auto start/stop

Good Morning. I recently installed mysql-3.23.41-pc-linux-gnu-i686.tar.gz onto RH Linux 7.1 via MySQL Manual instructions for Installing a MySQL Binary Distribution. I can start the server via safe_mysqld with no apparent problems. Question #1: My Linux/MySQL newbie question...Do you need to

error: 'Can't create a new thread (errno 11)

Hi I am running MySql 3.23.40-max on Caldera OpenUnix8/LKP with Apache 1.3.20/php4.0.6. I just installed it and I am testing it. After I installed php, I tested it with simple php side and after 5 or 6 hits. I am getting: Warning: Can't create a new thread (errno 11). If you are not out of

RE: A couple of questions about connections

Grigory Bakunov wrote: Hello! TW Hi all, TW I'm running MySQL Ver 3.23.32 for -freebsd4.2 on i386, With PHP4 TW compiled statically into Apache 1.3.17. All connections to the database TW are non-persistent connections. It's a pretty busy server, hitting TW about 60 queries

Re: VB with MySQL

Hi, Try http://www.avukatpro.com/mysql.html http://www.dwam.net/MySQL/ Ken - Original Message - From: Pablo Javier Gonzalez Mateos [EMAIL PROTECTED] To: Lista MySQL Ingles [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 5:12 PM Subject: VB with MySQL Hello, im new in the list, im a

Re: Setup own DB for each user?

Sure this is possible, take a look at the 'grant' command... and for each local user add their mysql account giving them access to their database only.. then other users will not be able to read any db but their own. ryan - Original Message - From: Ulv Michel [EMAIL PROTECTED] To:

Virtual Server?

i read somewhere that you can setup virtual mysql servers, so that users can actually have their own sql server to administer with whatever databases they want to create, with out interferring or even seeing other peoples databases. Does anyone know how to do this? could you help me? jason

column_name

Hi , I was wondering if there was a way to retreive a column_name instead of a value in an sql select query? For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. And my first record is JohnDoe 555- good

Dates

i have noticed something, i have ported some asp, and visual basic applications from MSSql to MySql, and i have noticed something with the dates, i have to change my entire date format. Does anyone know how to set the way dates are interpreted in MySQL? jason http://mrtg.whitetec.com

Re: Problem with user rights

At 14:01 2001-08-22 +0200, Yarek wrote: Hi I wanted to install MySQL under Windows 2000 with default-charset=latin2. I cannot use binary distribution because it is not compiled with this charset. So, I loaded and compiled source for MySQL 2.3.41 under Cygwin (Win32, POSIX compatible). I received

Editing code on WinNT

Does one of our more experienced brethren know of an article/web page comparing offerings/discussing a good editor to use when working on MySQL and PHP code please? I use WinNT and 2000 platforms and am new to Open System tools (although 'old' in the business). Please advise, =dn

UPDATE command, Integer, Null/zero

Created a table which will be used to track/process URLs: CREATE TABLE dbURLlist( IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, AGING TINYINT UNSIGNED * , URL TINYTEXT NOT NULL, PRIMARY KEY (ID), INDEX (URL (25))) In a PHP script (also prototyped using MySQL-Front)

Re: Loading Data

Dear Ben, there is no need for two separate .sql files (maybe there *is* a need, you will know ;-) To dump structures from one database, all tables and all data included, and with drop table so you can restore overwriting existing tables: mysqldump my_db --add-drop-table my_db.sql To

Re: ldap authentication for mysql

Dear Jeremy, Is there currently a way for mysql to take it's users and passwords from an ldap server? There is not. There is: It's called PHP ;-) See http://php.net/manual/en/ref.ldap.php and http://php.net/manual/en/ref.mysql.php Regards, -- Stefan Hinz Geschäftsführer / CEO

Re: Setup own DB for each user?

Dear Ulv, My problem is that every user sees every other users databases. Is there a way to setup mysql so that every local user has his own empty database? Please tell me how this has to be set up. When they can state show databases, other users will see databases where they have no access

Re: ldap authentication for mysql

Dear Mike, AFAIK you cannot do this with SQL, but you can use PHP. See http://php.net/manual/en/ref.ldap.php for a description. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin

Re: slow querys

Hi, The slow queries are those like... SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1 where table have about 20.000 records and field is a text field. I need to find ALL the records that have text, even if text is a i have to find all the records that have one a. Many of

FULLTEXT search with hyphens in data

Hi, I'm performing a FULLTEXT search against varchar columns of one of our tables. One of our columns contains embedded serial numbers such as 02-123456 and 04-234567. The problem that when I do a FULLTEXT search against 02-123456, it brings back results with the following values: ...

RE: RH Linux 7.1 Binary Install Configure and Auto start/stop

I install MYSQL on Redhat 7.1 using RPMs ... I start the server the same way you do, but to start it automatically, i went to the control panel (GNOME) Programs-System-Control Panel and enter the services and levels configuration (Run level Manager) and move the MSQLD service from NON

Re: A couple of questions about connections

hi from the manual: Aborted_clients : This means that something of the following has happened: · The client program did not call mysql_close() before exit. · The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests. See section · ·

Re: column_name

At 10:48 AM 8/22/01 -0400, you wrote: For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. You haven't done a good job of database normalization. Those movies should be broken out to their own table. Onto what you were talking about, I know

Re: column_name

On Wednesday 22 August 2001 16:48, Jeremy Morano wrote: I was wondering if there was a way to retreive a column_name instead of a value in an sql select query? For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. And my first record is

Re: replace/insert into ... 150,000 -plus rows

Besides that theoretical stuff, though, the real problem is that INSERT is for inserting new records into a database table. What you're trying to do is UPDATE existing records with new data. And there's no INSERT ... SELECT counterpart in the UPDATE syntax. What about replace? replace

Encryption of Data

If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt the data. Can anyone help please? Regards Elizabeth

Re: How to restrict users from accessing database.

On Tue, Aug 21, 2001 at 04:08:42PM -0400, Sekaran, Chandra wrote: Hi We have a licensed MySQL software. I have one question. During Database Maintenance, i don't want users to be connected with the database. I want to start my database in restricted mode, thereby other than DBA, no one can

Re: Editing code on WinNT

At 03:56 PM 8/22/01 +0100, DL Neil wrote: Does one of our more experienced brethren know of an article/web page comparing offerings/discussing a good editor to use when working on MySQL and PHP code please? I use WinNT and 2000 platforms and am new to Open System tools (although 'old' in the

Re: Editing code on WinNT

TextPad works for me. Sammi Sammi Thompson Futura Interactive Ltd 1-5 Clerkenwell Road London EC1M 5PA T +44 [0]20 7608 1616 F +44 [0]20 7608 1605 www.futura.com - Original Message - From: DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 3:56 PM

Information

I am a user whom it loves to use the services of mysql, but do not have like beginning, please to send the manuals to me of as to begin to work this fabulous manejador of data base att. randy ochoa

RE: SV: Is it possible to group by an interval?

On 22-Aug-2001 Johan Nilsson wrote: Is it possible for me to do a SELECT COUNT(*) and GROUP BY the answers based on a INTERVAL e.g. HOUR? snip SELECT HOUR(time) as hour,count(*) as cnt FROM foo GROUP BY hour; Thanks, but I wrote a bad test data =( +---+ | id |

Re: Cannot build with C++

At 11:50 2001-08-21 +0200, ARAKON wrote: Hi! Try to put the header windows.h before mysql.h and add the header for the winsock if you are using it. Regards, Miguel i'm using mysql 3.23.40 for windows, when i try to build one very simple application, it shows me that error: e:\pere\mysql

Re: FULLTEXT search with hyphens in data

On Wed, 22 Aug 2001, Marty McCoy wrote: I'm performing a FULLTEXT search against varchar columns of one of our tables. One of our columns contains embedded serial numbers such as 02-123456 and 04-234567. The problem that when I do a FULLTEXT search against 02-123456, it brings back results

RE: UPDATE command, Integer, Null/zero

Created a table which will be used to track/process URLs: CREATE TABLE dbURLlist( IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, AGING TINYINT UNSIGNED * , URL TINYTEXT NOT NULL, PRIMARY KEY (ID), INDEX (URL (25))) In a PHP script (also prototyped using

RE: column_name

On 22-Aug-2001 Jeremy Morano wrote: Hi , I was wondering if there was a way to retreive a column_name instead of a value in an sql select query? For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. And my first record is

Data Encryption

If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt the data. Can anyone help please? Regards Elizabeth

Re: FULLTEXT search with hyphens in data

Hi! On Aug 22, Marty McCoy wrote: Hi, I'm performing a FULLTEXT search against varchar columns of one of our tables. One of our columns contains embedded serial numbers such as 02-123456 and 04-234567. The problem that when I do a FULLTEXT search against 02-123456, it brings back

Re: slow querys

On 22-Aug-2001 Osus wrote: Hi, The slow queries are those like... SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1 where table have about 20.000 records and field is a text field. I need to find ALL the records that have text, even if text is a i have to find all

Re: Testing new filter

On Tuesday 21 August 2001 23:30, Alexander Skwar wrote: So sprach »Sasha Pachev« am 2001-08-21 um 19:51:25 -0600 : I have updated the filter, this message should make it. This message arrived 5 times at the list - or at least, I got it 5 times. All the messages had different times. Was

Re: Query optimization issue.

mysql explain select * from dominf.domip order by ip desc; 'ORDER BY something DESC' does not use an index. It must be ascending. See the manual. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please

deleting dead customers

Hello! I have two tables. One contains invoices, one contains customers. How do I delete customers that are not linked to any invoice. The relation is one to many (invoices -- customers). I can select them with: select customers.* from customers left join invoices on

Re: slow querys

The slow queries are those like... SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1 WHERE field like '%text%' -- this will not use an index. Read the manual about fulltext. It may or may meet your needs. It works pretty good. If the text is a word you could also build a word

Re: ????????????????

On Wednesday 22 August 2001 01:53, Colin Faber wrote: Sasha, Are you sure its working? That is a bug in the filter, or rather a lack of feature. It is currently treats everything after the header as the boby, and it accepted quoted-printable in the header of one attachment part because it

Data Encryption

If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt the data. Can anyone help please? We can't afford to use ssh - we would

Re: Virtual Server?

Jason Brunk schrieb am Mittwoch, 22. August 2001, 19:45:58: i read somewhere that you can setup virtual mysql servers, so that users can actually have their own sql server to administer with whatever databases they want to create, with out interferring or even seeing other peoples

Re: UPDATE command, Integer, Null/zero

Created a table which will be used to track/process URLs: CREATE TABLE dbURLlist( IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, AGING TINYINT UNSIGNED * , URL TINYTEXT NOT NULL, PRIMARY KEY (ID), INDEX (URL (25))) In a PHP script (also prototyped

Re: Encryption of Data

Elizabeth Alderton schrieb am Mittwoch, 22. August 2001, 17:00:53: If I do a SELECT query to bring data down to a PC (this is being done through Delphi) how can I encrypt the data so that it comes safely? Equally when doing UPDATE and INSERT in the other direction I would want to encrypt

RE: slow querys

What about SELECT id FROM table WHERE ok=1 AND type=1 and field like '%text'. MySQL would have chance to create a temp table, reduce its contents via ok=1 AND type=1 and then do the expensive like '%text%' matches... Just my $0.02, Guus -Original Message- From: Osus [mailto:[EMAIL

password()

http://www.mysql.com/doc/M/i/Miscellaneous_functions.html PASSWORD() encryption is non-reversible. PASSWORD() does not perform password encryption in the same way that Unix passwords are encrypted. Hello, we are using mysql password() function to encrypt users' passwords (I mean the users of

Re: error: 'Can't create a new thread (errno 11)

On Wed, 22 Aug 2001, Eugene Reuter wrote: I am running MySql 3.23.40-max on Caldera OpenUnix8/LKP with Apache 1.3.20/php4.0.6. I just installed it and I am testing it. After I installed php, I tested it with simple php side and after 5 or 6 hits. I am getting: Warning: Can't create a new

Problems with connecting

We've had a lot of shakeups recently because of our DSL service going out of business. While shifting over, we also changed our primary Domain name for the site. I'm not an expert at configuring networks, and especially not at configuring MySQL, so I'm thinking these problems are my own doing.

Re: ???œ???Ÿ??????????

Sasha, Hey that works for me. I'm personally not to fond of HTML email any ways ;-) Sasha Pachev wrote: On Wednesday 22 August 2001 01:53, Colin Faber wrote: Sasha, Are you sure its working? That is a bug in the filter, or rather a lack of feature. It is currently treats

Re: ldap authentication for mysql

On Wed, Aug 22, 2001 at 05:03:05PM +0200, Stefan Hinz wrote: Dear Jeremy, Is there currently a way for mysql to take it's users and passwords from an ldap server? There is not. There is: It's called PHP ;-) See http://php.net/manual/en/ref.ldap.php and

Re: Editing code on WinNT

a good editor to use when working on MySQL and PHP code please? I use WinNT and 2000 platforms and am new to Open System tools (although 'old' in the business). I don't understand the relation between the use of an editor and the Open Source systems. Claudio, M$ dev tools tend to come

Building on Win32

Are instructions available for building the MySQL source tree on a Win32 platform for a Win32 target! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Information

http://www.mysql.com/ es la pagina de mysql. Desde alli puede encontrar la documentacion - en varios formatos- es de las mejores que pueda conseguir. Happy reading, --- Claudia M. Castaneda Phone 301 286 3397 On Wed, 22 Aug 2001, randys wrote: I am a user whom it loves to use the

Re: LAST_INSERT_ID()

A caveat is that you get the last_insert_id for your connection. Not the last one in the database. Curtis On Wed, 22 Aug 2001, Dr. Werner Stürenburg wrote: Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06: At 13:19 22.8.2001 +0200, you wrote: LAST_INSERT_ID() should return

Re: RH Linux 7.1 Binary Install Configure and Auto start/stop

#1 no. #2 yes. run /usr/sbin/setup and go to system services. Then check off the mysql entry and save it. or you can put /etc/rc.d/init.d/mysqld start in your rc.local file, HTH Curtis On Wed, 22 Aug 2001 [EMAIL PROTECTED] wrote: Good Morning. I recently installed

Re: Encryption of Data

What do you mean by bring data down? Would this be over a network? If so, what OS would the other machine be running? I'll assume it's Unix because that's my favorite. Seeing that mysql prints to STDOUT you could write a script to interface with MySQL, get the output, encrypt it, and then

MSAccess -- MySQL - append query slows, then dies

My setup: Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space WinNT Server 4.0 with sp6 MS Access 97 MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip) MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip) My objective: Copy data from two large MS Access 97 to MySQL

confirm

Re: LAST_INSERT_ID()

Curtis Maurand schrieb am Mittwoch, 22. August 2001, 21:17:40: A caveat is that you get the last_insert_id for your connection. Not the last one in the database. I'm puzzled. There is no last_insert_id of the database, only of a certain table, and it is indeed the one last manipulated. So

RE: deleting dead customers

Hello! I have two tables. One contains invoices, one contains customers. How do I delete customers that are not linked to any invoice. The relation is one to many (invoices -- customers). I can select them with: select customers.* from customers left join invoices on

  1   2   >