Re: alter table blocks other tables!

I would assume that if you have two MySQL threads, one doing the ugly ALTER TABLE and another responsible for a simple SELECT query (perhaps even query cached) on a table in another database, that no matter how long that ALTER TABLE thread took, the OS would schedule the SELECT thread soon enough a

Re: InnoDB question(s)

Hi Edward, Thank you for the reply. I really appreciate the response,but I was thinking into a different direction. I was hoping that perhaps additionally to the normal backup procedure that there is a shortcut or a trick which would quickly allow you to fix that specific issue (f.e. recover t

Re: Joining data

Ernesto, Are you looking for this? SELECT * FROM transaction INNER JOIN purchased_product ON transaction.number=purchased_product.transaction INNER JOIN payed_amount ON purchased_product.transaction=payed_amount.transaction WHERE transaction.number=1; PB - Original Message - From: Er

Re: INNODB Transactions

http://www.innodb.com/ibman.html#InnoDB_transaction_model Scroll down a bit to Section 8.5 Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Miguel Perez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, 09 June, 2003 18:44 Subject: INNODB Trans

Re: InnoDB question(s)

http://www.innodb.com/ibman.html#Backing_up See the section on Forcing Recovery. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 01:40 Subject: InnoDB question(s)

InnoDB question(s)

O.K MySQL List This one is on me, a bit funny, a bit strange but with a serious background. You are allowed to laugh ;-). Assuming that somebody has the "clever idea" to rename the folder for a InnoDB database f.e. on the command line base (mv command for Linux). Now the mysqld server startsu

Re: Need Help About mysql.sock ERROR

You have several options, here is, I think, the easiest: First you need to locate the sock file. The location depends on the distribution (in my system is in /tmp). Use "find / -name mysql.sock". On some distributions the name can be slightly different, for example mysqld.sock. Then create a sym

Need Help About mysql.sock ERROR

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Than

Re: Default Datetime?

At 0:23 +0100 6/10/03, Trevor Sather wrote: Hello I have a table for messages, and when a new message is inserted I want the current date and time to be inserted into the MessageDated and MessageTimed fields. I'm using MySQL 3.23.56 (?), with Chilisoft ASP, and using the MySQL Control Center inte

Re: Logging Into MySQL

At 21:01 -0700 6/9/03, CM Miller wrote: Hello. Been lurkin' on the list for awhile, I have the summer off, got Paul's book MySQL next to me, so I'm gonna hunker down and learn mysql on RH 8.0. Anyway, I'm learning about logging in. I saw the thread about user mysql and not having a password. When

Re: I need advice. MSAccess frontend to PHP/MYSQL. ANyone done this?

Interesting question. I'm not sure if such a tool exists, so I will explain how I would go about it without the aid of a third-party tool. The main thing you should realize right off the bat is that Access gives you a lot of functionality with buttons and other controls and they are quite easy to

Logging Into MySQL

Hello. Been lurkin' on the list for awhile, I have the summer off, got Paul's book MySQL next to me, so I'm gonna hunker down and learn mysql on RH 8.0. Anyway, I'm learning about logging in. I saw the thread about user mysql and not having a password. When I do the following for logging int

I need advice. MSAccess frontend to PHP/MYSQL. ANyone done this?

I want to move my Microsoft Access based front end (back end is already on MySQL/Linux) to PHP. MSAccess does have some forms that have VBscript in the, but I think I can figure other ways to do that.I am not a wizard with PHP, so I would interested in finding some open source apps, or something li

How to Upgrade MySQL 3.23 to MySQL 4.0

Hi All, I have a dependency problem in libmysqlclient.so.10 when I try to install MySQL 4.0 (rpm downloaded from www.mysql.com) This is a Redhat 8.0 system (original rpm install) If I perform a rpm -e mysql* it will tell me there's a dependency for libmysqlclient.so.10 for perl-DB

red hat 9.0 rpm issues

I'm running a fully up2date redhat 9.0 as my home webserver. I've got an idea to build something for my site that requires a a database backend, but havn't fully decided on the details of which technologies I will use. On the theory that it is generaly a good idea to keep up with latest version

Query cache not working with JDBC driver?

I have the query cache on MySQL 4.0.13-standard running and working fine, with a large amount of memory allocated to it. But it doesn't appear to be working with the MySQL JDBC driver access. I have used versions 2.0 and 3.0 of the JDBC driver. Although it will cache a query from the JDBC drive

Re: Trouble with SELECT AS syntax

I posted a page containing the reserved words at http://www.knowd.co.jp/staff/nils/ In case it is of any help for somebody. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > > SELECT item_n

Re: web app ideas

I really don't know. I'm doing this all by trial and error. I'm using www.spaceports.com to host it and they have php and mysql support. i know the php part works fine cuz I've tried a few pages. I just don't know how to work with the MySQL part going through them, but I'm sure I can find that o

Re: Trouble with SELECT AS syntax

Thank you much. I don't know why that didn't occur to me. :) Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Jim Winstead" <[EMAIL PROTECTED]> To: "Becoming Digital" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, 09 June, 2003

Re: Trouble with SELECT AS syntax

Jim was faster ;-), ..but I am getting there. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > > SELECT item_name AS name, item_desc AS desc FROM food; > > 'desc' is a reserved word. > > T

Re: Trouble with SELECT AS syntax

Hi Edward, I am not sure which version and OS you are using. I tried it on Suse Linux 8.1 and MySQL 4.1 alpha. I get the same error. It seems that there is a problem with this part "item_desc AS desc " AS a test I modified the definiton of item_desc to the same as the column item_name, but

Re: Trouble with SELECT AS syntax

On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > SELECT item_name AS name, item_desc AS desc FROM food; 'desc' is a reserved word. Try: SELECT item_name AS name, item_desc AS `desc` FROM food; Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://

Trouble with SELECT AS syntax

Despite my review of the manual, I cannot get my SELECT AS statements to work. Every attempt returns Error 1064. My statements, which appear to be in accordance with the manual (http://www.mysql.com/doc/en/SELECT.html), are formed as below. I have included my with my CREATE TABLE record for refer

RE: web app ideas

Timmy, Out of interest, what else did you think you would need to store? I believe you're correct in saying that this is all you need. The only possibility I can think of is if the host's PHP installation is not configured to your liking, wrong version for your needs, etc., in which case you migh

Joining data

I have three tables, to model a purchasing system: transaction number client date purchased_product transaction product price payed_amount transaction date amount This model allows me to have a transaction with multiple products and also record several payments on the trasacti

Re: diff between 7.2 and 8.0 rights?

Hi Mark, could you do a check at the following : do this on both machines: --- >mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.56-1-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> --- My guess

MySQL 4.0 Slave to 3.23.55 master Replication

I noticed that my MySQL 4.0.13 Slave Replication server is having a wierd problem. If you look at the master.info file on the slave it keeps updating like it is really updating the slave but in the mysql.err log it shows: 030609 16:12:08 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3

Re: Default Datetime?

You can't use a default value of NOW(), to the best of my knowledge. However, if your INSERT statement is properly formatted, you should have no problem getting it to do as you please. Personally, rather than having two hidden form fields, I'd just setup my INSERT statement as follows (using PHP

Re: alter table blocks other tables!

Can you grab the output of 'vmstat' or iostat or something that'll measure disk I/O next time this happens? I'm going to try real hard not to do that again until it is upgraded or another solution is found. What'd help more is adding more disks not a single faster one--unless the SCSI disk is an

Insert Image content via command line

Hi, I am trying to insert an image directly from command line into mysql table. My table looks like == Create table ImageTab (id int, content longblob); === I login to localhost. I have an image at /tmp. Then i issue this query insert into

Newbie Installation Question

When executing from the COMMAND PROMPT, the following is returned:   C:\>cd mysql      C:\mysql>cd bin      C:\mysql\bin>mysqlshow -u Administrator --password=1234567890 mysql   Database: mysql   +--+   |    Tables    |   +--+   | columns_priv |   | db  

Re: alter table blocks other tables!

On Mon, Jun 09, 2003 at 04:39:22PM -0700, Dan Edwards wrote: > > Against my better judgement I went ahead and added a field to a table > with 875,000 records, it took over 10 minutes. That pretty much makes > our games unplayable during that time. During this time other queries > that normally

Re: arrangement of fields in a table

Hi Mohitaba, Sounds to me that it makes sense to put the important 8 fields at least in a separate table to speed up any SELECT requests. You may even consider putting a copy of the small table containing only the 8 fields into the memory as a heap table ( if they are not containing any blobs

Re: alter table blocks other tables!

Against my better judgement I went ahead and added a field to a table with 875,000 records, it took over 10 minutes. That pretty much makes our games unplayable during that time. During this time other queries that normally take a few milliseconds took 1-30 seconds. For smooth operation it need

Re: Default Datetime?

On Mon, 2003-06-09 at 16:23, Trevor Sather wrote: > How can I get the default value to be now()? The only way I've succeeded is > by setting the type of field to VARCHAR, but that's not ideal. Trevor, take a look at the TIMESTAMP type: http://www.mysql.com/doc/en/DATETIME.html or, if you woul

Default Datetime?

Hello I have a table for messages, and when a new message is inserted I want the current date and time to be inserted into the MessageDated and MessageTimed fields. I'm using MySQL 3.23.56 (?), with Chilisoft ASP, and using the MySQL Control Center interface. The problem is that no matter what I

INNODB Transactions

Hi : I would like to know what happen if I start a transaction using BEGIN command I do some insert or update statements, and just before executing a ROLLBACK or COMMIT command I get disconnected and I can't execute those commands. For how long does the table remain locked, or in other words h

Re: alter table blocks other tables!

You say you are using replication. In this situation, if you make an update to the master (using ALTER...) that takes a long time, this will get serialized into the binary log as normal and block all subsequent queries from executing on the slave until it has completed. One of the issues with

Re: alter table blocks other tables!

On Mon, Jun 09, 2003 at 01:05:43PM -0700, Dan Edwards wrote: > > I have a mysql server containing multiple databases, one of the > databases is very important that it is not slowed down by other > databases. This database is used for a real time game server (card > games), and any stalls causes all

Re: Hi CPU on FreeBSD

CPU usage improved a lot as well... It's always above 90% free and before it was 70-75% idle... here is a snapshot: last pid: 58730; load averages: 0.09, 0.11, 0.08 up 9+20:59:57 17:11:24 216 processes: 1 running, 215 sleeping CPU states: 0.0% user,

alter table blocks other tables!

I have a mysql server containing multiple databases, one of the databases is very important that it is not slowed down by other databases. This database is used for a real time game server (card games), and any stalls causes all players to stall, they hate that. I've mostly solved this problem

Re: Hi CPU on FreeBSD

On Mon, Jun 09, 2003 at 01:41:00PM +, Gustavo A. Baratto wrote: > the load average in my freebsd 5.0 (latest releng) compiled statically > with linuxthreads decreased 80% after I tunned these variables: What about actual CPU usage? Did is increase similarly? The load average isn't necessari

Re: Hi CPU on FreeBSD

the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: set-variable = key_buffer_size=100MB set-variable = read_buffer_size=5M set-variable = table_cache=500 set-variable = max_delayed_threads=0 set-variable = max_use

Re: Turning off column and value reconciliation

Thanks for the suggestion, but its a tossup between that and the perl 8o( I'll need to give it some thought about how much I want to port. MySQL is sure easier to install and also faster (I'm told anyway, without getting my data in I can't be sure). best, Campbell At 04:22 PM 6/9/2003 -0400, Keit

RE: Turning off column and value reconciliation

Thanks for the suggestion Mike, but I have more columns than data values already 8o) At 02:17 PM 6/9/2003 -0600, Mike Hillyer wrote: There is no way to turn it off (well, no practical way, with open source nothing is impossible). Can you add dummy columns to the mysql table to the insert statements

Re: Turning off column and value reconciliation

On 9 Jun 2003 at 13:16, Campbell D. McCausland wrote: > Thank you for your responses. Unfortunately, the sql > I'm loading is output from another tool, so I don't > get to vote on the format of the insert statements. > > If it's not possible to just turn the check off, then I > guess I'll have to

RE: Turning off column and value reconciliation

There is no way to turn it off (well, no practical way, with open source nothing is impossible). Can you add dummy columns to the mysql table to the insert statements match up? Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL PROTECTED]

Re: Turning off column and value reconciliation

Mike, Keith, Thank you for your responses. Unfortunately, the sql I'm loading is output from another tool, so I don't get to vote on the format of the insert statements. If it's not possible to just turn the check off, then I guess I'll have to consider writing a perl script or something to add th

Re: SSL and Windows

http://www.google.com/search?q=openssl+windows&ie=UTF-8&oe=UTF-8 On Monday, June 9, 2003, at 01:43 PM, Sparky Kopetzky wrote: Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package bu

RE: SSL and Windows

Are you looking to encrypt fields or the entire session between client and server? SSL is used for the latter, for the former you could look at the ENCODE and DECODE functions. (See http://www.mysql.com/doc/en/Miscellaneous_functions.html) I can use them without openssl being installed. Regards,

Re: ADD CONSTRAINT on InnoDB tables

Marco, - Original Message - From: "Marco B" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 09, 2003 8:45 PM Subject: ADD CONSTRAINT on InnoDB tables > Hi all,=0D=0A=0D=0AI've just installed mysql 4.0.1 on my pc and I'm tryin= > g to migrate a set of old MyISAM

SSL and Windows

Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package but there isn't one for Windows. Help! Thanks in advance!! Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmes

Re: money field

I use Decimal, because I like my money calculations to be correct. Mojtaba Faridzad wrote: Hi, Which type do you usually use to keep money values? Decimal (12,2) or Float? to keep the first one, system takes 12 bytes but for the second one, 8 bytes. Thanks -- MySQL General Mailing List For

Re: money field

> A Float may be smaller, but only because it > rounds off the last several digits of large values. ... > Not big losses, but when dealing with financial accounting > it is generally an unacceptable inaccuracy. More to the point, if the DB rounds oddly, your attempts to access the data might fail.

RE: money field

I would use Decimal (12,2). A Float may be smaller, but only because it rounds off the last several digits of large values. A single-precision float uses 23 bits for storing digits, meaning that for values over 8,388,607 you are loosing pennies. When storing a value around 100 Million you would loo

Re: Turning off column and value reconciliation

On 9 Jun 2003 at 12:13, Campbell D. McCausland wrote: > General error: "Column count > doesn't match value count" > > I know what it means, but I need MySQL to turn off this > checking. I'm loading legacy data into a new database > that has some extra colu

RE: Turning off column and value reconciliation

Why not just specify what columns you are inserting into? This check has to be in place, because in the case of a mismatch MySQL would not know which value goes into which column. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL PROTECT

Joining unrelated data

I have three tables, to model a purchasing system: transaction number client date purchased_product transaction product price payed_amount transaction date amount This model allows me to have a transaction with multiple products and also record several payments on the trasac

Turning off column and value reconciliation

I'm getting the error message:- General error: "Column count doesn't match value count" I know what it means, but I need MySQL to turn off this checking. I'm loading legacy data into a new database that has some extra columns and I just want to fill the o

Re: Hi CPU on FreeBSD

On Mon, Jun 09, 2003 at 11:26:36AM -0700, Lalo Castro wrote: > > We had the same problem. Upgrading Freebsd to 4.8 and recompiling > MySQL to work with Linux style threads seemed to work. Great. > The MySQLd process no longer pops up to ~90% on each request. > However, with the application we're

money field

Hi, Which type do you usually use to keep money values? Decimal (12,2) or Float? to keep the first one, system takes 12 bytes but for the second one, 8 bytes. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL P

Re: fastest way to get last row

Hi Thanks! Looks like everyone knew the exact answer. I guess I posted too soon, as I figured it out also. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: "Ryan Yagatich"

Duplicates, but different

Good Afternoon! I have a table like this; id (unique, auto-increment) foo char(6) bar char(10) foo may be duplicated from row to row, bar may be duplicated from row to row i.e. foo bar 949433 IRVINE 949514 NEWPORTBCH 949514 NEWPORTBCH 949533 IRVINE 949533 IRVINE 949633 SADLBK VLY It

RE: **field type for large amount of text***

Well, that would be TEXT, MEDIUMTEXT, or LARGETEXT, they hold 65535, 16777215, and 4294967295 characters accordingly. I personally would stick to TEXT, maybe MEDIUMTEXT. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: Monday

**field type for large amount of text***

What is the best field type to use for a field that will be used to display a large amount of text (and possibly numbers) IE a field that will display the main text for a web page. Thanks -Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

diff between 7.2 and 8.0 rights?

Hi I have 2 servers both with 3.23.56-1 installed via rpm's proteus2 which is running RedHat 7.2 on 1 cpu and has been in use for over 1 year works as expected. [EMAIL PROTECTED] [/var/lib/mysql]# mysqladmin status Uptime: 515357 Threads: 1 Questions: 2412696 Slow queries: 782 Opens: 19654

Re: fastest way to get last row

Couldn't something like this work? SELECT id,foo,bar FROM tbl ORDER BY id DESC LIMIT 1 Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http://www.pant

Re: array/pointer question

Peter Brawley wrote: Peter Brawley wrote: MySQL, like other relational databases, does not support arrays or pointers. I didn't write that. My apologies -- it was written by John Griffin, not Peter Brawley. I edited carelessly. Oops. Bruce Feist -- MySQL General Mailing Lis

Re: Hi CPU on FreeBSD

We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're running that queries the database (Request Tracker 3), we still get proc

Re: fastest way to get last row

On Mon, Jun 09, 2003 at 02:22:56PM -0400, Chris Edwards wrote: > Hi > > Does anyone have tips on the fastest way to get the last row in a table. > > What I have is an int as the the primary key, using auto inc. > > I currently do a select max(id), then run another query retrieving a row > based

RE: fastest way to get last row

SELECT * FROM table ORDER BY id DESC LIMIT 1; Regards, Miek Hillyer www.vbmysql.com -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 12:23 PM To: MySQL List Subject: fastest way to get last row Hi Does anyone have tips on the fastest way t

fastest way to get last row

Hi Does anyone have tips on the fastest way to get the last row in a table. What I have is an int as the the primary key, using auto inc. I currently do a select max(id), then run another query retrieving a row based on the the max(id). Its two queries. Would I be able to get it all into one

Re: array/pointer question

>Peter Brawley wrote: >> MySQL, like other relational databases, does not support arrays or >>pointers. I didn't write that. PB

Re: array/pointer question

Peter Brawley wrote: MySQL, like other relational databases, does not support arrays or pointers. Of course, relational databases don't allow duplicate rows in table, either... I have yet to find a "relational" database with that feature! Bruce Feist -- MySQL General Mailing List For lis

Re: array/pointer question

Some intros on the web are listed at http://www.artfulsoftware.com/dbresources.html - Original Message - From: John Griffin To: Ioana ; [EMAIL PROTECTED] Sent: Monday, June 09, 2003 10:38 AM Subject: RE: array/pointer question Hi, MySQL, like other relational databases, doe

Re: subselects in 4.1 and indexes

On Mon, Jun 09, 2003 at 12:46:32PM -0500, Christopher Knight wrote: > Im have a problem / misunderstanding with the 4.1 release. Im having issues > with indexes related to 'IN' vs '=' in subselects. > assume the subselect returns 1 value > > select SQL_NO_CACHE user_id from table_a where user_id

Re: arrangement of fields in a table

On Mon, Jun 09, 2003 at 01:40:47PM -0400, Mojtaba Faridzad wrote: > Hi, > > I need to define for example 100 fields in a table. 8 of them are more > important and many queries just need these fields. Should I define them > before the other fields in the table or it doesn't matter? Is accessing the

subselects in 4.1 and indexes

Im have a problem / misunderstanding with the 4.1 release. Im having issues with indexes related to 'IN' vs '=' in subselects. assume the subselect returns 1 value select SQL_NO_CACHE user_id from table_a where user_id in (select SQL_NO_CACHE user_id from table_b where ... blah) 9.5 seconds... s

ADD CONSTRAINT on InnoDB tables

Hi all, I've just installed mysql 4.0.1 on my pc and I'm trying to migrate a set of old MyISAM table to InnoDB type table, to introduce referential integrity on my data. I found this problem. I create an index for each key in the references and the sql command ALTER TABLE utenti ADD CONSTRAINT

arrangement of fields in a table

Hi, I need to define for example 100 fields in a table. 8 of them are more important and many queries just need these fields. Should I define them before the other fields in the table or it doesn't matter? Is accessing the the beginning fields faster than the other fields? thanks -- MySQL Gene

RE: How to get meta data info in MySQL

At 10:11 -0700 6/9/03, Karen Chu wrote: Thanks for the reply! Please see my pseudo code below. @@@ mark is the place where my questions come from. I wonder if it is doable in MySQL. I'm not sure why you wonder that. You've received several replies so far that indicate you cannot use SELECT for thi

Re: How to get meta data info in MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karen Chu wrote: > Thanks for the reply! > Please see my pseudo code below. @@@ mark is the place where my > questions come from. I wonder if it is doable in MySQL. > > I wish to have code like this: (@@@ is where my questions come from) > // connect

AW: AW: mysql linux user

Hi, ok, now I understand! I was just a little bit confused, because I got a preinstalled virtual server with MySQL already installed on it! The user 'mysql' was a shell user: mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash Thanks for your help!! Regards Andy > -Ursprungliche Nachricht

Fw: 2 questions about indexing and testing speed

Hi, I'm learning MySQL and I got two question: 1) As I know, MySQL has a buffer to keep the last records which have been retreived. So if I run a query two times, the second time will be faster. How can I temporarly stop this service? because I want to run different queries and compare their sp

RE: How to get meta data info in MySQL

Thanks for the reply! Please see my pseudo code below. @@@ mark is the place where my questions come from. I wonder if it is doable in MySQL. I wish to have code like this: (@@@ is where my questions come from) // connect to the DB // list all table names in the dtabase print "$table Table"; //

Re: Certification study quide from Dubois, Hinz and Pedersen

Hi Paul, 2003年 6月 10日 火曜日 01:26、Paul DuBois さんは書きました: > At 1:08 +0900 6/10/03, Nils Valentin wrote: > > > > > >Hello Stefan, > > > >well I have my sources ... ;-) .. I guess its no secret ,especially as it > > was announced on the UC. > > > >I guess when you say Q3 you mean the english version, w

Re: Certification study quide from Dubois, Hinz and Pedersen

At 1:08 +0900 6/10/03, Nils Valentin wrote: Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a german version ? If yes , when ? I am not asking to pin you down

Re: Batch Deletes...

At 11:01 -0500 6/9/03, Todd Gruben wrote: in the TRUNCATE TABLE t1 This is the documented behavior: http://www.mysql.com/doc/en/TRUNCATE.html You cannot use TRUNCATE on tables for which you hold locks. On Monday 09 June 2003 10:57 am, you wrote: At 9:01 -0500 6/9/03, Todd Gruben wrote: >In an

Re: array/pointer question

Arrays are coming from version 5.0 as far as I know the plans. Best regards Nils Valentin 2003年 6月 9日 月曜日 23:49、Ioana さんは書きました: > Hello, I have just recently started learning mysql, and was wondering if > it supports arrays/pointers(for linked lists) of any types, and if so, > what is the synta

Re: Certification study quide from Dubois, Hinz and Pedersen

Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a german version ? If yes , when ? I am not asking to pin you down really I am asking so that I can make p

Re: Batch Deletes...

At 9:01 -0500 6/9/03, Todd Gruben wrote: In an effort to speed up large batch deletes i devised this script. LOCK TABLES t1 WRITE; SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date>="2003-06-09"; TRUNCATE TABLE t1; LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1; UNLOCK TABLES; this script w

RE: array/pointer question

Hi, MySQL, like other relational databases, does not support arrays or pointers. Arrays and pointers do not fit within the relational model. It would take quite a bit of text to describe what the relational model is and how to use SQL to manipulate data. I suggest that you read a good text on r

Re: Loading database information from a text file.

from a command prompt mysqldump -opt database >dumpfile Curtis On Sunday 08 June 2003 02:59, JeRRy wrote: > Okay thanks. > > One last thing. > > From the mysql prompt how can I generate a database > backup? (So I can see the database setup in notepad > so I can backup and transfer easily online

Re: Do all mysql versions from 4.1 support sub selects?

"Nils Valentin" <[EMAIL PROTECTED]> wrote: > Will all mysql versions (std, max and debug) from 4.1 support sub selects or > will this only be included f.e in the max version ? In all. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by E

Re: Help! How to generate a list of consecutive numbers with a SELECT?

"Martin Szabo" <[EMAIL PROTECTED]> wrote: > I've tried to find a way to generate a list of consecutive numbers with a > SELECT statement. > I would like something like "Select ..." that would result the numbers > between 1 and 20 on separate rows. > > So far, the only solution I have found is to

Re: My SQL ERROR 2002

"skjois" <[EMAIL PROTECTED]> wrote: > I get this error > > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > how can i get rid of this? Easily. Start MySQL and get rid of the message. :-) -- For technical support contracts, goto https://order.mysql.

Re: Certification study quide from Dubois, Hinz and Pedersen

Nils, > Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, Ah! How did you find out? ;-) > I was wondering if you guys would let me know about the release schedule of > the "MySQL Certification Study Guide " which is about to be released - as > announced on the UC 2 months ago. > Any informati

RE: How to empty the cache?

Thanks. I will try it. Iago Sineiro. -Mensaje original- De: Dan Nelson [mailto:[EMAIL PROTECTED] Enviado el: lunes, 09 de junio de 2003 16:54 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: How to empty the cache? In the last episode (Jun 09), Iago Sineiro said: > Sorry for the ambig

array/pointer question

Hello, I have just recently started learning mysql, and was wondering if it supports arrays/pointers(for linked lists) of any types, and if so, what is the syntax... could not find info on this in any manual. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: How to get meta data info in MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karen Chu wrote: > I wish to have something like 'select name from all_tables' in oracle or > 'select name from sysobjects' in Sybase. Oracle has 'show tables' or > 'describe ' too, but actual meta data is *stored* in systems > tables. I wonder if MyS

  1   2   >