php pages not inserting data into table

i'am not sure if this is related to suse 9.1 or what i'am beginning with mysql and php i'am running: mysql 4.0.21-standard suse9.1 kernel version 2.6.5-7.10b-default php version 4.3.4 - default install apache 2.0.49 - prefork i created an "address book" using php and when i go thru and fill in

Re: Using Visio to diagram MySQL db, export SQL

Is there a version or a product available for LINUX? On Tue, 28 Sep 2004 13:55:19 -0500, Tim Hayes <[EMAIL PROTECTED]> wrote: > ari > > MYdbAL which you can download at www.it-map.com is completely FREE and > includes data modeling, DDL generation or whatever you need to create your > MYSQL data

Re: Indexing for OR clauses

At 06:03 PM 10/1/2004, you wrote: Wondering if anyone can give me advice on indexing for OR clauses. I have a table with a number of fields, two of which are sender_id and receiver_id. I also have a query such as this: SELECT ... WHERE (sender_id = 98765 OR reciever_id = 98765) The query is OK for

Indexing for OR clauses

Wondering if anyone can give me advice on indexing for OR clauses. I have a table with a number of fields, two of which are sender_id and receiver_id. I also have a query such as this: SELECT ... WHERE (sender_id = 98765 OR reciever_id = 98765) The query is OK for a limit of 10, but if I incre

Order rows before applying GOUP BY / DISTINCT

Hello. I'm having a problem where I seem to need to order a table before applying group by (or distinct?) in my query. Here is a simplified table structure example: ID USER HOST TIME ID = Primary Key I would like to do the following in ONE query, if possible: I am looking to retrieve the L

RE: GINA Development

> And here is my.ini > > > > [MYSQL-API] > > user='user' > > password='**' > > Server='chilton.***.edu' > > database='machine' > > > > > > the * are there for the purpose of this email only. Even though you put *** in the server address, I bet it's Server='chilton.BYU.edu'

GINA Development

I am working on a replacement GINA (Graphical Identification and Authentication) for the University I work for. It is a DLL written in C and I need to add mysql connectivity to it. I am writing this in Visual Studio 2003. It took me forever to get all the MySQL API's libs to link correctly bu

Re: (if !update then insert) sequence - result Duplicate key :(

Laercio Xisto Braga Cavalcanti wrote: When you use the replace command if the row does not exist it is inserted. MySQL Reference Manual: Section 14.1.6 REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record for a PRIMARY KEY or a UNIQUE index

RE: (if !update then insert) sequence - result Duplicate key :(

Hi, When you use the replace command if the row does not exist it is inserted. MySQL Reference Manual: Section 14.1.6 REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record for a PRIMARY KEY or a UNIQUE index, the old record is deleted be

Re: full text search question

GH schrieb: Laura did this work... inquiring minds want to know :) Laura: Perhaps the "-" is acting like a Boolean operator. What if you put double quotes around your search phrase: SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN BOOLEAN MODE ); Or.. the - is possibly suppose

Reg Backup

Thank you very much. One more question i.e Is there any command to take the Backup in MySQL 4.0 (windows) classic which does not support innodb. I know 2 commands like mysqldump and mysqlhotcopy. mysqlhotcopy seems to support myism but only in linux and netware os. But i need it in windows.

Re: matching people with projects via resources

It's not as elegant as I wanted I got it to work this way (I must be getting tired) create temporary table projects_need SELECT proj , count(rsrc) as rsrc_count FROM project group by proj; CREATE temporary table suppliers_match select p.proj , s.name , count(s.name) a

Re: full text search question

Laura did this work... inquiring minds want to know :) On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele <[EMAIL PROTECTED]> wrote: > Laura: > > Perhaps the "-" is acting like a Boolean operator. What if you put > double quotes around your search phrase: > > SELECT * FROM metadata WHERE MATC

Re: memory utilization

We have an Opteron server with 6 gig of RAM. The issue used to be 4 gig - the max amount of memory a 32-bit processor could access. With 64-bit processors, the amount of accessible memory has jumped into the terrabyte range. Pick a distribution that is for the AMD-64 (we use SuSE 8 Enterprise)

Re: two-column indexes and joins with ranges

Thanks for the suggestion, but no luck. Here's the explain output for, in order, my original query, the 2-part query, and the explicit join (note, not quite like my first post, I had "cleaned up" my tables to simplify the situation): mysql> explain SELECT * FROM accounts, transactions WHERE canon_

RE: matching people with projects via resources

This may not be elegant, but why not define a 3rd table proj_c containing proj and project_rsrc. This assumes that when you define a project you know how many resources are required. CREATE TABLE proj_c ( proj varchar(11) default NULL, project_rsrc INT default 0); INSERT INTO proj_c VALU

Re: Sync db

It's safe to implement two-way replication (properly called multimaster replication) in MySQL if each master is guaranteed to only update a unique subset of that data (ie data that no other master database changes). Each master database would be able to safely read all the data, however. For e

CONVERT CHARACTER SET option work on TEXT fields?

Folks -- I'm using Client version:mysql Ver 14.6 Distrib 4.1.5-gamma, for pc-linux (i686) Server version: 4.1.5-gamma-standard-log They both happen to both be on the same system, which is RHEL AS 3. All defaults are now UTF8: Server characterset:utf8 Db characterset:u

Re: please help me!

At 11:15 AM 10/1/2004, you wrote: Content-Type: text/plain; charset="UTF-8" Content-Language: en Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on “INSTALL-BINARY” in “mysql

Re: Sync db

Two way replication is possible. However, it does not work like you think it would. It would not be safe to modify data on both databases at the same time. See the FAQ on replication: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html There is some information regarding two-way replication tha

memory utilization

Hi folks, I have to setup some high performance servers that will be used for MySQL databases and have a couple questions regarding MySQL running on Linux AMD-64 (Opteron). We are looking at setting up these machines with 16-64 gb of RAM, can MySQL running on Linux handle this amount of RAM effic

please help me!

Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on âINSTALL-BINARYâ in âmysql.docsâ 2. Got the message as âWindows cannot open this fiel: File: INSTALL-BINARYâ To open t

RE: **[SPAM]** RE: **[SPAM]** matching people with projects via resources

[snip] You haven't stated the resources required for the project in the query. Try this ... SELECT project.proj, project.rsrc, people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc WHERE project.rsrc = 'wood' AND project.rsrc = 'canvas' Not tested, but limits people to thos who h

Re: matching people with projects via resources

Hi Laszlo, This is sort of a butchery, and might be a little nicer with two queries and a temp table, but this works in mysql 4.1.3-beta (at least, it did for me). SELECT A.name, B.proj FROM people as A, project as B WHERE A.rsrc=B.rsrc GROUP BY A.name, B.proj HAVING COUNT(*)=(SELECT COUNT(*) FR

Re: Sync db

yeah, I seen that have. Have you tried that before? I need to do it two-way. But have not seen any special setup for that. Each site will be entering data and all sites will need to see the updated change. On Fri, 01 Oct 2004 10:38:07 -0400, Michael Stassen <[EMAIL PROTECTED]> wrote: > Have y

RE: **[SPAM]** matching people with projects via resources

[snip] I'm pretty sure this is a good starting point, but that's just matching resource to resource without excluding Lincoln from building an Ark (no canvas). mysql> SELECT project.proj,project.rsrc,people.name FROM project LEFT JOIN people ON project.rsrc=people.rsrc; +--+-+-

matching people with projects via resources

I'm having difficulty constructing a query. I've got two kinds of information: a table of resources that various people have, and a table of resources that various projects need. === CREATE TABLE `people` ( `name` varchar(11) default NULL, `

Re: Sync db

Have you considered replication ? Michael spiv007 wrote: I want to know what to best way to keep a 4 mysql servers sync. I have 4 remote locations, I am thinking about putting a mysql server in each location and every hour have the 1 db that I

Re: two-column indexes and joins with ranges

Well, you haven't posted the output of EXPLAIN, but I'll take a guess. I expect mysql sees your query as having a JOIN condition of accounts.account_id = transactions.account_id and two WHERE conditions: WHERE accounts.name = 'dave' AND when BETWEEN '2004-02-05' AND '2004-02-10' The optimiz

Re: the table is read only

Hi, I just encountered a similar problem on one of my production servers this morning. (I'm still investigating the cause.) After doing a quick bit of Google-searching, this solved my problem: mysqladmin -u -p flush-tables By the way: All directories in /var/lib/mysql should have 700 permiss

RE: views/cursors in mysql 4.0

Yes. Best of luck with your conversion! Shawn Green Database Administrator Unimin Corporation - Spruce Pine <[EMAIL PROTECTED]> wrote on 09/30/2004 05:25:22 PM: > > Hi, > > Thank you very much for your reply. So for the cursors result > set C API's will be suitable ..right?. > > thanks,

Re: compare schemas

Josh Howe wrote: Does anybody know of any free tools to compare two mysql schemas? Thanks. you still have the quick solution of : mysqldump --no-data db1 > db1.sql mysqldump --no-data db2 > db2.sql diff -u db1.sql db2.sql -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For

two-column indexes and joins with ranges

I have a performance/index usage problem, and I am hoping somebody can tell me why this problem exists, and whether there is a better solution than the workaround that I'm using now. The problem: I have a table with a two column index, such as CREATE TABLE transactions ( account_id INT NOT NULL