Fw: Swapping around values in a database
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 3,PASSWORD,10 How do I get 2 and 3 to change over, so the data becomes. 1,TEXT,20 2,PASSWORD,10 3,TEXT,30 Thanks in advance, Steve. (Some background if interested... The data in the table goes into making up a page with a lot of INPUT's on, the user needs to be able to change the order in which these elements appear on the page... I want arrows on the page that the user can click on to move elements up or down the page... These changes would be saved back into the page table and re-used the next time the page is looked at). I've simplified the above example table. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Null values set in tables
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 set up as NOT NULL I have an ODBC trace file but it seems quite large to post to the list MySQL will store default value instead of NULL and it's a known behaviour: http://www.mysql.com/doc/en/Design_Limitations.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqld-nt vs mysqld-max-nt
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: http://www.mysql.com/doc/en/mysqld-max.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Replication error
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 PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Look in the error logs. What versions of master and slave do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JOIN on same table
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_idnameroot_project_group_id node_depth inherit 10 0 ProjectA0 0 0 57 10 SubProjectA 10 1 1 59 57 SubProjectB 10 2 0 60 59 SubProjectC 10 3 1 63 59 SubProject_110 3 1 62 60 SubProjectD 10 4 1 64 63 SubProject_210 4 1 This would look somehting like this in a treeview: ProjectA (10) - node_depth = 0 (root) \ SubProjectA (57)- node_depth = 1 \ SubProjectB (59)- node_depth = 2 / \ SubProject_1 (63) SubProjectC (60) - node_depth = 3 /\ SubProject_1 (64) SubProjectD (62)- node_depth = 4 But if running your query against the database I get the following output: project_group_idref_project_group_idnameroot_project_group_id node_depth inherit 10 0 ProjectA0 0 0 57 10 SubProjectA 10 1 1 62 60 SubProjectD 10 4 1 64 63 SubProject_210 4 1 What could be wrong? Best Regards Jakob Vedel Adeltoft, CTO [EMAIL PROTECTED] WebProof - www.webproof.dk Tel +45 46 32 68 68 Fax +45 46 35 94 94 -Original Message- From: Uttam [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 7:57 AM To: Jakob Vedel Adeltoft; [EMAIL PROTECTED] Subject: RE: JOIN on same table try this: SELECT PG1.* FROM project_group_list AS PG1 LEFT JOIN project_group_list AS PG2 ON PG1.ref_project_group_id = PG2.project_group_id WHERE (PG1.root_project_group_id=10 AND PG1.inherit=1 AND PG2.inherit=1) OR (PG1.project_group_id=10) OR (PG1.ref_project_group_id=10) ORDER BY PG1.node_depth regards, -Original Message- From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 16:30 To: [EMAIL PROTECTED] Subject: JOIN on same table Hi there, I have this table: project_group_id ref_project_group_idname root_project_group_id node_depth inherit 100 ProjectA0 0 0 5710 SubProjectA 10 1 1 5957 SubProjectB 10 2 1 6059 SubProjectC 10 3 0 6260 SubProjectD 10 4 1 project_group_id (int) = primary key. ref_project_group_id (int) = parent project (if root, then 0) name (char) = name of project root_project_group_id (int) = project_group_id for root project (if root, then 0) node_depth (int) = how far down in the tree this child is (if root, then 0) inherit (int) = determines if this project inherit information from parent (no=0, yes=1) This would look somehting like this in a treeview: ProjectA (10) - node_depth = 0 (root) \ SubProjectA (57)- node_depth = 1 \ SubProjectB (59)- node_depth = 2 \ SubProjectC (60)- node_depth = 3 \ SubProjectD (62)- node_depth = 4 I now wan't all child records (inclusive root) for ProjectA that inherit information. This means that I only wan't records with project_group_id = 10, 57, 59, because 60 is NOT inheriting and it's child project (62) is then not able to inherit. I've made the follwoing query: SELECT
re: MySQLGUI links are broken
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, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking for a bona fide distributed database that is open source
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 now?To wait until some *automation* will be implemented ? Anyhow this discussion risk to be already off topic for MySQL mailing list. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Bruce Feist [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 3:26 AM Subject: Re: Looking for a bona fide distributed database that is open source Gelu Gogancea wrote: It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have implemented facilities for this. Distributed database can be achieved,like example, using DISTRIBUTED OBJECTS(let's say CORBA).In my understanding that means that MySQL already can be used like distributed database. Can be used like is not the same as is. Similarly, by writing software in C, you can achieve SQL and use OS files like a relational database -- that doesn't mean that flat files *are* a relational database. Finally,What i wish to say is that distributed databases depend on us to be achieved and not by the RDBMS. Yes, it can be done manually... but there are many advantages to having Is not invented yet the tools/technologies which can design the distributed capabilities built into the RDBMS itself. I've used such systems (Computer Associates' OpenIngres product), and when distributed capabilities are needed it's far superior to use a product designed for it. Some examples of the improvements are: 1) Distributed optimizer automatically takes advantage of changes to distribution structure 2) Applications can be written which are independant of distribution structure 3) Complexity of applications is reduced, resulting in lower development costs and fewer bugs 4) Transaction management spanning databases on multiple computers Paul have right and i read very carefully him message:He said (very explicit and without any doubt)that MySQL can not manage multiple tables which are hosted on different servers with one single query.For me this is not a reason to not use MySQL for distributed database system. It's one factor, though. If we relax the definition of a distributed database system to be a client-server RDBMS which can be used to build an application which can combine information from queries to multiple databases on multiple computers, as it seems you wish to do, then yes, MySQL qualifies, and has its usual advantages of low cost, open source, and speed. Depending on the project's needs, these may or may not be enough to counterbalance built-in distribution capabilities of true distributed RDBMSs. If i remember well, on the MySQL website is a link to a german company which has develop a modules which treat multiple MySQL database(hosted on different machine of course) to a logical one. If so, then using it in conjunction with MySQL would indeed create a distributed database management system. Bruce Feist - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: comment with foreign key text causes innodb CREATE TABLE failure
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 - From: Brandon Bird [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, March 15, 2003 12:36 AM Subject: comment with foreign key text causes innodb CREATE TABLE failure From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: comment with foreign key text causes innodb CREATE TABLE failure Description:=09 If an innodb table is created with a comment with the words foreign key, the table creation fails.=20 The syntax used to work with MySQL-4.0.4-beta-win and earlier, running on both Linux and Windows. This query (missing the comment) executes successfully: CREATE TABLE a(a INT) TYPE=3Dinnodb; I consider this bug pretty important since many of our existing scripts use this style of comments. How-To-Repeat:=09 Execute this query: CREATE TABLE a(a INT /* foreign key */) TYPE=3Dinnodb; =20 You'll get this output: ERROR 1005: Can't create table '.\a\a.frm' (errno: 150)=09 Fix:=09 Change the /* foreign key */ comment in all database scripts. foreign-key works. Synopsis: comment with foreign key text causes innodb table creation failure Submitter-Id:=09 Originator: Brandon Bird Organization: Pacer/CATS MySQL support: none Severity: serious Priority:=09 Category: mysqld Class: sw-bug Release: mysql-4.0.11 Exectutable: mysqld-max-nt=20 Environment: dell 4400; ntfs System:WinXP Compiler: =20 Architecture: i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JOIN on same table
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 still able to inherit from the parent that breaks the node - but then they only inherit information from this parent and not from the root. Best Regards Jakob Vedel Adeltoft, CTO [EMAIL PROTECTED] WebProof - www.webproof.dk Tel +45 46 32 68 68 Fax +45 46 35 94 94 -Original Message- From: Uttam [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 12:59 PM To: Jakob Vedel Adeltoft Subject: RE: JOIN on same table you want only following records, i.e. excluding all childs of SubProjectB because SubProjectB is not inheriting? project_group_id ref_project_group_idname root_project_group_id node_depth inherit 100 ProjectA 0 0 0 5710 SubProjectA 101 1 -Original Message- From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 15:28 To: Uttam; [EMAIL PROTECTED] Subject: RE: JOIN on same table 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_id ref_project_group_idname root_project_group_id node_depth inherit 100 ProjectA 0 0 0 5710 SubProjectA 101 1 5957 SubProjectB 102 0 6059 SubProjectC 103 1 6359 SubProject_1 103 1 6260 SubProjectD 104 1 6463 SubProject_2 104 1 This would look somehting like this in a treeview: ProjectA (10) - node_depth = 0 (root) \ SubProjectA (57) - node_depth = 1 \ SubProjectB (59) - node_depth = 2 / \ SubProject_1 (63) SubProjectC (60) - node_depth = 3 /\ SubProject_1 (64) SubProjectD (62) - node_depth = 4 But if running your query against the database I get the following output: project_group_id ref_project_group_idname root_project_group_id node_depth inherit 100 ProjectA 0 0 0 5710 SubProjectA 101 1 6260 SubProjectD 104 1 6463 SubProject_2 104 1 What could be wrong? Best Regards Jakob Vedel Adeltoft, CTO [EMAIL PROTECTED] WebProof - www.webproof.dk Tel +45 46 32 68 68 Fax +45 46 35 94 94 -Original Message- From: Uttam [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 7:57 AM To: Jakob Vedel Adeltoft; [EMAIL PROTECTED] Subject: RE: JOIN on same table try this: SELECT PG1.* FROM project_group_list AS PG1 LEFT JOIN project_group_list AS PG2 ON PG1.ref_project_group_id = PG2.project_group_id WHERE (PG1.root_project_group_id=10 AND PG1.inherit=1 AND PG2.inherit=1) OR (PG1.project_group_id=10) OR (PG1.ref_project_group_id=10) ORDER BY PG1.node_depth regards, -Original Message- From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 16:30 To: [EMAIL PROTECTED] Subject: JOIN on same table Hi there, I have this table: project_group_idref_project_group_idname root_project_group_id node_depth inherit 10 0 ProjectA0 0 0 57 10 SubProjectA 10 1 1 59 57 SubProjectB 10 2 1 60 59 SubProjectC 10 3 0 62 60 SubProjectD 10 4 1 project_group_id (int) = primary key. ref_project_group_id (int) = parent project (if root, then 0) name (char) = name of project root_project_group_id (int) = project_group_id for root project (if
RE: Updat not Updating
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 being executed, because often the problem will lie in the variable you're inserting. Brian McCain 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', CityID='$CityID', CTelephone='$CTelephone', Cfax='$Cfax', Cemail='$Cemail', Caddress='$Caddress', Cfax='$CTown', Cwww='$Cwww', WHERE ItemID='$ItemID'); $result = mysql_query($query, $connection) or die(Error with query: .mysql_error().); Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Subscription Required
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updat not Updating
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', CityID='$CityID', CTelephone='$CTelephone', Cfax='$Cfax', Cemail='$Cemail', Caddress='$Caddress', Cfax='$CTown', Cwww='$Cwww', WHERE ItemID='$ItemID'); $result = mysql_query($query, $connection) or die(Error with query: .mysql_error().); 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;; echo(\n\n$querystring\n\n); mysql_query($querystring); will output.. select * from mytable; You can check the syntax of the command this way. S. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie - How can I insert new data with the current date/time?
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, PRIMARY KEY (id) ); I want to do a simple insert into the table with the current date and time, i.e. the system date. I'm having some problems finding the correct sql syntax to do this. Could anyone help with this? Do I need a Now() function? insert into animals the rest of the query??; Thanks! Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD + MySQL bottleneck
- 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 example, that using UFS file systems, are very slow compared to newer file systems. Yes. I am using UFS + softupdates. I wasn't aware that I could run ext3 on FreeBSD. However, I suppose, they have the trade off that they're perhaps safer in the event of a system crash. But the disk I/O is much much heavier on a UFS file system, than on some of the newer systems, like ext3 file systems. UFS seems to insist on doing writes as soon as possible, to prevent accidental loss of information due to a crash (just my guess, based upon the experience). I tried to speed up a very slow PostgreSQL database on UFS once.. I turned off fsync(2) for the database, and that helped some, but the disk I/O was still enormously extensive for what was going on. The same database under Linux flies (ext3) (with significantly less disk I/O activity). I was glad to see the MySQL supports the InnoDB in a partition (raw disk space). This can eliminate the file system from the equation, assuming that the necessary caching occurs in either the block device or in the database engine (using a raw char device). -- Warren W. Gay VE3WWG http://home.cogeco.ca/~ve3wwg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Query Question
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 | tbl_peoples_interests | id | interest_id | person | -- | 1| 500 | 1 | | 2| 504 | 1 | So... basically what I am trying to do is find the person and join them with their interests, but I need to get ALL their interests and I need to be able to access the values of each interest separately. Here is what I have, but both SELECT DISTINCT p.fname AS firstname, p.lname AS lastname, int_1.interest_id AS int_a, int_2.interest_id AS int_b FROM tbl_personnel AS p, tbl_peoples_interests AS int_1, tbl_peoples_interests AS int_2 WHERE int_1.person = p.id AND int_2.person = p.id AND p.id = 1 what I get back has 500 for both int_a and int_b Thanks Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Query Question
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 SELECT fname, lname, interest_id FROM tbl_people, tbl_peoples_interests WHERE tbl_people.id = tbl_peoples_interests.person If you have another interests table, it may be more like SELECT fname, lname, interest FROM tbl_people, tbl_peoples_interests, tbl_interests WHERE tbl_people.id = tbl_peoples_interests.person AND tbl_people_interests.interests.id = interests.id -jeff On Sat, 2003-03-15 at 09:23, Charles Kline wrote: 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 | tbl_peoples_interests | id | interest_id | person | -- | 1| 500 | 1 | | 2| 504 | 1 | So... basically what I am trying to do is find the person and join them with their interests, but I need to get ALL their interests and I need to be able to access the values of each interest separately. Here is what I have, but both SELECT DISTINCT p.fname AS firstname, p.lname AS lastname, int_1.interest_id AS int_a, int_2.interest_id AS int_b FROM tbl_personnel AS p, tbl_peoples_interests AS int_1, tbl_peoples_interests AS int_2 WHERE int_1.person = p.id AND int_2.person = p.id AND p.id = 1 what I get back has 500 for both int_a and int_b Thanks Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie - How can I insert new data with the current date/time?
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 AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY (id) ); I want to do a simple insert into the table with the current date and time, i.e. the system date. I'm having some problems finding the correct sql syntax to do this. Could anyone help with this? Do I need a Now() function? That's exactly right. insert into animals the rest of the query??; INSERT INTO bug_master (id,name,date) VALUES(id_val,name_val,NOW()); Thanks! Kevin -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Query Question
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 Kilpatrick wrote: 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 SELECT fname, lname, interest_id FROM tbl_people, tbl_peoples_interests WHERE tbl_people.id = tbl_peoples_interests.person If you have another interests table, it may be more like SELECT fname, lname, interest FROM tbl_people, tbl_peoples_interests, tbl_interests WHERE tbl_people.id = tbl_peoples_interests.person AND tbl_people_interests.interests.id = interests.id -jeff On Sat, 2003-03-15 at 09:23, Charles Kline wrote: 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 | tbl_peoples_interests | id | interest_id | person | -- | 1| 500 | 1 | | 2| 504 | 1 | So... basically what I am trying to do is find the person and join them with their interests, but I need to get ALL their interests and I need to be able to access the values of each interest separately. Here is what I have, but both SELECT DISTINCT p.fname AS firstname, p.lname AS lastname, int_1.interest_id AS int_a, int_2.interest_id AS int_b FROM tbl_personnel AS p, tbl_peoples_interests AS int_1, tbl_peoples_interests AS int_2 WHERE int_1.person = p.id AND int_2.person = p.id AND p.id = 1 what I get back has 500 for both int_a and int_b Thanks Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Query Question
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 a static query that can do that. I think you'll need to compensate in the PHP script. If you don't get any better responses or don't want to wait, email me off the list and we'll do some php hacking; now would be a good time. Thanks, -jeff On Sat, 2003-03-15 at 10:44, Charles Kline wrote: 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 Kilpatrick wrote: 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 SELECT fname, lname, interest_id FROM tbl_people, tbl_peoples_interests WHERE tbl_people.id = tbl_peoples_interests.person If you have another interests table, it may be more like SELECT fname, lname, interest FROM tbl_people, tbl_peoples_interests, tbl_interests WHERE tbl_people.id = tbl_peoples_interests.person AND tbl_people_interests.interests.id = interests.id -jeff On Sat, 2003-03-15 at 09:23, Charles Kline wrote: 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 | tbl_peoples_interests | id | interest_id | person | -- | 1| 500 | 1 | | 2| 504 | 1 | So... basically what I am trying to do is find the person and join them with their interests, but I need to get ALL their interests and I need to be able to access the values of each interest separately. Here is what I have, but both SELECT DISTINCT p.fname AS firstname, p.lname AS lastname, int_1.interest_id AS int_a, int_2.interest_id AS int_b FROM tbl_personnel AS p, tbl_peoples_interests AS int_1, tbl_peoples_interests AS int_2 WHERE int_1.person = p.id AND int_2.person = p.id AND p.id = 1 what I get back has 500 for both int_a and int_b Thanks Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forcing mysql client to use TCP socket?
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 get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' localhost is a special hostname to mysql: it tells it to use the local Unix socket. To talk to a local mysqld server through TCP, use 127.0.0.1, or any other IP address configured on the machine. It'll be a bit slower than using a Unix socket, though. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)
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 SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH) or MYSQL_ERRMSG_SIZE (200). This has been observed to lead to memory corruption when the client e.g. tries to redefine a key with a name whose length is of order 200 (yes, that _is_ a realistic use case for computer-handled keys). Nope. Fails for me. Error message gets truncated, no overflow. OK, let me give a bit more information. I am using MySQL through a server (the Globus RLS, if you care about that), which does all the SQL statements. I did some stress testing of that server, trying to break it, e.g. by supplying ridiculously long names for keys, which caused it to corrupt its own memory and/or crash. Debugging that, I ultimately came to the MySQL client code that it uses, and found that it _evidently_ does not check for overflows in error messages. In the debugger I clearly saw the code scribbling beyond the end of an error message buffer, overwriting adjacent fields in some struct. I then patched various routines dealing with error messages (also in MyODBC) and my problem went away. I got truncated error messages too, but _after_ they had overflowed... Furthermore, whenever such overflow happens, the damage depends on the layout of the data segment or stack, so your program may survive, or _seem_ to survive, having corrupted its own memory. Please download the diffs and have a look at them: http://litmaath.home.cern.ch/litmaath/MyODBC-MySQL-patches/mysql-4.0.10-gamma-ml-diffs.tgz Ok, I took a look at this. (btw, this was not a diff at all, but rather tarball of new and old files. Having a real unified diff would make your changes MUCH easier to understand). Though your changes looked innocent - that is they most probably could do no harm - I failed to understand when they'll do any good. You replaced a set of checks for buffer overflow by some other set of checks, which looked equivalent to the old one. Please, show at least one single test case where old code gets buffer overflow. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connect via Internet
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 you'd be nuts to put it on the internet. Versions 4.x and above support SSL. You'd have to check the mysql site for the specifics. Even with SSL support I'd be wary of putting a db server on the internet. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Jon Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 11:12 AM To: MySQL List Subject: re:Connect via Internet 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 getting a 'cannot connect to server on 'domain'' error. Also I want to have a logfile setup to log this type of problem. I see nothing in the /var/log/messages or /var/log/mysql.log. In /etc/my.cnf I have the following: [mysqld] datadir =3D /var/lib/mysql socket =3D /var/lib/mysql/mysql.sock [mysql.server] user =3D mysql basedir =3D /var/lib [safe_mysqld] err-log =3D /var/log/mysqld.log log =3D /var/log/mysqlquery.log pid-file =3D /var/run/mysqld/mysqld.pid Will changing the line that contains the myql.sock to tcp help? Any suggestions? Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD + MySQL bottleneck
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. Yes. I am using UFS + softupdates. I wasn't aware that I could run ext3 on FreeBSD. You can't. UFS should be just as fast as ext3 as far as mysql is concerned. Softupdates doesn't help you here because you're not creating or deleting many files. -- Dan Nelson [EMAIL PROTECTED] sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL
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. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re:Connect via Internet
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 getting a 'cannot connect to server on 'domain'' error. Also I want to have a logfile setup to log this type of problem. I see nothing in the /var/log/messages or /var/log/mysql.log. In /etc/my.cnf I have the following: [mysqld] datadir =3D /var/lib/mysql socket =3D /var/lib/mysql/mysql.sock [mysql.server] user =3D mysql basedir =3D /var/lib [safe_mysqld] err-log =3D /var/log/mysqld.log log =3D /var/log/mysqlquery.log pid-file =3D /var/run/mysqld/mysqld.pid Will changing the line that contains the myql.sock to tcp help? Any suggestions? Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile from source
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 good idea. I was wondering, if infact this is recommended. We are on a RH/Linux 6.2 We compile with the 2.91 gcc with no problems, with the last two sources we compiled. We use the following configuration when we compile: CCFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/var/lib --with-berkeley-db --without-docs --without-bench \ --without-readline --enable-assembler --with-mysqld-ldflags=-all-static \ --with-mysqld-user=mysql --with-low-memory --with-tcp-port=3306 \ --with-unix-socket=/tmp/mysql.sock --localstatedir=/var/lib/mysql appreciate any input on using the --enable-thread-safe-client or if it's really needed in our case. TIA ;) sql mysql database -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Warning: mysql_select_db() [function.mysql-select-db]: Can'tconnect to local MySQL
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() [function.mysql-select-db]: Can't connect to local MySQL 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. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compile from source
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 --enable-thread-safe-client when compiling was a good idea. I was wondering, if infact this is recommended. Depends. Are you going to be writing multi-threaded client programs? If not, you don't need it. When you were told that using this option was a good idea, what reason were you given for using it? We are on a RH/Linux 6.2 We compile with the 2.91 gcc with no problems, with the last two sources we compiled. We use the following configuration when we compile: CCFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/var/lib --with-berkeley-db --without-docs --without-bench \ --without-readline --enable-assembler --with-mysqld-ldflags=-all-static \ --with-mysqld-user=mysql --with-low-memory --with-tcp-port=3306 \ --with-unix-socket=/tmp/mysql.sock --localstatedir=/var/lib/mysql appreciate any input on using the --enable-thread-safe-client or if it's really needed in our case. TIA ;) -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
access-myodbc-interruption_mode?
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 to stop the execution of the code? - german-original: dieser vorgang wird den aktuellen code in den unterbrechungsmodus zuruecksetzen. moechten sie die ausfuehrung des codes anhalten? i have to kill ms-access with the task-manager! after 24 minutes, no problems. my preferred solution would be: $killall -9 access.exe #rpm -e ms-office #rpm -e windows is this a known problem with myodbc? access? how can i prevent this? -- shrek-m - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
suggestion to max_connection
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 connection count, which is limited under max_connection imagine that so many connection idling, and no more connection can be taken so, my idea is to add setting like this: max_connection(idle+running): 400 max_connection_running(not idle): 50 i wonder if possible to make mysqld hold a connection without start a child process _ MSN Messenger: http://messenger.msn.com/cn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking for a bona fide distributed database that is open source
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 the features that I described. An example is CA-OpenIngres. They are good for building distributed databases because they allow the implementer to work at a higher and more appropriate level, concentrating on the distribution appropriate instead of the mechanism for implementing distribution, and because they let the application developer ignore the fact that the database happens to be distributed. I made no claim that these other tools think or design; they simply have extra functionality which implements distribution -- which is what the original poster was asking about. A human being still must figure out what the most effective distribution strategy is. MySQL is a fine RDBMS; it simply does not implement distribution in its engine. By claiming that it does, you do a disservice to other RDBMSs which *do*, and to people looking for such a solution. Bruce Feist - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updat not Updating
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;; echo(\n\n$querystring\n\n); mysql_query($querystring); will output.. select * from mytable; You can check the syntax of the command this way. Yep. My code is littered with: // echo $qry;exit; -- and -- echo !-- $qry --; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Init. Config Error 1045
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 plain user name. Can anyone help? Thanks. Jay Cox --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/03 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fw: Swapping around values in a database
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 has this data in. 1,TEXT,20 2,TEXT,30 3,PASSWORD,10 How do I get 2 and 3 to change over, so the data becomes. 1,TEXT,20 2,PASSWORD,10 3,TEXT,30 Thanks in advance, Steve. Untested: UPDATE page SET pgposition=IF(pgposition=3, 2, 3) WHERE pgposition IN (2,3); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
