linux-redhat 6.2

i get this error when starting MySQL ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql. Brad. _ Get Your Priv

Searching records ?'s

Hi Everyone, I'm writing a script using perl for a search function. I have a large text column that I want to scan for certain words. I do something like the following: select * from table_name where column_1 LIKE "%word1%" AND column_1 LIKE "%word2%"; In this situation, words like 'tree' will

Re: MySQL

[EMAIL PROTECTED] wrote: > I am running MySQL on a LINUX System. I am having trouble starting the > server as a non root user. I set up a non user account and changed the > permissions on the necessary files but I still can't start the server unless > I do it as root. It just hangs there un

strange behavior (to me, at least)

Howdy. Some of the following is part rant. I know this email is too long, but I want to be sure to give enough info so you folks have to ask me for more info. All of it will probably be forwarded to the bugs list, depending on what solutions I find. I'm running SuSE 7.0 and I had mysql 3.2

Re: Showing image

At 9:50 PM -0500 7/6/01, Dawn H wrote: >If I save the image name in the database, I can call it that way. >BUT when the file is uploaded, it saves the whole path in >the database (ie C:\Path1\Path2\filename.jpg). How do I >break that up to make it save just "filename.jpg" and not the >whole path?

Re: RPM or Source or Binary

That's exactly what I do with MySQL. For PHP I go with DSO module. - Original Message - From: "sysadmin" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 10:20 PM Subject: Re: RPM or Source or Binary > this way works perfectly for us. > > http://www.mysql

Showing image

If I save the image name in the database, I can call it that way. BUT when the file is uploaded, it saves the whole path in the database (ie C:\Path1\Path2\filename.jpg). How do I break that up to make it save just "filename.jpg" and not the whole path? Thanks, Dawn http://www.rdcss.com/ - R&D

Re: RPM or Source or Binary

this way works perfectly for us. http://www.mysql.com/articles/ddws/4.html - Original Message - From: "Roger Ramirez" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, July 07, 2001 10:02 AM Subject: RPM or Source or Binary > I'm curious as to how people are installin

RPM or Source or Binary

I'm curious as to how people are installing MySQL on Linux. I've been learning linux on Red Hat and more recently I've been using Trustix Secure Linux (which also uses RPMs) but I've never actually installed MySQL through the RPM's. The person who gave me my first basic lessons in Linux had an a

RE: ORDER and LIMIT dilemma

On 06-Jul-01 Tom Beidler wrote: > I have a dealer database with 3000+ records and I'm building a manager to > sift through the items. > > Currently I ORDER and LIMIT by name so I can come up with names that begin > with "A" and LIMIT the returns to 25, and then click to see the next 25 > names b

connecting to mysql using tcp/ip

sorry if this is the wrong list I am a beginner user of mysql, but a few pl I know are very active in scripting using mirc, especially gaming using tcp/ip connections to game servers to find out various details. I would like to know how/if I can connect to a mysql database using tcp/ip as mirc a

Re: db design questions

Pretty much was Siomara says is the way I think, except that I would have made the extra table for the two addresses. For the kids field it depends on what you want. If you want to have information for each child then you would create a separate table, but if you just need to record the number o

RE: Adding fields -- I used

UPDATE runner SET totals = (run + swim + bike)/60 WHERE name='jim' I had to use the /60 to divide the minutes by 60 to get the hours -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 6:13 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] S

RE: Adding fields--Thanks

Thanks for the great tutorial I added it to my MySQL notes database. I like the way you explained it start to finish.. TIA M;-) -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 6:13 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:

MySQL

I am running MySQL on a LINUX System. I am having trouble starting the server as a non root user. I set up a non user account and changed the permissions on the necessary files but I still can't start the server unless I do it as root. It just hangs there until I abort it. If I installed th

Re: Adding fields

Hi. On Fri, Jul 06, 2001 at 03:45:48PM -0600, [EMAIL PROTECTED] wrote: > > to many hours anyway I am struggling with what seems to be an easy task but I am >stuck. > > I am trying to total the fields with numbers (run + swim + bike) from a racer >name="joe" > and insert the ammount into a fiel

Packaging problem in Linux RPM install

>Description: After installation of using the RPM on Linux-pc-intel-i686 version, the script gave the message to set the password using /usr/bin/mysqladmin. But the mysqladmin program was not found. >How-To-Repeat: Install the rpm on a Linux-pc-intel-i686. >Fix: Don't know

Re: Perhaps a stupid question about KEY...

At 12:14 AM +0200 7/7/01, Fournier Jocelyn [Presence-PC] wrote: >Hi, > >Is there any structural difference between a PRIMARY KEY and a UNIQUE key ? > >Thanks ;) > >Jocelyn Fournier >Presence-PC >www.presence-pc.com They're mostly the same, with these differences: There can only be one PRIMARY KE

RE: Adding fields - got it

Thanks but I got it working -Original Message- FROM: [EMAIL PROTECTED] TO: [EMAIL PROTECTED] DATE: Fri 7/6/01 15:49 SUBJECT: Adding fields Hi All to many hours anyway I am struggling with what seems to be an easy task but I am stuck. I am trying to total the fields with numbers (run

Re: backup on nt4

Pete: I think I would go for replication (http://www.mysql.com/doc/R/e/Replication_Implementation.html) If replication isn't in the cards, then look at using CD-RW ... tape is too slow. Gerald Jensen - Original Message - From: "Pete Kuczynski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

Re[5]: Proposition: Attach a comment to each connection

Do you know - would that be of any help? 23.2 The Query Log If you want to know what happens within mysqld, you should start it with --log[=file]. This will log all connections and queries to the log file (by default named `'hostname'.log'). This log can be very useful when you suspect an error

Adding fields

Hi All to many hours anyway I am struggling with what seems to be an easy task but I am stuck. I am trying to total the fields with numbers (run + swim + bike) from a racer name="joe" and insert the ammount into a field called totals in a table called runner. UPDATE runner SET totals="SUM(run

Re[5]: Proposition: Attach a comment to each connection

WS>> Oh, I see, you would like to connect this information with the WS>> pid, right? I wouldn't know how to do that. How do you get a pid? WS>> Is this something MySQL could provide? > No, not with the pid. > With the number of places from where sql queries are executed and > the numb

Re: db design questions

sorry I typed my website wrong. The right url is: www.geocities.com/hisiomara >From: "Siomara Pantarotto" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: db design questions >Date: Fri, 06 Jul 2001 18:07:36 -0300 > >Hi, > >Try to keep the simple attributes in one tab

Re: db design questions

Hi, Try to keep the simple attributes in one table and the repetitions in separated tables> For example: A person has only one gender, one name, one marital stauts , etc however a person can have none,one or more than one kid. Create another table and create a relationship between both.

Re: direct ISAM access vs. SQL parser

On Fri, Jul 06, 2001 at 08:31:56PM +0100, Tim Bunce wrote: > > > It is in the manual under this heading : > > > > `HANDLER' Syntax > > > > Perhaps, but it's not listed here: > > http://www.mysql.com/doc/manual.php?search_query=handler&depth=0 I *think* that only searche

Re: direct ISAM access vs. SQL parser

On Fri, Jul 06, 2001 at 04:36:08PM +0300, Sinisa Milivojevic wrote: > Tim Bunce writes: > > On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote: > > > > It may have been implemented 2 months ago (for v4.0), but it doesn't > > seem to be documented. > > > > Will is be documented so

backup on nt4

Hi, being new to mysql on nt4, how do those of you running Mysql on NT4 server, backup and restore you databases. I understand that transactions are not supported on nt, if so, is a tape backup all that I have to fall back on in the event of a crash? What about all the records that will be lost b

control flow in select statement.

Hi all Can anyone tell me how to properly get a conditional in my select statement? This is being used for an authorization scheme using a Radius authentication server. What I'm trying to do in psuedo mysql is the following with english where I'm stuck: select password, ip_address, num_ips, idl

Re: direct ISAM access vs. SQL parser

On Fri, Jul 06, 2001 at 04:36:08PM +0300, Sinisa Milivojevic wrote: > Tim Bunce writes: > > On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote: > > > > It may have been implemented 2 months ago (for v4.0), but it doesn't > > seem to be documented. > > > > Will is be documented so

Installation Problem

Hi there, I am trying to install mySQL mysql-3.23.39-sun-solaris2.7-sparc on my solaris(sparc)2.6 box. After I ran the mysql_install_db I got the message below can anyone of you pleas help me? ORCSUN01> scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open fai

RE: conditional AND

OK, Im going to have to look more carefully at MYSQL, I think that when there is no JOIN between the two tables "l.id_person" is evaluating to 0, when I expected it to evaluate to NULL. Let me do some more research! Jason -Original Message- From: franky [mailto:[EMAIL PROTECTED]] Sent:

Re: conditional AND

I write this: "Select p.name >From tab_person p, tab_list l Where l.id_tab_list = 18 And l.id_person = 0 Or l.id_person = p.id_person" i will receve all name in person table! --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher [EMAIL PROTECTED] ___ _

RE: conditional AND

OK, I thought that might be the case, I wasnt thinking too clearly, but its because there is no JOIN with the second table. MS SQL is my area of expertise, Im just learning MYSQL, let me have a look through my books, Im not sure what JOIN syntax is supported by MYSQL. Give me a little while, if

RE: conditional AND

Actually neater code would be "Select p.name Fromtab_person p, tab_list l Where l.id_tab_list = 18 And l.id_person = 0 Or l.id_person = p.id_person" If its important, you might want to add "And p.id_person <> 0" -Original Message- F

Query/Table optimization help needed

Hi, I have a perl script that loops through and executes 2 queries 50 times. I need to make sure that I have done all I can to make these queries and the indexing on the table as efficient as possible. Would someone do me the gargantuan favor of taking a peek at the info below and offer any sug

ORDER and LIMIT dilemma

I have a dealer database with 3000+ records and I'm building a manager to sift through the items. Currently I ORDER and LIMIT by name so I can come up with names that begin with "A" and LIMIT the returns to 25, and then click to see the next 25 names beginning with "A" etc. Now here's where I'm

Re: Mysql question (access rights)

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

Fw: Annoying "Aborting Connection" in .err file

- Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: "Tonu Samuel" <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 6:16 PM Subject: Re: Annoying "Aborting Connection" in .err file > In fact pconnect aren't close at the end of the PHP Script. The MySQL > pr

RE: conditional AND

Selectp.name fromtab_person p, tab_list l wherel.id_tab_list = 18 and ((l.id_person != 0 AND l.id_person = p.id_person) or l.id_person = 0) } -Original Message- From: franky [mailto:[EMAIL PROTECTED]] Sent: 06 July 2001 19:35 To: LIste de Mysql Subject: conditional AND Hi

[Fwd: Re: Re: Annoying "Aborting Connection" in .err file]

Fournier Jocelyn [Presence-PC] wrote: > Hi, > > Is there any mean to not log the "Aborting Connection" line in the .err file ? > Nothing except programming application to close unused MySQL connections. This is the common cause of this error message. Tõnu --

conditional AND

Hi I want to make query like this Selectp.name fromtab_person p, tab_list l wherel.id_tab_list = 18 if (l.id_person != 0){ AND l.id_person = p.id_person } table person id_person,name,tel table list id_list,id_person,title how can i do? --=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Looking for

Thought I might ask before I dig into a new project. I am looking for a race program built on MySQL and PHP. By race I mean running, biking, swimming not cars Anyone seen anything like this laying around somewhere It's for a non-profit group that I do some work for.. Cheers M;-) ---

Looking for an expert

Hi, We are looking for MySQL expert that can convert a MySQL database tables to another. We are using a CFBoard forum (programmed by Cold Fusion and using MySQL database). We are moving to vBulletin Forum (programmed by PHP and using MySQL database). We need an expert to export our database to

Re: HAVING strangeness in InnoDB

Hi! I will send you a special version of row0sel.c with which you can print a lot of trace info on SELECT execution. Those traces may reveal what is wrong. Regards, Heikki >Hi, this is a follow-up to the previous message. > >As far as I've understood when Innodb parses a Having clause it creat

RE: front end/client for mysql

Thanks to all those who offered suggestions...However, I just found out that my webhost does not remote connections to the mysql server. It was suggested that I use a Perl program to modify my database. Any suggestions on something I can load on my website to modify the db? Ed -Original M

Re: Installing on FreeBSD 3-4

I have it running on FreeBSD 4.3-RELEASE. I just installed it form the ports collection: /usr/local/ports/database/mysql323-client & mysql323-server Everything seems to work well. = r a n d y / sesser at mac.com > From: "Gustavo Santos" <[EMAIL PROTECTED]> > Date: Fr

InnoDB-3.23.39b source released with support for < 4 GB BLOB and TEXT columns

Hi! You can download new InnoDB-3.23.39b source from http://www.innodb.com You should first download the MySQL/InnoDB-3.23.39 source from the MySQL website www.mysql.com and extract it to form a source tree. Then extract the files in innodb-3.23.39b.tar.gz into the /mysql/innobase subtree in t

Question

i have designed a system that works on MSSQL but i have decided to port it over to mysql. One of the problems i have come across is i need to figure out how to get the autoid back. so just say i insert a record, and MYSQL gives it the auto id of 6, how do i know that from my VB program? Jaso

Re: connecting to mysql securely via network

James Gosnell wrote: > If I connect to mysql: > mysql -u username -p wherever.net > > is that encrypted at all? No and never will be default behaviour to encrypt communication as this reduces performance. > and if I make a network program via the C API, would that be encrypted > too? T

Re: inaccesable mysql db from other users but root

not true.. one of the user was able to give himself all the rights inside of mysql db in user table - Original Message - From: "Tonu Samuel" <[EMAIL PROTECTED]> To: "alexus" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 12:03 PM Subject: Re: inaccesable mysql db

Re: inaccesable mysql db from other users but root

alexus wrote: > hi > > is it possible to make mysql db inaccessable from other users but root? > This is the default behaviour of MySQL server. You should just have password on root user of MySQL. Tõnu - Before posting,

Re: front end/client for mysql

On Fri, 6 Jul 2001, Ed Peddycoart wrote: > I am looking for a Win32 front end/client for mysql. I want to be able to > run it on my local machine, but modify a remote mysql db. I would like it > to be as user friendly as possible, with the user having to know as little > sql as possible. Any s

Re: front end/client for mysql

You might want to have a look at urSQL (http://www.urbanresearch.com/ursql). There are several options for editing and viewing data. On Fri, 6 Jul 2001, Ed Peddycoart wrote: > I am looking for a Win32 front end/client for mysql. I want to be able to > run it on my local machine, but modify a

Re: Tr: MySQL mailing list

Matthieu Neukirch wrote: > > We would be peased to be subscribed to My SQL mailing list. > > Regards, > > Dominique Vellin > Business developement Please use the http://www.mysql.com always before posting any questions or enquiries into list! There is a simple technical procedures you shou

Fw: Installing on FreeBSD 3-4

- Original Message - From: Gustavo Santos To: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 12:43 PM Subject: Installing on FreeBSD 3-4 Hello I´m trying to install MySQL binary in a FreeBSD 3-4. I´ve gone thru all the installation steps but I still get the following message: floatin

Re: tables locked

Patrick Prémartin wrote: > I use Delphi 5 and MyODBC to access a MySQL database. > > In my program, I've sometimes a tables locked and I don't understand why ! I am the >only user on this database and I change records correctly (as I do it for other >programs on other databases). > > Does so

Installing on FreeBSD 3-4

Hello I´m trying to install MySQL binary in a FreeBSD 3-4. I´ve gone thru all the installation steps but I still get the following message: floating point exception --core dumped whenever I start mysql daemon. I just don´t have a clue of what this might be... If anynone has a documentation on ex

RE: Random Selection

On 06-Jul-01 Roger Ramirez wrote: > I have a database of 5.6 million records and I need to choose 5000 random > records. What would that query look like? > SELECT foo from bar ORDER BY RAND() LIMIT 5000 Regards, -- Don Read [EMAIL PROTECTED] -- It's alw

Creating Tables

Hello All What is the best way to create table in a database under Win9X Paul [EMAIL PROTECTED]

Re: Random Selection

> I have a database of 5.6 million records and I need to choose 5000 random > records. What would that query look like? select * from records order by rand() limit 5000; destiney - (des-ti-ny) - n. 1. deity of all things "

db design questions

I am working on a website which will make use of a MySQL database. I know little if anything about the best way to design my db for efficiency, or anything else for that matter. The information which I need to put in the database will be contact/profile information on various people: Name, Addre

front end/client for mysql

I am looking for a Win32 front end/client for mysql. I want to be able to run it on my local machine, but modify a remote mysql db. I would like it to be as user friendly as possible, with the user having to know as little sql as possible. Any suggestions? Or maybe a web client that I can run

RE: A good problem. (have fun)

On 06-Jul-01 Artem Koutchine wrote: > Hi! > There are two tables: > TASK: > select all ids for names which are unique among both tables: > RETURNS: 3,4,5,6 > > The trick is to do it in ONE SQL statement. > Why one ? is this a test ? mysql> create table t (id int not null, name char(10),

Random Selection

I have a database of 5.6 million records and I need to choose 5000 random records. What would that query look like? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mysqld as a library in 4.0

Has anyone seen any documentation for using mysqld as a library. I am building an "embedded device" on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other

Can not Start MySQL

Hello all I need some help. My OS is Windows 98. Here the problem I go though the install for MySQL everything seem to work. But MySQL will never start up. What am I doing wrong? Paul Castiglione [EMAIL PROTECTED]

RE: Innodb

Hi! The first thing that catches my eye is that you have not specified the data file ibdata size. Also there is an extraneous ; there. Look at the manual at www.innodb.com for an example how to specify startup options. Regards, Heikki Copied message: .. These are th

Can't get keys for table

I am getting an error when I try to use mysqldump on a database. /usr/local/mysql/bin/mysqldump: Can't get keys for table agora (Lost connection to MySQL server during query) When this happens, I get a message in the mysql error log saying the database has been restarted. mysqld restarted on T

Re: MySQL binary/source

I assume this is the correct one to download then: mysql-3.23.39-pc-linux-gnu-i686.tar.gz >>"MikeBlezien" <[EMAIL PROTECTED]> writes: >>> >>> Thanks. Which files would I need to download then?? Just the RPM's or RPM's and >>> the tarball binary? >>On Fri, 6 Jul 2001 16:54:12 +0300, Sinisa Mi

Re: MySQL binary/source

"MikeBlezien" <[EMAIL PROTECTED]> writes: > > Thanks. Which files would I need to download then?? Just the RPM's or RPM's and > the tarball binary? > > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work!

Re: MySQL binary/source

Thanks. Which files would I need to download then?? Just the RPM's or RPM's and the tarball binary? >>On Fri, 6 Jul 2001 16:41:05 +0300, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: Use our MySQL-Max binary as it contains InnoDB. Our binaries are built in the most optimial manner, a

Re: MySQL binary/source

"MikeBlezien" <[EMAIL PROTECTED]> writes: > Hello All, > > Our company is going to be setting up on a dedicated server, so I am in the > process of doing some "crash course" learning as a system admin. We are looking > at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stab

Re: direct ISAM access vs. SQL parser

Tim Bunce writes: > > It may have been implemented 2 months ago (for v4.0), but it doesn't > seem to be documented. > > Will is be documented soon? > > Tim. Forgot to mention that it is implemented on MyISAM, not ISAM tables. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/

Re: direct ISAM access vs. SQL parser

Tim Bunce writes: > On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote: > > It may have been implemented 2 months ago (for v4.0), but it doesn't > seem to be documented. > > Will is be documented soon? > > Tim. > It is in the manual under this heading : `HANDLER' Syntax

tables locked

Hi I use Delphi 5 and MyODBC to access a MySQL database. In my program, I've sometimes a tables locked and I don't understand why ! I am the only user on this database and I change records correctly (as I do it for other programs on other databases). Does somebody have this problem ? Can you

MySQL binary/source

Hello All, Our company is going to be setting up on a dedicated server, so I am in the process of doing some "crash course" learning as a system admin. We are looking at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stable version w/InnoDB enabled. Now from the docs, it s

Re: HAVING strangeness in InnoDB

Hi, this is a follow-up to the previous message. As far as I've understood when Innodb parses a Having clause it creates a temporary table where it stores the results of the query satisfying all the conditions except the HAVING clause, then it makes a SELECT * from ... WHERE having_clause on th

Re: direct ISAM access vs. SQL parser

On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote: > Volker Paepcke writes: > > Hi! > > > > One year ago Michael Widenius posted this: > > > > > > We have on the other hand played with the idea to at some point > > implement SQL commands of type: > > > > IS

Tr: MySQL mailing list

We would be peased to be subscribed to My SQL mailing list. Regards, Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED]

Question : migration from Access 2000 to MySQL

We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02

HAVING strangeness in InnoDB

Hi, the following query yields: mysql> SELECT DISTINCT (@c:=@c+1), p.*, count(k.keywords) AS found FROM keywords k, poll_keywords pk, poll p , section_poll sp WHERE 1 AND k.keywords IN ('quarto') AND k.id_keyword=pk.id_keyword AND pk.id_poll=p.id_poll AND sp.id_section IN (29, 0, 1, 2, 3, 4,

Re: Type Mismatch issue when Deleting from table

why do you use Replace if deleteheadline is an integer? On Fri 6. July 2001 14:26, you wrote: > Platform: W2k/Advanced Server > DB: mySQL 3.23.33 > Language: ASP/VBScript > > Issue: I'm creating a backend administration program that will allow > updates, deletes, additions, etc. All is well exp

Re: primary keys with several parameters

the combination is unique so iyou dont get an error On Fri 6. July 2001 14:04, you wrote: > Hi all! > > Sorry for the dumb question, but am I right in the following suggestion: > > I have the following table: > > create table tab_1 ( > field_1 integer not null, > field_2 integer not

Type Mismatch issue when Deleting from table

Platform: W2k/Advanced Server DB: mySQL 3.23.33 Language: ASP/VBScript Issue: I'm creating a backend administration program that will allow updates, deletes, additions, etc. All is well expect for in one table in particular when I choose to delete a record it gives me a type mismatch Error. I've

Re: primary keys with several parameters

üÄÕÁÒÄ óÕÒÏ× wrote: > > Hi all! > Hi, > Sorry for the dumb question, but am I right in the following suggestion: > > I have the following table: > > create table tab_1 ( > field_1 integer not null, > field_2 integer not null, > primary key (field_1, field_2)); > > Do

primary keys with several parameters

Hi all! Sorry for the dumb question, but am I right in the following suggestion: I have the following table: create table tab_1 ( field_1 integer not null, field_2 integer not null, primary key (field_1, field_2)); Does it mean that this key requires unique COMBINATION

Re: direct ISAM access vs. SQL parser

Volker Paepcke writes: > Hi! > > One year ago Michael Widenius posted this: > > > We have on the other hand played with the idea to at some point > implement SQL commands of type: > > ISAM INSERT table_name (...) > ISAM UPDATE table_name SET ... WHERE key_name=(key_part

Re: NEW TO MYSQL

On 6 Jul 2001, Anoop K Gupta wrote: > it prompts for password : it is blank so I just pressed enter. and Mysql prompt >appeared.. > mysql > Well, do you have a password for the root user? If so, type it in! Note, root in mysql is NOT the root login for the server, so the passwords are probably

Re: user accessing his/her own database only

On Thu, 5 Jul 2001, alexus wrote: > hi again > > another security related question... > is it possible to do so user won't be able to access anyone else's database > but his or her own? Read the fine manual, especially the part about granting privileges. Grant each user the privileges to their d

Re: got nowhere faster :(

On Thu, 5 Jul 2001 [EMAIL PROTECTED] wrote: > [MySQL] > what does this mean and how can i fix it? > > Access denied for user: 'niban@localhost' to database 'tracking'Could > not drop database tracking > > thanks. It means what it says :) The user niban, coming from the local loopback interface

Re: problems with dowloads

Fernando Ibaven M. writes: > I cant download in this link: > Win32 static binary of MySQLGUI 1.7.5-1 > > The client software. > Thanks > I just tried and had no problems what so ever. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTEC

Re: MySQLGUI

chris writes: > > Are there any know issues or bugs with MySQLGUI running on Solaris 8 > > thanks No, if properly built. Use g++ 2.95.2 and it's STL lib, plus follow instructions closely. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL P

Re: Alternate database handlers / tests

Jeremy Zawodny writes: > On Thu, Jul 05, 2001 at 09:52:43AM +0200, Matthias Urlichs wrote: > > Hi, > > > > did anybody ever try to run the standard test suite with another > > table handler? > > I thought the MySQL team did that... > You will find some on InnoDB site. > > We think about swit

RE: FULLTEXT with explicit ORDER BY score == empty set

Sorry, I failed the obligitory full-read of the mysql manual page .. One question answered: Default sort order is descending score .. my bad. -Jay J - Before posting, please check: http://www.mysql.com/manual.php (the ma

FULLTEXT with explicit ORDER BY score == empty set

Hi, Current mysql version: mysql Ver 10.11 Distrib 3.23.24-beta, for pc-linux-gnu (i686) I realize it's old, but got length mismatch on t/merge for 3.23.39 -- still checking on it. I used the fulltext example from the manual: manual_Fulltext_Search.html Then I tried something like this: ---

thank you all!

i'm in the dbs and the book i wanted to be in!!! it was http://home.ubalt.edu/abento/797/mysql/ that helped so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Hi,sir.I have a question!

At 16:11 06/07/2001 +0800, rqhuang wrote: Hi, I would like to ask you a favour for to make a test when you not are able to stop the slave. There is a tool called NETWATCH.EXE from Microsoft to be used on Win9x machines, this tools it isn't installed by the default and you can find instructions ho

Re: Mac OS X Server 10.0.4 and startup

On 5/7/01 4:40 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi -- > > Has anyone installed MySQL on MacOS X Server and has safe_mysqld start > automatically at boot? > > On my LinuxPPC box, I add the provided startup script to the /etc/rc.d dir > structure. > > In MacOS X, there is n

Subtraction in WHERE statement

Hi, as I am using PERL to operate my MySQL-Database, I need the following statement to carry out the new entries: (Id is an auto-incrementing column) $sth2 = $dbh2->prepare("SELECT * FROM mywartungstermine WHERE (Id > (Id - $id_max))"); Refering to the manuals, it is allowed to use subtraction

  1   2   >