RE: MySQL Clients Hang

> What seems to be happening is that the "open" of the db hangs. So, when > you attempt to connect with a client, mysql tries to look at the grant > tables and hangs waiting for access. This is just a guess though. When you connect with a client, mysql_real_connect opens a socket to the server,

Re: MySQL gurus - easy one.

Hello Odhiambo, Seems like From and To are MySQL reserved words. http://www.mysql.com/doc/R/e/Reserved_words.html Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building

Re: print database schema

You can run mysqldump from the command line, if you only want the schema you can do: mysqldump -u username databasename -d -p > my.dump man mysqldump to see more options. or if you want you can try phpmyadmin at http://www.phpwizard.net/projects/phpMyAdmin/ it is a web based admin tool for mysq

Re: print database schema

Hello more of a visual tool. The program I did see had views of all the tables as if you had done a "describe table_name" for each table, then had lines linking the relationships between tables (similar to what you can view in Access , even though i hate to admit I have used it :) would just be

Re: Trouble in unsubscribing

Hi: Does anyone know how to unsubcrib from sql mailing list? I tried twice a few days ago but still getting emails. I even receieved a confirm which told me my email has been removed from the mysql list after I unsubcribed. My mail box can't stand for getting too many emails a day. Thanks

Re: MySQL gurus - easy one.

At 22:23 -0700 1/28/02, Colin Faber wrote: >Correct, > >If you MUST use date as the column name escape it with forward ticks, >`date` Actually, according to the error message, neither one of you is correct. :-) The message was: ERROR 1064 at line 3: You have an error in your SQL syntax near 'fr

Re: print database schema

At 14:42 +1000 1/29/02, Steven Wren wrote: >Hello > >I was wondering if anyone knew of a program that would allow you to print >out a complete database. I have seen it on a PostGre DB, so I am sure >MySQL should have something... You mean mysqldump --no-data db_name ? > >cheers! > >Regards, > >

Re: MySQL gurus - easy one.

Correct, If you MUST use date as the column name escape it with forward ticks, `date` "Mike(mickalo)Blezien" wrote: > > On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington <[EMAIL PROTECTED]> > wrote: > > >>Please forgive my bad step of joining the list and begining with questions. > >>I'm

Re: MySQL gurus - easy one.

On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington <[EMAIL PROTECTED]> wrote: >>Please forgive my bad step of joining the list and begining with questions. >>I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn >>(self-teaching). >> >> >>I am trying to create a table and

Re: InnoDB help !!

Hi, On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote: > I have downloaded and installed MySQL ( rpm's). Now, I want to configure > it with InnoDB option, as given in the manual, > but can't see the below configure file anywhere. > // cd /path/to/source/of/mysql-3.23.37 >./configure --with-in

MySQL gurus - easy one.

Hello list, Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching). I am trying to create a table and made a file as below: ## CONNECT mysql; CREATE TABLE maildb ( i

RE: InnoDB help !!

thanks for reply, but I have installed MySQL on Linux using the RPM files and while using RPM files should I have to give the option while installing? As while using the RPM files there is no compilation. It is no where mentioned in the manual with the RPM files. can you please, help me out in de

print database schema

Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce S

Re: How to emulate subselect on larger table? ###

At 12:12 PM 28/01/2002 -0600, you wrote: >I have 2 tables, detail and product. The detail table could have millions >of rows. The product table could have a few hundred. I need to know which >products are in the detail table. (It would also be nice to know which >products aren't in the detail t

RE: InnoDB help !!

You can only do this while compiling it from source. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Chetan Lavti [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 9:11 PM To: [EMAIL PROTECTED] Subject: InnoDB help !! hi, I have downloaded

RE: Replication of selected DB

Hi, Check the error, not in mysqld.log ..its in hostname.err Jai -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 9:52 AM To: Girish Nath Cc: [EMAIL PROTECTED] Subject: Replication of selected DB Hi, I have to replicate the selected Databa

Replication of selected DB

Hi, I have to replicate the selected Database. I have followed all the steps given in the manual page. But i am not getting the result as i need. There is no error message in the mysqld.log. The message in the log file is "replication is started". But the replication is not happening. Can you he

Re: [PHP] MySQL Newbie

Hi Yes and No :/ It all depends on the priviledges setup within the MySQL Server. More information is in the manual at : http://www.mysql.com/doc/P/r/Privileges.html If you have a shell account and appropriate MySQL login then you can maintain your database through shell and use the mysql clie

InnoDB help !!

hi, I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. Thanks and regards,

RE: Using LIMIT to select random rows

This is an example from MySQL's class on Using MySQL MySQL> Select Name -> From Country -> Where Continent="Europe" -> Order By RAND() -> LIMIT 1; If you do Limit 3 you should get 3 random rows. -Original Message- From: Ulf Harnhammar [mailto:[EMAIL PROTECTED]] Sent: We

RE: starting mysql deamon

Use YaST to edit your configuration file. Scroll down to 'start_mysql', and set it to 'yes'. Hit F10, and wait while it reconfigures things. Enjoy. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Samy Elashmawy [mailto:[EMAIL PROTECTED]] Sent: Monda

RE: Converting Access 2000 to Mysql

There is a program at http://www.convert-in.com/acc2sqlp.htm which will create the MySQL tables from the Access 2000 database and populates created tables directly from the Access 2000 source. It also converts date/datetime fields into MySQL format and Yes/No fields into tinyint. The best news is

Help on client connection

Hi all I try to connect mysql on turbolinux with my windows mysql client but the client tells me my host is not allowed to connect the mysql server. Can anyone tell me what is wrong? I think I haven't installed things like oracle net listener. How to solve the problem? Thanks -

Re: mysql access control

At 13:15 +0100 1/28/02, Joachim Hörnle wrote: >The mysql access control is drinving me crazy. > >I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4) >After the installation of mysql I run the mysql_install_db script > >I could change the passwords for root so I reset the GRANT

RE: MySQL Clients Hang

--On Monday, January 28, 2002 04:11:53 PM -0600 Ed Carp <[EMAIL PROTECTED]> wrote: >> --On Monday, January 28, 2002 11:52:08 AM -0600 Ed Carp <[EMAIL PROTECTED]> >> wrote: >> >> > Hi, Bill! Did you ever get this issue resolved? I've got the same >> > problem - MySQL starts, but no clients c

Re: Group By Error

Lance, Lance, You are asking for help in the wrong place. MySQL doesn't issue Oracle error messages. Only Oracle issues Oracle error messages. Try www.oracle.com. When you go there, they will surely ask you what in the world you are trying to do. They might suggest that you start by defin

Performance tuning

Hello, I've just set up a MySQL server. I've installed the rpm and run the server before on multi-purpose servers (also running mail, httpd, etc) but this is the first time I've set up a dedicated SQL sever and spent any time tuning it. First, the specs: Dell PowerEdge 2450 2GB RAM 5 disk RAID

Re: innodb

On Mon, Jan 28, 2002 at 09:30:59AM -0600, ryc wrote: > > Hello, > > > > is possible "on the fly" change size of innodb tables ?? > > > > i create table 1G large but is small and i need enlarge it. Can i > > change number in my.cnf or something else ? > > Just add another file entry to my.cnf sep

server problems and CPU usage issues

I have a server here that is troubling me - I have a database server that is lagging no matter what I do. When I start the server, I can watch CPU usage slowly creep up to 99% and it never drops. The queries that are hitting the database are not terribly involved, and should be completing quickly

Re: Group By Error

SELECT ROUND(AVG(COUNT(Time_stamp))), MIN(COUNT(time_stamp)), MAX(COUNT(time_stamp)) FROM cp_license_use Where time_stamp = parmTime and time_stamp >= SYSDATE-7 group by Time_Stamp) On Mon, Jan 28, 2002 at 05:27:15PM -0800, Lance

[patch] corrected manpage headers

Hello To get apropos working and the header comply to man(8) you should apply the following command on the man/ directory: perl -pi -e 's/^\.TH\s+(\S+?)\s+.*/sprintf(".TH %s 1 \"19 December 2000\" \"MySQL 3.23\" \"MySQL database\"", lc($1))/e' *.1 bye, -christian- <[EMAIL PROTECTED]> -

Re: Group By Error

At 05:27 PM 1/28/2002 -0800, Lance Prais wrote: >Why when I use the following SQL it get a >ORA-00937: not a single-group group function > >What could I be doing wrong? > >I am only trying to group on Time_stamp. > >Thank you in advance > >SELECT > ROUND(AVG(COUNT(Time_stamp))), >

How to load data into non-empty tables

Hello, On Sun Saloris box, can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way decided to change LF's

How to load data into non-empty tables

Hello, Can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way decided to change LF's into CRLF's (I remote

Group By Error

Why when I use the following SQL it get a ORA-00937: not a single-group group function What could I be doing wrong? I am only trying to group on Time_stamp. Thank you in advance SELECT ROUND(AVG(COUNT(Time_stamp))), MIN(COUNT(time_stamp)), MAX(COUNT(time_stamp)),

Oracle -> MySQL

Need some assistance... I have an already existing Oracle database, and wish to "attach" a MySQL database to it by using the primary keys in some Oracle tables as Foreign keys in some MySQL tables. I was just wondering how this would work out, as I have no prior knowledge to Oracle and thought ma

mysql access control

The mysql access control is drinving me crazy. I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4) After the installation of mysql I run the mysql_install_db script I could change the passwords for root so I reset the GRANT table using ../safe_mysqld --skip-grant-tables a

Lost data

Greetings, Forgive me for butting in but I'm having a tragic problem with MySQL and could really use some help. I have two large tables in a database with a few million entries. There is only one column in each table. Everything was working okay until today. The size of the table files is

Re: Grant Permission Syntax/Qualifier for Column?

In the last episode (Jan 28), Nic Plum said: > It looks to be possible to set a permission on a column in a table. > > If this is true, what is the syntax with respect to qualifying the name - > for a table it would be databasename.tablename but > databasename.tablename.columnname doesn't appear

Grant Permission Syntax/Qualifier for Column?

It looks to be possible to set a permission on a column in a table. If this is true, what is the syntax with respect to qualifying the name - for a table it would be databasename.tablename but databasename.tablename.columnname doesn't appear to work for a column? Nic --

Re: ? in primary key

Hello Paul, Thanks for your help! The new preparedStatement that you sent works. Sincerely, Tiffany --- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 8:52 -0800 1/28/02, Tiffany C. wrote: > >Hello, > > > >It seems that the following preparedStatement is > >changing the character ? to null. >

Re: Unix binary installations somewhere other than in /usr/local

At 20:51 + 1/28/02, John Murdie wrote: >On 26 Jan, To: [EMAIL PROTECTED] wrote: >>> I'd like to see an explicit statement that it is possible to install a >> binary distribution of MySQL in some non-standard place, or not, as the >> case might be. If it *is* possible, I'd like to see full i

Help with hanging MySQL server

Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the box, mysql will start, but connections to the database just hang. mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when we

Re: Unix binary installations somewhere other than in /usr/local

On 26 Jan, To: [EMAIL PROTECTED] wrote: >> I'd like to see an explicit statement that it is possible to install a > binary distribution of MySQL in some non-standard place, or not, as the > case might be. If it *is* possible, I'd like to see full instructions > for doing this. Thanks to the two p

(Sort of ) replication issue

You wrote: What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html for more info about mysqldump. well, no, not really : site1 - has apache / php / mysql + database x site2 - has apache / php / mysql + database y site3 - has apache / php / mysql + database z at 9:00 am all data

Re: describe all tables

At 2:54 PM -0500 1/28/02, Andy Ingham wrote: >A fellow in our shop wrote a perl script to do just that. Nice but I do not think I have perl DBI library installed. Does it have to be compiled in? I am on Mac OS X -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mai

Re: Accessing MySQL Using ASP

At 03:24 PM 1/28/2002 -0500, [EMAIL PROTECTED] wrote: >Does anyone have a good example of accessing and displaying data in a MySQL >database using ASP and displaying it on a web page? I'm a VB programmer and >I'm new to accessing databases from the web and just need one good example >to tie ever

Accessing MySQL Using ASP

Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks ---

Accessing MySQL Using ASP

Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks ---

RE: MySQL JDBC setup in weblogic.

This config worked for me: weblogic.jdbc.connectionPool.PoolName=\ url=jdbc:mysql://localhost:3306/test,\ driver=org.gjt.mm.mysql.Driver,\ initialCapacity=1,\ maxCapacity=10,\ capacityIncrement=1,\ props=user=DBUser;password=DBPassword weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.PoolName=

Accessing MySQL Using ASP

Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks ---

Accessing MySQL Using ASP

Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks --

re: MySQL Clients Hang

--On Monday, January 28, 2002 11:52:08 AM -0600 Ed Carp <[EMAIL PROTECTED]> wrote: > Hi, Bill! Did you ever get this issue resolved? I've got the same > problem - MySQL starts, but no clients can connect, not even mysqladmin. > TIA :) I have not completely figured out what the problem is a

Accessing MySQL Using ASP

Does anyone have a good example of accessing and displaying data in a MySQL database using ASP and displaying it on a web page? I'm a VB programmer and I'm new to accessing databases from the web and just need one good example to tie everything together. Thanks ---

RE: describe all tables

At 1:46 PM -0600 1/28/02, Paul DuBois wrote: >I'd write a script that issued SHOW TABLES, then a DESCRIBE for each >table. Thanks for the suggestion, I know some of the workarounds, I am looking for the shortcut. Consider this as a feature request: allow for describe to take a wildcard for the

[Fwd: describe all tables]

bash-2.04$ for i in `mysql mysql -e 'show tables;'`; do mysql mysql -e "describe $i;"; done Assuming bash as the shell, and os as UNIX, of course... Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ =

Re: describe all tables

You can write a shell script that does: mysqlshow database, and then loops throught the tables returned doing: mysqlshow database table Michael Collins wrote: >> From: Michael Collins [mailto:[EMAIL PROTECTED]] >> Can "describe" be used to show columns from all tables in a database? > > > At 9:

Re: describe all tables

A fellow in our shop wrote a perl script to do just that. Enjoy! Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] * #!/usr/local/bi

RE: describe all tables

At 11:33 -0800 1/28/02, Michael Collins wrote: >>From: Michael Collins [mailto:[EMAIL PROTECTED]] >>Can "describe" be used to show columns from all tables in a database? > >At 9:56 AM -0800 1/28/02, Bruce Sandell wrote: >>try mysqldump with the -d option. > > >That was my first thought, but this d

RE: describe all tables

Crack the Perl book. A script to do this using SHOW DATABASES and SHOW TABLES to get the lists would be fairly trivial to write. james montebello On Mon, 28 Jan 2002, Michael Collins wrote: > >From: Michael Collins [mailto:[EMAIL PROTECTED]] > >Can "describe" be used to show columns from all

RE: describe all tables

>From: Michael Collins [mailto:[EMAIL PROTECTED]] >Can "describe" be used to show columns from all tables in a database? At 9:56 AM -0800 1/28/02, Bruce Sandell wrote: >try mysqldump with the -d option. That was my first thought, but this does not give a result in the nice tables wish describe

Re: authentication

From: Don Smith <[EMAIL PROTECTED]> > our other alternative ms sql server 2000 which has the ability to > authenticate off samba Uh, oh! Another of our brethren is being tempted by the Dark Side. I doubt that MySQL could be easily coerced into external authentication, since the existing authe

Re: table lock

On Mon, Jan 28, 2002 at 12:00:43PM -0500, bin cai wrote: > Hi, > > I have one concern about multithread. I am building online exam > system. many students can get access to one table in one > time. Should i use table lock every time when one student get access > to the table. As i know, mysql is

RE: RE: How to emulate subselect on larger table? ###

Oops, I didn't realize that you were looking for more than one product id. Original Message: - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon, 28 Jan 2002 13:31:37 -0500 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: How to emulate subselect on larger table? ### Woul

MySQL JDBC setup in weblogic.

Does anyone know how to set up a connection pool to the MySQL database in weblogic.properties? I tried to set it up as follows: weblogic.jdbc.connectionPool.mysqlConnPool=\ url=jdbc:mysql:localhost:3306,\ driver=org.gjt.mm.mysql.Driver,\ loginDelaySecs=1,\ initialCapa

Re: authentication

I would like to use a single sign on for samba, mysql, and login...is this possible? our other alternative ms sql server 2000 which has the ability to authenticate off samba.is external authentication on the todo list? many thanks don smith

Re: URL encoding

At 1:50 -0800 1/28/02, Andrei B. wrote: >Is there a function for URL encoding a value ? > >Here's what I mean : > >select x from y >returns 'word1 word2 %word3' >If I were to put this into a URL, some browsers will not handle the URL >correctly, especially at the space character, also the same hap

RE: How to emulate subselect on larger table? ###

Would LIMIT work? select distinct prod_id from products, detail where and product.prod_id = detail.prod_id LIMIT 1; Original Message: - From: BD [EMAIL PROTECTED] Date: Mon, 28 Jan 2002 12:12:48 -0600 To: [EMAIL PROTECTED] Subject: How to emulate subselect on larger table? ###

Re: How to emulate subselect on larger table? ###

At 12:12 -0600 1/28/02, BD wrote: >I have 2 tables, detail and product. The detail table could have >millions of rows. The product table could have a few hundred. I need >to know which products are in the detail table. (It would also be >nice to know which products aren't in the detail table).

RE: How to emulate subselect on larger table? ###

Sounds like a job for a LEFT JOIN. However, before we can help, we need to know the table structure andhow the two tables are related. Of course, if sub-selects are out of the question. -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 12:13 PM To: [EM

starting mysql deamon

How do you start mysql autamaticaly on boot up ? Am running suse 7.2 linux with mysql installed to /usr/loca/mysql Thanks Samy __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com ---

RE: printing camera-ready mysql report

A "camera-ready document" is what is sent to a printing service. The print-out may have crop marks or color information. bb -Original Message- From: Andrew Gould [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 12:35 PM To: David S. Jackson; [EMAIL PROTECTED]; [EMAIL PROTECTED]

Source Install / Config problems

Hi folks, Hope some of you could help me here. I have done ./configure --prefix=/ussr/loca/mysql --localstatedir=/usr/loca/mysql/data --withunix-socket-path=/tmp/mysql.sock make make install 1/ There is no /usr/local/mysql/data directory 2/ There is no /tmp/myq

How to emulate subselect on larger table? ###

I have 2 tables, detail and product. The detail table could have millions of rows. The product table could have a few hundred. I need to know which products are in the detail table. (It would also be nice to know which products aren't in the detail table). The problem is it has to be fast, ver

(Sort of ) replication issue

David, Monday, January 28, 2002, 10:39:12 AM, you wrote: DS> Hi, I was wondering if any of you clever people out there can help me. I DS> have a client with a problem I'm sure some of you have fixed in the past ... DS> Client has 3 geographically separate sites, running same application (mine,

Re: printing camera-ready mysql report

Camera ready means the a commercial printer cn go direct from the provided document(s) to negatives/plates or direct to plate without having to modify the originals in any way. Save a lot of money in make up and AA charges. Jack Andrew Gould wrote: > > Please forgive my ignorance; but what is

Re: printing camera-ready mysql report

Andrew Gould writes: > Please forgive my ignorance; but what is a > "camera-ready document"? > > Andrew > That is easy : A document that looks so nice that you can spare one shot on it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROT

Granting Privileges

Hey there! Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic privileg

How to stop sql from executing in MySQL.exe?

Several times I have selected too many rows from a table while playing with the database in MySQL.exe (Win2k). So rather than wait for several thousand rows to scroll by, I press Ctrl-C. Of course this terminates the MySQL.Exe program entirely and puts me back at the DOS prompt. This is rather

RE: Selecting the row with largest number in a column

>You are correct... my apologies, I was thinking in VB where I built a handler to let me sent multiple sql statements in one chunk and where the '@' doesn't matter. BB This Works as a test... my $getbigage = $dbh->prepare( "SELECT \@maxage:=max(age) from contacts"); my $getbiga

Re: printing camera-ready mysql report

Please forgive my ignorance; but what is a "camera-ready document"? Andrew --- "David S. Jackson" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm just starting my first MySQL db, and I'm going > to want to > print out reports from it and produce a camera-ready > document. > Has anyone done this before

Re: Double foreign key references?

On Mon, Jan 28, 2002 at 06:48:30PM +0200, Heikki Tuuri wrote: : Philip. : : you must have an index on the referenced key in the parent table. Now : test_base has no indexes at all. Apparently, you also need indexes on the child table: mysql> create table test_bk ( fld int not null, primary key

RE: Speed problem with sorted select statements

* [EMAIL PROTECTED] > Description: > I try to get the last 5 different times and the first 5 > different times. There is a difference of aproximately > 1 minute and 40 seconds between this to queries. I do not see > reason for the difference in the execution times. There is a problem in some case

RE: Cannot import mysql dump

On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: > =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > > On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: > > > > Hi, > > > > Hmm, well because that's just a mysqldump of a database which already > > exists in mysql and it turned out that I cannot reimport it

Re: ? in primary key

At 8:52 -0800 1/28/02, Tiffany C. wrote: >Hello, > >It seems that the following preparedStatement is >changing the character ? to null. > >PreparedStatement selectLocation = >conn.prepareStatement("select location, addressLine1, >addressLine2, addressLine3, addressLine4, >addressLine5, addressLin

table lock

Hi, I have one concern about multithread. I am building online exam system. many students can get access to one table in one time. Should i use table lock every time when one student get access to the table. As i know, mysql is multithread,that means it already incorporate the table lock feature?

RE: Selecting the row with largest number in a column

You are correct... my apologies, I was thinking in VB where I built a handler to let me sent multiple sql statements in one chunk and where the '@' doesn't matter. BB -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:28 AM To: [EMAIL PROTEC

Re: ? in primary key

Hello, It seems that the following preparedStatement is changing the character ? to null. PreparedStatement selectLocation = conn.prepareStatement("select location, addressLine1, addressLine2, addressLine3, addressLine4, addressLine5, addressLine6, addressLine7, addressLine8, addressLine9, add

Re: SQL query

On Tue, 2002-01-22 at 22:40, DL Neil wrote: > Hi Jonas, > > > I wonder if its possbile to make a toplist from the folowing table: > > > > +--+--+ > > | name | status | > > +--+--+ > > | Bob | working | > > | Jane | sleeping | > > | Joe | sleep

printing camera-ready mysql report

Hi, I'm just starting my first MySQL db, and I'm going to want to print out reports from it and produce a camera-ready document. Has anyone done this before, using, say, Star Office or AbiWord or something? TIA. -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=

Re: Double foreign key references?

Philip. you must have an index on the referenced key in the parent table. Now test_base has no indexes at all. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: ? in primary key

At 7:37 -0800 1/28/02, Tiffany C. wrote: > >Hello! > >I have a table with one field that is a varchar & >primary key. Can the ? be added/updated/deleted to >this varchar primary key? What does this mean? You want to add a literal "?" character to the end of the column value? > >Thank you for y

RE: Selecting the row with largest number in a column

At 10:06 -0500 1/28/02, Butch Bean wrote: >Richard, > >I use this with all kinds of situations. >I am using this function and others like it on tables with 100k to 3m >records. >They always work best when the field your looking for info on is indexed. >Order By only causes a second process that se

Problem with norwegian characters

A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø Ø and å Å. (html: æ ø and å) When a string is inserted with either of these characters, and later selected and returned, they do not appear as they are supposed to. I.e: Ø becomes O. Also: Alphabetically sorting strings

? in primary key

Hello! I have a table with one field that is a varchar & primary key. Can the ? be added/updated/deleted to this varchar primary key? Thank you for your help. Sincerely, Tiffany __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Aucti

Re: seeking partner

And YOU are part of the problem - every spam is backed up by one of your complaints, doubling the traffic. If it really bothers you that much then set up a filter rule (killfile) for the persistent spammers, or risk being killfiled yourself - you have become a spammer. Can't you take your petiti

Speed problem with sorted select statements

Description: I try to get the last 5 different times and the first 5 different times. There is a difference of aproximately 1 minute and 40 seconds between this to queries. I do not see reason for the difference in the execution times. I am the only one who works on the database. Nobody else has

Re: selecting over various tables

At 15:52 28.01.02 +0100, you wrote: > > Your suggestion might work but I'm not sure if it's fast enough to be > > done "on-the-fly" (i.e. during a http user request) due to the fact that > > the tables are quite large and I have to "manually join" 10 tables :( > >I'd say that a UNION over 10 table

Re: innodb

Just add another file entry to my.cnf seperated by commas... You can add as many seperate files as you like... (within reason of course, eventually if the line length gets longer than 1024 or so you cant add anymore). Once you edit the file, restart mysql and innobase will detect the new file entr

renice -20 $$ in safe_mysqld

Keith, Sunday, January 27, 2002, 6:22:31 AM, you wrote: K> The MySQL documentation (2.6.1 Linux Notes) states that is essential to K> run the 'mysqld' process with the highest possible priority on the Linux K> 2.4 kernel and this can be achieved by adding 'renice -20 $$' to K> 'safe_mysqld'. Wh

  1   2   >