Re: Limits of mySQL

On Wed, May 01, 2002 at 08:02:20AM +0200, Svensson, B.A.T. (HKG) wrote: > > Do you have any idea how well MySQL scales with tables containing > some 10th of million rows of data? How about 280 million? We've got one that big. It performs very well--because we have it properly indexed and don't

RE: Limits of mySQL

> I'm not a suitable person to compare MySQL against other databases but MySQL > will cope with this size of database if the tables are properly indexed and > your queries optomised. Here our main database has over 90 tables and several > of our tablse hold about the amount of data your'll acrue

PHP/MySQL connetion query

Hello, While granting permissions to particular user, the administrator has to give username@machine_address !! Then how can we connect to MySQL only by passing "username" as one of the arguments to mysql_connect() ? Thanks. Paras. ---

Re: Can I create a table name 'INT'?

In the last episode (Apr 30), Tim Johnson said: > Hello All: > using mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) > > I'm attempting to build a database with programming code. I get > an error when I attempt to execute the following: 'DROP TABLE IF > EXISTS INT' >

Unknown column

Hello mysql, This is my query: SELECT countries.*, lnk0.Value AS fraudIndex, lnk1.Value AS enabled FROM o as countries LEFT JOIN l_TINYINT AS lnk0 ON lnk0.FID=countries.ID AND lnk0.TID=55 LEFT JOIN l_TINYINT AS lnk1 ON lnk1.FID=countries.ID AND lnk1.TID=57 WHERE ((enabled=1) AND countries.Parent

Buliding relationships between tables - how?

Hello friends, Can someone tell me how I can build the relationships between tables in mysql? I have tried books and web manuals. Even a link will do. Thanks Denis - Before posting, please check: http://www.mysql.com/manual

Can I create a table name 'INT'?

Hello All: using mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I'm attempting to build a database with programming code. I get an error when I attempt to execute the following: 'DROP TABLE IF EXISTS INT' Is there any way around this, or must I use a different ta

Re: select by total goals

Try: SELECT SUM(goals) AS leaders FROM stats GROUP BY [player_field] ORDER BY leaders DESC --jeff - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 6:55 PM Subject: select by total goals > hey guys, > > I'm work

select by total goals

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

select by total goals

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

select

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

SQL Query and DATETIME

> All - Is it possible to use the DATETIME column type inside of a SQL query > ? Let's say I have a table named foo and that one of the columns (named > start_time) is defined as a DATETIME. > > I'd like to do something like the following: > > select * from foo where (start_time > "2002-05-30 1

Where are binaries for MySQL 3.23.50 pre-release ?

I couldn't find binaries for MySQL 3.23.50 pre-release. Can anyone help me with this. Thanks. _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com ---

Re: Innodb's inner workings and checkpoints

Hi! - Original Message - From: "Balteo" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 8:02 AM Subject: Re: Innodb's inner workings and checkpoints > Heikki, > > Thanks for your prompt reply. > > If I understand: > > 1. In order for data to make

RE: MyODBC Question

Hi, Please call SQLGetTypeInfo with SQL_LONGVARCHAR, then you get the results what is expected. Here is the output snippet: SQLGetTypeInfo: In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARCHAR=-1 Return: SQL_SUCCESS=0 Get Data All: .. long varchar, -1, 16777215, te

UDF and embedded MySQL

I know the documentation says UDF and embedded MySQL server is not allowed, but then it says, some of these limitations can be changed by editing mysql_embed.h. I see in there that it has HAVE_DLOPEN undefined. I assume it is not as simple as uncommenting that line to whether or not UDF will

Re: MySQL Performance on Dual Processor machine

Do keep in Mind that FreeBsd isn't 100 % with Smp .. you might have to compile linux threads in order to try and use the dual cpu's .. FreeBSD 5.0 should have the next Generation of SMP that should work great with mysql.. - Original Message - From: "Ken Menzel" <[EMAIL PROTECTED]> To: "J

Re: Innodb's inner workings and checkpoints

Hi! - Original Message - From: "Balteo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:12 AM Subject: Innodb's inner workings and checkpoints > Hello, > > Can data be flushed from the buffer pool to the main innodb tablespace > (checkpoint) but not be presen

Re: MyODBC Question

I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype that the MyODBC driver will return as character data greate

RE: MyODBC Question

Hi, > -Original Message- > From: David M. Peak [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 2:44 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: MyODBC Question > > > So what is the best way to store information in a MySQL > database through MyODBC that is

Re: MyODBC Question

So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? - Original Message - From: "Venu" <[EMAIL PROTECTED]> To: "'David M. Peak'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 30,

Pushing the limits!

I am running a pretty big database in MySQL, about 120 million records. Indexes are very important for the performance of the database. Every time I alter the tables to add indexes I takes about 3 hours of processing time. I was wondering what would be a good rule of thumb for optimizing the serve

RE: mySQL & PervasiveSQL

Hi, > -Original Message- > From: Jay Blanchard [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 1:05 PM > To: 'Andrew Hazen'; [EMAIL PROTECTED] > Subject: RE: mySQL & PervasiveSQL > > > [snip] > Now here's a bit of an oddball question: > > I am building a php/mysql web app

Re: GUI managers for Linux

Victoria, sorry it has taken so long to get back to you, Ive had a partition table problem that has taken a couple of days to fix anyway, Using MyCC, in the database connection dialog, I have the host "localhost" a valid user name, and password Identified the port as the default 3306 but dont

RE: MyODBC Question

Hi, > -Original Message- > From: David M. Peak [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 12:35 PM > To: [EMAIL PROTECTED] > Subject: MyODBC Question > > > I have a question about MyODBC and the results of > SQLGetTypeInfo from a table with a column of type TEXT. The

Triggers and procedures

Newbie Question! All my research shows that stored procedures triggers and referential integrity are not available in current MySQL versions. Does anyone know a work around to this? I would like to set up a few basics like "on insert" and data verification triggers and procedures. Any idea? P

RE: ODBC Problem.....

Hi, > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 29, 2002 12:28 AM > To: [EMAIL PROTECTED] > Subject: ODBC Problem. > > > > I've downloaded a version of MySQL ODBC Driver from The > MySQL.com site named [ myodbc-2.50.36-win95.zi

Re: MySQL Performance on Dual Processor machine

Just becareful not to use too much memory unless you raise the DMAX and such values (see /usr/src/sys/i386/conf/LINT ) if mysql runs out of memory things can get ugly! Also just run "show variables" to see the differences in the default configs. Also you did not say if both machines were the sa

RE: MySQL Performance on Dual Processor machine

/etc/my.cnf isn't installed by default. Try my-huge.cnf (I think) Also, did you use mysql-max on the new one and mysql on the old (just wondering) This is what I use for a 1 Gig RAM single processor machine: [mysqld] set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable =

Re: lost root password trouble

Try GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; Or you could always do a straight INSERT INTO user VALUES('%','root',password('mypassword'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); james --- Nick Wilson wrote: Well, I'm in !! Now I'

RE: How do I find duplicate records?

Thank you for the email. Following is the php code but it doesn't work. 1 "; $result1 = mysql_query($query); while ($row = mysql_fetch_array($result1)) { echo "$row[id]"; } } ?> Best regards, James --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > [sn

RE: How do I find duplicate records?

[snip] I have over 68,000 records in a table with unique ID field that has 10 chars. Need to create a query to find all matching or duplicate IDs up to 8 chars. (Eg. 12345678%%) Can anyone help me? [/snip] Try select ID from tblFOO group by ID having count(*) > 1 HTH! Jay Blanchard Applica

RE: mySQL & PervasiveSQL

[snip] Now here's a bit of an oddball question: I am building a php/mysql web app that will be linking with an accounting system in PervasiveSQL. Right now the various pieces of the web app are built in mySQL. Is there a way to do JOINS between tables in the two different databases? [/snip] Th

RE: lost root password trouble

Nick, Everything you need to know will be in the defaults file you provided when starting mysqld deamon. Study the following pages very carefully: http://www.mysql.com/doc/C/o/Command-line_options.html http://www.mysql.com/doc/O/p/Option_files.html As for where the databases are *really* located,

How do I find duplicate records?

Hi All, I have over 68,000 records in a table with unique ID field that has 10 chars. Need to create a query to find all matching or duplicate IDs up to 8 chars. (Eg. 12345678%%) Can anyone help me? Thanks in advance for any comments. James _

Re: lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then James Carrier declared > It's OK Nick - it started. It's just writing that to the terminal > window. Hit enter to get the command prompt back (or ctrl-c if that > doesn't work). Ahhh,,, what a donkey (me not you) of course it 'ha

MyODBC Question

I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. SQL question.. ---

RE: MySQL Performance on Dual Processor machine

[snip] I would suspect other things first such as the my.cnf configuration (show variables) or has the kernel been optimised on the old box. Did you check kernel configurations and disk subsystems? Also the default process size on FreeBSD is 256Meg, so more memory won't help much unless you use

AW: my.cnf

Hi, normaly my.cnf is in the share directory of mysql (with RedHat this normaly is /usr/share/mysql). You just have to take one of the predefined (my-huge.cnf,my-large.cnf,my-small.cnf etc) and copy it to /etc (renaming it to my.cnf) .. That's all I think. Stefan -Ursprungliche Nachricht---

Re: lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then James Carrier declared > Do you have permissions over the mysql directories? Certainly do. > Can you start safe_mysqld as root? (purely for problem solving > purposes ;) Yep, well at least before it 'hangs' > And of course - are yo

mySQL & PervasiveSQL

Now here's a bit of an oddball question: I am building a php/mysql web app that will be linking with an accounting system in PervasiveSQL. Right now the various pieces of the web app are built in mySQL. Is there a way to do JOINS between tables in the two different databases? Andrew Hazen, O.C

Re: MySQL Performance on Dual Processor machine

Hi, I don't have any experience with FreeBSD; however, I use MySQL on SMP servers with Linux. 1. due to MySQL architecture (1 thread per connection) you should not expect any performance inprovement on a dual processor for a SINGLE SQL query compared to an uniprocessor machine. This is what

Re: MySQL Performance on Dual Processor machine

Hi Jay, There are other things that could be affecting the performance besides mysql. If both machines are idle. The long query should run about the same on the new machine. One thread will only run on one processor no matter how you compile mysql. For compiling MySQK on FreeBSD use the por

Re: lost root password trouble

Ah... Do you have permissions over the mysql directories? Can you start safe_mysqld as root? (purely for problem solving purposes ;) And of course - are your databases in /var/lib/mysql? james Nick Wilson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > * and then Gerald Clark

Re: Good color coded SQL editor for MySQL?

I find textpad (www.textpad.com) is a really great text editor. can even download modules for php, js, etc, etc... Shaun - Original Message - From: "Paul W. Reilly" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 2:05 PM Subject: RE: Good color coded SQL editor

RE: Good color coded SQL editor for MySQL?

I'm rather fond of GTE (GWD Text Editor) myself -- http://www.gwdsoft.com -JF > -Original Message- > From: Jerry [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 6:37 AM > To: MySQL General List > Subject: Good color coded SQL editor for MySQL? > > > Does anyone know of a goo

Re: lost root password trouble

It's OK Nick - it started. It's just writing that to the terminal window. Hit enter to get the command prompt back (or ctrl-c if that doesn't work). james Nick Wilson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > * and then James Carrier declared > >>It'll be something

my.cnf

I just installed MySQL 3.23 RPM binary for Linux. After installation I am missing my.cnf. Any idea what I'm doing wrong? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: lost root password trouble

Nick, There is (at least) one other way of doing this. 1. Shutdown myql 2. Go grab a copy of one of the unix binary downloads. 3. Go into your data directory, rename the directory called mysql to mysql_bak or something equally original. 4. Untar the binary distribution in some safe locat

Re: lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared > Are your databases in /var/lib/mysql ?IT is trying to startup with reading > databaseses from that path but i think it can't.. > Also check the error log file to see what's going on. Sounds reasonable, 2 quest

Re: lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gerald Clark declared > >Well, that's certainly progress of sorts :-) > >It's just 'hanging' now. It says 'starting mysqld daemon with databases > >from /var/lib/mysql' and just hangs > > > It just wrote that message over the comma

MySQL double quote problems

Does anyone know why this is happening? It seems like the double quote matching isn't working... -- Nick mysql> SELECT count(id) FROM products WHERE MATCH (SearchData_AutoUpdate) AGAINST ('"socket abcde"' IN BOOLEAN MODE) order by MATCH (SearchData_AutoUpdate) AGAINST ('"socket abcde"' IN B

RE: Good color coded SQL editor for MySQL?

Several to choose from. I am currently working with MySQL-Front (pretty good). I am also trying out Case Studio Lite (Okay-better for data modeling). I really like PrimalScript (www.sapien.com) but it is expensive at $280. If you can deal with a little less function try notetab or UltraEdit.

RE: lost root password trouble

Are your databases in /var/lib/mysql ?IT is trying to startup with reading databaseses from that path but i think it can't.. Also check the error log file to see what's going on. Gurhan -Original Message- From: Nick Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 1:33 P

Re: lost root password trouble

Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then James Carrier declared > >>It'll be something like: >> >>/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables >> > >Well, that's certainly progress of sorts :-) >It's just 'hanging' now. It s

MySQL Performance on Dual Processor machine

Howdy all, We have a curious situation here, and I was wondering if any of you have encountered this before. We have MySQL installed on a FreeBSD machine (733mHz, 256Mb RAM). Compiled from source. We installed MySQL on another FreeBSD machine (dual 866mHz, 512Mb RAM). Compiled from source. The

INSERT INTO ..... SELECT

I am having problems with this INSERT INTO, below is a example. The SQL is built in an ASP page and ASPVariable is, well the variable in the ASP page. For some reason this will only insert the first row. In my test data the SELECT alone returns 3 rows, but when added to the INSERT INTO only one

RE: confirm unsubscribe from mysql@lists.mysql.com

That is exactly what happened. I have already apologized and sent off an unsubscribe message with the correct email address. Brandy -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:00 PM To: mysql Cc: Steve Buehler Subject: Re: confirm un

Re: Good color coded SQL editor for MySQL?

On Tue, Apr 30, 2002 at 09:36:44AM -0400, Jerry wrote: > > Does anyone know of a good color coded SQL editor for MySQL that > works in Windows? GNU Emacs and sql-mode. :-) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell:

Re: confirm unsubscribe from mysql@lists.mysql.com

I stll think it was that crazy worm. MS -Original Message- From: Keith C. Ivey <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Cc: Steve Buehler <[EMAIL PROTECTED]> Date: Tuesday, April 30, 2002 11:23 AM Subject: Re: confirm unsubscribe from [EMAIL PROTECTED] On 30 Apr 2002, at 11:00,

Re: lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then James Carrier declared > It'll be something like: > > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables Well, that's certainly progress of sorts :-) It's just 'hanging' now. It says 'starting mysqld daemon with da

RE: Large Tables

It has been my (unfortunate) experience that OLAP type applications are not MySQL's strong point. Large dataset applications involving queries that perform aggregations, and scan most/all of the dataset tend to take a very very long time to execute on MySQL even when using a star-schema (although

Re: lost root password trouble

Hi Nick It'll be something like: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables Cheers james Nick Wilson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi everyone, > I have searched the archives and read the manual but am at a loss as to > how to get my

Re: Number Of Records in a Table

At 12:13 -0400 4/30/02, Andrew Kuebler wrote: >Everyone on this list has been very helpful so far. I greatly appreciate >all the help! > >I use Perl/DBI with MySQL. Normally to count records, I pull a query >like: > >$a = $db->prepare("SELECT * FROM table"); >$a->execute; > >Then: > >$numrows = $a

RE: confirm unsubscribe from mysql@lists.mysql.com

Actually it was my fault. I made an error by copying the unsubscribe line from his message and not seeing that it was specific to his email account. I am a rookie to the listservs. Brandy -Original Message- From: Woolsey, Fred [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 1:4

Re: Number Of Records in a Table

$a = $db->prepare("SELECT COUNT(table.column) FROM TABLE"); $a->execute - Original Message - From: "Andrew Kuebler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 12:13 PM Subject: Number Of Records in a Table > Everyone on this list has been very helpful so

Re: Deadlock errors - Can nobody help??!!

Hi. On Tue, Apr 30, 2002 at 04:54:27PM +0100, [EMAIL PROTECTED] wrote: [...] > >(From http://www.sleepycat.com/docs/ref/transapp/put.html - did not > >find an explanation in the MySQL manual :-( ) > > > This reference is very useful, actually. If I modify my test program to > detect the deadloc

lost root password trouble

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi everyone, I have searched the archives and read the manual but am at a loss as to how to get my root password back (or change it) The trick appears to be to start mysqld with --skip-grant-tables but I can't seem to do it. Here is what I've done:

RE: confirm unsubscribe from mysql@lists.mysql.com

Steve, Hmmm... I wonder if this is a result of the 'Klez' worm... may not be her fault! FCW -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:00 PM To: mysql Cc: Brandy Trudeau Subject: Re: confirm unsubscribe from [EMAIL PROTECTED] Any

RE: confirm unsubscribe from mysql@lists.mysql.com

I think I could live with that. Steve At 11:17 AM 4/30/2002, Brandy Trudeau wrote: >OMGI am s sorry! I was trying to unsubsribe myself. Again...I am >very sorry. I am new to the listserv concept and didn't check the address >before I sent the email. > >Brandy > >-Original Message---

Number Of Records in a Table

Everyone on this list has been very helpful so far. I greatly appreciate all the help! I use Perl/DBI with MySQL. Normally to count records, I pull a query like: $a = $db->prepare("SELECT * FROM table"); $a->execute; Then: $numrows = $a->rows; to get a total count of records in the table. Is

Re: confirm unsubscribe from mysql@lists.mysql.com

Anybody know who this Brandy person is and why she is trying to unsubscribe me? Has anybody else had this child trying to unsubscribe them? "Brandy Trudeau" <[EMAIL PROTECTED]> Thanks Steve At 07:49 AM 4/30/2002, [EMAIL PROTECTED] wrote: >Hi! This is the ezmlm program. I'm managing the >[EMAI

Re: Deadlock errors - Can nobody help??!!

Benjamin Pflugmann wrote: >>>[...] Which table >>>type (MyISAM/InnoDB/BDB) do you use? Do you intend to use transactions >>>or not? >>> >>I am using BDB tables, and I am making use of transactions. >> >Okay, than that is the reason for the deadlocks and it is to be >expected, as far as I understa

Re: Large Tables

Hi, I run something similar, apx 11 Gb MyIsam + 9 Gb index per month and I use a merge table on top of sevral 9-11 Gb tables. I dont think you need to have a merge table if doesnt bring you any other advantages, eg. cycling of tables. RH 7.2 + 2.4.18 kernel, ReiserFs Compaq 4 way XENON, fiber

RE: MySQL running out of Hard drive space

Mike Try moving the datadir to your home partition. This is a variable in the my.cnf config file. I just did this on an NT box. You will have to stop mysql, change the config file, move your current data dir to new location and restart mysql. David -Original Message- From: Mike Mike [ma

Data Directory

I installed MySQL4.0 source on my redhat7.2 linux server it compiled and make intall fine with no problems execpt that i chose to install it in /databases/mysql/ rather than /usr/local/mysql/ so i did this by typing this instead ./configure --prefix=/database/mysql rather than ./configure --pr

setup confusion

Hi there Server: i386 System: LAMPS (Suse Linux 8.0, Apache, MySQL, PHP, SSL) I've installed MySQL now several times and I am running already two databases. Sounds if I would have understood how things working? I still don't know where the mysql-stuff actually is. Now I want to set up a new se

mysql: 15 tables equi-join problems

Hi, Do anyone know there may be a limitation in mysql to do a 15 tables equi-join? I did some experiment with it if I only do 10 tables equi-join, it takes seconds to retrieve the results, but if I do more than 10 tables, it took forever and run with 100% CPU time to execute the query. The

Re: Mandatory Fields

Hi. On Tue, Apr 30, 2002 at 03:31:25PM +0200, [EMAIL PROTECTED] wrote: > Dear Sir > > I want to ask how can i assign a field as mandatory and other as > optional using the Mysql Database. If you mean that you want a query to fail, if a specific field is not specifed, you to declare the columns

Re: MYSQL question - Urgent

Hi. Sorry, but I beg to differ. I think it is not a good idea to recommend to others to run the MySQL server as root. The manual explicitly recommends otherwise. On Mon, Apr 29, 2002 at 10:15:31PM -0600, [EMAIL PROTECTED] wrote: > > Questions: > - Do I use root account to install the software?

RE: Good color coded SQL editor for MySQL?

> From: Jerry [mailto:[EMAIL PROTECTED]] > > Does anyone know of a good color coded SQL editor for MySQL that > works in Windows? Visual Studio? You get keywords in blue, anyway. Tim Ward Brett Ward Limited - www.brettward.co.uk ---

Re: Good color coded SQL editor for MySQL?

Mysql-front is v.good, www.mysqlfront.de i think. james Jerry wrote: >Does anyone know of a good color coded SQL editor for MySQL that >works in Windows? > >TIA, >Jerry > > > - Before posting, please check: http://www.m

Re: foreign key / duplcation / optimization

At 08:29 29/04/02 -0700, Jeremy Zawodny wrote: >On Mon, Apr 29, 2002 at 01:06:02PM +0100, David Hanney wrote: > > > I've got a nice fat varchar(255) primary key who's content is > > duplicated (as a foreign key) in many other tables. I hope MySQL > > optimizes away that duplication internally. >

Large Tables

I need to use some large tables using MySQL under Linux and would welcome suggestions from anyone with any experience. Currently one months data creates a table of 3M records about 750Mb in size. I should like to consolidate 12 Months data (which is expected to grow to say 50M records per month) s

How to query SET OPTION variables?

Hi. Maybe I am blind, but I cannot find, how I can query the status of one of the variables I can set with SET OPTION. I.e. if I do SET OPTION SQL_AUTO_IS_NULL 1 SET OPTION AUTO_COMMIT 1 What is / is there a way to query to current value? I stumbed upon this, when I wanted to recommend to som

MySQL running out of Hard drive space

Hello, I have made a couple of partisions in Linux. Somehow MySQL got installed in a partision that doesn't have a lot of space and i'm running very low. How do I add more space to that directory or partision? I have a lot of space on my user partision and my home partition. Is there a command in

RE: Mandatory Fields

DEpending on the table layouts you can use NOT NULL, UNIQUE, ENUM(), column types and definitions.. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/C/o/Column_types.html Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-47

Re: Problems setting up database for PHP/MySQL

Am Dienstag den, 30. April 2002, um 03:24, schrieb Dicky Wahyu Purnomo: > On Mon, 29 Apr 2002 08:22:07 -0700 > John Clark <[EMAIL PROTECTED]> wrote: > >> 'm trying to set up the database link between apache+php and >> mysql. The error messages that I get have suggested the user >> 'httpd' does n

Re: Deadlock errors - Can nobody help??!!

Hello. First, my apologies, if my answer sounded too harsh. It wasn't meant personally, but after answering ten or more mail with too few details, one gets somehow bored, you know. ;-) On Tue, Apr 30, 2002 at 09:29:41AM +0100, [EMAIL PROTECTED] wrote: [...] > and referred by date to the original

Re: FW: I need an example on DELETE /UPDATE with JOIN syntax

Vadim, Monday, April 29, 2002, 7:10:27 PM, you wrote: V> My company migrated to MySQL a few months ago from Sybase Adaptive V> Server Anywhere. Where I'm very impressed with the performance and the V> simplicity of management I find its very difficult, however, to run V> regular updates or delete

Re: Re: Stuck Some More

Ian, Sunday, April 28, 2002, 5:18:57 AM, you wrote: IP> In reply to Egor's request... Egor>> > Ian, show me the contents of your .err file (the last IP> 20-40 rows) IP> This is the total contents of this file. IP> /nfs/usr/libexec/mysqld: ready for connections IP> /nfs/usr/libexec/mysqld:

Re: Follow-up DELETE ISSUE

Andrew, Tuesday, April 30, 2002, 5:33:27 AM, you wrote: AW> Thank you very much for the leads. I looked at the section in the manual AW> and still have a few questions (I have added some more info which might AW> help). AW> As a reminder my problem was ... >> AW> I have a DELETE statement: >>

Re: start up problem

Cindy, Monday, April 29, 2002, 8:03:24 PM, you wrote: I combine into one all your postings C> OK, it seems like every time I install mysql, I run smack dab into C> some type of access problem -- if it isn't a password hangup, it's a C> mysql.sock problem or (at the moment) a refusal to allow me

Re: MySQL lost connection problems with PHPLib classes

Ivan, Monday, April 29, 2002, 11:29:31 PM, you wrote: IS> We use the PHPLib classes for our website. IS> ( http://phplib.sourceforge.net/ ) IS> Now we have a lot of lost connection problems when we use 2 or 3 different IS> db queries with different db tables ! IS> . IS> $db = new newsDB();

Re: Mandatory Fields

Mohamed, Tuesday, April 30, 2002, 4:31:25 PM, you wrote: MF> I want to ask how can i assign a field as mandatory and other as MF> optional using the Mysql Database. Take a look at the MySQL manual: http://www.mysql.com/doc/C/R/CREATE_TABLE.html There is a description of CREATE TABLE synta

Re: Can't get the lower_case_file_names variable to change

Flowers, Monday, April 29, 2002, 9:00:53 PM, you wrote: Feoen> I can't change the lower_case_file_names variables using the -O Feoen> lower_case_file_names=1 parameter to either the mysqld or the Feoen> /etc/rc.d/init.d/mysql script. Neither mysqld -O lower_case_file_names=1 or Feoen> /etc/rc.

Re: mysql_real_query and escaping a semicolon

Hi! > "Anna" == Anna Fowles-Winkler <[EMAIL PROTECTED]> writes: Anna> I removed the semicolon from the end of the query string, and I still get the Anna> same syntax error: Anna> You have an error in your SQL syntax near ''.1' at line 10 Anna> This is what the query looks like: Anna> INSE

RE: MYSQL question - Urgent

Hi Lucia.. 1- The answers might/will be depent on what type of installation you are planning to do. Will you compile source code, or install binaries, or , since you said you would be installing on Linux, will you install from RPMs? 2 - Yes , you need to do the installation as root . 3 - There

_complicated_ isnull(to_days()) problem 3.23.47 and 3.23.49

>Description: See "How-To-Repeat" >How-To-Repeat: vrm@food:~$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 236 to server version: 3.23.47 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use bugtest Dat

Re: Good color coded SQL editor for MySQL?

Try urSQL (http://www.urbanresearch.com/ursql) -- it's got a very customizable editor... On Tue, 30 Apr 2002, Jerry wrote: > Does anyone know of a good color coded SQL editor for MySQL that > works in Windows? > > TIA, > Jerry k -

  1   2   >