Using more than one CPU on FreeBSD?

> Hi, > > First of all, we can presume you're using SMP kernel. Then I'd suggest > using Linuxthreads despite your dislike for them - by my > experience, they > work far better for mysql/FreeBSD than native threads. May be > you try it > again - compile mysql from the ports (WITH_LINUXTHREADS=y

Query

Hi, I am having MySQL server having BugZilla on "Sun" machine. My Workstation is Windows 2000. I need to create bug reports(E.g. say using Crstal Reports). I installed the MyODBC driver. Bu t still it is not allowing to connect. Kindly let me know how I can I solve this problem Thanks and regards,

Optimizing Ext3 for MySQL

Are there any general guidelines for optimizing ext3 for MySQL? I have a perl script that runs 200K + updates into my database once a day and I see pretty wildly fluctuating query/sec numbers using Jeremy Z's mytop program. I've seen in excess of 2000 qps and then seen that number drop to 40 qps. T

RE: mysql.users read only?

What I have discovered is that, when mysqld Windows service is running, I can't do anything to the user table. If I start it on the command line with the service stopped but set automatic, it works just fine. An interesting bug? that creates a nice security block. -- Loren McDonald Gods Of Mus

Re: Compiling error 3.23.54a (src)

On Tue, Jan 14, 2003 at 08:58:07PM -0700, Tyler wrote: > what appropriate forums? I'm not a Mandrake user, but every Linux distribution I've tried has had various e-mail and web-base forums in which you can ask questions. Furthermore, they have official support channels and ways of filing bug rep

Notice: Undefined index:

Hi, Anyone know why I would be receiving this error in Windows. I have a small PHP script that accesses a MySQL database and prints out a couple lines. This works fine in LinuxI have searched google and found many users with the same problem, but not one solution. TIA Notice: Undefined index

Re: Compiling error 3.23.54a (src)

what appropriate forums? - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 7:21 PM Subject: Re: Compiling error 3.23.54a (src) > On Tue, Jan 14, 2003 at 05:56:07PM -0700, [EMAIL PROTECTED] wrote

Doorstop II - coming soon

The second edition of "MySQL" is supposed to get to the warehouses in a couple of days, and should be reaching readers by the end of the month, so I'm releasing the software distribution that acccompanies the book. A PDF of the revised sample chapter (chapter 6) is available as well. To get eithe

replication user privilege

for a normal replication, you need to create a replication user by issuing such command: GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY ''; for a secured replication (mysql-4.0.7-gamma), do you need to issue a REQUIRE SSL, eg: GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '' REQUIRE SSL; but when RE

Re: when to normalize out to a table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cal, et al -- ...and then Cal Evans said... % % http://froogle.google.com/froogle?q=sql+for+dummies&btnG=Froogle+Search % http://froogle.google.com/froogle?q=sql+for+smarties&btnG=Froogle+Search % http://froogle.google.com/froogle?q=mysql+paul+dubois

RE: when to normalize out to a table

http://froogle.google.com/froogle?q=sql+for+dummies&btnG=Froogle+Search http://froogle.google.com/froogle?q=sql+for+smarties&btnG=Froogle+Search http://froogle.google.com/froogle?q=mysql+paul+dubois&btnG=Froogle+Search (first book in the list) I can personally recommend the first two and while I'v

RE: how to have varying number of fields?

Having designed this database 4-5 times over the past 10 years, I will share with you how I did it. I have 4 tables for this product --- productID === title === person --- personID === name === role --- roleID === description === product_person --- productID FK personID FK roleIDFK === ==

RE: Design feature or bug

Unfortunately that won't help me. The slave database is part of of an access system at a ski resort. Missing updates means unhappy customers that are being denied access. Thanks for your help. Ross > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Tuesday,

RE: Bug Report: Restrictions on index naming

MySQLCC probably uses the backtick (`) to escape stuff so it issued UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location) and not UNIQUE KEY IDX_Postcode-Location (Postcode,Location) It has been mentioned on the list a few times in the last couple months that if you escape strings containing hyph

RE: how to have varying number of fields?

Sounds a lot like the grape blends in different wines question posted last week. :) You'll need a cross ref table with a one to many relationship and possibly a field that says what the person did. like | SongID | ComposerID | Role | ++-++ |1 | 1 | P

Re: Bug Report: Restrictions on index naming

On Wed, Jan 15, 2003 at 11:44:24AM +1100, Daniel Kasak wrote: > Hi all, > > I recently had to restore from a backup and discovered that mysql didn't > want to re-create a table which had the minus symbol (-) in it, eg Yeah, you need to quote such names now. Upgrade your version of mysqldump and

Re: Compiling error 3.23.54a (src)

On Tue, Jan 14, 2003 at 05:56:07PM -0700, [EMAIL PROTECTED] wrote: > Does this mean I wont get a reply? this is the 3rd post regarding this > matter, and I've been trying to install MySQL for a month :(. It seems to be Mandrake-specific issue. Have you asked in the appropriate forums for that? T

Re: Design feature or bug

On Tue, Jan 14, 2003 at 04:41:53PM -0800, Ross Davis - DataAnywhere.net wrote: > > > I stand corrected. In a production environment a stopped server is as > good as crashed. Ah, good. > I know why things work they way they do, but it would be nice to have an > option to change the replication

filter input

Hi all, I want to insert some text into my database, but I'm worried about bad data - metacharacters etc. So I need to filter the input and remove bad characters. Which characters should I remove? What is bad for mysql? does anyone know a good subroutine (or webpage telling me all about it) for

Re: when to normalize out to a table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cal, et al -- ...and then Cal Evans said... % ... % % product then has vocalRangeTypeID as a FK. % % >> Right. That means another lookup, but it would certainly work. % % If by lookup you mean another trip to the database, not necessarily, left %

help w/join condition

Hello, Is it possible to have a join condition where the condition is not always me? Here is my query: SELECT u.name, item1.name AS item1_name,item2.name AS item2_name, item3.name AS item3_name,item4.name AS item4_name, item5.name AS item5_name,item6.name AS item6_name,item7.name AS item7

ATENÇÃO: Possível Vírus de E-mail detectado

Nosso detector de vírus bloqueou a mensagem que você enviou: Para: <[EMAIL PROTECTED]> Assunto: Data: Wed Jan 15 00:05:48 2003 Partes infectadas da mensagem não foram entregues. Essa mensagem é apenas um aviso que seu computador provavelmente está infectado com vírus e precisa ser checado.

RE: when to normalize out to a table

% % vocalRangeType % --- % vocalRangeTypeID % === % description % === % % product then has vocalRangeTypeID as a FK. >> Right. That means another lookup, but it would certainly work. If by lookup you mean another trip to the database, not necessarily, left join this table to your product select

ANSWERED: Re: how to have varying number of fields?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jennifer (and Josh and John and Cal), et al -- ...and then Jennifer Goodie said... % % Sounds a lot like the grape blends in different wines question posted last % week. :) Well, hully gee. I never knew songs and wine could have so much in common -

Re: when to normalize out to a table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cal, et al -- ...and then Cal Evans said... % % IMHO, etc. *grin* % % Always start with a *fully* (ok, by fully I mean 3rd normal form...mainly % because I still don't fully understand 4th and don't even pretend to Yeah; I'm in the same boat :-)

RE: when to normalize out to a table

IMHO, etc. Always start with a *fully* (ok, by fully I mean 3rd normal form...mainly because I still don't fully understand 4th and don't even pretend to understand 5th) normalized design. You can always denormalize for speed but it's real hard to normalize once you are in production. Vocal range

Getting back lost data using .frm files in InnoDB

mysql,query (BHello, I am posting it again. (B (BI have installed mysql4.0.8 replacing mysql4.0.3 (BI just copied all the database files in the *data* folder of mysql4.0.3 & (Bthen copied the same to the *data* folder of mysql408. (B I suppose something happened and have got only the

Re: Compiling error 3.23.54a (src)

Does this mean I wont get a reply? this is the 3rd post regarding this matter, and I've been trying to install MySQL for a month :(. - Original Message - Wrom: GJSNBOHMKHJYFMYXOEAIJJPHSCRTN To: <[EMAIL PROTECTED]> Sent: Saturday, January 11, 2003 10:03 AM Subject: Compiling error 3.23.54a (

Bug Report: Restrictions on index naming

Hi all, I recently had to restore from a backup and discovered that mysql didn't want to re-create a table which had the minus symbol (-) in it, eg DROP TABLE IF EXISTS Postcodes; CREATE TABLE Postcodes ( DanPK mediumint(8) unsigned NOT NULL auto_increment, MyStamp timestamp(14) NOT NULL,

RE: Design feature or bug

> -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 4:00 PM > To: Ross Davis - DataAnywhere.net > Cc: [EMAIL PROTECTED] > Subject: Re: Design feature or bug > > > On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis - > DataAnywhere

three table join

I want a list of all the people in all the meetings in a given event, for the purpose of printing all their schedules. I can get a list of meetings in an event given the event id with the following query: select meetings.id from meetings where eid=2; People are assigned meetings in the table

Compiling on W2K using MSC 6.0 from source tree.

I have downloaded the source (3.23.55) tree using Bitkeeper. What is the best way to compile MySQL for Windows using MSC++ 6.0. I noticed the files (*.dsw, *.dsp) under the directory VC++Files. When I try to compile any of the projects, MSC is unable to locate the source files. Do I need to cop

Re: Avg_row_length

In the last episode (Jan 14), Stefan Hinz said: > here's my final stupid question for today. Why is the average row > length 11 when it should be 10? > > mysql> DESCRIBE myrowisam; > +---+--+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > +--

Re: storing a picture in a file or database (newbie)

On Tue, Jan 14, 2003 at 03:58:10PM -0700, Grant Cooper wrote: > > Is it better to store a picture in mysql field or a link to the file > on my server? I want to allow people to use a php script to upload a > gif or a pic. Any pro's and con's would be appreciated. Have you looked in the archives?

Re: Linux Mysql vs Windows Mysql

On Tue, Jan 14, 2003 at 03:20:20PM -0500, Beauford wrote: > Hi, > > I just installed MySQL and PHP on Windows XP and have a question. I created > a test database on Windows (exactly the same as the test one I use in Linux) > and copied a test PHP script which accesses Mysql and displays some > inf

Foreign key in INNODB

HI I'm not sure what is wrong with my CREATE TABLE syntax, Please advice mysql> CREATE TABLE equipment ( -> equipID CHAR(20) NOT NULL, -> assetNumber CHAR(20), -> serialNumber CHAR(50), -> description BLOB, -> barcode CHAR(20),

Re: Design feature or bug

On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis - DataAnywhere.net wrote: > I have a 3.23.53 server that is a slave of another 3.25.52 server. > Master has 2 databases on it. > > On the slave only only one of the databases is replicated. > > If I reference the table database that is not on

Re: replication - queries out of order or dropped?

On Tue, Jan 14, 2003 at 05:26:25PM -0500, David Nedved wrote: > I've been doing a lot of poking around... > > the actual database is what didn't get created. The CREATE DATABASE > statement did make it into the log file, and the slave got past that > point without ever creating the database. Tha

Re: Solaris Performance

On Tue, Jan 14, 2003 at 10:25:34PM -, Andy Eastham wrote: > Jeremy, > > Thanks for replying. It's CPU bound. > > The 64 bit version has improved things a little - about 5-10%. > > I just expected an enterprise server to be faster than a laptop running > win2k with an IDE, Tomcat, Outlook, Of

when to normalize out to a table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I wonder if there's a best-practice line of when to bother to normalize data out to a table. Certainly I wouldn't want to have a table of integers and have a column in another table point into it :-) and almost certainly I'd want to point

Re: Avg_row_length

I believe there is an extra byte for the 'null' flag; if you declare this column to be NOT NULL, I'll bet the avg length will be 10. -steve At 10:43 PM +0100 1/14/03, Stefan Hinz wrote: Dear gurus, here's my final stupid question for today. Why is the average row length 11 when it should be 10?

RE: Avg_row_length

I am not a guru, but I figured I'd try to answer anyway. It needs an extra bit because it has NULLs. I think it uses the bit to mark if the field is NULL or not, but I've been known to be wrong. http://www.mysql.com/doc/en/Data_size.html - Dear gurus, here's my final stupid question

how to have varying number of fields?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- The Subject: may be a bit misleading, so let me start from scratch. I'm creating a sheet music catalog for our church, and one of the things I'll want to track is who wrote it. [Actually, we have music composers and arrangers and poet aut

Re: SHOW STATUS LIKE 'Com_%'

On Tue, Jan 14, 2003 at 10:35:32PM +0100, Stefan Hinz wrote: > Jennifer, Paul, > > >> can anyone point me to a reference regarding the Com_ status > information > > > http://www.mysql.com/doc/en/SHOW_STATUS.html > > states that the com_ is just how many times the command has > been > > i

storing a picture in a file or database (newbie)

Is it better to store a picture in mysql field or a link to the file on my server? I want to allow people to use a php script to upload a gif or a pic. Any pro's and con's would be appreciated. - Before posting, please check:

Design feature or bug

I have a 3.23.53 server that is a slave of another 3.25.52 server. Master has 2 databases on it. On the slave only only one of the databases is replicated. If I reference the table database that is not on the slave during an insert or something on the server it crashes the slave! Shouldn't the

Re: replication - queries out of order or dropped?

I've been doing a lot of poking around... the actual database is what didn't get created. The CREATE DATABASE statement did make it into the log file, and the slave got past that point without ever creating the database. Go figure... On Tue, Jan 14, 2003 at 02:06:39PM -0800, Jeremy Zawodny wrot

RE: Solaris Performance

Jeremy, Thanks for replying. It's CPU bound. The 64 bit version has improved things a little - about 5-10%. I just expected an enterprise server to be faster than a laptop running win2k with an IDE, Tomcat, Outlook, Office all at the same time... I now know better. I'm thinking of putting a fa

mysql reporst system error 1067

I am trying to install (first-time installation) Mysqld-nt on a W2000 workgroup computer. when starting it reports "system error 1067 has occurred, process terminated unexpectedly" TCP/IP is on. I covered all the installation directives. I have a feeling that it might have something to do with 'lo

Re: Version 4 "safe" to use?

On Fri, Jan 10, 2003 at 01:48:23PM -0300, Maximo Migliari wrote: > Cool, you work for Yahoo? Yup. I do a lot of our internal MySQL advocacy and consulting. I used to post from my work address but decided it'd be easier to manage one on-line "identity" than two. Plus it might help to keep the la

Re: replication - queries out of order or dropped?

On Mon, Jan 13, 2003 at 02:16:23PM -0500, David Nedved wrote: > > We keep having issues where we create a new table on the master, and > a short while later the slave will crash because it starts trying to > perform queries which insert into the new table, but it looks as if the > query to create

Avg_row_length

Dear gurus, here's my final stupid question for today. Why is the average row length 11 when it should be 10? mysql> DESCRIBE myrowisam; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | co

Re: innofb foreign keys problem

yes -- you need to create indexes on foreign key colums. it would be better if one of the following 2 things happened instead. 1. foreign key creation failed if no index existed. 2. indexes were created automatically it's more dangerous than actually not having foreign keys as it stands since it

Re: SHOW STATUS LIKE 'Com_%'

Jennifer, Paul, >> can anyone point me to a reference regarding the Com_ status information > http://www.mysql.com/doc/en/SHOW_STATUS.html > states that the com_ is just how many times the command has been > issued. Sorry. I didn't see the com_... line on this page, must consult the eye

Re: Corrupt ISAM table

Thanks, I'll try that! Robert On Tue, 2003-01-14 at 14:54, Dyego Souza do Carmo wrote: > Dobrý den, > terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste: > > RC> I'm new to administering MySQL, so bear with me: > > RC> We run a large MySQL database with one of the tables amassing > RC>

Re: details needed

> > > Hello, > > > I want to know whether the mysql depot (mysql-3.23.54a) works on > > > HP-UX PA_RISC2.0 or it works only on PA_RISC1.0. > > > If it doesn't work on PA_RISC2.0, where can I find a mysql depot > > > that works on PA_RISC2.0? Hello, One of our developers recommends that yo

Availablility of MySQL 4.0.9 for Windows (bins)

Does anyone know when MySQL 4.0.9 for Windows (bins) will be available for download? Thanks, Gabe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Corrupt ISAM table

Dobrý den, terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste: RC> I'm new to administering MySQL, so bear with me: RC> We run a large MySQL database with one of the tables amassing RC> over 40 million entries. It somehow got corrupt and now I'm RC> running isamchk -o (-r failed) and it'

Re: select the next name

On Tue 2003-01-14 at 09:22:40 -0500, [EMAIL PROTECTED] wrote: > > One solution could be something like > > > > SELECT id, first, last > > FROM names > > WHERE last > '$previouslast' AND first > 'previousfirst' > > ORDER BY last, first > > LIMIT 1 [...] > I don't think it would loop for

Re: MS SQL vs MySQL

Hi, In fact ...you can choice the RDBMS depend on what you wish to do. If you are able to design the database for using without store procedures,viewers,triggers...you can choose MySQL. It's stable enough and the better part is that have very good performance. Regards, Gelu __

Linux Mysql vs Windows Mysql

Hi, I just installed MySQL and PHP on Windows XP and have a question. I created a test database on Windows (exactly the same as the test one I use in Linux) and copied a test PHP script which accesses Mysql and displays some information. On Linux it works perfectly, but on Windows I get the follow

Re: SHOW STATUS LIKE 'Com_%'

In the last episode (Jan 14), Stefan Hinz said: > can anyone point me to a reference regarding the Com_ status > information you get with SHOW STATUS LIKE 'Com_%'? I searched the > MySQL website and Google groups, but nothing. http://www.mysql.com/doc/en/SHOW_STATUS.html `Com_xxx' Nu

Aborted clients, aborted connects

Dear all, can someone explain this phenomenon (I connect to mysqld-max-nt in another DOS box, then close the window without issuing 'quit'; MySQL 4.0.7 with InnoDB tables on Win2K SP2): mysql> SHOW STATUS LIKE 'Aborted%'; +--+---+ | Variable_name| Value | +

Re: SHOW STATUS LIKE 'Com_%'

At 19:11 +0100 1/14/03, Stefan Hinz wrote: Dear all, can anyone point me to a reference regarding the Com_ status information you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and Google groups, but nothing. They're counters for the number of times various types of statements

May be bug in MySQL 4 (addition)

In addition to the previous I just want to say that the problem is most likely with the unsigned columns - I altered the integer column to remove the 'unsigned' property and now it is working properly Regards Dobromir Velev [EMAIL PROTECTED] - Original Message - From: "Dobromir Velev" <[

RE: SHOW STATUS LIKE 'Com_%'

>can anyone point me to a reference regarding the Com_ status information What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html states that the com_ is just how many times the command has been issued. So if com_select = 34021 there have been 34021 selects issued to the

Re: Populating one table with data from another

Michael, > I have a table, products containing a 944 rows. One of the fields is > fgNumber, > I have another table, categoryRelatedToProducts which also has an fgNumber > field and currently has no data. > I'd like to add all 944 fgNumbers to the categoryRelatedToProducts table. INSERT INTO categ

MySQL BLOB fields and large binary data

Greetings Seemingly MySQL has a persistant problem that I could not solve whatever I tried to do. It seems that it is impossible to send large amount of binary data to mysql's BLOB field. It is written in manual that 4.0x versions do not have limit for max_allowed_packet. It is also written that b

May be bug in MySQL 4

Hi, There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when combining simple arithmetic operations and date conversion I have a table with the following structure date_col date -00-00 int_col tinyint(3) unsigned This is what happens when I try to run a query like the one

Re: MySQL 4.0.9 is released

On Tue, Jan 14, 2003 at 12:42:18AM +0200, Jani Tolonen wrote: ... >* Added join operator `FORCE INDEX (key_list)'. This acts likes `USE > INDEX (key_list)' but with the addition that a table scan is > assumed to be VERY expensive. One bad thing with this is that it > makes `FORC

Re: Populating one table with data from another

Hi, You can use INSERT...SELECT. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Michael Knauf/Niles" <[EMAIL PRO

Populating one table with data from another

Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another table, categoryRelatedToProducts which also has an fgNumber field and currently has no data. I'd like to add all 944 fgNumbers to the categ

Re: Solaris Performance

On Mon, Jan 13, 2003 at 03:34:29PM -, Andy Eastham wrote: > > I've got a mysql application that was developed on win32 and linux that is > now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided > SCSI disks. No problem I thought - the performance is fine on my PIII > 850M

Corrupt ISAM table

I'm new to administering MySQL, so bear with me: We run a large MySQL database with one of the tables amassing over 40 million entries. It somehow got corrupt and now I'm running isamchk -o (-r failed) and it's in its 110th hour and it's getting slower. I'm running 3.23.38 and cannot upgrade d

Re: MySQL Secure Replication

On Mon, Jan 13, 2003 at 02:46:45PM +0800, Ivan Hoo wrote: > hi All, > > has anyone been able to setup ssl secure replication for mysql? I don't believe you can do that yet. There's now way to specify the necessary credentials in the slave setup. > how do i know whether the replication is actual

Re: Mysql on FreeBSD with a NT linked database

On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote: > Hi, > > I'm running Freebsd 4.6.2 with mysql server v3.23.49 > > I have a little question about using Mysql on Freebsd and having a > database on a NT 4 linked drive, using Samba (the drive was mounted > on my FreeBSD system with Sharity-

Re: MS SQL vs MySQL

On Tue, Jan 14, 2003 at 11:41:16AM +0200, Octavian Rasnita wrote: > Hi all, > > I've asked on another list which database they recommend among MySQL > and MS SQL, and ... possibly PostgreSQL. Most of that list members > answered me that they recommend MS SQL because it has much more > features.

Re: indexing a blob

At 10:10 +0200 1/14/03, Octavian Rasnita wrote: Can I index just a smaller number of characters from a field even though the field has more? Will this make MySQL to index that field faster? For BLOB and TEXT columns, you *must* in fact index just a certain number of bytes (maximum of 255 bytes).

RE: myODBC, if left alone, can lock up an Access table

> -Original Message- > From: Steve Quezadas [mailto:[EMAIL PROTECTED]] > I notice that sometimes when I establish a connection with > myODBC with > Microsoft Access, and send it occasional sql statements it > works fine at > first. But if you let it sit for, say, 30 minutes and comes

Re: innofb foreign keys problem

> then i ask me: why mysql needs explicit creation > instead of create itself what it needs? > manually creating the index seems to be a big > complication (for big databases) and a waste of time. > don't you think so? > it's a bug or a wanted feature? why? I agree with you 100%. A foreign key,as

Re: Populating one table with data from another

Use INSERT...SELECT syntax: http://www.mysql.com/doc/en/INSERT_SELECT.html -steve At 12:01 PM -0500 1/14/03, Michael Knauf/Niles wrote: Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another

Re: InnoDB table, NOT NULL question

> >>I have an InnoDB table that looks like the following. > >> > >>CREATE TABLE `stuff` ( > >> `stuff_id` int(11) NOT NULL auto_increment, > >> `somevalue1` varchar(35) NOT NULL, > >> `somevalue2` varchar(35) NOT NULL, > >> PRIMARY KEY (`stuff_id`) > >>) TYPE=InnoDB COMMENT='stuff table'; > >>

Re: Populating one table with data from another

At 12:01 -0500 1/14/03, Michael Knauf/Niles wrote: Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another table, categoryRelatedToProducts which also has an fgNumber field and currently has no da

RE: innofb foreign keys problem

I agree with you. If there is no index already on the referenced fields then add one. By adding a foreign key you are already altering the table why not just finish the job. -Original Message- From: Natale Babbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:58 AM To: Oka

SHOW STATUS LIKE 'Com_%'

Dear all, can anyone point me to a reference regarding the Com_ status information you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and Google groups, but nothing. TIA, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH Heesestr. 6

RE: Foreign keys

> Does MySQL allow using foreign keys or not? It does. Try it by yourself with version 4.0.8 +. Adolfo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: Foreign keys

> Use table type =Innodb for foreing keys and transacionts...etc > and type =myisam for speed Yes, but do the foreign keys in InnoDB honor the constraints? I think that was the original question. What's the poing of using foreign keys if it's not going to maintain the integrity of your data. Tha

multiple references

mysql, query Hi, all, I have a development table which is created using the following commands on 3.23.53-log mysql server on MAC 10 CREATE TABLE web_transaction_item( trans_item_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, trans_id INT UNSIGNED, prod_id INT UNSIGNED, INDE

select now() returns incorrect time

I'm having trouble on one of my SQL servers. It is the slave in a master/slave setup. select now() returns the wrong time (+5 hours). The systems time is in EST and "show variables" shows timezone=EST. Eg. mysql> select now(); +-+ | now() | +---

Re: mysql replication problem

Vaso Koutsonikola wrote: > Hi, > I am replicating a table between 2 servers. > The table on the master executes many transactions that should be > replicated to the table on the slave.. > The table on the slave is only readable... > I have noticed that the changes on the master are not replicated

Re: Foreign keys

On Tue, Jan 14, 2003 at 12:20:06PM +0200, Octavian Rasnita wrote: > I've read the following text in a book: > > ANSI SQL supports a special kind of key called a foreign key. Foreign keys > help protect database integrity by enabling the database to manage things > such as the deletion of rows with

Foreign keys

HI all, I've read the following text in a book: ANSI SQL supports a special kind of key called a foreign key. Foreign keys help protect database integrity by enabling the database to manage things such as the deletion of rows with dependent relationships in other tables. Though MySQL supports the

RE: InnoDB table, NOT NULL question

I'm aware that NULL and "" are not the same thing.. I would like to prevent the column from accepting values automatically ( with out the presence of a DEFAULT). -Original Message- From: Csongor Fagyal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:21 AM To: [EMAIL PROTECTED

Re: indexing a blob

On Tue, Jan 14, 2003 at 10:10:02AM +0200, Octavian Rasnita wrote: > Can I index just a smaller number of characters from a field even though the > field has more? > Will this make MySQL to index that field faster? Good Day Octavian, You can index part of a column with the syntax INDEX

RE: InnoDB table, NOT NULL question

Are there plans in future versions to have MySQL fail the below INSERT statement? It would be useful to at least receive a warning. In my situation, I only intend on leaving fields blank by omitting them if: 1. I have set a DEFAULT on the column. 2. Or the column accepts NULL's.

Re: innofb foreign keys problem

many thanks for your reply. then i ask me: why mysql needs explicit creation instead of create itself what it needs? manually creating the index seems to be a big complication (for big databases) and a waste of time. don't you think so? it's a bug or a wanted feature? why? Thanks. --- Okan CIMEN

RE: doc storage as BLOB and its search engine on MYSQL

Thx for the correction Paul. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:17 PM To: Vikash K Agarwal; [EMAIL PROTECTED] Subject: Re: doc storage as BLOB and its search engine on MYSQL At 16:00 +0530 1/14/03, Vikash K Agarwal wrote: >H

RE: Foreign keys

Use table type =Innodb for foreing keys and transacionts...etc and type =myisam for speed Simon -Original Message- From: Octavian Rasnita [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 10:20 To: MySQL Subject: Foreign keys HI all, I've read the following text in a book: ANSI SQL supp

Re: Fw: Problem on WinXP

At 09:49 14/01/2003 -0500, C. Reeve wrote: Hi, Something wrong happens with your system: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. c:\mysql\bin>mysqld --standalone --console --port=3308 mysqld: ready for connections in another windows: Microsoft Windows 2

Mysql on FreeBSD with a NT linked database

Hi, I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because "smbmount" doesn't work on Freebsd) . I can query my da

  1   2   >