RE: loggin all calls made to mysql from php

Use --log option when starting mysqld_safe(or safe_mysqld) -- Chung Ha-nyung Sayclub NeoWiz > -Original Message- > From: Petre Agenbag [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 17, 2002 4:05 PM > To: [EMAIL PROTECTED] >

SHOW SLAVE HOSTS print master host also.

I set up two-way replication with two servers, A and B. Since all queries go to only one server, it seems not to matter. Anyway. When A starts it registers itself to B, and vice versa. I thought query "SHOW SLAVE HOSTS" to A should shows only about B and B should do about A, but both show the sa

loggin all calls made to mysql from php

HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mys

Re: select from multiple tables - solved

Thanks Joseph and Kelly. I think "merge tables" will be a good solution for me. Veysel Harun Sahin wrote: > Hello, > > I have a problem with select statetement. I need to query and select > records from multiple tables which have the same column types. I have > done this with left join but my

Re: a mysql question

Pada Thu, 17 Oct 2002 13:36:58 +0800 (CST) µÑ ¶Ì <[EMAIL PROTECTED]> menulis: > I'm a chinese software engineer, and I has use mysql > for three years ago.Now,I get a matter from it. > recently,I'm deal big data use mysql first.every > table's data is one million,so user search the data > will us

What is relay-bin log?

At the slave server of replication there are log files like environment hostname-relay-bin.xxx. For what these logs and how can I know which one I can delete safely? p.s. sql, query : used to bypass spam filter. :( -- Chung Ha-nyung Sayclub NeoWiz

RE: a mysql question

I think you need to give us the SQL you are using to do the search - we'll ba ble to see what your are trying to do better Alan > -Original Message- > From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 15:37 > To: [EMAIL PROTECTED] > Subject: a mysql question > > > I

Re: query question

Hope this will work for u select distinct substring(name, 1,1) from test1 order by name asc ; - Original Message - From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 2:40 PM Subject: query question > Hello, > > I have a table with a list of names

Re: a mysql question

Sorry, but it is hard to understand what you are actually asking, but I'll try. If you are returning too large resultset, it is possibly a JDBC driver problem, since it will retrieve all into Java objects, which could take "forever". If you know your SELECT statement, just issue it in the my

Re: query question

SELECT DISTINCT FROM ORDER BY ASC ; - Original Message - From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 2:40 PM Subject: query question > Hello, > > I have a table with a list of names. I need to get a distinct list of the > names by first

Re: query question

Hi, Try SELECT distinct substring(name, 1, 1) from names; That should work :) -Dan On Wed, 16 Oct 2002, Kevin wrote: > Hello, > > I have a table with a list of names. I need to get a distinct list of the > names by first letter, as follows: > > John > Mary > Mark > Tom > > the query shoul

a mysql question

I'm a chinese software engineer, and I has use mysql for three years ago.Now,I get a matter from it. recently,I'm deal big data use mysql first.every table's data is one million,so user search the data will use long time.now ,if some user search one table togeter,the table is dead , and I find the

query question

Hello, I have a table with a list of names. I need to get a distinct list of the names by first letter, as follows: John Mary Mark Tom the query should return the following: J M T Is there any way to this with a single query? TIA -Kevin [EMAIL PROTECTED] -

the highly recomended MySQL version

Hi Can anyone suggest me the highly recomended MySQL version(non vulnerable). Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

Re: update and data manipulation

On Thu, 17 Oct 2002 03:50:47 +0100, Nikolas Galanis used a few recycled electrons to form: | Hello | | When I want to update a value, I can use numerical functions like +,* | etc. Can I do the same with strings? For example, when I want to append | a string in an existing value, how (if of cou

Re: comparing tables -> continue

Thank you Peter, it does work, I have some question again if you don't mind. Let say i have similiar tables like before, but i will add another field for "pick". They will become like this : Table "Master" Table "Pick" m p q - --

Two queries, can I make it one?

Lo everyone, I have a bit of a dilemma. I use MySQL for all my authentication (user accounts etc, via ftp / mail / radius / http / etc), and currently am using PureFTPD as my FTPD to allow my clients to upload web sites. I use the following to authenticate users for their personal web space...

Re: comparing tables

Toni > i have a problem to compare data inside two tables. i have two tables let > say: "Master" and "Pick". For example the content of these two tables are: > > Table "Master" Table "Pick" > aa > bb > cc

comparing tables

dear all, i have a problem to compare data inside two tables. i have two tables let say: "Master" and "Pick". For example the content of these two tables are: Table "Master" Table "Pick" aa bb cc d

update and data manipulation

Hello When I want to update a value, I can use numerical functions like +,* etc. Can I do the same with strings? For example, when I want to append a string in an existing value, how (if of course) can I do it inside the update query? Thanks. Nikolas p.s: I know I can do it with PHP, I was j

How to do a conditional "drop function"

I am currently migrating a database from mssql to mysql. This mssql database has (sigh) many stored procedures in it. These stored procedures are automatically generated from a UML model. I am trying to change the UML model to generate C code so I can create user defined functions with the same

Re: Wierd login problem

On Thursday 17 October 2002 05:36, Bill Leath wrote: > I am trying to use mysql. > > I use the line > > mysql -u username -p > and then enter the correct password > > The error message I get is error 1045 access denied for user: > username@localhost (Using password: YES) > > I know that I am usin

Re: Normalization

Arthur Fuller wrote: >>Ooops! You just threw a new wrench into the works! "A video may have >>multiple titles." In this case you must distinguish the original from its >>presumably foreign-translations (or whatever). In other words, you might >>store the master as "La Cage aux Folles" and the En

Re: Problem with UPDATE table ... can u help plz?

You need to include the field names along with the table name. UPDATE table1 INNER JOIN Table1 ON Table2.FieldID = Table1.FieldID Set Table1.Field1=Table2.Field1, Table1.Field2=Table2.Field2, ... Bruce Lewis - Original Message - From: "Greg Knaddison" <[EMAIL PROTECTED]> To: <[EMAIL P

Re: Normalization sql

Ooops! You just threw a new wrench into the works! "A video may have multiple titles." In this case you must distinguish the original from its presumably foreign-translations (or whatever). In other words, you might store the master as "La Cage aux Folles" and the English subtitled version as some

MySql module won't load in Apache (DebianLinux)

Apache document root works fine, and php3 is fine also. I uncommented the lines in /etc/apache/httpd.conf LoadModule php3_module /usr/lib/apache/1.3/libphp3.so AddType application/x-httpd-php3 .php3 AddType application/x-httpd-php3-source .phps I added a webpage to document root, with the follow

RE: Problem with UPDATE table ... can u help plz?

When I try that modified for my tables that fit this hypothetical, I get: CREATE TABLE `sales_table` ( `item_s` varchar(100) default '', `price_s` varchar(100) default '' ) TYPE=MyISAM CREATE TABLE `lookup_table` ( `item_l` varchar(100) default '', `price_l` varchar(100) default '' ) TYP

Re: Problem with UPDATE table ... can u help plz?

You need an InnerJoin to perform the operation similar to: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... INNER JOIN Table1 ON Table2.ID = Table1.ID Bruce Lewis - Original Message - From: "STIBS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: We

Re: information

Florian Litot wrote: > > hi, > > Somebody saw comparaisons of productivity for mysql and others RDBMS? > or somebody do comparaisons? > > thanks > > - > Before posting, please check: >http://www.mysql.com/manual.php (th

Wierd login problem

I am trying to use mysql. I use the line mysql -u username -p and then enter the correct password The error message I get is error 1045 access denied for user: username@localhost (Using password: YES) I know that I am using the correct username and password, because an application using jdbc

RE: Query for multiple rows

I've tested this on a table of mine with different names, so it should work when you tweak your columns/table. The "having clause" is a seldom taught, but highly useful clause. select count(1), first_name, last_name from myuserstable group by first_name, last_name having count(1) > 1; You sho

RE: Query for multiple rows

Fibilt try: SELECT id, concat(lname, fname) as name, count(*) as cnt FROM table1 GROUP BY name HAVING cnt > 1; This is close anyhow. David > -Original Message- > From: Phillip S. Baker [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 1:17 PM > To: [EMAI

Re: MySQL-max-3.23.52-win

Dobrý den, quarta-feira, 16 de outubro de 2002, 17:33:00, napsal jste: S> I installed MySQL-max-3.23.52-win in the Win98 with the following S> configuration S> #This File was made using the WinMySQLAdmin 1.4 Tool S> #16/10/2002 14:37:55 S> #Uncomment or Add only the keys that you know how works

MySQL-max-3.23.52-win

I installed MySQL-max-3.23.52-win in the Win98 with the following configuration #This File was made using the WinMySQLAdmin 1.4 Tool #16/10/2002 14:37:55 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [WinMySQLadmin] Server=C:/MYSQL/bin/mysqld-m

RE: killing a hung thread

Inandjo Try setting the variable "connection_timeout" to 300 seconds. That way, the mysqld will close the connection automatically. Set the variable in file "my.cnf". David > -Original Message- > From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 9:54

Problem with UPDATE table ... can u help plz?

Hi from Dresden, Germany! I have a littlebig problem: I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this case a product number) is the same in both tables. OK, I did this: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... WHERE ta

Query for multiple rows

Greetings all, I have a users table in the DB. I am importing allot of existing data from various places into this users table. There is a strong likelihood of the same user getting entered twice. Though each record will have a separate and unique ID, I want to be able to query the table and lo

Re: How many columns does MySQL Support?

>From: "Andrew Kuebler" <[EMAIL PROTECTED]> > >2) Is it just as fast with Mysql to access 10 fields in a table with 10 >columns as it would be to access those same 10 fields among let's say 90 >other fields in a 100 column table? Are you certain that performance should be your primary concern her

Back Table syntax

hello.. i have a winxp and linux 7.2 on the same machine. I have mysql on the linux server and MyCC in the win partition. i connect to the linux MySQL using the vmware lopback adapter. everything is working fine. now when i issue a backup table syntax. it is giving syntax. Is back table only

multiple incremental inserts

Greetings, I need to be able to insert many rows into a table at once. Only one field, an incremental serial number will change for each row. Is there a way to do that in a single query? I need to be able to specify the start and end points (i.e. start at 59 and end at 605000) Or do I have

Help Migrating from NuSphere

Previously I had been a NuSphere subscriber for MySQL (and PHP and Apache). As you probably know, NuSphere no longer produces or supports the MySQL product. How do I migrate out of the NuSphere? I currently have: RH Linux 7.2 (kernel 2.4.9-34) MySQL 3.23.44-100.nusphere Location: /usr/local/

Oracle wrapper in MYSQL

Hi, I'd like to know if there is something similar to Oracle's Wrapper in MYSQL. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: load problems on mysql 3.23.52 with and without Max

I had the same problem with 4.0.4, I downgraded to 3.23.52 because I thought it was something with the unstable version. Is 4.0.4 also built against the same static glibc? regards /Lars >This problem is due to the glibc used by mysql AB for building binary ... > >Have a look to mysql 3.23.53 c

RE: about use Dev-cpp and C++

sql, query > But it would be so nice to write: > > MySQLConn DB = new MySQLConn ('host', 'port'); > DB.Login('user', 'pass'); > MySQLTransaction X = new MySQLQuery(DB); > > // STL-derived slist: > MySQLResults Results = X.Query("..."); > > // STL map: > map Row; > while (Results.NextRow(Row)) { >

RE: remote connections have stopped working

Moving from glibc 2.2.5-40 to glibc 2.2.5-39 has solved the problem i was having with remote connections, Thanks to everyone who helped. -Jon Keller At 06:18 AM 10/16/2002 -0500, you wrote: >I started to receive this error as well after upgrading the glibc update >just released from Red

Re: MySQl db as filesystem.

Jan Steinman wrote: >I believe the Pick operating system from the 70's had a database filesystem, for >example. It was popular among business types. As I recall, it also had a BASIC >command interpreter as its primary way of interacting with the system. > FWIW, we use Pick database systems quit

re: remote connections have stopped working

Mysql was installed from binary, and this is redhat 7.3 running kernel 2.4.18-3 At 02:16 PM 10/16/2002 +0300, you wrote: >Jon, >Wednesday, October 16, 2002, 8:04:12 AM, you wrote: > >JK> I'm running mysql-3.23.49 on a redhat machine, mysql has stopped >responding >JK> to remote connections

killing a hung thread

hi, i'd like to know if there is a way to tell the mysqld to remove a thread that has hang, without human intervention. Let say an update query is fired to the engine, and the client just freezes and we have to reboot the machine manually: how can i make sure that mysqld will remove that threa

Re: load problems on mysql 3.23.52 with and without Max

This problem is due to the glibc used by mysql AB for building binary ... Have a look to mysql 3.23.53 change log : << We've hopefully fixed the problem with spurious load spikes on Linux > >systems when accessing the Database via TCP/IP. This was caused by the > >static glibc files we us

Re: Problems installing on Solaris/Intel

On Wed, Oct 16, 2002 at 10:15:43AM -0400, Ben Goodwin wrote: > I've compiled and installed this on my Solaris8/Intel box a few times > without a hitch.. I don't recall seeing what version of Solaris you're > running.. ? I'm running Solaris 8 with gcc 2.95.2. > I also compiled with just ./configu

Re: adding a string to enum

Russ & Cindy Stanger wrote: >When I try to add a string to the end of an enum list I get the following >error message: > >You have an error in your SQL syntax near '\','Historical > > It looks like you've accidentally added a slash to quote a quote ... check your code. However, I'd highly sug

Re: load problems on mysql 3.23.52 with and without Max

This problems are making me a bit tired, forgot to give you information about the systems. MySQL-3.23.52 dual pentium 700, 800MB ram RedHat 6.1 Kernel 2.2.19-6.2.1smp glibc-2.1.3-27 MySQL-3.23.52-Max dual pentium 1.4Ghz, 2 GB ram Redhat 7.3 Kernel 2.4.18-10smp glibc-2.2.5-40 regards /Lars On

Re: Autoextend

At 13:33 -0300 10/16/02, Silmara wrote: >- Original Message - >From: Paul DuBois <[EMAIL PROTECTED]> >To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Wednesday, October 16, 2002 12:16 PM >Subject: Re: Autoextend > > >> At 12:08 -0300 10/16/02, Silmara wrote: >> >How can I cre

Re: Autoextend

- Original Message - From: Peter Brawley <[EMAIL PROTECTED]> To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 12:18 PM Subject: Re: Autoextend > 1. "inoodb" should be "innodb". Ok. I typed wrong in the e-mail. > > 2. Does the directory named in in

Re: Autoextend

- Original Message - From: Paul DuBois <[EMAIL PROTECTED]> To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 12:16 PM Subject: Re: Autoextend > At 12:08 -0300 10/16/02, Silmara wrote: > >How can I create a autoextend database? > > > >I tried using th

Re: about use Dev-cpp and C++

Insanely Great wrote: >Is it necessary that you usee STL. Other wise MySQL C API are much more >easy to maintain and program. Even SQLyog which I am a beta tester is >written using MySQL C API and its very fast. > > But it would be so nice to write: MySQLConn DB = new MySQLConn ('host', 'port'

Re: Normalization sql

John Chang wrote: > >> Studios (StudioName, StudioID) >> Genres (GenreName, GenreID) >> Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) >> Actors (F_Name, L_Name, ActorID) >> Stars (TitleID, ActorID) > > TitleGenres (TitleID, GenreID) > > So, if I just use theses tables I will

Re: Slow performance with full text index

Xavier LENOIR wrote: >>I use queries like this : >>SELECT count(*) FROM MyTable WHERE (MATCH(Title) AGAINST('a word')); >>SELECT * FROM MyTable WHERE (MATCH(Title) AGAINST('a word')) LIMIT 10; >> > > Have you tried building a seperate table of titles for the sake of having a smaller table to

one table frozen, rest is okey...

I'm using mysql Ver 11.16 Distrib 3.23.49, for slackware-linux-gnu (i386). Everything was just fine for months, but yeasterday I started to use one of the tables by connecting to it with MS Access 2000. The table has ~10 records. And the strange thing: it was working for few hours (queries,

re: startup error

Zack, Wednesday, October 16, 2002, 5:56:11 PM, you wrote: ZWK> I followed the directions in the Mysql documentation, but I can't get it ZWK> to fire up properly. I dl the binary distribution ZWK> mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz ZWK> Mysql 3.23.53 ZWK> Redhat 8.0 ZWK> When I start i

re: RE: data-type help with NULL entries

Hammons, Wednesday, October 16, 2002, 4:57:10 PM, you wrote: HRGS6AS> I have a table named projects. Within that table, one specific column is HRGS6AS> called costing and is of the following schema (projects float(8,2)). Nothing HRGS6AS> fancy. The interface that updates information to this table

re: Autoextend

Silmara, Wednesday, October 16, 2002, 6:08:18 PM, you wrote: S> I tried using the following configuration: S> inoodb_data_file_path=date_d1:100M:autoextend ^ innodb_data_file_path S> But the MySQL don't started. S> What's wrong? What error did you get? Check error logs. --

load problems on mysql 3.23.52 with and without Max

I'm managing two database servers, one 3.23.52 and one 3.23.52-Max (using innodb tables on that one). They are both running along fine until they suddently start to accumulate a lot of treads (a lot ~= 200-300), the state of these threads is mostly "closing" and "opening" tables. This drives up t

Solved the local-infile and related problems

I have solved my problem with MySQL and MySQLdb. The problem was: > I have installed mysql-3.23.52 as part of the Gentoo Linux > distribution. I am accessing MySQL via mysql-python AKA MySQLdb > which calls the MySQL C API. During testing I start MySQL using > "safe_mysqld" and shutdo

Re: Autoextend

At 12:08 -0300 10/16/02, Silmara wrote: >How can I create a autoextend database? > >I tried using the following configuration: > >inoodb_data_file_path=date_d1:100M:autoextend I assume you mean innodb_... and not innnodb_... ? > >But the MySQL don't started. > >What's wrong? What does the err

Where's safe_mysqld?

Hi! > "Chung" == Chung Ha-nyung <[EMAIL PROTECTED]> writes: Chung> Dear, Chung> I installed MySQL 4.0.4 from source tarball and I found that Chung> "safe_mysqld" is Chung> mentioned here and there in the manual but I can't where it, Chung> safe_mysqld, is Chung> located. All that I fou

information

hi, Somebody saw comparaisons of productivity for mysql and others RDBMS? or somebody do comparaisons? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: mySQL on windows xp

- Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 3:56 PM Subject: re: mySQL on windows xp > Mark, > Wednesday, October 16, 2002, 4:08:03 PM, you wrote: > > M> Ok, I tried to set up MySQL at home (3.23.53), on my window

Re: Misunderstandings about SQL

The section below should be in a loop if you expect it to happen more than once ... John Chang wrote: > > > $row_Recordset1['V_ID']; ?> > $row_Recordset1['40K']; ?> > > > SQL ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock ---

Re: RE: Inserting Master and Details records

sql,query At 0:07 +1000 10/17/02, Alan McDonald wrote: >Peter, >Thanks you - I looked up Insert_ID() in the manual... >Page 171-172 >If I insert into person but before I insert into short, someone else inserts >into person, surely my inserts into shirt will have their last Insert_ID()? Surely y

Re: Autoextend

1. "inoodb" should be "innodb". 2. Does the directory named in innodb_data_home_dir exist? 3. Does the file date_d1 already exist? PB - - Original Message - From: "Silmara" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 8:08 AM Subject: Autoextend

Is this possible - Remote Connection with SSL

I would like to know if this is at all possible using MySQL 4.0.4 in Windows. We want to be able to host our web site using either Windows and ASP or Linux and PHP in our service provider server. All the scripts will be in their machine away from our network. Then I would like for those scripts

re: RE: Inserting Master and Details records

Alan, Wednesday, October 16, 2002, 5:07:05 PM, you wrote: AM> Thanks you - I looked up Insert_ID() in the manual... AM> Page 171-172 AM> If I insert into person but before I insert into short, someone else inserts AM> into person, surely my inserts into shirt will have their last Insert_ID()? la

re: highly recomended MySQL version

usha, Wednesday, October 16, 2002, 7:48:26 PM, you wrote: u> Can anyone suggest me the highly recomended (non vulnerable)MySQL version. What about stable version? What OS do you use? 3.23.5X has some loading problems on Linux .. In Ensita we use v3.23.52 and v4.0.4 on production servers. He

Re: Inserting Master and Details records

Alan McDonald wrote: >Do you know if this is true only in the same connection context only? Or >does insert_id() return another connections last insert? > > I find it easiest to use MySQL's variables: INSERT INTO Master ... SELECT @MasterID:=last_insert_id(); INSERT INTO Detail1 (MasterID, Dat

Autoextend

How can I create a autoextend database? I tried using the following configuration: inoodb_data_file_path=date_d1:100M:autoextend But the MySQL don't started. What's wrong? - Before posting, please check: http:/

startup error

I followed the directions in the Mysql documentation, but I can't get it to fire up properly. I dl the binary distribution mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz Mysql 3.23.53 Redhat 8.0 When I start it from safe_mysqld I get in the .err log Fatal error: 'Can't change to run as user 'mysq

RE: data-type help with NULL entries

Re-send. Hopefully someone can help... -Original Message- From: Hammons Randy G SSgt 612 ACOMS/SCXX [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:01 AM To: Mysql (E-mail) Subject: data-type help with NULL entries I have a table named projects. Within that table, one spec

RE: data-type help with NULL entries

>>1) What is a syntax example for inserting a NULL into a column? insert into projects set costing=NULL >>2) If a NULL is inserted into a column with a float type, does that NULL show up as anything else other than NULL? Like my 0.00 for example. Is that actually mysql's way of showing a NULL f

re: permissions mysql.user

Gavin, Wednesday, October 16, 2002, 3:59:04 PM, you wrote: GL> I have a mysql database (version 3.23.47) running on a virtual server. GL> I have taken the running over from someone else and have been having trouble GL> with database permissions. To combat this I bypassed passwords by creating a

Problems installing on Solaris/Intel

I've compiled and installed this on my Solaris8/Intel box a few times without a hitch.. I don't recall seeing what version of Solaris you're running.. ? I also compiled with just ./configure - I didn't bother with the other options.. although that might be asking for trouble under certain circumst

RE: Inserting Master and Details records

Sorry your second link makes that claim a little clearer - it's on a per-connection basis Alan > -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 16 October 2002 23:58 > To: [EMAIL PROTECTED] > Cc: Alan McDonald > Subject: Re: Inserting Master and De

RE: Inserting Master and Details records

Peter, Thanks you - I looked up Insert_ID() in the manual... Page 171-172 If I insert into person but before I insert into short, someone else inserts into person, surely my inserts into shirt will have their last Insert_ID()? Do you know if this is true only in the same connection context only?

Re: Inserting Master and Details records

* Alan McDonald > My task is to insert a new master record and several detail records within > the one transaction. > > There is a foreign key on the detail table set to the unique key (autoinc) > field of the master table. > > Inserting a master record, even with a special field value so > that i

re: mySQL on windows xp

Mark, Wednesday, October 16, 2002, 4:08:03 PM, you wrote: M> Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I M> can test database stuff before I use it on the UNIX server. I installed it, M> set it up as services, the service is running, yet I get: M> C:\mysql\bin>mysq

RE: Inserting Master and Details records

Hi insert_id returns the key value. I use php, and the mysql_insert_id is the last insert_id on that connection, so even if other processes have added new records in the time the script runs the insert_id is the correct one. You can then use that as the key in the detail records. HTH Peter --

RE: inserting records

Ok, so I've broken down your problem into small, manageable steps. First, users are provided with a box to enter a value (e.g. pumpkin) and the 1)ability to select a ranking for pumpkin, or 2)the ability to select which old value (apefruit) the new value-pumpkin-belongs above/below (scenarios 1

Inserting Master and Details records

My task is to insert a new master record and several detail records within the one transaction. There is a foreign key on the detail table set to the unique key (autoinc) field of the master table. Inserting a master record, even with a special field value so that it can be quickly returned with

Re: Crystal Reports & MySQL

We use Crystal and it is great. It is especially good for the more complicated reports. >>> "Webmaster MBTRADINGCO" <[EMAIL PROTECTED]> 10/15/02 11:45PM >>> Hi, does anyone knows if Crystal reports is a good reporter to make reports out of MySQL, or does anyone knows a good reporter for PHP MySQ

RE: mySQL on windows xp

>Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I >can test database stuff before I use it on the UNIX server. I installed it, >set it up as services, the service is running, yet I get: >C:\mysql\bin>mysql.exe >ERROR 2003: Can't connect to MySQL server on 'localhost' (1

Re: How many columns does MySQL Support?

I'm not sure what the limit is. MySQL limits tend to be dictated by the OS that is being used. The more columns you have the larger the database file will be. You should try to avoid having many empty columns in a database design, even if you are using varchar instead of char. Try to think ahe

mySQL on windows xp

Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I can test database stuff before I use it on the UNIX server. I installed it, set it up as services, the service is running, yet I get: C:\mysql\bin>mysql.exe ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

permissions mysql.user

I have a mysql database (version 3.23.47) running on a virtual server. I have taken the running over from someone else and have been having trouble with database permissions. To combat this I bypassed passwords by creating a my.cnf file. I then have deleted all records in the mysql.user table and

Re: select from multiple tables

Assuming that you're joining data based on colB, you would use: select t1.colA,t2.colA,t3.colA from tblA t1 inner join tblB t2 on t1.colB = t2.colB inner join tblC t3 on t1.colB = t2.colB where... You can alias the table names, but there's really no way to get around specifying the table identif

Dead server

Hello, After upgrading to 4.0.4 from 4.0.2 on three server we have got some mysterious problems with one of the server. Several times it appears to be dead. Connecting takes a very long time, and the CPU load goes throug the roof and beyond. The two other servers runs without problems. The o

Re: select from multiple tables

Hello, You can define a "merge table" and run your select on it. Check the manual for details: http://www.mysql.com/doc/en/MERGE.html Regards Joseph Bueno Veysel Harun Sahin wrote: > Hello, > > I have a problem with select statetement. I need to query and select > records from multiple tables

highly recomended MySQL version

Hi all, Can anyone suggest me the highly recomended (non vulnerable)MySQL version. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arc

select from multiple tables

Hello, I have a problem with select statetement. I need to query and select records from multiple tables which have the same column types. I have done this with left join but my query became so complex. Because i have written "left join" between all of my tables and also if i need to query so

Result using after statement and connection close

Hi, I am using MySQL with the mm.mysql-2.0.14 dirver. I got connection with the databse after that i created an object of statement and after that i got the object of ResultSet, then i closed the statement and then conection. But when i use this resultset it works fine. Can anybody tell me how it

re: Segmentation Fault when connecting via TCP/IP

clint, Wednesday, October 16, 2002, 1:14:08 AM, you wrote: caddn> Recently the server had to be hard-booted... a safe shutdown was not possible. After the server came back up, mysql caddn> has been acting very funny. When the server first boots, mysql wont respond to anything. I restart

  1   2   >