Fw: Swapping around values in a database

2003-03-15 Thread Mr Orange
Hello all : ) Can anyone offer any advice on how to achieve the following with SQL? Say I have a table. CREATE TABLE page ( pgposition int(6) not null, pgelement char(20) not null default '', pgsize int(4) not null default '0')); and it has this data in. 1,TEXT,20 2,TEXT,30

re: Re: Null values set in tables

2003-03-15 Thread Egor Egorov
On Thursday 13 March 2003 20:27, Steve Holt wrote: I am linking an MS Access front end to MYSQL on the back with ODBC If I open the table I can enter a value in the course name field only which is the primary key and it will save the record even though I have not entered values in the fields

re: mysqld-nt vs mysqld-max-nt

2003-03-15 Thread Victoria Reznichenko
On Thursday 13 March 2003 04:45, Dan Cumpian wrote: I've been running mysqld-nt on W2K and WinXP for awhile now (using MyISAM tables) and I'm a bit confused by what's in the max binary. Is the biggest difference InnoDB tables? Difference is described here:

re: Replication error

2003-03-15 Thread Egor Egorov
On Wednesday 12 March 2003 20:05, trashMan wrote: I've tried to setup a replication but ...i've several problem! I've follow the manual istruction http://www.mysql.com/doc/en/Replication_HOWTO.html But the slave don't start the replica. SHOW SLAVE STATUS on SLAVE return SLAVE:running SHOW

RE: JOIN on same table

2003-03-15 Thread Jakob Vedel Adeltoft
Uttam: Your're great! But there's still one thing I haven't mentioned (my fault)... If I add more childs to the same node_depth and sets SubProjectB NOT to inherit, then the query fails... I now have these records: project_group_idref_project_group_idname

re: MySQLGUI links are broken

2003-03-15 Thread Egor Egorov
On Tuesday 11 March 2003 14:26, jarausch at igpm dot rwth-aachen dot de wrote: it seems as if all links on http://www.mysql.com/Downloads/mysqlgui/ are broken. Link for downloading MySQLGUI is http://www.mysql.com/downloads/gui-mysqlgui.html -- For technical support contracts,

Re: Looking for a bona fide distributed database that is open source

2003-03-15 Thread Gelu Gogancea
Hi, You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet invented the tools which should THINK instead of our BRAIN when must design a system...any kind of.I hope you feel the difference.For example,a new concept of databases is : the neural database system.What you will do

Re: comment with foreign key text causes innodb CREATE TABLE failure

2003-03-15 Thread Heikki Tuuri
Brandon, thank you for the bug report. I will try to fix this in 4.0.xx. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Original Message -

RE: JOIN on same table

2003-03-15 Thread Jakob Vedel Adeltoft
Yup! Maybe I haven't explained me correct, but yes, that's what I wan't. This is because as soon as a project is NOT inheriting, then all of it's childs are then also not able to inherit from the original root, because the project that's NOT inheriting breaks the node... But the childs are

RE: Updat not Updating

2003-03-15 Thread Andrew
can you explain how I would do this tracking? Andrew Subject: Re: Updat not Updating If this is really exactly what your code looks like, you've got an extraneous comma after the Cwww line. But when you're tracking down a bug like this, you may find it helpful to output the exact query that is

Subscription Required

2003-03-15 Thread Amit Prakash
Dear sir/Madam I am a mysql developer and want to keep myself updating the events with MySQL. Thanking You Regards Amit Prakash Software Engineer Savitr Software Services (P) Ltd. Hyderabad - Before posting, please check:

Re: Updat not Updating

2003-03-15 Thread Sime
Andrew wrote: can you explain how I would do this tracking? My code looks exactly like this: mysql_connect($DBHost,$DBUser,$DBPass); mysql($DBName,UPDATE items SET ItemSKU='$ItemSKU', ItemName='$ItemName', ItemDescription='$ItemDescription', PostCode='$PostCode', Category='$Category',

Newbie - How can I insert new data with the current date/time?

2003-03-15 Thread KKolle
I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL,

Re: FreeBSD + MySQL bottleneck

2003-03-15 Thread Jesse Guardiani
- Original Message - From: Warren W. Gay VE3WWG [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 4:45 PM Subject: Re: FreeBSD + MySQL bottleneck snip The OP didn't indicate where the files are being kept, and under FreeBSD this can be significant. I know for

Newbie Query Question

2003-03-15 Thread Charles Kline
Hi all, My first post to this list. I have a query which I can't quite get to work. I was hoping that someone here could educate me a bit. I have two tables. tbl_people | id| fname|lname| --- | 1 |frank |smith |

Re: Newbie Query Question

2003-03-15 Thread Jeff Kilpatrick
Charles- So, you have a table unique with respect to people (a person appears at most once), and a table with interests (some number of interests are associated a person in the first table. This is a one-to-many relationship. You need to join on the person in the first table. Something like

Re: Newbie - How can I insert new data with the current date/time?

2003-03-15 Thread Paul DuBois
At 8:37 -0600 3/15/03, [EMAIL PROTECTED] wrote: I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: Looks like it's called bug_master, not animals. :-) create table bug_master ( id MEDIUMINT NOT NULL

Re: Newbie Query Question

2003-03-15 Thread Charles Kline
Jeff, Thanks. This is ALMOST doing what I need. Suppose that the person could have from 0 - 5 records in tbl_peoples_interests and I need to have each one of those interests as a different name so I can use it in my PHP form? Thanks, Charles On Saturday, March 15, 2003, at 11:30 AM, Jeff

Re: Newbie Query Question

2003-03-15 Thread Jeff Kilpatrick
Charles- OK, let's say a person has `n' interest id entries in tbl_people_interests. It seems like you're wanting a result set with one row per person and (n + 2) (assuming you're selecting first and last name with the interests). I'm no UEbergeek with respect to SQL, but I don't think there's

Re: forcing mysql client to use TCP socket?

2003-03-15 Thread Murad Nayal
thank you all for the help! best Murad Dan Nelson wrote: In the last episode (Mar 14), Murad Nayal said: how can I force mysql interactive client (actually the client library as well) to use a TCP port on the local host if I do: mysql -h localhost -u user -p --port=2000 I

Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)

2003-03-15 Thread Sergei Golubchik
Hi! On Mar 14, Maarten LITMAATH wrote: Sergei Golubchik wrote: On Mar 12, Maarten LITMAATH wrote: Description: MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows when formatting error messages: the code just assumes that no message will ever be larger than

RE: Connect via Internet

2003-03-15 Thread Joe Stump
Just a simple point on security. The current stable versions of 3.23.x don't encrypt passwords or data. Thus you would be logging in unencrypted and sending all data unencrypted. If this is just a dev box and you don't care about the data then it probably isn't a big deal. If it's a production box

Re: FreeBSD + MySQL bottleneck

2003-03-15 Thread Dan Nelson
In the last episode (Mar 15), Jesse Guardiani said: From: Warren W. Gay VE3WWG [EMAIL PROTECTED] The OP didn't indicate where the files are being kept, and under FreeBSD this can be significant. I know for example, that using UFS file systems, are very slow compared to newer file systems.

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL

2003-03-15 Thread Jose
I get this error after upgrade my server aix 4.3.3.10 to 4.3.3.11: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock Any one can tell me what could be the problem ? Thanks.

re:Connect via Internet

2003-03-15 Thread Jon Miller
Okay, got the system up and running locally. The programmer wants to be able to access the MySQL server via the internet. We have MySQL installed on a Linux server, this sits behind a firewall with port 3306 opened. The programmer has phpMyAdmin installed on his laptop (Widows XP Pro). We keep

Compile from source

2003-03-15 Thread Mike Blezien
Hello all, we will be upgrading our current MySQL version 3.23.40 to 3.23.55, compiled from source. We've always had good luck on our machine compiling from the source as opposed to using binaries. my question is, I was told, that using the --enable-thread-safe-client when compiling was a

Re: Warning: mysql_select_db() [function.mysql-select-db]: Can'tconnect to local MySQL

2003-03-15 Thread Bhavin Vyas
It is probably looking for a socket file that doesn't exist. Check to see if it does. Also check to see if DB server is running. Bhavin. - Original Message - From: Jose [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 3:03 PM Subject: Warning: mysql_select_db()

Re: Compile from source

2003-03-15 Thread Paul DuBois
At 15:58 -0600 3/15/03, Mike Blezien wrote: Hello all, we will be upgrading our current MySQL version 3.23.40 to 3.23.55, compiled from source. We've always had good luck on our machine compiling from the source as opposed to using binaries. my question is, I was told, that using the

access-myodbc-interruption_mode?

2003-03-15 Thread [EMAIL PROTECTED]
hi, access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin) if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51 i cannot close ms-access: - free translation: this procedure will put the current code back into the interruption mode. would you like

suggestion to max_connection

2003-03-15 Thread xuefer tinys
often, mysql in web services, there're many situation make a mysql connection idle for example: after php open mysql_pconnect(), finished a request, http start keep-alive or service other pages/images which do not require mysql connection however, the connection is still there, counted as

Re: Looking for a bona fide distributed database that is open source

2003-03-15 Thread Bruce Feist
Gelu Gogancea wrote: You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet invented the tools which should THINK instead of our BRAIN when must design a system...any kind of. You are mistaken if you think that I am confused about this. There are RDBMS's out there that support

Re: Updat not Updating

2003-03-15 Thread Don Read
On 15-Mar-2003 Sime wrote: Andrew wrote: can you explain how I would do this tracking? snip Hi Andrew, Try building the query to a variable first, then output the variable to see if what MySQL is receiving is what you expected.. eg, $querystring=select * from mytable;;

Init. Config Error 1045

2003-03-15 Thread Jay Cox
I just recently installed MySQL and when I try and connect I get an error 1045, Access Denied for user. I am running 3.2.55-nt with local host via TCP/IP on W2000. I think it has something to do with the local host, because the error message returns my [EMAIL PROTECTED] rather than just the

RE: Fw: Swapping around values in a database

2003-03-15 Thread Don Read
On 15-Mar-2003 Mr Orange wrote: Hello all : ) Can anyone offer any advice on how to achieve the following with SQL? Say I have a table. CREATE TABLE page ( pgposition int(6) not null, pgelement char(20) not null default '', pgsize int(4) not null default '0')); and it