Lots of whitespace on your homepage

Hello, I don't know why, but when I visit your site I only see the navigation bar at the top of my browser. All content, eg. the company information is far below the bottom of a full screen browser window. Only the main page (//www.mysql.com/) displays correctly (I suppose). This behaviour

thread_cache . what is it ? (no newbie question) .

Hi . Simple but still tricky question : what mean 'thread' in mysql's server point of view ? I've set the thread_cache_size=30 in my.cnf . I use Mysql with Php and my aplication's behaviour is like this : connect - select update insert select etc..

INSERT INTO from a SELECT does not work?

Hello, I'm trying to run the following SQL statement on a table of my MySQL DB: insert into MYTABLE(ID, VALUE, SORTKEY) select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by T.ID This was suggested by a SQL expert (which I'm unfortunately not) , and works perfectly on MS

Extracting foreign key info via ODBC (via JDBC)

Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods DatabaseMetaData.getImportedKeys(...) and DatabaseMetaData.getExportedKeys(..)

Is it possible to backup a corrupt database without being root?

Hello, I`ve got myself into a bit of a mess by allowing my raq3's 200mb var partition to fill up. This means I can no longer login to my server as root, because a log file of my login cannot be created. Naturally only root can delete or move any files in /var to fix this problem :o Anyway,

Re: Is it possible to backup a corrupt database without beingroot?

on 12/19/2002 5:00 PM, Paul Nolan at [EMAIL PROTECTED] wrote: I`ve got myself into a bit of a mess by allowing my raq3's 200mb var partition to fill up. This means I can no longer login to my server as root, because a log file of my login cannot be created. Naturally only root can delete or

Re: Programmatic MySQL backup in Perl

Hello, I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option. When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB JeffsDB.sql I get: ERROR 1065 at line 21: Query was empty Now, line 21 of the SQL file contains: /*!4

add one more innodb_data file when I do have an autoextending one?

I have an production MySQL-Max -3.23.54a server running innodb databases. I've migrated the server and data from an older Linux installation (with max filesize 2GByte). The new server is running Linux 2.4 and can deal with larger files. I have three in innodb_data files and the last one is

minor problem with ALTER TABLE

I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so I expected to get an error. Instead, the table type has been set to MyISAM, wich is the default type. I think this is a bug, if it isn't I think this behavoir should be changed. --

Re: Compile 3.23.53 error on HPUX 11.11

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 16 Dec 2002, Zengfa Gao wrote: I just send the one again, hope to find someone to help me out with MySQL compile. I am using HPUX 11.11, gcc 3.1. 1. CFLAGS=-fomit-frame-pointer -O3 -fpic CXX=gcc CXXFLAGS=-felid-constructors

MySQL 4.0.6 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.6, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.

DISTINCT on one collum

MySQL as the filter stupidly does not match SELECT Hiya, How do you get a disctinct value from one collumn only? I am basically using it to construct a dynamic menu, and need the menu names at a level. Items are in one table, like CATEGORY, SUBCATEGORY, SUBSUBCATEGORY, PAGE, ID I

RE: Help w/ Join Query

SELECT * FROM t1,t2,t3 WHERE t1.img_id=t2.img_id AND t2.caption_id=t3.caption_id Adolfo -Original Message- From: mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 8:15 PM To: [EMAIL PROTECTED] Subject: Help w/ Join Query Hello, I working on a small my

Re: INSERT INTO from a SELECT does not work?

At 9:30 +0100 12/20/02, Thierry Michalowski wrote: Hello, I'm trying to run the following SQL statement on a table of my MySQL DB: insert into MYTABLE(ID, VALUE, SORTKEY) select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by T.ID You can't insert into the same table that

Re: minor problem with ALTER TABLE

At 18:31 +0800 12/20/02, Federico Razzoli wrote: I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so I expected to get an error. Instead, the table type has been set to MyISAM, wich is the default type. I think this is a bug, if it isn't I think this behavoir should be

mysqlimport access denied errors

Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql grant all on db1 to user1@localhost -and it appears to work fine. However when as the solaris user 'user1', I

4.1 Download

Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

mysqlbinlog segfaults with host args

$ mysqlbinlog --host=mysqlserver --table=sometable --database=somedb \ --user=someuser --password=somepassword Segmentation fault. $ strace mysqlbinlog --host=mysqlserver --table=sometable \ --database=somedb \ --user=someuser --password=somepassword (...) old_mmap(NULL, 1203040,

mysqladmin access denied error

Hi, I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the

Re: Suitability of mySQL for desktop use?

Dan, I don't believe I will be placing stressful demands on the database/PC. I will be querying about a dozen tables varying in size from 100 records up to around 500,000 records each. Do you agree? What are you doing by comparison? Are you using the Zeos components to access mySQL from Delphi?

Re: add one more innodb_data file when I do have an autoextending one?

Lars, - Original Message - From: Lars Andersson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, December 20, 2002 12:17 PM Subject: add one more innodb_data file when I do have an autoextending one? I have an production MySQL-Max -3.23.54a server running innodb

Re: 4.1 Download

On Friday 20 December 2002 14:14, Anthony W. Marino wrote: Where/how can I get a copy of 4.1? Thanks, Anthony http://www.mysql.com/doc/en/Installing_source_tree.html Regards Georg filter: mysql, query - Before posting,

Re: 4.1 Download

Dobrý den, sexta-feira, 20 de dezembro de 2002, 11:14:04, napsal jste: AWM Where/how can I get a copy of 4.1? AWM Thanks, AWM Anthony AWM sql,query,queries,smallint AWM - AWM Before posting, please check:

Re2: 4.1 Download

oohhh, sorry the corrent page is : http://www.mysql.com/doc/en/Installing_source_tree.html sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento

Re: /etc/my.cnf does not contain innodb_log_files_in_group.

Hi! For the record, I exchanged email with Kip, and it turned out he had forgotten to add the keyword 'set-variable' to the my.cnf line. It should be set-variable=innodb_log_files_in_group=... Note that the default is 2 if you have not specified this previously in your my.cnf. I read from the

crash if etc/hosts misconfigured

Description: I'd a /etc/hosts misconfigured, it told that the machine name was linux200 with IP 192.168.0.3 but eth0 was configured to use IP 192.168.0.16. In this enviroment executing this command mysql -h 192.168.0.16 cause a mysqld crash. Correcting /etc/hosts to report the correct

Re: 4.1 Download

http://www.mysql.com/newsletter/2002-10/a79.html - Original Message - From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 1:14 PM Subject: 4.1 Download Where/how can I get a copy of 4.1? Thanks, Anthony

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this

re: 4.1 Download

On Friday 20 December 2002 15:14, Anthony W. Marino wrote: Where/how can I get a copy of 4.1? You can install it from development tree using BitKeeper: http://www.mysql.com/doc/en/Installing_source_tree.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita

re: DISTINCT on one collum

On Friday 20 December 2002 13:35, Steve Vernon wrote: MySQL as the filter stupidly does not match SELECT Hiya, How do you get a disctinct value from one collumn only? I am basically using it to construct a dynamic menu, and need the menu names at a level. Items are in one table,

re: minor problem with ALTER TABLE

On Friday 20 December 2002 12:31, Federico Razzoli wrote: I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so I expected to get an error. Instead, the table type has been set to MyISAM, wich is the default type. I think this is a bug, if it isn't I think this behavoir

re: Tables read only

On Friday 20 December 2002 04:48, cable at ionbits dot net wrote: i cant create SQl tables andoso cant del the tables.. it always shows table is read only.. anyway to solve? Is your table packed with myisampack utility? Check also that MySQL server has permissions to write in these files.

re: INSERT INTO from a SELECT does not work?

On Friday 20 December 2002 10:30, Thierry Michalowski wrote: I'm trying to run the following SQL statement on a table of my MySQL DB: insert into MYTABLE(ID, VALUE, SORTKEY) select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by T.ID This was suggested by a SQL expert

re: mysqldump user prive

On Thursday 19 December 2002 21:29, Arun kumar R wrote: I want to run mysqldump through a batch process, in order to do that what prive do i need to give to the user. It will be running as a cron job, i don't want to give any creation or deletion authorization. Your help will be greatly

ANN: EMS MySQL Utils 1.2 released!

EMS HiTech Company is announcing the next version (1.2) of MySQL Utils -- Powerful Windows/Linix Data Management Utilities for MySQL Server. You can download the latest version from http://www.mysqlutils.com/download.phtml. What's new in version 1.2? 1. MySQL Export: export to MS Access added

MySQL BUG

Hi, I am facing strange problem while accessing a LONGTEXT field. I've been using VisualBasic 6.0 MySQL 4.0.4 via ADO 2.0 by using MyODBC 3.51.04 on WIN2k Server (SP 2). Pls follow the below steps to generate a bug -- '/' 1. Create a Table

Re: mysqlimport access denied errors

At 13:04 + 12/20/02, Imran Khan wrote: Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql grant all on db1 to user1@localhost -and it appears to work fine.

Is innodb still beta in MySQL-Max-3.23.54a?

Is Innodb still beta in MySQL-Max-3.23.54a? If not, I am thinking of making the move. :) Thanks! - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Extracting foreign key info via ODBC (via JDBC)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods

Best Windows MySQL client?

What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? Thanks, Jeff - Before posting, please check:

Re: 4.1 Download

i wish to know too! thanks --- Anthony W. Marino [EMAIL PROTECTED] ha scritto: Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before

Restoring db from mysqldump output problem...

Hello, I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option. When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB JeffsDB.sql I get: ERROR 1065 at line 21: Query was empty Now, line 21 of the SQL file contains: /*!4

4.0.6 Standard for Windows.

There does not seem to be a windows download for 4.0.6 Standard on the downloads page. There is a version on the Max page.Is this an oversight or intentional? Which version should I be using with Classic commercial licence? The downloads page says that the standard version includes InnoDB, which

Re: Extracting foreign key info via ODBC (via JDBC)

Mark Matthews wrote: Alan Hodgkinson wrote: I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods

Using PHP to do a MySql Dump

Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual)

[ANN] Lasso Professional 6.0.1 Update Contains Updated MySQL

If you're looking for Web application server alternatives that work extremely well with MySQL, Blue World recently announced the Lasso Professional 6.0.1 Update which includes the latest 3.23.54 build of MySQL. If interested, check out the following support article:

Badly placed ()'s and also access denied

Being the newbie that I am I get this Badly placed ()'swhen I try to do a mysql_connect(localhost,gary,password); I have a php script that gives me a Access denied for user: 'gary@localhost' to database 'CONTACT'Can't Select CONTACT1046: No Database Selected When the runs. I

Re: Extracting foreign key info via ODBC (via JDBC)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Mark Matthews wrote: [snip] First, you need to use InnoDB tables to be able to extract foreign key information. Ah.. thank you. I had though that native tables in the newer MySQL version, stored and we able re-display,

Re: thread_cache . what is it ? (no newbie question) .

Hi. On Fri 2002-12-20 at 10:13:57 +0200, [EMAIL PROTECTED] wrote: Hi . Simple but still tricky question : what mean 'thread' in mysql's server point of view ? I've set the thread_cache_size=30 in my.cnf . I use Mysql with Php and my aplication's behaviour is like this : connect -

re: 4.1 Download

On Fri, 20 Dec 2002, Victoria Reznichenko wrote: On Friday 20 December 2002 15:14, Anthony W. Marino wrote: Where/how can I get a copy of 4.1? You can install it from development tree using BitKeeper: http://www.mysql.com/doc/en/Installing_source_tree.html Is it true that the host

RE: Accessing last_insert_id problem.

Jeff Snoxell wrote: At 09:46 19/12/02 -0500, you wrote: Jeff Snoxell wrote: Nope. That doesn't do it either! I go: TRUNCATE TABLE my_table Are you using InnoDB tables? You'll have to do something akin to ALTER TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :)

time of query

Glad to greet you all, ladies and gentelmen! I have written a dynamic web page in Perl to display some kind of statistical information usefull for my company. My question: how can I get the time which MySQL returns after the query? For example: MySQL returns a line like this 870 rows in set

SQL Get access denied when trying to create a database

Now I get an access denied even trying to create a mysql database which is weird because I just created one an hour ago the same way. Thanks Gary - Before posting, please check: http://www.mysql.com/manual.php (the

CREATE TABLE issue?

Hi again :) I found the following mysql stuff in the MySQL manual in a section explaining how to do relationships. CREATE TABLE persons ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) ); CREATE TABLE shirts ( id SMALLINT UNSIGNED NOT

user password issue help ?!?

Hello ... my name is Brent ..and im using the latest version of mysql on a Freebsd box with apache php3 php4. My problem is that ive set a password for the root mysql user by doing: /usr/local/bin/mysqladmin -u root password 'x' then i installed phpMyAdmin ..and set the correct username

send_file() : Failed reading file name ?

Hi all, We got this spurios error message the other day in our .err file and haven't been able to figure out exactly what it is. 021219 14:10:37 failed in send_file() : Failed reading file name we checked the tables and everything seemed fine. anyone have any ideas? mysql Ver 11.18 Distrib

re: INSERT... SELECT Statement fails when...

On Thursday 19 December 2002 19:19, Andrew Kuebler wrote: When I run an INSERT. SELECT query and I am inserting the records into a new table that has a UNIQUE key, the statement will fail as soon as it hits a Duplicate entry error. No further entries will be inserted. The only way I know to

Re: Best Windows MySQL client?

Greetings I prefer SQLyog. You can download it at http://www.webyog.com/sqlyog/download.html Its free, compact and has lot of features. Insane - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:54 PM Subject: Best Windows

RE: Using PHP to do a MySql Dump

You could do an SELECT * INTO OUTFILE (the documentation is on mysql's website). --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Using PHP

Re: Using PHP to do a MySql Dump

Upon initial search, does not appear to be. except: exec(mysqldump) or system(), or shell_exec() Maybe the PHP list would render better results? HTH -Brad Todd Cary wrote: Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software,

Re: Is it possible to backup a corrupt database without being

I can FTP and telnet in to my site as admin or a user, but all the files in /var are owned by root so cannot be deleted, with the exception of several mysql files owned by mysql, which I also cannot move or delete :( If I could extract the info in the database I could delete that remotely,

Indexes That Span Columns...

I have the following table; I renamed the columns a b for easy reading: ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY, aID INT(9), bID MEDIUMINT(7), UNIQUE ab (aID, bID) INDEX b(bID) As far as I understand the UNIQUE INDEX also provides the index for aID, but not bID. Is there any other way to

Count and Selects

I'm trying to get a count of records by combining a search from 2 seperate tables. I have both listings and agents as tables. What I need to do is get a agent, ad count for all the agents listed in agents even if they don't have any ads in listings. Here's the query: select name, count(*) as

RE: Badly placed ()'s and also access denied

Problem is not in the connecting it is in the mysql_select_db as you are denied access to the database, not the server. Your permissions might be off or the php might not be right. It would be helpful if you posted more of your code. -Original Message- From: Gary Hostetler

Re: Badly placed ()'s and also access denied

I got it fixed with using the right username and password in the php file. Being a newbie I was actually trying this from the command line not from a php file. I found this by accident and found it nowhere in documentation etc. thanks to all who have helped. Gary On 12/20/02 2:21 PM, Jennifer

i have given up -- bug

I think I'll throw in the towel. Here is the slow performance I'm getting when joining 13 tables. The query simply takes too long. J explain SELECT distinct Medias.pk_media_id, Organisms.common_name, Tissues.type As tiss_type, Cells.type As cell_type, Organelles.type As org_type,

Extracting information from a list contained in Varchar file

I have a question on the following query statement: SELECT content_title, content_category, content_order, content_name1 FROM content INNER JOIN category ON content.content_category = category.category_id WHERE content_category = 'Intbk' Union Select content_title, content_category,

Extracting information from a list contained in Varchar file

I have a question on the following query statement: SELECT content_title, content_category, content_order, content_name1 FROM content INNER JOIN category ON content.content_category = category.category_id WHERE content_category = 'Intbk' Union Select content_title, content_category,

RE: SQL Get access denied when trying to create a database

With the same user? It sounds like you might want to read the documentation on GRANT and permissions. It is always a good idea to try the documentation before asking questions on the list. http://www.mysql.com/doc/en/User_Account_Management.html -Original Message- From: Gary

Re: CREATE TABLE issue?

At 17:13 + 12/20/02, Jeff Snoxell wrote: Hi again :) I found the following mysql stuff in the MySQL manual in a section explaining how to do relationships. CREATE TABLE persons ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) ); CREATE

Re: time of query

In the last episode (Dec 20), Vitali Malicky said: Glad to greet you all, ladies and gentelmen! I have written a dynamic web page in Perl to display some kind of statistical information usefull for my company. My question: how can I get the time which MySQL returns after the query? For

RE: MySQL BUG

MsgBox 1 -- Data provider or other service returned an E_FAIL status. Been there, done that (so have a lot of people via my research). Not so much a MySql thing as it is a Microsoft thing - I was seeing similar messages with not only MySql, but also Microsoft SQL (ADO and E_FAIL). Like

Re: Using PHP to do a MySql Dump

AFAIK, there is no built-in function in PHP for a dump. That's at least what the manual says. An alternative is to use a system call e.g. system() or exec() with mysqldump. Hope that helps, Claudia From Todd Cary [EMAIL PROTECTED] on Fri, Dec 20, 2002 at 08:35:02AM -0800 Is there a function

RE: SQL Get access denied when trying to create a database

All is well and yes I find any documentation that I can find..thanks Gay -- Original Message -- From: Jennifer Goodie [EMAIL PROTECTED] Date: Fri, 20 Dec 2002 11:57:09 -0800 With the same user? It sounds like you might want to read the documentation on

Re: time of query

I don't think MySQL can give you back the execution time via DBI, but you might be able to calculate something similar from the Perl side by calculating how long the script runs overall. Here's a good thread from perlmonks about how to do it: http://perlmonks.org/index.pl?node_id=35318 -bill

Re: 4.1 Download

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thomas Spahni wrote: On Fri, 20 Dec 2002, Victoria Reznichenko wrote: On Friday 20 December 2002 15:14, Anthony W. Marino wrote: Where/how can I get a copy of 4.1? You can install it from development tree using BitKeeper:

RE: Count and Selects

I am new at this, but if listings and agents are both tables I do not see a reference in the select statement: select name, count(*) as cnt from agents as p1, listings as p2 where p1.name = p2.agent; Or something like that Chuck http://68.43.100.7:81/aa8vs

RE: Is it possible to backup a corrupt database without being

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] I can FTP and telnet in to my site as admin or a user, but all the files in /var are owned by root so cannot be deleted, with the exception of several mysql files owned by mysql, which I also cannot move or

RE: CREATE TABLE issue?

Missing TYPE=INNODB in create table statement. MySQL parses references for type MyISAM but doesn't use them. Adolfo -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 1:14 PM To: [EMAIL PROTECTED] Subject: CREATE TABLE issue? Hi

Re: Indexes That Span Columns...

At 14:12 -0500 12/20/02, Andrew Kuebler wrote: I have the following table; I renamed the columns a b for easy reading: ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY, aID INT(9), bID MEDIUMINT(7), UNIQUE ab (aID, bID) INDEX b(bID) As far as I understand the UNIQUE INDEX also provides the index

Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

Hi all! I wanted to thank the MySQL team for making such a great product! We moved from 3.23 to 4.0.x a couple of months ago and everything works great. Just upgraded to 4.0.6 and glad to see it work out of the box without a rev 4.0.6a. Those glib issues were such a pain! 4.0.5a and 4.0.6 have

MySQL Decimal Column Types Question

Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? For a 10,2 decimal column, should this be a valid number: 1234567890.12? Thanks. MySQL, SQL -- Michael She : [EMAIL PROTECTED] Mobile : (519)

Re: Best Windows MySQL client?

At 03:24 PM 12/20/2002 +, Jeff Snoxell wrote: What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? I've been using EMS HiTech's Trial version of MySQL Manager.

How to convert Varchar data field into a list

After thinking about some, I think I can ask my question in a clean manner. How do I convert a Varchar data field into a list? Can someone tell me what I'm doing wrong? I have a query see below where the value (a varchar) of category.category_common is - 2,3 I add the ( ) in the query below to

update mysql

I e-mailed the list but haven't received a response. I have win2k w/ 3.23.53 and need to update it to 54. Is there a patch or do I have to do a reinstall or install on top of it? mysql - Before posting, please check:

Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote: i like mySQL, but it has a long way to go to gain the level of 'confidence' that oracle, db2 or mssql or sybase have when it comes to frontline mission critical stuff. Can you explain why? I think it will in time...thats why i stick

Re: MySQL Decimal Column Types Question

At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to

Need help revising CREATE TABLE

Greetings and happy holidays! This is a query about how to better structure an existing mysql table. I want to make a rather complex SELECT off an opinion poll. Thus: SELECT Those who answered Q3 as 1 SELECT these people's answers for Q4, Q5, Q6… (Any size array of the rest of the questions.

Hostname resolve issue?

Hi all, Due to the severe security issue released last week for mysql, we had to upgrade all our 3.22.32 servers to the latest 3.23 release. However, this introduced us to some problems across several of our 80+ DB servers: 1. Weird resolve issues: Host A tries to connect to Host B

Re: MySQL Decimal Column Types Question

At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be

redhat 6.1 / 6.2

Hi, In regard to my previous message - I would also be interested if anyone is aware of a general source for MySQL rpm's built for 6.1/6.2. I would prefer to build my own but if I do not succeed I would also be interested in anyone else's. I assume that there are no MySQL supplied rpm's for

Docs make wrong statement about Debians init scripts

Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in Debian GNU/Linux. I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debconf.

Re: Can MySQL handle 120 million records?

At 03:28 PM 12/20/2002 -0800, Jeremy Zawodny wrote: I think it will in time...thats why i stick with it. besides, confidence is often just a synonym for 'knowledge' Really? I tend to see it more like confidence builds with experience (and therefore time). You don't need to know a lot about

rpm source build problems

Hi, I hope this message is not out of place, but I have not been able to solve this problem. I need to rebuild the latest MySQL rpm's for use on some RedHat 6.1/6.2 machines and have been having quite a few problems. I've made sure I have : autoconf-2.52 automake-1.5 libtool-1.4.3 which I

[patch] Error in Makefile prevents complete distclean

Description: The unpacked source differs from the source tree after a ./configure make make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs

Missing -lwrap on mysqld/mysqltest?

Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init'

RE: Suitability of mySQL for desktop use?

Frank, That doesn't sound like it will be a problem for MySQL. I am using the Zeos components. The only caveat that I have about these components is that they are very slow in loading large (more than 3-4 lines) SQL query statements. It is much, much faster to create a data module and create

Re: (In addition...) mysqldump user prive

On Friday 20 December 2002 08:42 am, Victoria Reznichenko wrote: On Thursday 19 December 2002 21:29, Arun kumar R wrote: I want to run mysqldump through a batch process, in order to do that what prive do i need to give to the user. It will be running as a cron job, i don't want to give

Re: MySQL Decimal Column Types Question

From: Michael She [EMAIL PROTECTED] Date: Fri, 20 Dec 2002 21:18:44 -0500 To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Decimal Column Types Question At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all,

happy

Looking for a free email account? Get one now at http://www.freemail.com.au/ - Before posting, please check:

  1   2   >