RE: Table statistics

2002-04-04 Thread andy thomas
On Thu, 4 Apr 2002, Doug Bishop wrote: > Try: > > mysql_connect("localhost", "user", "password"); > $query = "SHOW TABLES;"; > $result = mysql_db_query("databasename", $query); > $i = 0; > while ($row = mysql_fetch_array($result)) > { > $tableNames[$i] = $row[0]; > $i++; > } > for ($

Re: Supporting Transactions and Binary Logs

2002-04-04 Thread Rajeev Rumale
Hi, Yes I have checked the Docs. And even tried to make the entries in the .ini file. But when I doing so the database is not starting. There is no error what so ever. When removed the entires for innodb the data base starts properly. Rajeev - Original Message - From: "Jeremy Zawod

Privileges for backups

2002-04-04 Thread Simon Green
I have got a backup script that locks the MySQL tables then use cp(unix) to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live

RE: Table statistics

2002-04-04 Thread andy thomas
On Wed, 3 Apr 2002, Nick Arnett wrote: > > > > -Original Message- > > From: Doug Bishop [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, April 03, 2002 10:13 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: RE: Table statistics > > > > > > Try: > > > > > mysql_connect("local

RE: Table statistics

2002-04-04 Thread Roger Baklund
* andy thomas > Is there a command I can give in the mysql client to find the number of > rows in a table or, better still, the number of rows in all the > tables in a database? The "normal" way: SELECT COUNT(*) FROM table To get all tables in one statement... this is a hack, I'm not sure it wil

Re: Table statistics

2002-04-04 Thread Georg Richter
On Thursday, 4. April 2002 10:42, andy thomas wrote: > Yes but this is PHP code that can only be run through a suitable web > server, browser, etc - I want a command line solution like mysqlshow ... > or from within the mysql client itself. You can also run PHP from the commandline without any w

Re: Table statistics

2002-04-04 Thread andy thomas
On Thu, 4 Apr 2002, denonymous wrote: > From: "andy thomas" <[EMAIL PROTECTED]> > > > Is there a command I can give in the mysql client to find the number of > > rows in a table or, better still, the number of rows in all the tables in > > a database? > > > To return the # of rows in a table: >

SQL Server to MySQL Using DTS

2002-04-04 Thread Stephen Smithstone
Was wondering has any 1 used DTS in SQL Server 2000 to insert table from a SQL server table into a mysql table Disclaimer & Confidentiality Notice This email, together with any attachments, is for the exclusive and confidential use of the addressee(s). Any other distribution, use or reproduction

Re: Table statistics

2002-04-04 Thread andy thomas
On Thu, 4 Apr 2002, Georg Richter wrote: > On Thursday, 4. April 2002 10:42, andy thomas wrote: > > > Yes but this is PHP code that can only be run through a suitable web > > server, browser, etc - I want a command line solution like mysqlshow ... > > or from within the mysql client itself. > >

Port 3306 restricted to IP addresses

2002-04-04 Thread Tshering Norbu
For the inbound connection on port 3306 of MySQL Server, how do I restrict the connection to some IP addresses something like 1.2.3.* What do I need to do in my.cnf file? Thanks in advance. NOBBY - Before posting, please che

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Dicky Wahyu Purnomo
On Thu, 4 Apr 2002 16:23:09 +0600 "Tshering Norbu" <[EMAIL PROTECTED]> wrote: > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file? > > Thanks in advance. you are playin

Restoring log file enteries.

2002-04-04 Thread Charitha
Hello all, I am having the mysql log file which is having all the queries which affects the data base. I have to restore those queries in the table in some remote server. Is that possible. Any ideas are welcome. Thanks in advance -- Regards, Charitha ---

Re: Restoring log file enteries.

2002-04-04 Thread Dicky Wahyu Purnomo
On Thu, 4 Apr 2002 16:05:57 +0530 (IST) Charitha <[EMAIL PROTECTED]> wrote: > > > Hello all, > > I am having the mysql log file which is having all the queries which > affects the data base. > I have to restore those queries in the table in some remote server. > Is that possible. YAP !!! ;-)

RE: Port 3306 restricted to IP addresses

2002-04-04 Thread Roger Baklund
* Tshering Norbu > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file? Nothing, this is done from the client. http://www.mysql.com/doc/G/R/GRANT.html > -- Roger ---

RE: Text Field Inserts

2002-04-04 Thread Nick Stuart
Thanks for the info I'll give it a try. Ya, I suppose I should have mentioned my front end. It just happens to be ASP and VBSCRIPT so your method should work fine. I did look through the manual but was really sure what to look for. I'll have to try this out though...thanks again. -Nick > Hi Nic

RE: How can I set a char(2) column to always stay 2 chars?

2002-04-04 Thread Rochester, Dean
-Original Message- From: [EMAIL PROTECTED] To: Rochester, Dean Sent: 4/3/02 4:26 PM Subject: Re: How can I set a char(2) column to always stay 2 chars? Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must

RE: Table statistics

2002-04-04 Thread Doug Bishop
May the gods of mySQL please forgive me. I just joined the list last night, and thought, in seeing the question, I could provide a possible solution. I was unaware that there was only one acceptable answer, and that all posts had to be pre-checked. In the future I shall not make such a mistake aga

group by year

2002-04-04 Thread Han de Neeling
I have a MySQL database containing records from several years. I want to calculate counts of records for each year and separate values for a couple of other fields. Each record contains a date-field, date. I tried putting the function YEAR(date) into a GROUP BY section, but this didnot work. ---

Re: Error: Transactions are not enabled

2002-04-04 Thread Egor Egorov
SankaraNarayanan, Thursday, April 04, 2002, 10:04:14 AM, you wrote: SM> I am using Visual Basic application to insert and SM> update records in MySQL database. SM> MySQL 3.23 is installed in Windows 2000 Server. SM> I am running my VB application from my Windows 95 SM> machine with MyODBC 2.50 f

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Egor Egorov
Tshering, Thursday, April 04, 2002, 1:23:09 PM, you wrote: TN> For the inbound connection on port 3306 of MySQL Server, how do I restrict TN> the connection to some IP addresses something like 1.2.3.* TN> What do I need to do in my.cnf file? Nothing. You should use 'host' table in the 'mysql' d

Re: MySQL Dumps

2002-04-04 Thread Victoria Reznichenko
João, Wednesday, April 03, 2002, 10:31:44 PM, you wrote: JPV> is there any way to make mysqldump dump every insert as a single insert JPV> instead of making INSERT INTO ... VALUES (...), (),(...) and so on ? JPV> I read the manual and there is sth about -e wich as I understood means JPV>

Re: Error in accept: Invalid argument and Duplicate entry '0' for key

2002-04-04 Thread Victoria Reznichenko
Martin, Wednesday, April 03, 2002, 5:45:00 PM, you wrote: MM> would anyone please explain me what are these error messages? MM> 020327 12:29:26 mysqld started MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98 MM> /usr/local/mysql/bin/mysqld: ready for connections MM> /usr

Re: BLOB in mysql

2002-04-04 Thread Victoria Reznichenko
chiou%2dguey, Wednesday, April 03, 2002, 9:47:50 PM, you wrote: c2l> I am trying to store a .gz file in a BLOB field in a mysql database. I have c2l> tried two commands : c2l> 1. Insert into mytable values('1', 'file1.gz'); c2l> 2 Insert into mytable values('1,','\'file1.gz\''); c2l> These two

Re: unkown table is full

2002-04-04 Thread Victoria Reznichenko
Richard, Thursday, April 04, 2002, 2:42:52 AM, you wrote: RC> create table test select * from summary_rts union select * from RC> summary_rts_old; RC> ERROR 1114: The table '#sqld70c_b4_0' is full RC> Can someone please help me figure out what is wrong with this. It was RC> working fine up

Re: bug report with functions

2002-04-04 Thread Egor Egorov
Patrice, Thursday, April 04, 2002, 4:41:24 AM, you wrote: P> MySQL Version: 3.23.49 P> OS: Win 98 P> Query 1: select length ('abc') returns P> You have an error in your SQL syntax near '('abc')' at P> line 1 P> Query2: select length('abc') returns 3: OK P> Note the space between the 'h' and '(

Re: Database Replication

2002-04-04 Thread Eric Baines
I finally got the log-bin to work. You CANNOT put an extension. log-bin = /mysql/log/replication Eric Baines

help with query, pelase

2002-04-04 Thread Hathaway, Scott L
I have the following query: select *, max(event_date) as high, min(event_date) as low from schedule where event_date between '2002-03-01' and '2003-04-30' group by week_ending,meeting_id order by name, event_date, start_time If I order by event_date, start_time, name, I get the proper results.

Re: Port 3306 restricted to IP addresses

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 12:23 Tshering Norbu wrote: > For the inbound connection on port 3306 of MySQL Server, how do I restrict > the connection to some IP addresses something like 1.2.3.* > > What do I need to do in my.cnf file? I let the fire

How do you set the char format for a column in Mysql table

2002-04-04 Thread Rochester, Dean
I have a Mysql table with a char(2) column, name is Dependents. I want the value that I insert to always be to places. I have tried Insert into Table1 Dependents values '02'; but it inserts 2 in the Dependents column How do I make it insert 02? Thanks Dean-O

Replication: "slave start;" crashes mysqld.

2002-04-04 Thread Johan Wahlström
Hello! I have a problem with replication, sometimes (daily) the slave server crashes and restarts itself. I have entered "skip-slave-start" into my.cnf and this makes the server get back online but of course without relplication running. This leads me to believe that the master do something wrong

RE: How do you set the char format for a column in Mysql table

2002-04-04 Thread Mike Grabski
Will the data in this field always be numbers? you could just use TINYINT(2) UNSIGNED ZEROFILL -Original Message- From: Rochester, Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:56 AM To: MySQL (E-mail) (E-mail) Subject: How do you set the char format for a column in Mys

Finding missing items in a series

2002-04-04 Thread George Smith
I have a mysql table like this mysql> describe reports; +-+-+--+-++---+ | Field | Type| Null | Key | Default| Extra | +-+-+--+-++---+ | rptdate | date| | PRI | -00-00 | | | id | int(11

RE: How do you set the char format for a column in Mysql table

2002-04-04 Thread Roger Baklund
* Rochester, Dean > I have a Mysql table with a char(2) column, name is Dependents. > I want the value that I insert to always be to places. I have tried > > Insert into Table1 Dependents values '02'; > > but it inserts 2 in the Dependents column Really? It is not valid SQL... mysql> create ta

RE: How do you set the char format for a column in Mysql table

2002-04-04 Thread Rochester, Dean
I know that is not valid sql, but it was the jist of what I was inserting. I got it figured out. I am using Java to create this sql statement and there is a decimal formatting object in java, so I used that to format the variable that I am inserting and bingo, fixed. Thanks for you gray matter

Keeping MySQL Databases Heathly

2002-04-04 Thread Alex Pilson
Do MySQL server administrators recommend running a cron script daily to isamchk? Is there any other things that should be run daily to keep MySQL running top-notch? If so, does anyone have any pointers to a script that has already been developed? Thanks. -- <-

Re: How do you set the char format for a column in Mysql table

2002-04-04 Thread denonymous
From: "Rochester, Dean" <[EMAIL PROTECTED]> > I have a Mysql table with a char(2) column, name is Dependents. I want the > value that I insert to always be to places. I have tried > > Insert into Table1 Dependents values '02'; > > but it inserts 2 in the Dependents column > > How do I make it

Re: Finding missing items in a series

2002-04-04 Thread Paul DuBois
At 9:14 -0500 4/4/02, George Smith wrote: >I have a mysql table like this >mysql> describe reports; >+-+-+--+-++---+ >| Field | Type| Null | Key | Default| Extra | >+-+-+--+-++---+ >| rptdate | date|

InnoDB 3.23.50 Release

2002-04-04 Thread Chandran Richard Honour
All Could someone please update me as to when the 3.23.50 version of MySQL/InnoDB will be released ? We are experiencing issues with the loss of foreign key constraints when using the ALTER TABLE command. regards, Chandran Honour. Technical Director, BrowserAngel. [EMAIL PROTECTED] +44 (0)20 7

RE: How do you set the char format for a column in Mysql table

2002-04-04 Thread Paul DuBois
At 9:32 -0500 4/4/02, Rochester, Dean wrote: >I know that is not valid sql, but it was the jist of what I was inserting. Generally, when you're reporting problems to the list, it's not worthwhile to report the gist. Particularly when what you're reporting is erroneous and doesn't actually have t

Re: (1) File Storage (2) CMPs

2002-04-04 Thread Egor Egorov
Ang, Thursday, April 04, 2002, 4:21:10 PM, you wrote: AHK> Is MySQL capable of storing files (*.doc *.zip etc)? If YES, AHK> - is there a limit to the size? AHK> - what is the data type to use? BLOB? Yes, you should use BLOB types (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB). You can read about

Re: RE: How can I set a char(2) column to always stay 2 chars?

2002-04-04 Thread Victoria Reznichenko
Rochester, Thursday, April 04, 2002, 3:39:41 PM, you wrote: Reoen> I have a table with a char(2) and when I send it '02' I want it to stay Reoen> 02, Reoen> but instead it stores 2 Reoen> How do I make this store as '02'? If you have char column your data will be stored as a string. Look: mysq

Re: help with query, pelase

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote: > I have the following query: > > select *, max(event_date) as high, min(event_date) as low from schedule > where event_date between '2002-03-01' and '2003-04-30' group by > week_ending,meeti

Re: Keeping MySQL Databases Heathly

2002-04-04 Thread John Klein
[EMAIL PROTECTED] wrote: > > Do MySQL server administrators recommend running a cron script daily > to isamchk? > > Is there any other things that should be run daily to keep MySQL > running top-notch? If so, does anyone have any pointers to a script > that has already been developed? I actuall

Re: Keeping MySQL Databases Heathly

2002-04-04 Thread Alex Pilson
At 10:09 AM -0500 4/4/02, John Klein wrote: >[EMAIL PROTECTED] wrote: >> >> Do MySQL server administrators recommend running a cron script daily >> to isamchk? >> >> Is there any other things that should be run daily to keep MySQL >> running top-notch? If so, does anyone have any pointers to a

Case tools

2002-04-04 Thread Smith.Michelle
Can someone please recommend CASE tools that function well with MySQL databases? Need to do some reverse engineering ... create the ERD, data dictionary, etc Regards, Michelle Smith - Before posting, please check: http:

RE: Keeping MySQL Databases Heathly

2002-04-04 Thread sean . odonnell
MySQLfront (www.mysqlfront.de) displays all the output from show status in the host tab when you connect. -Original Message- From: Alex Pilson [mailto:[EMAIL PROTECTED]] Sent: 04 April 2002 07:15 To: John Klein Cc: [EMAIL PROTECTED] Subject: Re: Keeping MySQL Databases Heathly At 10:09

Transfert Data from one DB to another

2002-04-04 Thread David BORDAS
Hi all, i've got a problem, i need to transfert some data from one database to the same database but on a différent mysql server. I think i can't do that easily via command line, so i'll try to make a C script to do that. If someone have some fonctions names that can help me ... Thanks in advan

Re: Case tools

2002-04-04 Thread Alex Pilson
At 10:19 AM -0500 4/4/02, Smith.Michelle wrote: >Can someone please recommend CASE tools that function well with MySQL >databases? > >Need to do some reverse engineering ... create the ERD, data dictionary, >etc Very cool tool... http://www.datanamic.com/dezign/index.html -- <--

Re: renaming

2002-04-04 Thread Katharina Daskalaki Aikaterini
[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text o

Newbie table question

2002-04-04 Thread Graham Nichols
Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards, Graham Nichols.

Re: Best hardware for a very large MySQL server? looking at x86

2002-04-04 Thread Tod Harter
Well, its tough to compare system configurations in a very general way. I've run any number of different systems. I can tell you that Sun has some very nice boxes. A 4 way SMP server with a couple gigs of ram and 1-2 internal 36 gig drives can be had in the 25k price range. They're perfectly ni

RE: Newbie table question

2002-04-04 Thread Rick Emery
delete from tableB; INSERT INTO tableB SELECT * FROM tableeA; see manual: 6.4.3.1 INSERT ... SELECT Syntax INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ... -Original Message- From: Graham Nichols [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 9:44 AM T

RE: help with query, pelase

2002-04-04 Thread Hathaway, Scott L
Yes, that should only cause a reordering within the group itself, but in my case, the group breaks into two groups! Scott -Original Message- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:58 AM To: Hathaway, Scott L; Mysql (E-mail) Subject: Re: help

Re: Case tools

2002-04-04 Thread BD
At 09:19 AM 4/4/2002, you wrote: >Can someone please recommend CASE tools that function well with MySQL >databases? > >Need to do some reverse engineering ... create the ERD, data dictionary, >etc > >Regards, >Michelle Smith Michelle, CaseStudio 2 is quite good at around $500 which

Re: Transfert Data from one DB to another

2002-04-04 Thread Egor Egorov
David, Thursday, April 04, 2002, 6:30:39 PM, you wrote: DB> i've got a problem, i need to transfert some data from one database to the DB> same database but on a différent mysql server. DB> I think i can't do that easily via command line, so i'll try to make a C DB> script to do that. Look at my

Re: RE: Tabel Referencing Question

2002-04-04 Thread Egor Egorov
Demirchyan, Wednesday, April 03, 2002, 10:16:53 PM, you wrote: DOA> Hello everyone, I have the following line in my create table code: DOA> SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES DOA> SCAN_PARAMETER(SCAN_PARAM_ID) DOA> I need to make it so that scan_param_id references to two differe

Re: Installation weirdness.

2002-04-04 Thread Victoria Reznichenko
Madscientist, Thursday, April 04, 2002, 2:50:40 AM, you wrote: M> I can't seem to find help for this in the docs or with the search M> engine. M> I am installing the new 4.x version an rather than run it over 3.23 I M> decided to erase the old packages first and start fresh. This is a M> RedHat

Re: Restoring log file enteries.

2002-04-04 Thread Victoria Reznichenko
Charitha, Thursday, April 04, 2002, 1:35:57 PM, you wrote: C> I am having the mysql log file which is having all the queries which C> affects the data base. C> I have to restore those queries in the table in some remote server. C> Is that possible. Yes, you can update database from update logs u

RE: Newbie table question

2002-04-04 Thread Gurhan Ozen
Hi Graham, You can just use "INSERT INTO ... SELECT ..." statement for it . See the manual: http://www.mysql.com/doc/I/N/INSERT_SELECT.html Gurhan -Original Message- From: Graham Nichols [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:44 AM To: [EMAIL PROTECTED] Subject: New

RE: Transfert Data from one DB to another

2002-04-04 Thread Gurhan Ozen
IS it something that you can get the data with mysqldump into an sql file and then load it into the database you want it to be transferred to? If yes you can do it all in the command line. Gurhan -Original Message- From: David BORDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04,

Re: Transfert Data from one DB to another

2002-04-04 Thread David BORDAS
Yes but in fact i forgot to say that i have to change a value of a column, Ex dump all data from table where category = 2 and insert all this data into the other mysql with category = 4 and not 2 I think with too connection i can select all data then insert in new server ben delete on the old ser

Re: InnoDB 3.23.50 Release

2002-04-04 Thread Heikki Tuuri
Hi! We apologize for the delay in releasing 3.23.50. InnoDB-3.23.50 has been ready for 2 weeks now. The problem is that Monty wants to compile on Linux the MySQL binaries with gcc-3.0.4 and a rather new glibc version, and that combination does not seem to produce stable binaries of MySQL. I aske

Re: Re: LOAD DATA not allowed with this MySQL version

2002-04-04 Thread Gilles Moyse
Hi. When I try : mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; I get this error message : The used command is not allowd with this MySQL version. I've nevertheless downloaded the latest stable version on mysql.com. The select version() statement gives me : 3.23.49-nt MyS

RE: group by year

2002-04-04 Thread Rick Emery
GROUP BY is done on column value. show us you query -Original Message- From: Han de Neeling [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 7:15 AM To: [EMAIL PROTECTED] Subject: group by year I have a MySQL database containing records from several years. I want to calculate

Clustering MySQL was: Re: Best hardware for a very large MySQL server? looking at x86

2002-04-04 Thread JW
On Thursday 04 April 2002 09:48 am, you wrote: > I think you'll find that the RISC systems have fewer processors and run at > lower clockspeeds for the same total performance. 100k is a HUGE amount of > money to drop on a system. You could get 2 full racks of high performance > 1U systems, includi

Getting the most recent record per id before date X

2002-04-04 Thread Anthony R. J. Ball
I am trying to figure out the best way to select the row of data for a specific id that is the most recent entry on or before a specific date. I realize that I could create a temp table and select where date <= X and group by id, inserting the max date into the table with the id, then do a

Re: Supporting Transactions and Binary Logs

2002-04-04 Thread Heikki Tuuri
Rajeev, please upgrade to 3.23.49a. .37 is a very old version, and the current documents do not accurately describe it. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http

Re: PERL/SQL, again? - Re: Procedures

2002-04-04 Thread Tod Harter
On Wednesday 03 April 2002 13:25, Russell E Glaue wrote: > I am an avid PERL programmer, I also know java. I cannot completely agree > with either of you. > However, this debated subject is best discussed in another community. > The focus here is what has the necessary abilities/functionality to c

Query help

2002-04-04 Thread Chuck Barnett
Hi. I have two fields, firstname, lastname. I populate a select box with the firstname lastname. Now when a user selects a name and hits submit, the program will(should) select * from table where the selected name equal firstname+lastname. I guess you have to some how put the first and last na

Strange ODBC Error

2002-04-04 Thread Bradley kornatowski
Everytime I try to setup an odbc connection from a windows 2000 to a sun unix box which is the sql server host is get the following error: ...Host '%-.64s' is nto allowed to connect to this MYSQL server. Any ideas??? _ Join the wo

RE: How can I set a char(2) column to always stay 2 chars?

2002-04-04 Thread Jens Vonderheide
Hi Dean, > I have a table with a char(2) and when I send it '02' I want it to stay > 02, > but instead it stores 2 > > How do I make this store as '02'? Works for me: mysql> create table t ( a char(2) ); Query OK, 0 rows affected (0.08 sec) mysql> insert into t values ('02'); Query OK, 1 row

Re: Re: Re: LOAD DATA not allowed with this MySQL version

2002-04-04 Thread Victoria Reznichenko
Gilles, Thursday, April 04, 2002, 7:20:35 PM, you wrote: GM> When I try : GM> mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; GM> I get this error message : GM> The used command is not allowd with this MySQL version. GM> I've nevertheless downloaded the latest stable version on

RE: Transfert Data from one DB to another

2002-04-04 Thread Gurhan Ozen
Hi david, Just create another table in your database with the structure and data of the table. See "CREATE TABLE ... SELECT ..." syntax at : http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task. Then update all the category values from 2 to 4 in that table. Use mysqldump to copy it into

Re: Best hardware for a very large MySQL server? looking at x86

2002-04-04 Thread JW
On Thursday 04 April 2002 09:48 am, you wrote: > I think you'll find that the RISC systems have fewer processors and run at > lower clockspeeds for the same total performance. 100k is a HUGE amount of > money to drop on a system. You could get 2 full racks of high performance > 1U systems, includi

Group by?

2002-04-04 Thread Tobias K. Tobiasen
Hello I think the gruop by is behaving strange. Could someone please explain this or maybe point me to a definition of the group by. (Inspired by http://www.mysql.org/doc/E/x/Examples.html). CREATE TABLE shop ( article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL, dealer CHAR(20)

RE: group by year

2002-04-04 Thread Jens Vonderheide
> I have a MySQL database containing records from several years. I want to > calculate counts of records for each year and separate values for a couple > of other fields. Each record contains a date-field, date. I tried putting > the function YEAR(date) into a GROUP BY section, but this didnot wor

dumps issue

2002-04-04 Thread David yahoo
Hi all, I hav a problem while dumoing my data into a mysql server provider. I have some lost connexion during dumping. So I have to delete by hand the lines inserted and then resrtar wuth the other. Do u know a tool that can make this for me. That meens redo with lines which hadnt been treated a

RE: Getting the most recent record per id before date X

2002-04-04 Thread Roger Baklund
* Anthony R. J. Ball > I am trying to figure out the best way to select > the row of data for a specific id that is the most > recent entry on or before a specific date. What about: SELECT * FROM table WHERE id = $specific_id AND date <= '$specific_date' ORDER BY date DESC LIM

RE: Getting the most recent record per id before date X

2002-04-04 Thread Rick Emery
SELECT * FROM mytable WHERE date_field mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:30 AM To: [EMAIL PROTECTED] Subject: Getting the most recent record per id before date X I am trying to figure out the best way to select the row of data for a specific id that is the most rece

RE: Query help

2002-04-04 Thread Rick Emery
SELECT * FROM mytable WHERE first_name=$first && last_name=$last -Original Message- From: Chuck Barnett [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: Query help Hi. I have two fields, firstname, lastname. I populate a select box with

Re: access sql statement

2002-04-04 Thread BD
At 12:16 PM 4/4/2002, you wrote: >Is it possible to access a sql statement to mysql database through >Internet explorer ? such as : > > http://www.abc.com?select * from test > >Thanks. > > >-- > >Best regards, > > >Ridwan >Goldbase Technology Ridwan, Of course, with something lik

Re: databases projecting

2002-04-04 Thread BD
At 04:23 PM 4/3/2002, you wrote: >hello, > >i have plans to create a complex SQL database. >before that i'd like to draw a scheme of it. >could you please advice which >program(freeware/shareware) >would fit for that purpose? >any links to pages, tutorials about graphical >databases projecting wou

Re: Strange ODBC Error

2002-04-04 Thread massey
Read http://www.mysql.com/doc/A/c/Access_denied.html > Everytime I try to setup an odbc connection from a windows 2000 to a > sun unix box which is the sql server host is get the following error: > > ...Host '%-.64s' is nto allowed to connect to this MYSQL server. > > Any ideas??? > > __

Re: Query help

2002-04-04 Thread Chuck Barnett
This will not work for my example. I have a select box that was populated from the db with firstname lastname. The option tag has the value of firstname+lastname then. Here lies the problem, when I build the query, I have no way of distinguishing firstname and lastname. Chuck - Original Me

RE: Getting the most recent record per id before date X

2002-04-04 Thread Gurhan Ozen
Anthony, Is all the information you need to retrieve in one table? If yes , I don't think you have to do join to get the row you want.. you should be able to do it by: SELECT columns FROM table WHERE id=yourid AND DATE => 'date' ORDER BY DATE LIMIT 1; Is this what you are asking? And I think it

RE: Query help

2002-04-04 Thread Rick Emery
T'would help had you provided us with your code. Regardless, create your SELECT box such that the values are comprised of first name and last name separated by +. The construction would appear liek: John Smith John Van Buren Sam Jones Chuck Barnett Zsa Zsa Gabor Frank Zappa process.php -

Re: Getting the most recent record per id before date X

2002-04-04 Thread Anthony R. J. Ball
Ack, sorry (to you and Gurhan)... I've done this trick, but I was actually looking at it with more than one ID, hence the group by... either select from a whole table for a date or joining against another table with the desired ids... On Thu, Apr 04, 2002 at 06:59:30PM +0200, Roger Baklund wro

Re: Clustering MySQL was: Re: Best hardware for a very large MySQL server? looking at x86

2002-04-04 Thread BD
At 10:28 AM 4/4/2002, you wrote: >On Thursday 04 April 2002 09:48 am, you wrote: > > I think you'll find that the RISC systems have fewer processors and run at > > lower clockspeeds for the same total performance. 100k is a HUGE amount of > > money to drop on a system. You could get 2 full racks o

RE: Transfert Data from one DB to another

2002-04-04 Thread BD
At 10:43 AM 4/4/2002, you wrote: >Hi david, >Just create another table in your database with the structure and data of >the table. See "CREATE TABLE ... SELECT ..." syntax at : >http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task. > > Then update all the category values from 2 to 4 in t

[sql_yacc.o] Error 1

2002-04-04 Thread root
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error: sql_yacco.yy:719: Parse error before '}' sql_yacco.yy:1462: Parse error before '}' sql_yacco.yy:1689: Parse error before '}' sql_yacco.yy:1723: Parse error before '}' sql_yacco.yy:1746: Parse error before '}' sql_yacco.yy:180

SQl query in MySQL (1)

2002-04-04 Thread Gastón Sancassano
My name is Gastón Sancassano and I would like to make some questions about MySQL because I am a novice. My question is: - How does PRYMARY KEY and UNIQUE works? My problem is that I want to create a table with 3 columns (Nombre, Password and Permiso) and I don't like to have the name repeated

RE: Query help

2002-04-04 Thread Luc Foisy
If this is web based, you could store the id of the record in the VALUE parameter of the OPTION tag You could alternately create some kind of object(Vector, array, list whatever your language is) that would track the id and have that be along side of the select box, or perhaps your select box can

More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86

2002-04-04 Thread JW
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 DN >In the last episode (Apr 04), JW said: DN >Heh. plus the maintenence nightmare of managing 48 servers, 96 mirrored DN >boot disks, 96 power supplies, etc etc.. DN > DN >A comparable system to the Dell link you pasted is the Sun Fire v880. DN >For

mysql on netware

2002-04-04 Thread Ed Heiger
Will MYSQL run on Netware? thanks Ed Edward Heiger III, CNE Manager of I/S Department of Medicine Phone: 410-328-1807 Fax: 410-328-3861 http://www.medicine.umaryland.edu/is - Before posting, please check: http://www.mys

Re: Query help

2002-04-04 Thread John Klein
[EMAIL PROTECTED] wrote: > > This will not work for my example. I have a select box that was populated > from the db with firstname lastname. The option tag has the value of > firstname+lastname then. Here lies the problem, when I build the query, I > have no way of distinguishing firstname an

error on connecting thru SSH w/ mySQL-FRONT

2002-04-04 Thread Mike Grabski
bear with me- my host disabled network so I can only connect thru SSH telnet via localhost. i'd like to use mySQL-FRONT to utilize mySQL. I am using PuTTY to establish SSH, and what I did was create local port forwarding. L3306 forwards to localhost:3306 I then run mySQL-FRONT, using localhost

Query's Speed

2002-04-04 Thread Ronnie Alfaro
Hi there, Lets say i do the following query: mysql > select something from some_table; Then i will get the results , how many rows and how much time it took to perform the query. My question is how can i get the time it took for perform the query. I want that cuz i would like to put in a web pag

Re: Group by?

2002-04-04 Thread Gerald Clark
Maybe you really wanted ORDER BY. Tobias K. Tobiasen wrote: > Hello > > I think the gruop by is behaving strange. Could someone please explain > this or maybe point me to a definition of the group by. (Inspired by > http://www.mysql.org/doc/E/x/Examples.html). > > > CREATE TABLE shop ( > arti

RE: SQl query in MySQL (1)

2002-04-04 Thread Rick Emery
Use CHAR, not TEXT for Nombre and Password Also, INT will NOT be set to length of 1 in permiso -Original Message- From: Gastón Sancassano [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 12:10 PM To: [EMAIL PROTECTED] Subject: SQl query in MySQL (1) My name is Gastón Sancassano

Problem with starting safe_mysqld

2002-04-04 Thread Satyanarayana V R
HI, I am doing a project which looks at internals of a database and I am trying to understand MySQL source code. I have installed the source code of version 3.23.47, the most stable version. I am working on Redhat linux 7.0 version. I have complied it, made some change

  1   2   >