Re: Deleting from multiple tables

- Original Message - From: "Steve Buehler" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 8:45 PM Subject: Deleting from multiple tables > I am using MySQL with a PHP front end. Is there a better way to delete > from multiple tables than the following?

RE: Query Problem

Never mind... Spotted this after I sent the post! This: SELECT dates.date, tracks.track, albums.album, artists.artist FROM dates, tracks, albums, artists, albums_tracks, tracks_artists, ex_playlist_tb WHERE example_playlist.id = dates.id AND example_playlist.track_id = tracks.id AND tracks.id = a

RE: Query Problem

Okay, I think I'm -almost- there: I have these tables: tracks albums artists Each with an id MEDIUMINT NOT NULL PRIMARY KEY and a track, album, or artist column. Then I have 2 linking tables, albums<=>tracks, tracks<=>artists, these are: albums_tracks tracks_artists Each of these has all MEDIUM

Re: Ibdata1 file thats just too big...

Hi! - Original Message - From: "walt" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, May 23, 2002 10:24 PM Subject: Re: Ibdata1 file thats just too big... > "Williamson, David" wrote: > > > Hi there, > > > > My Ibdatafile is set too big (the disk is full to the p

RE: Query Problem

Other than it is uglier than a Hut? The higest ideals of a database is to separate data into tables that keep track of data for the same objects. Some databases break these rules (oh and how) for simpler queries, and sometimes for faster queries. It is actually better to break the relationshi

MySQL: most useful vendor specific features

Hello, What are MySQL's coolest and most useful vendor specific features? Here is a partial list of features, none of which are part of any SQL standard but which I nevertheless find quite useful from time to time. I would like to invite you to add to this list: 1. AUTO_INCREMENT columns 2. LIM

Re: php+apache+mysql installation. Help!

Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002

Re: Help with REPLACE INTO statement syntax

At 21:27 -0500 5/23/02, Andrew Lietzow wrote: >Dear MySQL wizards, > >I have two tables, call them A and B. The database structure is identical. >I want the records in B to overwrite the records in (REPLACE INTO) A. > >This is the statement that does NOT work. > >REPLACE INTO a SELECT b.* FROM

Help with REPLACE INTO statement syntax

Dear MySQL wizards, I have two tables, call them A and B. The database structure is identical. I want the records in B to overwrite the records in (REPLACE INTO) A. This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b WHERE a.field1 = b.field1 I also tried this wi

query

Hi everybody, Can anybody help me? is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Record is like this:- ID name gender 1 aF 2 bM 3 cM 4 dF 5 eM Result should b

Re: MySQL-InnoDB autoextend syntax gives errors

Hi Steve, On Fri, 2002-05-24 at 09:56, Orr, Steve wrote: > I changed my.cnf to add an autoextending datafile but I get errors on > startup. > > Here's the my.cnf syntax: > "innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend" > > Here's the error output from mysqld: > "InnoDB:

GUI compiling on OSX

Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it likely that one of BSD sources will compile under OSX? I haven't compiling anything yet, so I thought I'd should ask if it has been mentioned before. -

RE: Query Problem

Thanks for the tips! I'll definitely try that out. I've already finished the arduous task of entering all of the playlist data, I have all of the data in a readily sortable form, so trying out different stuff doesn't involve much more than creating tables and writing my queries. Let me throw

RE: How can I do this SQL query

* Smith, Mike > I have a file(transfile) that has 2 fields(cust# and item#) > > CUST# ITEM# > 1 '12a' > 1 '13a' > 2 '12a' > 3 '13a' > 4 '15a' > > If I want to select customers that have ordered item '12a' but not '13a' > How ca

RE: Query Problem

Jason, First, as to the structure of the database. I agree with Sammy, you probably don't need 3 tables linking data together. A more generic structure would have only 2 relationship tables connecting as such: albums <=> tracks <=> artists. In this fashion, you can determine who the artist is

Re: Location of header files - RPM

The quick way to answer this question is to go to the directory where you have the rpm (if you still have it) and run the following command: rpm -qpi -l MySQL-3.23.49a-1.i386.rpm This will give ytou the details on where everything has been installed. On Thursday 23 May 2002 11:46 am, Carl Carp

MySQL-InnoDB autoextend syntax gives errors

I changed my.cnf to add an autoextending datafile but I get errors on startup. Here's the my.cnf syntax: "innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend" Here's the error output from mysqld: "InnoDB: syntax error in innodb_data_file_path 020523 16:34:24 Can't init database

Re: SELECT and WHERE clause

You should also get rid of the quotes, so MySQL doesn't have to convert from string to integer: SELECT team_id,name FROM team WHERE deleted != 1 ORDER BY 'name' --jeff - Original Message - From: "Steve Buehler" <[EMAIL PROTECTED]> To: "Keith C. Ivey" <[EMAIL PROTECTED]>; <[EMAIL PROTECT

php+apache+mysql installation. Help!

Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from R

Re: Query Help Needed

sql,query I have a table with the following structure: CREATE TABLE cartconfig_module ( UserID int(10) unsigned NOT NULL default '0', GroupID int(10) unsigned NOT NULL default '0', SiteID int(10) unsigned NOT NULL default '0', Perms enum('Modify','View','Deny') NOT NULL default 'View',

RE: SQL Help Needed

* Dave > Thanks for your responses but it's not that much help I need with > my SQL ;-) > > None of the 3 suggestions work. > > Please look at the examples I gave. I need *all* UserIDs regardless of > whether they have a record in History that matches both UserID and WeekID. ...and that is what

Re: MySQL on CYGWIN installtion

Hi, On Thu, 2002-05-23 at 13:29, [EMAIL PROTECTED] wrote: > Anybody has tried installing MySQL on CygWin? Not to evade your question, but... why would you want this, since there are native Windows binaries? Faster and more reliable. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 20

RE: SELECT and WHERE clause

try SELECT team_id,name FROM team WHERE deleted <> 1 ORDER BY name -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 3:20 PM To: [EMAIL PROTECTED] Subject: SELECT and WHERE clause Ok. I can NOT find out what I am doing wrong. The book makes

Re: MySQL 4

On Thursday, 23. May 2002 19:20, Olexandr Vynnychenko wrote: Hi, > Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell > me if I can use new MySQL 4. Is it very buggy? Is it safe enough to > use not only at home? AFAIR it has some features 3.23 doesn't have. > Thank's in advance.

Re: SELECT and WHERE clause

That did the trick. That just seems like it shouldn't have to be that way. Thanks a LOT Steve At 05:50 PM 5/23/2002 -0400, Keith C. Ivey wrote: >On 23 May 2002, at 15:20, Steve Buehler wrote: > > > Ok. I can NOT find out what I am doing wrong. The book makes it look > like > > any of these w

RE: mysql load data question

Yes it is ... See: http://www.mysql.com/doc/P/r/Privileges_provided.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:46 PM To: [EMAIL PROTECTED] Subject: mysql load data question What priviledge does a user need in order to be

Re: Caching

At 06:58 PM 5/22/2002, you wrote: >Greetings Friends, > >How could cache the whole mysql database in the memory? Which parameters >would help? > >Regards. > >Ravi Verma >916 705 3261 Ravi, MySQL 4.x already has excellent caching. The best thing you can do is to add the maximum amount of

Re: SELECT and WHERE clause

On 23 May 2002, at 15:20, Steve Buehler wrote: > Ok. I can NOT find out what I am doing wrong. The book makes it look like > any of these would work (deleted is a column name): > SELECT team_id,name FROM team WHERE deleted NOT LIKE '1' ORDER BY 'name' > SELECT team_id,name FROM team WHERE dele

Re: How do I uninstall a MySQL source installation on Linux ?

On Thursday, 23. May 2002 19:18, Sharksforum wrote: > > > How do I uninstall a MySQL source installation on Linux ? > > > > make uninstall > > I tried that without success. > Would it require the original source code? > > Regards Jacob > just, make clean like in any other makefiles. Regards Ge

RE: Deleting from multiple tables

> [snip] > I am using MySQL with a PHP front end. Is there a better way to delete > from multiple tables than the following? > $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'"); > $result=mysql_query("DELETE FROM conflicts WHERE team_id = > '$team_id'"); > $resu

Re[2]: MySQL 4

Hello MikeParton, Thursday, May 23, 2002, 9:47:13 PM, you wrote: M> What is it you are trying to accomplish with MySQL? M> I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP M> 4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I M> have asked it to do

mysql load data question

What priviledge does a user need in order to be able to execute the load data infile command in mysql..? is it FILE? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply."

Re: Query Problem

I'm wondering if anyone has a response for the query question I posted last night regarding my Songs/Albums/Artists database and related linking tables. I'm new to this list, so I'm not sure what kind of response time to expect. I'm still unable to solve this problem on my own, and searches o

SELECT and WHERE clause

Ok. I can NOT find out what I am doing wrong. The book makes it look like any of these would work (deleted is a column name): SELECT team_id,name FROM team WHERE deleted NOT LIKE '1' ORDER BY 'name' SELECT team_id,name FROM team WHERE deleted != '1' ORDER BY 'name' SELECT team_id,name FROM team

Indexing words

We have an application that needs to index every word (token) in a name, separately. Ex: "New York" must be indexed under "New" and "York". One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TAB

Re: Deleting from multiple tables

At 03:34 PM 5/23/2002 -0400, Keith C. Ivey wrote: >On 23 May 2002, at 12:48, Steve Buehler wrote: > > > I am using MySQL with a PHP front end. Is there a better way to delete > > from multiple tables than the following? > > $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");

RE: How can I do this SQL query

How can I do this SQL query I have a file(transfile) that has 2 fields(cust# and item#) CUST# ITEM# 1 '12a' 1 '13a' 2 '12a' 3 '13a' 4 '15a' If I want to select customers that have ordered item '12a' but not '13

Re: Deleting from multiple tables

On 23 May 2002, at 12:48, Steve Buehler wrote: > I am using MySQL with a PHP front end. Is there a better way to delete > from multiple tables than the following? > $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'"); > $result=mysql_query("DELETE FROM conflicts WHERE

RE: Deleting from multiple tables

[snip] I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'"); $result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'"); $result=mysql

RE: building tree view in mysql?

Hi, There are of course several ways of doing it !! I had to do this kind of thing few weeks ago, and I think the easier way of doing it is use a treepath schema in a field of your table +++---+ | id | treepath | name | +++---+

Re: MySQL 4

What is it you are trying to accomplish with MySQL? I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP 4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I have asked it to do (granted I am not doing anything at the edge of the envelope). Mike - Orig

Deleting from multiple tables

I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'"); $result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'"); $result=mysql_query

Re: Where is my.cnf in FreeBSD?

In the last episode (May 23), Iago Sineiro said: > Hi. > > Anybody knows where is the my.cnf file (or equivalent) in FreeBSD? > > I've installed mysql-3.23.49 using the port in FreeBSD 4.5. Run "mysql --help": Default options are read from the following files in the given order: /etc/my.cnf /v

Re: how to design mysql clusters with 30,000 clients?

On Wednesday 22 May 2002 18:44, Dave Watkins wrote: > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: > >Hello list, > > > >I am expecting to have 30,000 http clients visting my website at the > >same time. To meet the HA requirement, we use dual firewall, dual > >Layer-4 switch and multiple web s

Re: MySQL 4

On Thu, May 23, 2002 at 08:20:13PM +0300, Olexandr Vynnychenko wrote: > > Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to > tell me if I can use new MySQL 4. Is it very buggy? Is it safe > enough to use not only at home? AFAIR it has some features 3.23 > doesn't have. Thank's in

replication problem

Hi all, I have master -> Linux 7.2, mysql-4.0.1 and slave -> win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

Re: SQL Help Needed

Thanks for your responses but it's not that much help I need with my SQL ;-) None of the 3 suggestions work. Please look at the examples I gave. I need *all* UserIDs regardless of whether they have a record in History that matches both UserID and WeekID. In other words some UserIDs will only e

Re: FreeBSD & LinuxThreads from BK Tree?

On Thu, May 23, 2002 at 10:02:51AM -0500, Dan Nelson wrote: > In the last episode (May 22), Jeremy Zawodny said: > > Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads > > on FreeBSD? > > > > If so, how'd you do it? > > It looks like someone is in the process of removing getop

Re: Help a newbie please

See below... On Monday 20 May 2002 10:33 pm, Hoa Doan wrote: > Hi, > > Please don't kill me. I want to learn about databases. I hear MySQL is a > good start. I have RedHat Linux and I've download and (I believe) > installed mysql. > > Okay, my questions are? What is the difference between th

Re: WHERE MATCH () AGAINST ('%$search_string%')";

"Wilbert Enserink" <[EMAIL PROTECTED]> wrote: > i'm new to this list. currently busy with mysql. I'm having troubles with > the query string below. The part MATCH results in an error: Can't find > FULLTEXT index matching the column list Do `create fulltext index idxft on gallery (productname,prod

RE: how to design mysql clusters with 30,000 clients?

There is some info about slashdot and how they utilized MySQL here: http://www.mysql.com/articles/us/slashdot.html Gurhan -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 10:00 AM To: 'Dave Watkins'; 'Patrick Hsieh'; [EMAIL PROTECTED] Subject

Deleting from multiple tables

I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'"); $result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'"); $result=mysql_query

Re: Ibdata1 file thats just too big...

"Williamson, David" wrote: > Hi there, > > My Ibdatafile is set too big (the disk is full to the point that nothing is > executing properly) I am wondering is it safe to delete this file and then > in the my.cnf file reset the size to something smaller... - how does the > Ibdata file work in conj

RE: SQL Help Needed

SELECT UserID, WeekID, SUM(Points) AS WeeklyPoints FROM History GROUP BY WeekID; Gurhan -Original Message- From: Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:37 AM To: [EMAIL PROTECTED] Subject: SQL Help Needed I have 2 tables Users (UserID) History (UserID, WeekID

Re: Location of header files - RPM

On Thursday, 23. May 2002 17:46, Carl Carpenter wrote: Hi, > > From the php-4.2.1 directory, enter: > > ./configure --with-mysql=/usr/share/mysql --with-xml > --with-apache=/usr/loca l/src/apache_1.3.23/ --enable-track-vars > --enable-ftp > You don't need the configure option --with-mys

Re: Using LDAP with mysql.

openLDAP is capable of using various back end data stores, including an SQL database. You have to set up MySQL (obviously), and set up MyODBC (which probably means you will need to install an odbc manager like iodbc or unixodbc), and create a data source. Then you can reconfigure slapd so it w

RE: newbie - Old Samp_db question

you probably need to supply username and passwword to be able to access to the mysql server? See: http://www.mysql.com/doc/B/a/Batch_mode.html Gurhan -Original Message- From: Eugene McQuade [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:43 AM To: [EMAIL PROTECTED] Subject: F

RE: WHERE MATCH () AGAINST ('%$search_string%')";

Hi Wilbert, The error tells it all.. To be able to use FULLTEXT search you have to have FULLTEXT index on the column(s) that you want to perform FULLTEXT search.. See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Wilbert Enserink [mailto:[EMAIL PROTE

Re: newbie - Old Samp_db question

- Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 12:24 PM Subject: Re: newbie - Old Samp_db question > > - Original Message - > From: "Eugene McQuade" <[EMAIL PROTECTED]> > To: <[EMAIL PROTEC

errno: 145

hi when i try to read a table using query > select * from it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before posting, please check

Re: building tree view in mysql?

On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, > > How can I get MySQL to sort it like that? I tried to use group/order by, > but I cannot get it to sort it this way.. > > Any ideas? For trees you need self joins. Regards Georg mysql, query -

RE: SQL Help Needed

* Dave > I have 2 tables > > Users (UserID) > > History (UserID, WeekID, Points) > > When a User record is created a record is inserted into History with the > current WeekID, so for example data could be : > > Users > > > > > > > History > -- > - 1 - 10 >

MySQL 4

Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell me if I can use new MySQL 4. Is it very buggy? Is it safe enough to use not only at home? AFAIR it has some features 3.23 doesn't have. Thank's in advance. -- Best regards, Olexandr mailto:[EMAIL P

RE: How do I uninstall a MySQL source installation on Linux ?

> > How do I uninstall a MySQL source installation on Linux ? > > make uninstall I tried that without success. Would it require the original source code? Regards Jacob - Before posting, please check: http://www.mysql.com/

Replication problem

Hi all, I have master -> Linux 7.2, mysql-4.0.1 and slave -> win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

Re: SQL Help Needed

Ok this should be easy so I'm prolly going to screw it up, but here goes =D Your query should be: SELECT UserID, SUM(points) FROM History WHERE WeekID = 'whatever' GROUP BY UserIdI think that should do it. Someone yell if its wrong though. -Nick > I have 2 tables > > Users (UserID) > > History

Re: How do I uninstall a MySQL source installation on Linux ?

On Thu, 23 May 2002, Sharksforum wrote: > How do I uninstall a MySQL source installation on Linux ? make uninstall Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Replication problem

Hi all, I have master -> Linux 7.2, mysql-4.0.1 and slave -> win2000, mysql-4.0.1. I have the following error on my replication server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted

RE: Problem with join syntax

* andy > thanx for your help. Anyhow this statement does not return the wanted > fields. > > I would like to return the website and the signature of the > user, but only > if those values are available. There might be none of them available, but > maybe 1 or even both. > > this query: > SELECT >

Re: how to design mysql clusters with 30,000 clients?

Hello Benjamin Pflugmann <[EMAIL PROTECTED]>, This scenario is fine. But in real life, the circular master-slave replication will probably cause inconsistency of data among them. I wish to keep 1 copy of the shared raw data in a storage device and forget circular master-slave replication. If ther

Re: 0xADA1 in ujis character set

Neglected to mention the version (changing is not an option - sorry) Ver 11.15 Distrib 3.23.43, for sgi-irix6.5 (mips) -- (from mysql -V) On Wed, 22 May 2002 15:43:31 + Warren Pollans <[EMAIL PROTECTED]> wrote: > A colleague who is connecting to mysqld started as "/u/local/mysql/bin/safe_

Re: new functions in MySQL ?

Try here: http://www.mysql.com/doc/A/d/Adding_functions.html --jeff - Original Message - From: "a a" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 6:14 AM Subject: new functions in MySQL ? > Hi, > > Can we create and add new functions in MySQL with > windows

RE: how to design mysql clusters with 30,000 clients?

I believe slashdot uses one heavy duty database server (quad xeon) and a redundant one. This isn't an actual cluster, but I would have to assume that slashdot gets more that 30,000 clients at a time. slashcode.org has information (somewhere deep in there, I couldn't find it, but I remember bei

Re: Caching

Hi. If you are using a decent operating system and have enough memory, it will do it for you implicitly by caching the files. This is not as fast as it could be (because the content still has to be evaluated each time), but already gives you the main speed advantage of memory vs. disks. If you w

Where is my.cnf in FreeBSD?

Hi. Anybody knows where is the my.cnf file (or equivalent) in FreeBSD? I've installed mysql-3.23.49 using the port in FreeBSD 4.5. The script than launches mysql (usr/local/etc/rc.d/mysql-server.sh) is very simple and don't look for any configuration file. The script is: - #!/b

Re: how to design mysql clusters with 30,000 clients?

Hi. On Thu, May 23, 2002 at 11:16:33PM +0800, [EMAIL PROTECTED] wrote: > Hello Benjamin Pflugmann <[EMAIL PROTECTED]>, > > This scenario is fine. But in real life, the circular master-slave > replication will probably cause inconsistency of data among them. That is why I wrote you have to take

Re: how to design mysql clusters with 30,000 clients?

Hi. On Thu, May 23, 2002 at 10:44:15AM +1200, [EMAIL PROTECTED] wrote: > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: [...] > >1. use 3 or more mysql servers for write/update and more than 5 mysql > >servers for read-only. Native mysql replication is applied among them. > >In the mysql write s

Re: HELP uncancelled query

I posted this yesterday .. and it didn't seem to catch anyones imagination .. PLEASE .. the developers are looking into their side but I need to find what could cause this type of thing to happen .. We do not have this problem against Oracle. I would prefer not to use Oracle for this project as

Re: FreeBSD & LinuxThreads from BK Tree?

In the last episode (May 22), Jeremy Zawodny said: > Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads > on FreeBSD? > > If so, how'd you do it? It looks like someone is in the process of removing getopt_long() usage from the commandline tools. They're doing it backwards, th

Binary Installation of mysql-max

hello, i'm trying to install mysql-max...using binaryver 3.23.49 i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB table options:: innodb_data_file_path innodb_data_home_dir but after changing the options, mysqld starts but ends immediately... Pls. let me know the re

Newbie question: Which is better InnoDB or BDB?

Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? Is there a sign

Location of header files - RPM

>Description: Installed MySQL-3.23.49a-1.i386.rpm and the client. Then tried to install PHP which needs path to header files. From what I can determine from your website documentation, the header files should be in an include directory. There is no include directories under mysql. >How

FW: newbie - Old Samp_db question

Victoria Thanks for the quick response. If I enter what you provided using a 'dos' command, I get "Access is denied". I thought I had to be in Mysql in order to execute the command. So I enter (in dos) mysql\bin\mysql to get into mysql. And, I get the 'Welcome to the MySQL monitor' message. I

Re: Perl DBI

Yes. Denny said: > Hi, > > How can i use Perl DBI to create tables in mysql? > > Denny > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > >

SQL Help Needed

I have 2 tables Users (UserID) History (UserID, WeekID, Points) When a User record is created a record is inserted into History with the current WeekID, so for example data could be : Users History -- - 1 - 10 - 1 - 20 - 1 - 30 - 2 - 40

WHERE MATCH () AGAINST ('%$search_string%')";

hi all, i'm new to this list. currently busy with mysql. I'm having troubles with the query string below. The part MATCH results in an error: Can't find FULLTEXT index matching the column list however it looks like i'm doing the query according to the manual. Anybody has any clue what's going w

Re: Moving Data Between Proprietary Database and MySQL

Hello, > Because most web providers will not allow > direct TCP/IP access to > MySQL servers, I am considering the following > strategy: > > a) Save the proprietary database to a file > containing a series of SQL > CREATE TABLE and INSERT INTO calls. > > b) Upload the SQL file to the server via

building tree view in mysql?

Hi, I'm trying to build a simple categories tree in MySQL. Say I have the following table: CREATE TABLE test ( id int(10) unsigned NOT NULL auto_increment, parent int(10) unsigned NOT NULL default '0', name tinytext NOT NULL, PRIMARY KEY (id), KEY parent (parent) ) TYPE=MyISAM; +---

new functions in MySQL ?

Hi, Can we create and add new functions in MySQL with windows NT. This fonctions must be developped on C and C++ ? How compiled this C program in win NT (the compiled file must be a .so or a .dll file ?) exemple : SELECT My_Fonction(name) from personnel; I want to write My_Fonction() and integre

Re: Problem with join syntax

Hello, thanx for your help. Anyhow this statement does not return the wanted fields. I would like to return the website and the signature of the user, but only if those values are available. There might be none of them available, but maybe 1 or even both. this query: SELECT w.website,

RE: info...

Peter said: --- hi there ... can some one point in the right direction .. other than the mysql manul for mroe information on the INSERT SELECT statement & whether or not it can handle date inserted from a form on a web page... --- *Any* database can ha

RE: info...

[snip] can some one point in the right direction .. other than the mysql manul for mroe information on the INSERT SELECT statement & whether or not it can handle date inserted from a form on a web page... [/snip] Any query you can write in MySQL monitor can be written in your choice of progra

Re: strange fulltext behavior

"Sergei Golubchik" <[EMAIL PROTECTED]> wrote: > > 1 row in set (0.00 sec) > > Works fine for me (that is "No rows" - and no bug). > Probably, it's one of numerous fulltext-related bugs that were fixed > since 4.0.1 release. Will you fix it in 3.23.x ? There is still lot of time (I think) to rel

Re: Perl DBI

Hi Denny, >How can i use Perl DBI to create tables in mysql? I am not an expert in CPAN modules for Perl but I am using the DBD module that needs DBI module for access the MySQL. Please see the man pages for DBI module. I am using the: DBI-1.22 DBD-mysql-2.1017 You can installing all men

License question ...

Dear friends, I wish to know the answer of the next question : If i add some code/functionality to libmysql.dll (ver 3.x.x) i must change the name of the project or can be remain the same ?(I mean : "libmysql" or other name) Thanks Regards, Gelu _

Re: GROUP BY on multiple fields apparently broken

matt, Sunday, May 19, 2002, 6:14:17 PM, you wrote: m>Description: m> mysql> describe DLSummary; m> ++--+--+-+-+---+ m> | Field | Type | Null | Key | Default | Extra | m> ++--+--+-+-+-

Re: can't connect to server2

Hoa, Thursday, May 23, 2002, 8:49:36 AM, you wrote: HD> Okay so it says that I can't connect through socket HD> '/var/lib/mysql/mysql.sock'. So I checked and the UNIX socket is located HD> here: /tmp/mysql.sock. I'm relatively new to Linux. What does this mean? You should specify path to yo

Re: Grant tables

Glenn, Thursday, May 23, 2002, 1:11:25 AM, you wrote: GH> I have had trouble with the script that creates my user access tables. GH> I am assuming those tables should get created in the ./var/mysql folder. They are created in the MySQL data dir. So, if you data dir is /var/mysql they will be cr

Re: mysql priviledges question

Taylor, Tuesday, May 21, 2002, 4:40:06 PM, you wrote: TL> Could someone give me a brief description of the following priviledges and what they are used for...? TL> 1) References Not yet implemented. Is that still true? Yes, it's for future features. If you do this, it will grant you right

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN - Server based in U.S.A - 99.9% uptime - Pay monthly or Yearly by Credit Cards - 50MB Disk Space [more plans are available] - PHP, MySql, CGI, ASP and many more - POP3, SMTP, Forwarding and Auto Reply - Cpanel 4.7 - 1500MB Traffic per month - 9.95$

  1   2   >