Urgent Help needed

Hi All, Can anyone please tell me how to alter a table wherin modify a column (which is Unique) to a non unique column. Any help on this would be great . Thanks Regards, K Srinivas res Ph:6631851 ATS TransLogic Systems 5th Floor Amogh Plaza, Greenlands, Hyderabad, AP 500 016, India Tel: +9

RE: Suppress WARNING

Or you can just add an @ in front of the function you are calling in your script which tells PHP to suppress all error warnings, which allows you script to continue running. Neil Silvester -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 30 January 2002 3:52

Order By Query - Simple Help

Ok, I am setting up a small bidding system. I have a table with one column for "BID" and the other for "MAX_BID" with each row having a unique id number. Anyone have a simple query example where I can select ID, BID, MAX_BID and sort in descending order the BID and MAX_BID as if it were

Error 1006: Cant create database (errno:13)

Hi All, Forgive me if this question has been asked before. I'm new to the list and MySQL! I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13) when signed on as root and as user. I've also tried this command but my terminal had no idea what i was talking about. [lo

Error 1006: Cant create database (errno:13)

Hi All, Forgive me if this question has been asked before. I'm new to the list and MySQL! I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13) when signed on as root and as user. I've also tried this command but my terminal had no idea what i was talking about. [lo

Re: Suppress WARNING

At 11:40 PM 1/29/2002 -0600, Dan Nelson wrote: >In the last episode (Jan 30), Tshering Norbu said: > > > Hi list, > > > How do you suppress the WARNING message like the one here: > > > > > > Warning: stat failed for photos/p73n1.jpg (errno=2 - No such file or > > > directory) in /ad/details.php on

Compile Error 4.0.1-alpha

Hi, I downloaded the tar.gz and the src.rpm files for the 4.0.1-alpha version. When I try to compile it (with/without options), I get an error: *** ../merge/libmerge.a ../myisam/libmyisam.a ..! /myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a ../mysys/l ibmysys.a ../dbug/libdbug.a .

RE: InnoDB help !!

Hi, On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote: > It seems, you suggesting that after setting changes in the configuration > file the "Show variable." will list out the 'YES' in front of > 'have_innodb' (in table below). right ?? Indeed. > The second thing is that, how do I test for

Nested Queries

Hi!! I am trying to execute the following query. But it is giving an error at "select max(columnname)." select columname from tablename where columname1 = select max(columnname) from tablename Thanks Amit Lonkar -

Re: Suppress WARNING

In the last episode (Jan 30), Tshering Norbu said: > > Hi list, > > How do you suppress the WARNING message like the one here: > > > > Warning: stat failed for photos/p73n1.jpg (errno=2 - No such file or > > directory) in /ad/details.php on line 12 > > > > Everything works fine even with that erro

Re: Suppress WARNING

Tshering NORBU Webmaster DrukNet & Bhutan Telecom PO Box 134 Thimphu, BHUTAN Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Phone: Work: +975-2-326997 Home: Only on request - Original Message - From: <[EMAIL PROTECTED]> To: Tshering Norbu <[EMAIL PROTECTED]>

Re: bug in join on bdb table

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Carsten Hammer writes: >> Hi, >> I just experienced the following bug in tables created as berkeley >> tables: Sinisa> Hi! Sinisa> I have tested your report and it works just fine. I get the same Sinisa> results th

RE: InnoDB help !!

thanks again, It seems, you suggesting that after setting changes in the configuration file the "Show variable." will list out the 'YES' in front of 'have_innodb' (in table below). right ?? The second thing is that, how do I test for the innoDB support ? specifically whether it is making th

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

On Tuesday 29 January 2002 08:44 pm, Mike Wexler wrote: > >Description: > mysql crashes with the following stack trace: > 0x807db7f handle_segfault__Fi + 383 > 0x823d60a pthread_sighandler + 154 > 0x8204407 _mi_compare_text + 71 > 0x821bb96 _mi_ft_cmp + 158

Re: urgent respnse

On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote: > I think we can avoid things like this by adding some extra 'not- > allowed-on-the-list' words, that a non-subscribe can't use, without > including an extra keyword in the email. > > Sasha, what do you think about this? The point is t

MyODBC connection error

I am trying to use MyODBC and getting a connection error to a remote linux server. S1000[TCX][MyODBC]Access denied for user. I have read manual and read other postings but can figure this out. I had added the user to database and also added the host name, which is 45+ characters long as a user.

Re: Largest datatype

I am not getting the requirement fulfilled from that manual page. I want some other data type as one of the field and with that i have to check the replication in two servers. that data type should have large size about 10kb. Is there any data type like that. Please let me know and its usage als

Re: Mysql 4.0.1 autocommit bug with Innodb table

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Hi! Heikki> This is a bug in the MySQL layer of code. I am sending a carbon copy of this Heikki> email to Monty. Heikki> I assume calling COMMIT explicitly after the SELECT allows you to do the Heikki> TRUNCATE? If you are

mysqld with daemontools

Has anybody out there experienced with mysqld running on daemontools? We're now testing this combination on our staging server without any problem, but if you can suggest any problem for it or anything, it would be appreciated. * Environment mysql 3.23.47 FreeBSD 4.4R % cat /service/mysqld/r

Re: Largest datatype

At 9:48 +0530 1/30/02, Charitha wrote: >Hi all, > >I want to know data type which will have a size greater than or equal to >10kb in mysql. Just anybody response to this mail and let me know. You can check this for yourself in the MySQL manual: http://www.mysql.com/doc/S/t/Storage_requirements.

Largest datatype

Hi all, I want to know data type which will have a size greater than or equal to 10kb in mysql. Just anybody response to this mail and let me know. Thank u. - Before posting, please check: http://www.mysql.com/manual.php

Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com > From: Ryan Walker <[EMAIL PROTECTED]> > Date: Tue, 29 Jan 2002 18:40:12 -080

Replication of selected DB

Hi, I got the solution for the replication of the selected db. I typed only the database name in the replicate-do-db column. And this line is followed by the data dir line. Hope it is taking the path starting from the data dir column itself. Thanks a lot for your response for this mail. Regards

Is Triggers Possible in MySQL

Hi All Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS. regards, SREEDHAR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

RE: Lost Data #2

Personally, I just run it whenever I delete any large quantity of rows. You could run it once a week, or day, or whatever. Up to you. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29

MySQL 4.0.1 crashes when updating a field with fulltext index

>Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383 0x823d60a pthread_sighandler + 154 0x8204407 _mi_compare_text + 71 0x821bb96 _mi_ft_cmp + 158 0x820bb01 mi_update + 721 0x80d07ef update_row__9ha_

Re: urgent respnse

G'day Michael, (I can't believe I'm _really_ replying to you:-) > I don't agree that we should make the list subscribers only, as this > would be a big drawback for newcomers to MySQL. I'm a classic newcomer to mysql and have only been on the list for a week or so. It surprised me how much s

RE: Urgent Business Assistance.

If its so urgent and private then why are you spamming a mail list? I smell scam, or is that Spam? -Original Message- From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 2:28 AM To: [EMAIL PROTECTED] Subject: Urgent Business Assistance. Urgent Busi

RE: Problem with SQLSetPos(SQL_DELETE)

Hi, > -Original Message- > From: Jim Dickenson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 5:12 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Problem with SQLSetPos(SQL_DELETE) > > > I have an application that works with EasySoft's OOB driver but not with > MyO

메일 전송 실패 알림

Title: ³×À̹ö ¸ÞÀÏ È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù. ¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.

Re: Statement preparing

On Tue, Jan 29, 2002 at 08:33:46PM -0600, Paul DuBois wrote: > At 13:34 +0100 1/29/02, Pedro Alvarez-Tabio wrote: > >Hello, > > > >I'm developing an application with MySQL using the C API. I would like > >to implement a mechanism to prepare some queries in advance and just > >bind the parameters b

MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMY

how to give a `root` mysql DB to each user ...

I`ll make myself more clear here ! I work for a small ISP, we give a MySQL DB access to each of our corpo users, if they request it. We just build new more performant machines, and instead of giving them only a Database, in which they can create as many tables as they want, we want to give them

Re: Statement preparing

At 13:34 +0100 1/29/02, Pedro Alvarez-Tabio wrote: >Hello, > >I'm developing an application with MySQL using the C API. I would like >to implement a mechanism to prepare some queries in advance and just >bind the parameters before execution. I have found in the documentation >a way to do that usin

Re: [MySQL] Re: for You

laszlo wrote: > Looks like we will *all* get rich!!! > (Poor guys on Oracle and DB2 lists :-) > > laszlo > P.S.: > Is this going to be tax-free? Next time you feel a sudden urge to add to the spam on the MySQL list, please have the courtesy to delete the message, instead of blindly quoting

Re: what "Type" of field should a column be that stores numbers...

At 17:41 -0800 1/29/02, Chadwick Meyer wrote: >I have a column that stores numbers, i.e. "4,000" "135" "6"; >What should I set the Column Type as, in order to sort properly by that >field. > >the problem: if it's "TEXT", it sorts according to first number, thus the >above numbers would be: >"135"

Re: next insert id

At 17:38 -0800 1/29/02, James Montebello wrote: >Other people do know how to read manuals, Paul. > >If the original poster made any assumptions about the NEXT value in the >auto increment field based on the value of LAST_INSERT_ID, that assumed >value will be invalid the second another row is writ

RE: urgent respnse

Hi! > "Jonathan" == Jonathan Hilgeman <[EMAIL PROTECTED]> writes: Jonathan> Call me Ishmael. My whale and I would like to tour Mongolia, but alas, my Jonathan> whale swallowed a group of Enron executives, including the entire Bush Jonathan> administration, and now he is too full of money to

what "Type" of field should a column be that stores numbers...

I have a column that stores numbers, i.e. "4,000" "135" "6"; What should I set the Column Type as, in order to sort properly by that field. the problem: if it's "TEXT", it sorts according to first number, thus the above numbers would be: "135" "4,000" "6" this is not acceptable. But if I set th

Re: next insert id

Other people do know how to read manuals, Paul. If the original poster made any assumptions about the NEXT value in the auto increment field based on the value of LAST_INSERT_ID, that assumed value will be invalid the second another row is written to the table. If I did this: INSERT INTO foo S

Urgent Business Assistance.

Urgent Business Asistance. Engr Martin Douglas. No. 16 Kingsway road, Ikoyi lagos Nigeria. Tel/Fax:: 234-1-7742913 30th,January 2002. Dear sir, REQUEST FOR URGENT BUSINESS RELATIONSHIP. First, I must solicit your confid

Re: for You

Looks like we will *all* get rich!!! (Poor guys on Oracle and DB2 lists :-) laszlo P.S.: Is this going to be tax-free? Engr Duke Paul wrote: > NIGERIAN NATIONAL PETROLEUM CORPORATION > (DEPARTMENT OF PETROLEUM RESOURCES) > > ENGR PUAL DUKE > > > ATTN: THE PRESIDENT, > > REQUEST FOR URGENT BUSI

Problem with SQLSetPos(SQL_DELETE)

I have an application that works with EasySoft's OOB driver but not with MyODBC. I have compiled version 2.50.39 under RedHat 7.2 and I think there is a problem in the code. In cursor.c on line 217 there is a test to see if irow is being passed correctly. I think the test is wrong. I fetch one re

Urgent Business Assistance.

Urgent Business Asistan.ce. Engr. Martin Douglas. No. 16 Kingsway road, Ikoyi lagos Nigeria. Tel/Fax:: 234-1-7742913 30th,January 2002. Dear sir, REQUEST FOR URGENT BUSINESS RELATIONSHIP. First, I must solicit your conf

Re: SELECT DISTINCT BINARY crashes mysql on null values

On Wed, 30 Jan 2002 08:21:49 +1000, you wrote: >I tried this on an existing table using a char(50) column with 956 entries, >of which I have 1 valid entry and 954 NULL values. I have 2 records returned >1 = valid entry, 1 = NULL and mysql did not crash. >Is it only when you are using temporary ta

Re: next insert id

The original question that started this thread was: >> >>I need to find out what the next value will be in an auto_increment field >>will be. could someone help me out with the select statement? To which I replied: > >You can't find out what it *will be* until you actually create the record. >T

Re: next insert id

At 15:33 -0800 1/29/02, James Montebello wrote: >This result will be invalid when the a new row is written to the table, >whether it's part of a transaction or not, no matter what the table type. >I said as much, but perhaps I was a bit too cryptic. > >Generally speaking, getting this value reliab

Re: next insert id

At 15:30 -0800 1/29/02, laszlo wrote: >And then you hope that between 'insert' and 'select' nobody else inserted >another record? Only for the last method. The first two return client-specific values. > >laszlo > >Johnny Withers wrote: > >> INSERT into the table >> then SELECT last_insert_id(

Re: next insert id

At 15:35 -0800 1/29/02, James Montebello wrote: >Of course, if you do LAST_INSERT_ID, then try to use the value while someone >else is doing an insert, you're in the same boat. Neither method is reliable >without a lock. That's incorrect. LAST_INSERT_ID() is client-specific, other clients can't

Re: Accessing MySQL Using ASP

On the other hand, you can also try OLEDB downloaded from www.mysql.org. - Original Message - From: "A. Clausen" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, January 30, 2002 3:36 AM Subject: Re: Accessing MySQL Using ASP > - Original Message -

RE: next insert id

* James Montebello > Of course, if you do LAST_INSERT_ID, then try to use the value > while someone else is doing an insert, you're in the same boat. > Neither method is reliable without a lock. This is not correct. The LAST_INSERT_ID() function return the last inserted auto increment key for _th

Re: Lost Data #2

If I run optimize on the table once - will I have to come back and so it again? If so - how often? Thanks Mark -Original Message- From: Matthew Walker <[EMAIL PROTECTED]> To: Mark Stringham <[EMAIL PROTECTED]>; Scott Wang <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date:

for You

NIGERIAN NATIONAL PETROLEUM CORPORATION (DEPARTMENT OF PETROLEUM RESOURCES) ENGR PUAL DUKE ATTN: THE PRESIDENT, REQUEST FOR URGENT BUSINESS RELATIONSHIP ALTHOUGH THIS PROPOSAL MIGHT COME TO YOU AS A SURPRISE SINCE IT IS COMING FROM SOMEONE YOU DO NOT KNOW OR EVER SEEN BEFORE, BUT AFTER DU

RE: Understanding throughput with JDBC

Hi! > "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes: Emmanuel> Hello Monty, Emmanuel> With your help I'm getting the understanding I was looking for, thank you. >> Note however that if there would have been less matching rows (for >> example 60), the SQL_CALC_FOUND_ROW

RE: urgent respnse

Call me Ishmael. My whale and I would like to tour Mongolia, but alas, my whale swallowed a group of Enron executives, including the entire Bush administration, and now he is too full of money to walk. Please help me by sending your bank account information so I can safely deposit the money in a s

need help installing

I am trying to install MySQL on a Mac OS X server (v 10.1). I have followed the instructions in the online documentation, but I am having 2 problems. Any advice on the problems or on where to get more information is greatly appreciated. 1. I got mysql installed and running (using ./bin/safe_mys

Select with while loops

I am trying to do a select that will display events by category, but will NOT display a category name if it is empty (has no events). 2 tables: categories and events events contains a field called category_id that corresponds to the id of a category in categories. I am doing a 'while' loop for

Re: Descending indexes not working?

Hi! > "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes: >> ... WHERE key_prefix BETWEEN # and # ORDER BY key_prefix DESC Steven> What about Steven> ... WHERE key_part1 = xxx ORDER BY key_part2 DESC This is already fixed in MySQL 4.0.2 source tree; 4.0.2 should be out within a coup

Re: next insert id

Nathan: I suspect you are trying to solve the wrong problem. Why don't you tell us _why_ you think you need this value, what you are trying to accomplish. At 04:23 PM 1/29/2002 -0700, Nathan wrote: >But if this is the MyISAM table type, and you performed an insert, then a >delete, your MAX +

Re: next insert id

Of course, if you do LAST_INSERT_ID, then try to use the value while someone else is doing an insert, you're in the same boat. Neither method is reliable without a lock. james montebello On Tue, 29 Jan 2002, Paul DuBois wrote: > At 15:16 -0800 1/29/02, James Montebello wrote: > >SELECT MAX(i

Re: next insert id

This result will be invalid when the a new row is written to the table, whether it's part of a transaction or not, no matter what the table type. I said as much, but perhaps I was a bit too cryptic. Generally speaking, getting this value reliably while other work is going on is only possible if

메일 전송 실패 알림

Title: ³×À̹ö ¸ÞÀÏ ¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù. ¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ. -

Re: next insert id

And then you hope that between 'insert' and 'select' nobody else inserted another record? laszlo Johnny Withers wrote: > INSERT into the table > then SELECT last_insert_id() > > or when using php > > query(INSERT QUERY) > $last_id=mysql_insert_id() > > OR > > INSERT > SELECT MAX(id) FROM tablen

urgent respnse

SOS Oscar Malaba oscarmalabaxyahoo.com Bamako Mali Dear sir I know this will come to you out of the blue as a surprise. I write this crucial mail to solicit your assistance in a transaction that will be very beneficial to you, with hope that you will never let me down either now or in fut

Re: next insert id

At 15:16 -0800 1/29/02, James Montebello wrote: >SELECT MAX(id) FROM table; > >will get you the highest value for 'id', that +1 will be the 'next' value, >until someone inserts a new row into that table. Which may already have happened between the time you created your record and the time you iss

Re: next insert id

Not _necessarily_ true, surely, if there's another transaction active at the moment (assuming you are using a table that supports transactions)...? At 03:16 PM 1/29/2002 -0800, James Montebello wrote: >SELECT MAX(id) FROM table; > >will get you the highest value for 'id', that +1 will be the 'n

Re: next insert id

But if this is the MyISAM table type, and you performed an insert, then a delete, your MAX + 1 would get the next value of the series, but the auto_increment will actually use MAX + 2. Correct? Is there a system call to find out what MySQL will use next rather than the highest + 1? # Nathan --

Re: next insert id

At 17:03 -0800 1/29/02, Joel Wickard wrote: >database,sql,query,table > > >I need to find out what the next value will be in an auto_increment field >will be. could someone help me out with the select statement? You can't find out what it *will be* until you actually create the record. Then you g

Squid logging

Guys, I'm talking to the people from squid-dev mailing list about making Squid log directly into MySQL. Because Squid is a single-process application that does everything in one select() loop, there are worried about blocking sockets: if you open a socket from Squid to MySQL you don't want that s

RE: next insert id

INSERT into the table then SELECT last_insert_id() or when using php query(INSERT QUERY) $last_id=mysql_insert_id() OR INSERT SELECT MAX(id) FROM tablename assuming id is the auto incremnt field. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -O

Re: next insert id

SELECT MAX(id) FROM table; will get you the highest value for 'id', that +1 will be the 'next' value, until someone inserts a new row into that table. james montebello On Tue, 29 Jan 2002, Joel Wickard wrote: > database,sql,query,table > > > I need to find out what the next value will be in

RE: Lost Data #2

To get rid of overhead, run an OPTIMIZE TABLE on the table. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 11:02 AM To: Scott Wang; [EMAIL PROTECTED] Subject: Re: Lost Data #

RE: MyCC version 0.0.8 alpha - BUG

Hi! > I haven't found 0.8.1. When I do, I will upgrade. You can either get it from http://www.mysql.com/downloads/gui-mycc.html We just updated the website today :) > It is apparent that you are setting an explicit > window size and position The above is true. What I'll do is speed up the "

next insert id

database,sql,query,table I need to find out what the next value will be in an auto_increment field will be. could someone help me out with the select statement? - Before posting, please check: http://www.mysql.com/manual.ph

Importing data from SQL Server into MySQL

I am in the process of migrating our data from m$ SQL Server to MySQL. I am having a heck of a time trying to figure out how to deal with m$ SQL Server's data type called 'uniqueidentifier'. I have tried very large varchar's and blob's and even longtext but I always get datatype conversion errors

Submit/View images using PHP/MySQL

Hi, Can anyone point me to some good examples of how to add images using PHP 4 (from within a browser) to a MySQL database running on MacOSX, which is already configured & working, then display the images by selecting their name or category etc, again within the browser. I also need to restric

RE: SELECT DISTINCT BINARY crashes mysql on null values

I tried this on an existing table using a char(50) column with 956 entries, of which I have 1 valid entry and 954 NULL values. I have 2 records returned 1 = valid entry, 1 = NULL and mysql did not crash. Is it only when you are using temporary tables? Or have you tried this on multiple tables to g

RE: exporting data to a new DB

At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote: >Hello everyone, > >I need to export some data from one DB to another. > >Suppose I'm connected to DB1 and my trying to get stuff from there >and insert into DB2. I'm using Insert Select statements. Once I'm >connected to DB1, do I have t

SELECT DISTINCT BINARY crashes mysql on null values

>Description: Executing a SELECT DISTINCT statement in conjunction with the BINARY cast operator will crash MySQL server when the column being cast contains one or more null values. >How-To-Repeat: Executing the following code from a mysql prompt will cause the MySQL server to cra

RE: exporting data to a new DB

Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? An example Insert Sel

RE: InnoDB help !!

Hi, On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote: > thanks for your quick reply !! > > that's fine !! I have done the max.RPM installation part. > but what is "fix up the startup scripts so that > binary will be the one started." > > When I am trying "show variables like "have_%"; > +---

RE: Need some easy "select" assistance

Yes it is so easy.. You just need to use table joins.. Check out: http://www.mysql.com/doc/J/O/JOIN.html Gurhan -Original Message- From: Torkil Johnsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:50 PM To: [EMAIL PROTECTED] Subject: Need some easy "select" assistance

MyCC version 0.0.8 alpha - BUG

I got this address from the MyCC README file. If it is the wrong one, my apologies - could you send me the right one. Description: Starting MyCC on a W2000 native dual monitor PC results in the main window spanning both monitors. Details: Normally, when an application is started on a native d

Re: Need some easy "select" assistance

> Given this example: > table CARS > has got an entity "Labourghini" with car_id=5 > table NEWS > has got an entity "Lambourghini displays new super model" with > date=2002-05-02, news_id=735 and car_id=5 > I want this output: > NEWS HEADLINES > : () > Can I do this without 2 select queries? I

Re: Need some easy "select" assistance

At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote: >Given this example: > >table CARS >has got an entity "Labourghini" with car_id=5 > >table NEWS >has got an entity "Lambourghini displays new super model" with >date=2002-05-02, news_id=735 and car_id=5 > >Now: > >I want this output: > >NEWS HEADL

RE: Pattern Matching Problem

Since the days in a week are not likely to change, why not have an indexed column for each day? For example, select id from courses where day_m = 1 and day_t = 0 and day_w = 1 and day_h = 0 and day_f = 1; Wouldn't this approach be more efficient than a full table scan with regular expression mat

RE: Pattern Matching Problem Solved

Thanks to everyone for being so helpful with this solution. Douglas -- Douglas R. Brantz Computer Consultant Fine & Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] S

Need some easy "select" assistance

Given this example: table CARS has got an entity "Labourghini" with car_id=5 table NEWS has got an entity "Lambourghini displays new super model" with date=2002-05-02, news_id=735 and car_id=5 Now: I want this output: NEWS HEADLINES : () Can I do this without 2 select queries? As of now, I

RE: Please Help with Pattern Matching

Try this: select schdays from courses where schdays Regexp"[MWF]"; -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: Please Help with Pattern Matching I have a big problem with pattern matching; Why

Pattern Matching Solved

Paul Dubois helped me on this: Check page 520 of his book. REGEXP "[MWF]" matches all I need everything inside the [...] (brackets). Thank you again Paul. That problem fixed now moving on to the next one. Douglas -- Douglas R. Brantz Computer Consultant Fine & Applied Arts Appalachian State

RE: Pattern Matching Problem

SELECT schdays FROM courses WHERE (schdays LIKE "M") OR (schdays LIKE "W") OR (schdays LIKE "F") Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:15 PM To: [EMAIL PROTECTED]

Re: Pattern Matching Problem

At 15:15 -0500 1/29/02, Douglas Brantz wrote: >Hello, > >I have a big problem! I need to match all patterns in schdays from a >variable schdays and if schdays = mwf it only turns up mwf and not all >entries containing M, W or F. Is there a way to do this? Yes, but you can't do it with LIKE excep

Re: Please Help with Pattern Matching

In the last episode (Jan 29), Douglas Brantz said: > I have a big problem with pattern matching; > Why does the first example work like this I need to find everything with > MWF in it and I only get the 1 entry? Is there a way I can make this > work. > > mysql> select schdays from courses where

RE: Please Help with Pattern Matching

Doug, MySql is doing what it is supposed to... If you specify '%MWF%' it will only select the values with the string literal 'MWF' in it. If you would like to match all the rows that have either M or W or F in it, then use a query like : select schdays from courses where schdays LIKE "%M%" OR LI

OLE DB Driver for VB App

Is there an OLE DB Provider for MySQL or should I use the Generic ANSI SQL provider (if there are one of those)? Trying to use MySQL as a backend database for a project but performance is slower than using even MS Access - surely there must be a provider out there that blow away at least MS Acces

Re: Pattern Matching Problem

At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote: >Hello, > >I have a big problem! I need to match all patterns in schdays from a >variable schdays and if schdays = mwf it only turns up mwf and not all >entries containing M, W or F. Is there a way to do this? > >mysql> select schdays from course

Re: Please Help with Pattern Matching

At 14:59 -0500 1/29/02, Douglas Brantz wrote: >I have a big problem with pattern matching; >Why does the first example work like this I need to find everything with >MWF in it and I only get the 1 entry? Is there a way I can make this >work. It's unclear what you're expecting to happen. From th

making software with mySQL server

Hi all, I want to know how to make software using mySQL as the database server. I'm using SuSE Linux 7.3Pro + KDE 2.2.2 I've open a project in KDevelop 2.0 and put this link -lmysqlclient but I can't go thru: MYSQL mysql Am I missing something else Thank you. -

Pattern Matching Problem

Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this? mysql> select schdays from courses where schdays LIKE "%MWF%"; +-+ | schdays | +-

Please Help with Pattern Matching

I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work. mysql> select schdays from courses where schdays LIKE "%MWF%"; +-+ | schdays | +-+ | MWF

  1   2   >