Update with sub-select from same table FAILS

Description: MySQL doesn't allow me to use a sub-select in an update if the subselect happens to be from the same table. How-To-Repeat: mysql use test; mysql create table T(lfd int, foo int); mysql insert into T (lfd, foo) values ( ( select max( lfd ) + 1

Soundex Speed Up ?

Hi I have a single table with 123 columns and currently it holds 49,000 records My ISP is running MySql v: 3.23.38 I use MySql Front to access the table And I currently have a freetext index on the surname column. Running a query like SELECT SURNAME, GIVENNAMES, ageatdeath, gender, dode,

re: Indexes

On Tuesday 04 March 2003 09:50, Donna Robinson wrote: How can I avoid Using temporary, Using filesort when creating indices when my selects MUST be ordered? Please, check chapter 5 MySQL Optimisation of the manual. You can find cases when MySQL uses indexes and when it doesn't use them:

re: update/delete bug, please fix, thank you!

On Saturday 01 March 2003 17:30, miniwar at netvigator dot com wrote: Description: Dear sir, When I execute the command select * from user_info where regdate now()- interval 9 day and phone_confirmed is null and email is null and last_onlinenow()-interval 10 day got 770 rows result. But

replication connection problem

hi guys i am still haveing the same problem has anyone experienced this before ? 030305 08:33:36 mysqld started 030305 8:33:37 InnoDB: Started /usr/local/etc/mysqlslave/libexec/mysqld: ready for connections. Version: '4.0.11a-gamma' socket: '/usr/local/etc/mysqlslave/tmp/mysql.sock' port:

Loading pictures dynamically into MySql?

Hi, I'm quite new to MySql and databases in general (as will probably be obvious shortly). I am working on a very large commercial site right now that will have to database approx. 500 plus pictures, txt files and other various things (such as client info). Throughout a

Re: Loading pictures dynamically into MySql?

Have a relative location that is manageable and store the location and name of the file in the dB then get the application logic to use it from there. I've done something similar and have gone well over a 250K objects so I wouldn't worry about scaling, and that's blobbing not linking. Load data

Looping through parent and childs

I'm new to mySQL and would like to know how do a SELECT where I get all child records whose root parent=1 Here's my table (project_group_list): group_idparent_group_id 1 0 2 0 3 1 4 3 5

InnoDB and Solaris 8

Hi, I define innodb_buffer_pool_size at 4Go (i have a SUN V880 8Go RAM with Solaris 8) and i receive a innodb error : cannot allocate memory 2Go). What's wrong ? I use mysql_max for solaris 8. Best regards. - Before posting,

Re: Soundex Speed Up ?

* John Berman I have a single table with 123 columns and currently it holds 49,000 records [...] 17.72 Secs I believe I need to insert a soundex field and pre populate it and then create an index on the soundex field - If my approach is correct help on how to do this would be appreciated ?

sql

I am implementing a inheritence in sql database. I have got a table called Entity with attributes Name,Password and a = Advertiser table. Basically, in my java program the Entity is the base class of the = Advertiser class. ( I like using inheritence a lot ). Both tables have an autonumber as

mysql replication problem

Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the following error message on the slave when I restart. 030303 10:35:28 mysqld started 030303 10:35:29 InnoDB: Started /usr/mysql/libexec/mysqld: ready

mix soundex and fulltext

Hi, as MySQL doesn't seems to support a direct access to the fulltext index tables I wonder how or if it's possible to mix a soundex-fulltext-mixed-mode selection. So my actual selection is like: select data,match(data) against ('$query' in boolean mode) as score from TABLE where match(data)

maximum column width

What is the maximum column width allowed in MySQL. 255 or 256? Anis Floyd Wellershaus [EMAIL PROTECTED] Tuesday, March 04, 2003 6:24:50 PM Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the following

Query selected

Can anyone tell me why this mysql query and 'selected' isn't working? It does keep a fixed id selected but not the one that was selected and aslo doesn't return any results? echo select name=\CityID\ size=\1\ class='menuForm'; $result=mysql_query(SELECT City, CityID FROM city ORDER BY City);

Re: maximum column width

* Ahmed S K Anis What is the maximum column width allowed in MySQL. 255 or 256? No. URL: http://www.mysql.com/doc/en/Column_types.html URL: http://www.mysql.com/doc/en/String_types.html The theoretic maximum column width is 16M on 3.23.x, 2G on 4.x, restricted by max_allowed_packet, see:

Data sincronization

I need to sincronice two mysql databases that are in different places. It is imposible to centralice everything in one database. Then I would need to sincronice the changes made in both of them one time per day. Is there any way to do this?

Re: mysql replication problem

Have you turned log-bin on the master server? The master will not generate the log files that the slave reads unless this is turned on. |-+ | | Floyd Wellershaus| | | [EMAIL PROTECTED]| | | .com

Data sincronization

It must be in a master master way. -Mensaje original- De: Jerry [mailto:[EMAIL PROTECTED] Enviado el: Martes, 04 de Marzo de 2003 10:50 a.m. Para: Gaston Escobar Asunto: Re: Data sincronization Synchronise in a master master way or just to replicate the data for safety ?

Re: Data sincronization

I need to sincronice two mysql databases that are in different places. It is imposible to centralice everything in one database. Then I would need to sincronice the changes made in both of them one time per day. Is there any way to do this? See the section on replication in the manual at

Re: Data sincronization

I'm fairly sure it won't do master-master at the moment. I'd like to be wrong though. http://www.mysql.com/doc/en/Replication_FAQ.html Jerry Systems Dev Cable Wireless - Original Message - From: Gaston Escobar [EMAIL PROTECTED] To: [EMAIL

Re: Error 2013 - Lost connection to MySQL server during query

Now, it's working fine ! Thanks a lot Nivaldo - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 12:12 AM Subject: Re: Error 2013 - Lost connection to MySQL server during query Suporte schrieb: Hi

Re: Data sincronization

* Gaston Escobar I need to sincronice two mysql databases that are in different places. It is imposible to centralice everything in one database. Then I would need to sincronice the changes made in both of them one time per day. Is there any way to do this? This very much depends on your

RE: Querying for performance...

Paul, Thanks for the answers. As a matter of fact, I did think that I was issuing multiple queries at the same time. Thanks for the clarification. --- Jonathan -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:29 PM To: [EMAIL

Re: Data sincronization

* Jerry I'm fairly sure it won't do master-master at the moment. I'd like to be wrong though. http://www.mysql.com/doc/en/Replication_FAQ.html master-master replication is the same as two-way replication, and it is mentioned in the above FAQ, halfway down the page: Q: What issues should I

Simple subtraction problem

Hi. I've got two mediumint columns in a mysql table, and I'm trying to subtract them like this: SELECT column1-column2 FROM table WHERE name='johndoe'; This works some of the time, however, I get weird results for negative numbers. For example, when column1=0 and column2=4995, I get:

Re: Data sincronization

Yea, I've done what it says there but had to implement the locking myself, then just use two subsets of the dB and master slaved them to each other on the respective parts that weren't being used. Jerry Systems Dev Cable Wireless - Original Message

Re: Query selected

* Andrew Can anyone tell me why this mysql query and 'selected' isn't working? It does keep a fixed id selected but not the one that was selected and aslo doesn't return any results? Try to keep the html part of the problem separate from the mysql part of the problem... :) echo select

RE: Query selected

Absolutely brilliant Roger this has sorted the problem out :) Andrew -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: 04 March 2003 15:48 To: MySQL-Lista Cc: [EMAIL PROTECTED] Subject: Re: Query selected * Andrew Can anyone tell me why this mysql query and

Problems installing supper-smack

Hi I am installing MySQL's supper-smack on Linux. The problem is that it will not 'make'. It errors on two files 'die.cc' and 'gen_data.cc'. If in add '#include cstdlib' to die.cc and '#include cstring' to gen_data.cc in will 'make' and 'make install'. But then will not work. It runs with out any

A select query not working

I am using JDBC and trying to run this query. Select DISTINCT COURSE.ID, COURSE.NAME, COURSE.CATEGORYID, COURSE.DESCRIPTION + COURSE.GRADELEVELS, COURSE.OWNERID from MEETING, COURSE, INSTRUCTOR + Where INSTURCTOR.ID = 1 And COURSE.INSTRUCTORID = INSTRUCTOR.ID And

Re: A select query not working

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mufaddal Khumri wrote: I am using JDBC and trying to run this query. Select DISTINCT COURSE.ID, COURSE.NAME, COURSE.CATEGORYID, COURSE.DESCRIPTION + COURSE.GRADELEVELS,

re: Simple subtraction problem

On Tuesday 04 March 2003 16:51, Jamie Jennings wrote: Hi. I've got two mediumint columns in a mysql table, and I'm trying to subtract them like this: SELECT column1-column2 FROM table WHERE name='johndoe'; This works some of the time, however, I get weird results for negative numbers. For

re: Simple subtraction problem

Yes that must be it. Both columns are unsigned. Is there any way to accomplish this with one query with unsigned columns? Otherwise I will have to fetch each column seperately (two queries) and then do the subtraction outside MySQL (in my C code). --- Victoria Reznichenko [EMAIL PROTECTED]

Odd query problem

Hi Can anyone please explain why this first query works and returns the expected data, while the second one only returns a subset (and quite small) of the expected data. This one works.. select trans_type,prod_id,sub_prod_id,sum(credits) as credits, FROM_UNIXTIME(timestamp,'%Y-%m-%d')

LONGTEXT - All string column types are VAR? - MySQL

I know that for most purposes you can treat TEXT and BLOB as VARCHAR under a longer name, but is the same true of LONGTEXT? I have a field that needs to be open to a huge amount of text, but I don't want my database's size to be huge if that maximum allowed amount of text is not used. Thanks.

from_unixtime incorrectly applies localtime correction

Description: On a windows or linux system where the time is set to local time, the function from_unixtime incorrectly applies the offset from UTC to Local to the result. For example when set to EST, select from_unixtime(0); returns 1969-12-31 19:00:00. In fact, section 6.3.4 of the MySql

stalled mysqld-processes?

Hi folks, running mysql-4.0.x since the early versions without any problems, I had a problem 3 days ago. I'm not sure if its mysql-4.0.x-related but maybe anyone may shed a light on it. MySQL is running with the query-cache enabled (16 MB cache for it, 33% cache-hits). That day mysql got pretty

Replication

Hello I'd like to know if they have already implemented that feature of replication that changes the master server to other serve if the master fails. If they have not implemented that yet, how can I do something similar using the features that mysql have now? Thank you for any answer. ---

Re: LONGTEXT - All string column types are VAR? - MySQL

At 12:29 -0600 3/4/03, jason wesley upton wrote: I know that for most purposes you can treat TEXT and BLOB as VARCHAR under a longer name, but is the same true of LONGTEXT? I have a field that needs to be open to a huge amount of text, but I don't want my database's size to be huge if that

MySQLcc list down?

Hi, I was wondering if anyone knows - is the MySQLcc list down? I signed up yesterday but never got a confirmation e-mail from them. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Warning suppression?

Folk, I'm not having a lot of success with my provider, so I'll ask here. Is there any way to turn _show warnings_ off from script? I cant seem to find anything relevant. I'm getting a warning that, Supplied argument is not a valid MySQL result resource . . .. I don't see any way to test

latin1_de with index

Hello, Description: A select returns uncomplete results, when querying an indexed varchar row with latin1_de character set and strings containing umlauts or 'ß'. How-To-Repeat: start MySQL 4.0 with character set latin1_de. create table test (word varchar(255) not null default '',

RE: Warning suppression?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As far as suppressing errors you can suppress them in PHP by putting an @ symbol in front of the function call, i.e. $result = @mysql_fetch_array($sql); HTH HAND, Bryant Hester - -Original Message- From: databarn [mailto:[EMAIL

RE: Replication

I've devised a solution under Linux, using Heartbeat, DRBD and Perl, but we have not put it into production yet. We also use LVS to put our database slaves into HA clusters. The basic idea is that you have an Active/Standby master, (the standby being a slave) in a heartbeat cluster. You use

replication bug? - replace into db.table being recorded in the wrong bin-log....

Hi all, This is quite an involved one... Using MySQL 4.0.11 on linux I have two logical db's on the same machine, lets say db1 and db2. I have perl apps doing the following: replace into db2.tablename . In my.cnf I have the line binlog-do-db= db1 The queries are being performed OK on

Re: Warning suppression?

this is more a php question then mysql, but if you put a @ before the commands that are giving you warnings, it should cause it to not show them @mysql_connect(...) and you might also be looking for the php function error_reporting( [ int level ] ) On Tuesday 04 March 2003 13:55, you wrote:

getdate

Hello. I have problem to solve in a school homework that I hope someone could help me with. I have a small community, and the SQL statement below should set all logged in users that has been inactive for more than 300 seconds to 0 in the 'inloggad' field. Though the getdate() does not seem to

activate Innodb on mysql 3.23.49-3 (linux) ?

I want to add transaction support to an existing database running on mysql 3.23.49-3 distributed with Red Hat 7.3. After browsing through the Mysql and the Innodb documentation, it appears that I have the following options: 1) Configure mysql 3.23.49-3 to support innodb tables. Since the

Re: Warning suppression?

this is more a php question then mysql, but if you put a @ before the commands that are giving you warnings, it should cause it to not show them Didn't start happening until the provider upgraded the MySQL engine, and the _show warnings_ is a MySQL configuration, according to the MySQL docs.

RE: Warning suppression?

Is your database configuration the same on both environments? Usually this error comes querying for the wrong table/column name. I have also seen this error when, for example, customer_id = NULL, and in my script I say WHERE customer_id = $customer_id. --- Jonathan -Original

Re: Table Structure and Better way to query data

Hello, I`m doing a database in MySQL to catalog cds, and i`m not sure if my table structure is the best way to do it: Artist Table Artist_Id int unsigned not null auto_increment primary key Name char(120) // Artist or Band Name Country char(30) // Artist Or Band Country Members char(255) //

User rights - create database but no create tables inside?

Hi, I'm trying to set up a small database server for our students to play with and ran into problems while creating accounts and granting rights. I used insert into user (User, Host, Password, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv)

How to tell when mysql has frozen

I attempted to optimize a table last night, which usually takes about 5 minutes but I expected to take longer as I had done a slew of deletes. Well, it took over an hour, and from the last modified dates on the table and temp files, it looked like they hadnt been updated in 10-15 minutes.

help with join syntax

Hi, I have the following tables: mysql describe lawfac_pub; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | hawkid | varchar(16) | | PRI | |

Re: help with join syntax

Hi. This is not at all an answer to your problem, and perhaps you're already aware of my tip: I usually use phpMyAdmin and paste my SQL statements in there to see what is causing the error, and when it works you get a pretty good picture of how your virtual table looks like. Just my 2 cents.

Re: help with join syntax

At 03:57 PM 3/4/2003, Martin Ostlund wrote: I usually use phpMyAdmin Thanks for the tip. Unfortunately it isn't my server and they haven't finished installing phpMyAdmin on it yet. That's why I usually make odbc connections in access and build the queries graphically. But it just keeps

RE: Looping through parent and childs

Hi Jakob, You can not do this in MySQL. MySQL does not support hierarchical joins nor does it support Transact-SQL. You will need to do this with a combination of SQL and your favorite host language. Substituting Transact-SQL for Java, Perl, PHP or any other language and you will get the same

make test fails - strack trace included

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: make test fails - strack trace included Severity: Priority: Category:

what is wrong with this perl mysql code?

I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a username i need to check if this username already exsited in mysql database table. if it is already in the table, this program will prompt user to pick another user name. but something

problem setting up DES_ENCRYPT on MySQL 3.23.46

Hello Thanks for a great tool ! and thank you very much in advance for any help Description: I am a Programmer working with patient data and for privacy reasons I have been trying to get des_encrypt() to work on MySQL 3.23.46 with openssl-0.9.6b on a Linux server. I followed the steps described

Re: what is wrong with this perl mysql code?

You need quotes around $username in your SQL query, unless you've already run $username thorough $dbh-quote(); j- k- On Tuesday 04 March 2003 13:11, Jianping Zhu wrote: I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a

Re: what is wrong with this perl mysql code?

At 17:11 -0500 3/4/03, Jianping Zhu wrote: I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a username i need to check if this username already exsited in mysql database table. if it is already in the table, this program will prompt user

RE: help with join syntax

try thi FROM lawfac_pub INNER JOIN fac_stud_lunch ON lawfac_pub.hawkid = fac_stud_lunch_join.instructor_hawkid INNER JOIN fac_stud_lunch_join ON fac_stud_lunch.instructor_hawkid = fac_stud_lunch_join.instructor_hawkid -Original Message- From: Martin Ostlund [mailto:[EMAIL PROTECTED]

Temporary Tables

Hi, I would like to know how MySQL handles multiple temporary tables? 1. Can multiple temporary tables be created at the same time? 2. If so, how does MySQL differentiate them - do we need to explicitly give them different names inorder to identify them or does MySQL provide a timestamp (or use

Re: Temporary Tables

At 23:00 + 3/4/03, Mamatha Balasubramanian wrote: Hi, I would like to know how MySQL handles multiple temporary tables? 1. Can multiple temporary tables be created at the same time? 2. If so, how does MySQL differentiate them - do we need to explicitly give them different names inorder to

Re: Temporary Tables

Mamatha Balasubramanian wrote: Hi, I would like to know how MySQL handles multiple temporary tables? 1. Can multiple temporary tables be created at the same time? Yes 2. If so, how does MySQL differentiate them - do we need to explicitly give them different names inorder to identify them or

Re: Temporary Tables

Thank you once again. I have a web-interface that does search on a given text and I would have a script that creates a temporary table. So according to you, in my script, I just to need create a temporary table and not have to worry about another client using the same web interface (and

Re: Temporary Tables

At 23:19 + 3/4/03, Mamatha Balasubramanian wrote: Thank you once again. I have a web-interface that does search on a given text and I would have a script that creates a temporary table. So according to you, in my script, I just to need create a temporary table and not have to worry about

Re: Temporary Tables

At 23:19 + 3/4/03, Mamatha Balasubramanian wrote: Thank you once again. I have a web-interface that does search on a given text and I would have a script that creates a temporary table. So according to you, in my script, I just to need create a temporary table and not have to worry about

Re: Temporary Tables

Paul is right. I would like to add a small remark, it should better to drop the temp. tables before closing your script. This can free up resources. I had a painful experience that I had created hash temp. tables without dropping them. This lead to memory leak. Regards, -- Yours, KH Chiu CA

Re: Temporary Tables

At 15:56 -0800 3/4/03, William R. Mussatto wrote: At 23:19 + 3/4/03, Mamatha Balasubramanian wrote: Thank you once again. I have a web-interface that does search on a given text and I would have a script that creates a temporary table. So according to you, in my script, I just to need

Re: Temporary Tables

Paul DuBois wrote: That is, you're making an assumption that cannot necessarily be made. If you can guarantee that the web script will establish a new connection, and the connection will terminate when the script ends, you can indeed do what you describe above. But you *cannot* do that if you're

Table Design

Hello, I`m doing a database in MySQL to catalog cds, and i`m not sure if my table structure is the best way to do it: Artist Table Artist_Id int unsigned not null auto_increment primary key Name char(120) // Artist or Band Name Country char(30) // Artist Or Band Country Members char(255) //

Perplexed by reverse SELECT statement.

Man, this was a tough MySQL question to assign a Subject to. Hopefully the answer is easier. I have a table called news which contains a column called readBy. The read by column is of type TEXT and it contains a CSV list of IDs of users who have read a certain news item. For example, if my user

Linux Filesystem Type and Performance

Greetings, I've been running a public MySQL server for a couple of years that now supports several thousand users. I used to run this on a lowly PII-350 and it ran quite fine with CPU loads usually hanging well under 0.20. The only hitch was the time necessary to connect seemed to jump up

Re: Temporary Tables

At 12:08 +1100 3/5/03, Daniel Kasak wrote: Paul DuBois wrote: That is, you're making an assumption that cannot necessarily be made. If you can guarantee that the web script will establish a new connection, and the connection will terminate when the script ends, you can indeed do what you describe

RE: Perplexed by reverse SELECT statement.

Hi Rich, I think that instead of a readBY column in your news table, you should use what's called a lookup table. In this case, the lookup table would store the primary key from the news table and the primary key from the user table. Your table structure might look something like this: user

Re: Perplexed by reverse SELECT statement.

I'm sure you are aware that this is a non-normalized database design, and that those tend to make designing queries more difficult and/or inefficient. The LIKE operator should give you what you want, but you need to be careful: (PHP string def:) $sSQL = SELECT list FROM table WHERE readBy LIKE

RE: Perplexed by reverse SELECT statement.

Thanks to Beau and Tore for insightful feedback. I will most likely implement the lookup table logic and do things right from the start rather than using a band-aid solution. Rich -Original Message- From: Beau Hartshorne [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 9:56 PM To:

Count (*) function results needed in echo statement

I've got the following code in my php file: /* Select all categories from designcatagories table */ $query = SELECT designcatagories.catcode, designcatagories.catdesc, count(*) FROM designs,designcatagories where designs.catcode = designcatagories.catcode GROUP BY

RE: Count (*) function results needed in echo statement

-Original Message- From: Stitchin' [mailto:[EMAIL PROTECTED] Subject: Count (*) function results needed in echo statement I've got the following code in my php file: /* Select all categories from designcatagories table */ $query = SELECT designcatagories.catcode,

Reshuffling unique integers

I have a table in which the first column represents the order in which the data in the rows will appear in an HTML table on a Web page. The column is called ordr (to avoid conflict with the reserved keword order). This column is a primary key, but the values are not auto-incremented, they are

4.0.9 grant replication slave ... fails.

I'm using 4.0.9 and I can not grant replication slave. [EMAIL PROTECTED] root]# rpm -qf /usr/bin/mysql MySQL-client-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysql mysqld mysqld-max [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld-max MySQL-Max-4.0.9-0 [EMAIL PROTECTED] root]# rpm

Re: Perplexed by reverse SELECT statement.

Tore Bostrup wrote: I'm sure you are aware that this is a non-normalized database design, and that those tend to make designing queries more difficult and/or inefficient. The LIKE operator should give you what you want, but you need to be careful: (PHP string def:) $sSQL = SELECT list FROM

Peculiar Problem During Transactions

Placed At : MAATDLN Hi, I have a database with a table that has 3 columns - name, age and status and this table has 10 rows. This table is an Innodb table with dyname table type (incase this is important) and so I can conduct transactions

Load Balanced Mysql Cluster

I have a database heavy site that utilizes a master mysql server which processes all updates and replicates to 4 slave servers that handle the queries. Right now I have a simple perl randomized selection that determines which of the four database slaves will receive any given query. This

What's up with this query?

Hi all. Hi spam filter. SQL. Query. I'm trying to append data to a table ( Powertel_CCD_LineList ) if it doesn't already exist in the table: insert into Powertel_CCD_LineList ( AccountNo, ServiceNumber, ServiceNumberDescription ) select Powertel_CCD_CallDetails.AccountNo,

Re: 4.0.9 grant replication slave ... fails.

OK. I solved it. In a last ditch effort I tried the /usr/bin/mysql_fix_privilege_tables script. That fixed it up. Replication seems to be working fine. Cheers. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web Start:

Re: Reshuffling unique integers

Allow negative values in the column (but don't use them). When modifying the values, give them their correct numeric value but make them negative. Then update the negative values to positive. HTH, Tore. - Original Message - From: Amittai Aviram [EMAIL PROTECTED] To: Mysql [EMAIL

Re: What's up with this query?

Daniel Kasak wrote: Hi all. Hi spam filter. SQL. Query. I'm trying to append data to a table ( Powertel_CCD_LineList ) if it doesn't already exist in the table: insert into Powertel_CCD_LineList ( AccountNo, ServiceNumber, ServiceNumberDescription ) select Powertel_CCD_CallDetails.AccountNo,

Èô¸Éº«¹úÉÌÆ·ÔÚÏßÏúÊÛ¼°Åú·¢

mysql! http://www.site-homepage.net () ---() --() ()---() (350)--- --- 024-86387876 QQ:156387988 Email:[EMAIL PROTECTED] Sendmail by SITE-MailTrain - Before posting, please check:

Re: Count (*) function results needed in echo statement

At 23:08 -0500 3/4/03, Stitchin' wrote: I've got the following code in my php file: /* Select all categories from designcatagories table */ $query = SELECT designcatagories.catcode, designcatagories.catdesc, count(*) FROM designs,designcatagories where designs.catcode =

Èô¸Éº«¹úÉÌÆ·ÔÚÏßÏúÊÛ¼°Åú·¢

mysql! http://www.site-homepage.net () ---() --() ()---() (350)--- --- 024-86387876 QQ:156387988 Email:[EMAIL PROTECTED] Sendmail by SITE-MailTrain - Before posting, please check:

Replication from DB2 to Mysql

hi everyone, well this question has been asked before but was long time ago. Since i could not locate an answer i am posting this question once again. I want to replicate my database which exists on DB2 to my MySQL machine across the network I am using db2 version 7and mysql version 4.0.2 Thanks

Re: OS X codewarrior libraries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 28 Feb 2003, ben nevile wrote: hi, MySQL community. I am hoping to use the C API in Mac OS X using codewarrior, but it looks like the libraries provided in the standard MySQL distribution are not compatible. I've done a brief search

undef_short

I download the mysql++, but I found out that in the mysql++, there is an include undef_short which I can't find it in the package. Anyone has ideas of where I can find this undef_short. I use rpm for redhat and untar src files. No such file exists.