mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

granting ALL!

can i create a new user and 'grant all' to that user on all dbs and THEN add/import new databases and that user will still have all permissions on those as well? - Before posting, please check: http://www.mysql.com/manual.ph

NEW TO MYSQL

Hi everybody I am able to connect to my remote mysql server but fail to create, user any database ... I let you know step by step.. what I have done 1. First I have connected to my remote server through Telnet. After becoming root... I had supplied following command... 2. mysql -h mydomai

Re: Syntax question for a beginner..

You are the man...thanks a bunch! that's what I needed. = r a n d y / sesser at mac.com > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > Date: Fri, 6 Jul 2001 14:39:59 +0800 > To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]> > Subject: Re: Syntax question

Re: Insert queries add TWO records to database

I've expirienced the same problem And it's not a PHP bug no doubt... here the code $sql="insert into login_signup(createdate,logindate,uid,user)values(0,now(),$uid,'$user');"; $res=mysql_query($sql); if (!file_exists("r1.txt")){ $f=fopen("r1.txt","w"); fwrite($f,"1",1); f

Re: Syntax question for a beginner..

Well, if you are combining the 2 tables like that into 1, then there is an easier way without the need for an array. Make sure you have a unique index on email for tableA and then INSERT INTO tableA(email) SELECT email FROM tableB The unique index will stop the duplication while adding values t

Re: Syntax question for a beginner..

Well, I think I got it figured out. I am using PHP, and thought I could lick it with just one query...not so. I guess nested selects can be done in mssql. Anyway, here is what I did...basically: SELECT tableA.email FROM tableA,tableB WHERE tableA.email = tableB.email; Loaded that into an array[em

Re: Innodb

HI,,here's what mine says: [mysqld] innodb_data_home_dir = c:/mysql/data innodb_data_file_path = ibdata1.db:10M if you can find the proper section in the manuals you will see that you MUST specify a file size for that database file: innodb_data_file_path = ibdata1.db:10M I set mine to to: 10M the

Re: Enhanced MySQL

On Fri, Jul 06, 2001 at 02:57:51PM +1000, Noel Clarkson wrote: > I read the comments on NuSphere in the portals section: > > "As long as GEMINI is not released under open source, as required by the > GPL license of the MySQL server, we at MySQL AB can't recommend anyone to > use this distributi

Re: Syntax question for a beginner..

Even if sub-selects were available in MySQL (which they're not), that query would still not work as it will only select the values that are unique to tableA. What you would be looking at is something like: SELECT email FROM tableA UNION SELECT email FROM tableB But unfortunately, UNION is not a

Re: Mac OS X Server 10.0.4 and startup

Hi! I build mine successfully using the instructions at . That one including the startup item wich is edscribed there... Sincerely, Victor -- database,sql,query,table --

RE: Syntax question for a beginner..

I am a rookie as well so this may not work but I think it should. Could you not just copy all of one into the other and then select all out of it using DISTINCT so you get no duplicates out of it? Bomber Steel Mankind has, ever since it began to think, worshipped that which it cannot understand.

RE: Syntax question for a beginner..

I had never seen "WHERE NOT" before. Does this exist in mysql siomara >From: Shania Qiu <[EMAIL PROTECTED]> >To: '{ randy }' <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: RE: Syntax question for a beginner.. >Date: Fri, 6 Jul 2001 16:39:47 +1200 > >I remember somewhere has mentioned

RE: Enhanced MySQL

I read the comments on NuSphere in the portals section: "As long as GEMINI is not released under open source, as required by the GPL license of the MySQL server, we at MySQL AB can't recommend anyone to use this distribution." and I'm left thinking they are in violation of the GPL. If this is

RE: Syntax question for a beginner..

I remember somewhere has mentioned that MySQL does not copy with nested SELECT query. Properly it is the reason. Shania Qiu -Original Message- From: { randy } [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 July 2001 4:29 p.m. To: MySQL Subject: Syntax question for a beginner.. Alright, I

Syntax question for a beginner..

Alright, I am about to pull my hair out. I have 2 tables. Each have a column 'email' that are unique. Some of the records in both tables are duplicates and I want to combine the two tables into one with out bringing in the duplicates. So... I have this statement: Mysql> SELECT email FROM tableA

mysql 3.23.38 bug

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> It seems like if load data infile initiated to dammaged table Peter> sometimes after repair it does not unblock itself: I will try to test this as soon as I am back home. (If you can't create an examp

Re: Mysql question (access rights)

At 9:20 PM -0600 7/5/01, 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 something similar: > >mysql> GRANT SELECT ON *.* TO m

user accessing his/her own database only

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? thank you in advance. - Before posting, please check: http://www.mysql.com/manual

inaccesable mysql db from other users but root

hi is it possible to make mysql db inaccessable from other users but root? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Mysql question (access rights)

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 something similar: mysql> GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY "dirt"; ERROR 1064: You have

Re: Max count from 2 groups

Well, I just realized that my previous explination probably confused more than it explained, so here's my actuall query (with a bunch of extraneous stuff cout out): SELECT hlstats_Awards.awardId, hlstats_Events_Frags.playerId, COUNT(hlstats_Events_Frags.weapon) AS awardcount FROM

Re: Enhanced MySQL

thanks all, I guess it's time for new glasses! :) >>On Thu, 5 Jul 2001 22:51:56 -0400, "D'Arcy Rittich" <[EMAIL PROTECTED]> wrote: >>Try here: >> >>http://www.mysql.com/portal/distributions/html/index.html >> >>D'Arcy Rittich >> >>- Original Message - >>From: "MikeBlezien" <[EMAIL PR

Re: Mac OS X Server 10.0.4 and startup

go here: and put it in that folder. http://www.diax.ch/users/liyanage/software/macosx/mysql-startupitem.pkg.tar.gz note that the user might have to be changed from its default "mysql" at the line: /usr/local/bin/safe_mysqld --user=mysql --err- TR At 11:06 PM -0400 7/5/01, Patrick Larkin wrot

Max count from 2 groups

My current query is really complicated, so I'll only deal with my simplified output here. I'm doing Half-Life stats program, and right now I'm adding in awards to it. This is a snip from my current output: +-+--++ | awardId | playerId | awardcount | +-+-

got nowhere faster :(

[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. p.s. in this case i believe drop refers to adding or creating... if that is possible... because i am trying to add this db with a script.

Re: Mac OS X Server 10.0.4 and startup

I did find that directory. I created a dir called MySQL within and a file within that directory like so: #!/bin/sh /usr/local/mysql/bin/safe_mysqld & and made the file executable (chmod 555) but it still didn't work. This is basically the same way that other software starts up (albeit with a

Re: Enhanced MySQL

Try here: http://www.mysql.com/portal/distributions/html/index.html D'Arcy Rittich - Original Message - From: "MikeBlezien" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 10:34 PM Subject: Re: Enhanced MySQL On Fri, 6 Jul 2001 08:27:1

Help me : Replicaton problem

Hello brother or sister I have a problem with replication on MySQL. I used MySQL version 3.23.38. But why i cant connect to master from slave but i had a this problem. Below, message on the log from slave. I need you all help me, what i can do this. for information i must change max_allowed_p

Re: Enhanced MySQL

At 9:34 PM -0500 7/5/01, MikeBlezien wrote: >On Fri, 6 Jul 2001 08:27:11 +0300 (EEST), Michael Widenius <[EMAIL PROTECTED]> >wrote: > >Michael, > > >Strange, I went thru the entire portal section and couldn't find >anything about >this NuSphere's Enhanced MySQL. I just happen to notice the small

Re: Enhanced MySQL

On Fri, 6 Jul 2001 08:27:11 +0300 (EEST), Michael Widenius <[EMAIL PROTECTED]> wrote: Michael, Strange, I went thru the entire portal section and couldn't find anything about this NuSphere's Enhanced MySQL. I just happen to notice the small banner on www.mysql.com home page. But thank for the i

Re: Insert queries add TWO records to database

On Thu, 5 Jul 2001 20:22, John (*\\*) wrote: > I'm not convinced as I have the same problem in Netscape. > > More likely to be a PHP or MySQL configuration problem as the code is > fine. Or maybe IIS? > > May try it on a different server. > > Regards, > > John Stoops > Software Engineer > -O

Re: Enhanced MySQL

Hi! Cesar> Foxserv is also go it has Apache/PHP/MYSQL for Windows Cesar> Its pretty good and easy to install. Cesar> Cesar> http://sourceforge.net/projects/foxserv/ Cesar> Cesar> nusphere has Perl and if your not planing on using it theirs no need for it. Cesar> Cesar> Cesar Cuneo Cesar>

Re: Enhanced MySQL

Hi! > Hello all, > > Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/ > Enhanced MySQL and what advantages, if any it may have. > > THX, > > > Mike(mickalo)Blezien You can find information about this distribution and other MySQL distributions at: http://www.

Re: update

This is not possible at the moment and the best way I can think of is to separate them into 2 separate queries using the returned value of the select as the input value for the update. - Original Message - From: "Paulo Francioli DETRAN" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Fr

Re: mySQL & MS VB

Yes, you can run MySQL on a Windows machine and you'll need MyODBC if you're connecting through ODBC. - Original Message - From: "Simon Metz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 9:05 Subject: mySQL & MS VB > I am developing a Visual Basic application

Re: newbie - connecting to data base with php sql_pconnectstatement

One reason could be the server isn't running. This problem has been documented, please RTFM. - Original Message - From: "Roger deBry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 6:11 Subject: newbie - connecting to data base with php sql_pconnectstatement I

mySQL & MS VB

I am developing a Visual Basic application requiring a database on a win32 machine running 98SE and wanted to know if mySQL will run on this machine. I would like to avoid using MS SQL server as I will not require stored procedures and this will be running on a laptop for demo purposes. Also, my

Help me improve my table search

Hi, Below is the table I have mysql> describe eventlog; +-+--+--+-+ | Field | Type | Null | Key | +-+--+--+-+ | id | int(10) unsigned | | PRI | | timestamp | int(10) unsigned | | MUL |

Re: LIKE Magic

> > Dibo Chen == [EMAIL PROTECTED] napisa?(a): > >> You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. > >Yes it's true! But why NOT LIKE gives false for NULL values? NULL values fail all comparisons except IS NULL. >How can I get rid of this NULL's? >Is "update docs set

Re: Mac OS X Server 10.0.4 and startup

At 11:40 AM -0400 7/5/01, Patrick J. Larkin 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 no such directory. Thanks!

Mysql driver for Java

I recently downloaded the binary version of the MySQL driver for Java. I opened the Jar file. I copied the org directory into my PC. And I added the path to the classpath variable in the autoexec.bat file. Now I can't compile my source files that uses another of my classes. What I did wrong? reg

Re: Access to Other Databases Thru MySQL

What about to connect to Access from MySQL. -- Thomas S. Brettin Staff Member Bioscience Division, MS-M888 Los Alamos National Laboratory Los Alamos, NM 87545 505-665-3334 - Before posting, please check: http://www.mysql.com/

Re: Replication, update log, mysqldump???

At 12:51 AM 07/05/2001 , you wrote: >In fact, if you want to restore your database, you just have to drop your 7 >tables in your database before importing the database back. >Indeed, MySQL use a in memory key_buffer which store as much keys as >possible. If you delete *.frm, *.MYD and *.MYI, MySQL

VB: Recordset with ASP

Hi There! I have some trouble with a webaplication. I used to run it with an Access dbase but have changed to a nice MySQL dbase and then i got problems with the commands Addnew,Update,MoveFirst I use the samt locks and cursors as I did earlyer. Any good solution? Are there any parameters to s

Re: How delete the first register in a table?

Just to complete... If your table has a sequence as primary key (auto_increment column), you can delete the first row inserted based on the initial value of your sequence. However this is relevant to the application business. SQL, as mentioned before, has no concept like "first in a table". Y

newbie - connecting to data base with php sql_pconnectstatement

I am trying to connect to a mysql server fom a php script using the php sql_pconnect statement. I have used "localhost" as the host name, and the userid and password I normally use when connecting from the console. However, when executing the sql_pconnect statement I get an error message that r

Loading data into a remote server from csv file?

I need to be able to add a .csv file into a database table running on a mysql server of IP address 10.0.0.10 I know that "load data infile 'me.txt' into table stock;" will do the job locally but what's the easiest way for me to add me.txt to stock on 10.0.0.1? For arguments sake we can

RE: Innodb

hi. make sure you have the right binary...i believe it's called mysql-max or something... hth. -ravi. -Original Message- From: Brandon Berry [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:55 PM To: Ravi Raman Subject: RE: Innodb It's a binary install. - Oso -Original

connecting to mysql securely via network

If I connect to mysql: mysql -u username -p wherever.net is that encrypted at all? and if I make a network program via the C API, would that be encrypted too? Thanks James Gosnell [EMAIL PROTECTED] - Before posting, p

Re: How delete the first register in a table?

Hi. Within SQL, there is no such concept like "first in a table". By specification the internal table order is undefined and completely open to the actual implementation and may change anytime without notice. You may not rely on it. Order is determined on retrieval (SELECT) with the ORDER BY cla

Browser GUI

Hi All, I've been looking at alot of the GUI's offered at mysql.com, and was wondering if someone could recommend a good full MySQL administrator, for fully maintaining MySQL server/clients that is used thru the browser and not locally on a PC. thanks, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=

RE: Innodb

These are the options I used. [mysqld] innodb_data_file_path = ibdata; innodb_data_home_dir = /usr/local/mysql/data set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /usr/local/mysql/data set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-

Re: LIKE Magic

> Dibo Chen == [EMAIL PROTECTED] napisał(a): > You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Yes it's true! But why NOT LIKE gives false for NULL values? How can I get rid of this NULL's? Is "update docs set kword_10 = '' where kword_10 IS NULL" enough? Cheers, I love

Re: Innodb

On Thu, Jul 05, 2001 at 04:29:05PM -0400, Brandon Berry wrote: > > Anybody know why when I enable the Innodb in the /etc/my.cnf it > tells me can't init databases? Did you put all the InnoDB related options in your my.cnf file? Could you post the relevant section and the error message you got? J

Re: LIKE Magic

You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Jakub Wasielewski wrote: > > Hello! > > Could somebody explain me why it's like that: > > mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%'; > +--+ > | count(*) | > +--+ > |1 | > +-

restorin a nt 4 database

Hi, cen anyone help me with this question. > >To restoring a database [in the event of a disk crash for example], > run the restore from tape and rebuild the database, then > take the transaction logs and upload those into the database to bring it > up to date. > > >From what I can tell, Mysq

Innodb

Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

update

How do I do to execute a UPDATE using sub query as in the example below? update veiculo2000 set marca = ( select arq2.marca fromveiculo arq2 where veiculo2000.status_veic = '0'

LIKE Magic

Hello! Could somebody explain me why it's like that: mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%'; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.09 sec) ^^^ This is true! mysql> select count(*) from docs where kword_10 NOT LIKE '%Ukraina%'

RE: MS-DOS

hi, thanks a lot. It's going. regards, sibel. --- Ravi Raman <[EMAIL PROTECTED]> wrote: > hi. > > use mysqlc instead of mysql when you start the > client. > > hth. > -ravi. > > -Original Message- > From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:

indexing

Hi, I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with 640MB of Ram. I only 1 table in a database with 5.6 million records and I'm currently trying to index a varchar(100) field. I started the query "alter table mytable add index myfield (myfield)" at 10am EST this morning

RE: MS-DOS

hi. use mysqlc instead of mysql when you start the client. hth. -ravi. -Original Message- From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: MS-DOS Hi, I'm starting mysql in a DOS window. Is there a possibility to u

Can't init Databases

I get an error 'Can't init databases' how would I fix that? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

problems with dowloads

I cant download in this link: Win32 static binary of MySQLGUI 1.7.5-1 The client software. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: web search form for a mysql database

Thanks, I guess I just meant I'm just stupid on this subject, not stupid overall, heh heh. Anyway, thanks for the reference, I'll check it out shortly. -- Chip <[EMAIL PROTECTED]> on 07/05/2001 09:03:56 PM Internet mail from: To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: web

Can't get keys for table

I am getting an error when 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 error log saying the database has been restarted. mysqld restarted on Thu Jul 5

Re: MS-DOS

On Thu, Jul 05, 2001 at 03:17:05PM -0400, Matt TrollBoy Wiseman wrote: > > WinME has this built right in, elsewise try doskey How does WinME know what to do in the mysql command-line interpreter? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-78

Re: MS-DOS

WinME has this built right in, elsewise try doskey Matt "TrollBoy" Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft ---

Re: web search form for a mysql database

First NO ONE IS STUPID! Somethings have to be learned that's all. Now back to the search function. I use http://www.weberdev.com and a few other sites to pull tutorials from that show you how to do different things. Go join and search for Search and you'll find that there are allot of other s

Re: web search form for a mysql database

For my needs, that would not be necessary, just a simple single word search. I now have to figure out how to integrate what Mr. Massey suggested into my existing form, so far I have not got it to work. I guess I'm just stupid with mysql, I'm a newbie just trying to get something the marketing pe

MS-DOS

Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://person

Re: web search form for a mysql database

I think then you get into using Index's or FullText searchs http://www.mysql.com/doc/M/y/MySQL_indexes.html http://www.mysql.com/doc/F/u/Fulltext_Search.html -Original Message- FROM: Patrick J. Larkin TO: MySQL List DATE: Thu 7/5/01 11:51 SUBJECT: Re: web search form for a mysql data

RE: INSERT INTO

On 05-Jul-01 Ilan Fait wrote: > > > Hi, > > I am trying to insert data from one table to another with the command: > > INSERT INTO attrib_values (attrib_id,attrib_value) values (Select > attrib_id,attrib_default_value FROM attribs) > > And I get error massage: > > You have an error in yo

Re: Proposition: Attach a comment to each connection

BAUMEISTER Alexandre wrote: > > Bonjour Justin, > > JF> I don't know why I got interested in this thread... > > More important (or less), why are you so negative ? > Je ne suis pas contre. I just haven't felt the need for this, but after reading your scenario, I can't understand why. Email

Re: Problems Installing MySQL

Oh, and if you're going to use this system as a server for intranet/internet resources, why do you have a Win98 drive installed ?? You won't be able to use it if you're going to keep the system up, running Linux... - Original Message - From: "Steve Brazill" <[EMAIL PROTECTED]> To: "Gavi

Re: moving entire databases

Wonderful answer ..my problem solved Thanks chris - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "christopher sagayam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 6:49 PM Subject: Re: moving entire databases > On Thu, Jul 05, 2001 at

MySQLGUI

Are there any know issues or bugs with MySQLGUI running on Solaris 8 thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Re: moving entire databases

On Thu, Jul 05, 2001 at 06:41:15PM +0100, christopher sagayam wrote: > Hi > > While moving computers I tried to copy my entire database by just > copying the c:\mysql\data directory and after I have installed a new > mysql database on the new computer I just relpaced the data > directory with my

Re: web search form for a mysql database

What if you want to search for a number of terms? Say you have a database of common computer problems and solutions with a (simplifid) schema like this: Name Email Problem Solution Say you want to search on the Problem field. The Problem field would be strings of text like "Problem with aut

INSERT INTO

Hi, I am trying to insert data from one table to another with the command: INSERT INTO attrib_values (attrib_id,attrib_value) values (Select attrib_id,attrib_default_value FROM attribs) And I get error massage: You have an error in your SQL syntax near 'Select attrib_id,attrib_default_val

moving entire databases

Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.

Re: Alternate database handlers / tests

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... > We think about switching to InnoDB, but we see problems..: > > - The maximum blob/text length. We

RE: web search form for a mysql database

Here's a simple search in MySQL and PHP. Cheers M;-) Search.php3: Searching the Guest Book Searching the Database search for: Srch.php3: "; echo " Visit time and date User Name Last Name Email "; while ($r = mysql_fetch_array($result)) { // Begin while

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

Bonjour Scott, SH> Beyond that, you can already accomplish 90% of what you'd want by SH> simply coding your queries as "/* Comment */ SELECT ...", and so SH> on. For connections which are not currently running a query, this SH> won't work - but in my experience, you usually don't care muc

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

Bonjour Justin, JF> I don't know why I got interested in this thread... More important (or less), why are you so negative ? JF> I suppose you don't need a change to the wire protocol if JF> you have, logically, something like below. The API has JF> to be changed, however. JF> id = do_a

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

Bonjour Justin, "user agent" was just an example of what the commentary could be. You could put what you want as long as it's a string. I agree with you and I already had this reflection that it could be a modification that could create some problems to some. Instead of modifyin

Re: Query from two different databases ?

use 'select/insert/... db1.tbl2.fields3, ... db2.tbl3.fld4 from db1.tbl2, db2.tbl3 ... ' etc. in your query. "Andrey F. Mindubaev" wrote: > > Hi, > > How to create query to get data from tables of two different databases ? > > Best regards, Andrey > [EMAIL PROTECTED] > > -

Re: Store picture

- Original Message - From: "Duncan Hill" <[EMAIL PROTECTED]> To: "MySQL News Group" <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 7:46 PM Subject: Re: Store picture > On Wed, 4 Jul 2001, Moonesh Suggun wrote: > > > hi To All, > > > > Has anyone try to insert images e.h. gif into my

web search form for a mysql database

I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of dealer bulletins. I have created a web page to allow easy input of new bulletins into the database, and a second web page to display those bulletins. On this page are links to allow displaying the bulletins in several differan

Mac OS X Server 10.0.4 and startup

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 no such directory. Thanks! -- Patrick Larkin Information and Communications Techno

Re: Reporting Tool : Linux?

>OK, what are all you guys using for a reporting tool, with MySQL as a >backend (where you don't need Windows) I use StarOffice to connect to MySQL and generate reports. StarOffice is free and runs on Linux (I actually use it on Solaris myself).

problem mysql is running 10 minutes and then shuts down.

Hi With this message: show table status/usr/bin/safe_mysqld: line 156: 30874 Segmentation fault nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking >>$err_log 2>&1 Please help want is wrong. Regards Gerlinde BLITZ Internet Service GmbH

Re: Indexing is slow

Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC wrote: > > We are using mysql 3.23.39 . > We have the table p6882 with following structure : > > +---+-+--+-+-+-- > --+ > | Field | Type| Null | Key | Default | > Extra

Re: three tables and count() - Urgent i need it to my job !!

Original Message - From: "Robert Vetter" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 4:26 PM Subject: Re: three tables and count() - Urgent i need it to my job !! > > > Ireneusz Piasecki wrote: > > > > Hi my frien

RE: Proposition: Attach a comment to each connection

Dropping into the thread late, but two points: For all of the standard reasons, different database clients should use different usernames. In the limit, you could just make the username contain the comment. Beyond that, you can already accomplish 90% of what you'd want by simply coding your que

Re: three tables and count() - Urgent i need it to my job !!

Ireneusz Piasecki wrote: > > Hi my friends !! > > Some few days i have problems with count(). > i have 3 tables: > > t1 holds: > +++ > | id | number | > +++ > | 1 | one| > | 2 | two| > | 3 | three | > | 4 | four | > | 5 | five | > | 6 | sixs | > +-

Indexing is slow

We are using mysql 3.23.39 . We have the table p6882 with following structure : +---+-+--+-+-+-- --+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+-- --+ | id| int(10)

Re: No way to get offending Lines during laod data ?

[EMAIL PROTECTED] writes: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include

RE: LOAD DATA INFILE

Only if the date being converted is a standard length, i.e. not 2/4/99 All dates would have to be DD/MM/ or MM/DD/, eg. 02/04/1999 If so then yes it can be done in MySQL else u wouldn't know your /'s from your dates John (*\*) -Original Message- From: Bernhard Doebler [mailto:[

  1   2   >