Re: Select Limit question

my table is small but I can't tell what is faster.. a max or a limit mysql> select max(counter) from web; mysql> select counter from web order by counter desc; They seem to be the same in performance. Regards, Jake Johnson [EMAIL PROTECTED] _

Re: Select Limit question

At 12:32 PM 7/20/2003, you wrote: This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light on thi

Re: Working with the text datatype in Mysql

> | How are they typing in the information? From a web > | page? From the command line? From a custom program? > They type the information from a web page. What web programming language are you using to receive the post request from the web page and form the sql query to insert the data into the

System resets when loading a large table

Hi - I have an application which is essentially 'read-only' - once the database is loaded it is only read from. So, I am trying to implement it with various indices and a table containg some large content in blob columns. I observe the max_allowed_packet setting and 'split' blobs too large among m

Re: passwords & DBI/DBD

Jeremy Booker wrote: >I installed the current stable release of MySQL from RPMs. I used the client >and server packages. > >After installing the server package, the RPM printed a note saying I should >run two commands. I only got the first one, which was ># ./mysqladmin -u root --password >I ass

Re: passwords & DBI/DBD

I guess I forgot to mention that MySQL was running at the time. I could use mysqladmin (as long as I used the '-p' option and entered that root password i setup), and I could also run SELECT statements from the command line. -Jeremy ~ Jeremy Booker - Owner / Webmaster

Re: passwords & DBI/DBD

when you connect you connect to a running daemon try running mysqld beforehand -Martin - Original Message - From: "Jeremy Booker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 19, 2003 7:12 PM Subject: passwords & DBI/DBD > I installed the current stable release of My

passwords & DBI/DBD

I installed the current stable release of MySQL from RPMs. I used the client and server packages. After installing the server package, the RPM printed a note saying I should run two commands. I only got the first one, which was # ./mysqladmin -u root --password I assume this gave the root user a p

Re: oscom table structure

Hi Andrew, Thanks for the reply, that makes your question clearer, but I havent had a chance yet to try the system you described. Sorry, unfortunately at this time I am unable to help. Best regards Nils Valentin 2003年 7月 20日 日曜日 03:48、olinux さんは書きました: > There is a diagram of the database in

Re: Subselect in 4.0.12-max with --new option

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 July 2003 21:28, [EMAIL PROTECTED] wrote: > ERROR 1064: You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use > near …. > > Any ideas? I need subselect working.

Re: Adding and filling a new column

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 19 July 2003 19:20, Jim McAtee wrote: > Interesting. In the case where you want to begin numbering existing rows > at 1, > > is it necessary to set the autoincrement number to that of the next, i.e: > > Alter Table X Auto_Increment = 201;

Subselect in 4.0.12-max with --new option

Hi, I was reading the manual and it said that the subselect is only available in 4.1 or using the 4.0.12 with the mysqld –new command line to start it. But it doesn’t working!! So I downloaded the 4.1 alpha version with the same problem. The error is: ERROR 1064: You have an error in your SQL

(more concise) db admin question

To restate an earlier question more concisely: Is it true that a user who is given all privileges, including grant option, on a database (e.g., in order to administer that database) can create other users with any or all of his privileges, but cannot give them passwords? Is there some wa

Re: Adding and filling a new column

Michael Satterwhite wrote: > > Are you saying that it will propogate through the _existing_ rows, or only > > on rows added later? > > It will number all existing rows and continue with rows added later. Interesting. In the case where you want to begin numbering existing rows at 1, is it necess

Re: Adding and filling a new column

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 19 July 2003 18:17, Jim McAtee wrote: > Are you saying that it will propogate through the _existing_ rows, or only > on rows added later? It will number all existing rows and continue with rows added later. - ---Michael -BEGIN PGP SI

Re: Adding and filling a new column

Michael Satterwhite wrote: >> So I can add the column, and I can set it to have an auto_increment, but >> will that start out at 201? or will it start at 1 and propogate through? > > If you don't modify the table definition, it will start at 1 and propagate > throughout: e.g. Are you saying that

Re: Adding and filling a new column

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 19 July 2003 17:17, Andrew Rothwell wrote: > So I can add the column, and I can set it to have an auto_increment, but > will that start out at 201? or will it start at 1 and propogate through? If you don't modify the table definition, it

Adding and filling a new column

Good day list, I hope that this is an easy one for you guys to help me with, I am relatively new to DB design, and I realized that I have left out a few very important Indexing and counting columns. So my question is this, What do I need to do to fill in new column, I would like to have it au

mysql-socket

how do you make a socket or use unix_socket etc. The basics? -- G Gill

Foreign Key definition

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm trying to add a foreign key to a table. All tables are INNODB. Table a has following partial Definition: TableA ( Fld1 int Primary Key,... ) TableB (Fld2 int Primary Key, Fld1 int not null, ... ) I use the following Statement: Alter Ta

RE: text searching

At 14:53 -0400 7/19/03, [EMAIL PROTECTED] wrote: using colname like "string2search4" doen't seem to work for me w/ mysql also have tried select * table upb where Desc REGEXP "pipe"; as well as creating a (full text) index on the column. docs seem a little thin in this area, any tips or pointer

RE: text searching

using colname like "string2search4" doen't seem to work for me w/ mysql also have tried select * table upb where Desc REGEXP "pipe"; as well as creating a (full text) index on the column. docs seem a little thin in this area, any tips or pointers to resources greatly appreciated. miked _

RE: oscom table structure

There is a diagram of the database included in the milestone releases. it's in the top directory named tep_database_2.2CVS.pdf or something like that. olinux --- Andrew <[EMAIL PROTECTED]> wrote: > Thanks Nils, I will just add a little to the > original question, I am familar with the table > st

RE: DB Design

Check this http://www.fabforce.net/dbdesigner4 olinux --- Andrew <[EMAIL PROTECTED]> wrote: > this is exactly what I am looking for :) Is there a > free one of these guys > hanging around somewhere? > > Andrew > > >-Original Message- > >From: Peter Brawley > [mailto:[EMAIL PROTECTED]

Re: Select Limit question

At 13:32 -0400 7/20/03, C. Reeve wrote: This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light

Select Limit question

This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light on this? TIA -- MySQL General Maili

Re: BOOK: MySQL Cookbook

At 22:20 -0700 7/18/03, Ralph Guzman wrote: Paul, I just picked up your book today: MySQL Cookbook and I just wanted to comment on how great it is. I've spent hours at the bookstore looking through mySQL books, and by far this is the best one I come across. I strongly recommend it to anybody--Begi

Assistance Required - Syntax.

Assistance required. I have 3 tables: TABLE: client_invoice - client_id *1(show all from client_invoice, only those w/ info from client_info) - invoice_amount - invoice_date_due TABLE: client_info - client_id*1(show all from client_invoice, only those w/ info from client_in

Re: datetime column dummy question

At 23:10 -0500 6/24/03, MaFai wrote: Hello, mysql, A table contains a column named "mydate". //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter table p_asset add mydate datetime de

RE: DB Design

this is exactly what I am looking for :) Is there a free one of these guys hanging around somewhere? Andrew >-Original Message- >From: Peter Brawley [mailto:[EMAIL PROTECTED] >Sent: 19 July 2003 17:50 >To: MySQL-Lista >Subject: Re: DB Design > > >You probably don't mean the $Nk tools (Po

Re: DB Design

You probably don't mean the $Nk tools (PowerDesigner, ERWin, Rational Rose &c). MS Visio does it, but Dezign (http://www.datanamic.com/dezign/) does it better & cheaper IMO (no I'm not a principal). PB - - Original Message - From: Andrew To: MySQL-Lista Sent: Saturday, July 19,

DB Design

is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic :) Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Load Testing MySQL

I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a test script to allow me to perform some transactional database testing to load test a MySQL 4.0.13 da

Re: doskey feature in mysql !!

At 15:02 +0530 7/19/03, Neeraj Vasudeva wrote: Hello, I remember in WIN NT 4 if we type cmd at the run prompt, then command prompt use to come up and we can repeat the commands i.e. doskey feature is available. so now i have installed mysql database server version : 3.23.55 on win 98 and when i

RE: Crash on mysql_real_connect on FreeBSD 4.7

Thank you for your direction. I posted on both lists under the hope that I could find someone out there with experience using the API - whether the C api or the C++ - and who may have encountered a similar problem. I have been googling for days and found mostly stuff related to PHP and MySQL, but

MySQL core certification revision - clients

Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core certification revision check list. I understand that the mysql database itself is the "server". Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? I understan

creating db admins

I create a database, foo, then designate a user, pooh, with full privileges, including grant option (pooh is to administer this database, including creating other users): grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant option; Now pooh logs in to the mysql server

RE: tst msg

test failed -Original Message- From: Neeraj Vasudeva [mailto:[EMAIL PROTECTED] Sent: Samstag, 19. Juli 2003 11:28 To: [EMAIL PROTECTED] this is a test message -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

doskey feature in mysql !!

Hello, I remember in WIN NT 4 if we type cmd at the run prompt, then command prompt use to come up and we can repeat the commands i.e. doskey feature is available. so now i have installed mysql database server version : 3.23.55 on win 98 and when i use command prompt and go to mysql prompt , i

myisamchk -R

Hi, I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work myisamchk -R=ID \mysql\data\db\mytable.myi ID is the index name I want to use to sort the table I'm using mysql 4.0.13 on Win 2K server Thanks for help Patrizio

tst msg

this is a test message

RE: oscom table structure

actually just add a little more to this, perhaps what I am after is some kind of tool that creates a DB schema layout , dare I say it like access ;) Is there something that does this for MySQL ? Andrew >-Original Message- >From: Andrew [mailto:[EMAIL PROTECTED] >Sent: 19 July 2003 09:5

RE: oscom table structure

Thanks Nils, I will just add a little to the original question, I am familar with the table structure in that I have access to the tables ect. I have even installed a few versions of osc ;) I am asking if anyone has gone beyond looking at .sql and actually worrking out how all the tables are

Re: Working with the text datatype in Mysql

The problem could be in the HTML page. I suppose You use a form to submit data. If You want to pass more than about 1K data You must use POSTs and not GETs. The Get option has a limit in the URL len so You can not successful pass more than 1K bytes (browser/platform specific limit). The url in