Re: Multiple updates

That the thing see, the form(using GET instead of POST) sends data with the new dates like this:- id=1&name=Mark&job_number=AA1&job_date=2002-5-19 &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 &id=3&name=Mark&job_number=AA3&job_date=2002-5-25 and the UPDATE query like

problem

respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how

RE: MySQL and stored procedures -> v4.1 :(

> > Checked my own version and found it to be "Ver 11.16 Distrib 3.23.49". > > > > He, version 11??? Quit confused, but after a sanity check with reality > > I realized I must be using version 3.23. Anyhow, check the status of > > next version and found out that version 4.0 is in alpha mode... >

RE: MySQL and stored procedures -> v4.1 :(

Did I ask for optimization tips? Nope. ;) But I did ask for a release date of version 4.1. > -Original Message- > From: Land, Christopher > Sent: Friday, April 12, 2002 11:18 PM > To: Jon Frisby; Mysql List > Subject: RE: MySQL and stored procedures -> v4.1 :( > > > 5.2.12 Other Opti

new windows Tool

Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip __

database problems

respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how

Re: Multiple Inserts

Mark > Does anyone know if it's possible to insert mutilple records into 1 table > in one query? yes > Something like - > > insert into mytable (id,name,job_number,job_date) values > ('1','Mark','AA1','2002-04-15') > > insert into mytable (id,name,job_number,job_date) values > ('2','Mark','AA2'

Re: Multiple updates

Mark, Is it a two-fer-one sale today? > I'm now trying to UPDATE the three records with one query. > > Once the data is INSERTED into the db with this - > > insert into mytable (id,name,job_number,job_date) values > ('1','Mark','AA1','2002-04-15'), > ('2','Mark','AA2','2002-04-16'), > ('3','Mark

Re: Multiple updates

Mark, Earlier joke rebounds - pardon me whilst I wipe the comedic egg from my face... > That the thing see, the form(using GET instead of POST) sends data with > the new dates like this:- > > id=1&name=Mark&job_number=AA1&job_date=2002-5-19 > &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 > &

Проблема Mysql on FreeBSD

Ïðèâåòñòâóþ òåáÿ, mysql, Ïðîøó ïðîùåíèÿ çà íàçîéëèâîñòü íî êàðòèíà òà æå è íå çíàþ ê ñîæàëåíèþ êàê ñ íåé áîðîòüñÿ... :( --- Ôðàãìåíò Top - last pid: 55153; load averages: 1.60, 1.43, 1.35 up 4+19:23:57 10:42:44 205 processes: 2 running, 202 sleeping, 1 zombie CPU states: 23.7

mysql server not starting

From: terrence To: [EMAIL PROTECTED] Subject: see above Description: MySQL version 3.23.47 Darwin 5.x When I run mysqladmin version, I get the following message: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mys

Re: Multiple updates

> That the thing see, the form(using GET instead of POST) sends data with > the new dates like this:- > > id=1&name=Mark&job_number=AA1&job_date=2002-5-19 > &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 > &id=3&name=Mark&job_number=AA3&job_date=2002-5-25 > > and the UPDATE query like this:- >

mysql@lists.mysql.com

imran, Sunday, April 14, 2002, 1:26:42 PM, you wrote: i>Description: i> After installing the mysql server i moved it to my home dir under SQL. Tried i> running the configure script first. Then i tried mysqladmin version but it i> doesnt help. It says that not able to find /tmp/mysql.sock file. i

Re: How to find out where is the installation directory

Jayakumar, Monday, April 15, 2002, 7:24:14 AM, you wrote: JD> I am using Red Hat 7.1. When i use rpm query, it says that I have My SQL JD> 3.23 Server and Client installed. Where can i find the installation JD> directory. It depens on your installation ... If you installed MySQL from w

Re: Difference between MySQL and MySQL Max

Jayakumar, Monday, April 15, 2002, 6:54:05 AM, you wrote: JD> I am new to MySQL. Can anyone tell me what is the difference between JD> MySQL and MySQL Max. MySQL-Max is the extended MySQL server. It's configured with options: --with-server-suffix=-max --with-innodb

Re: problem

HITESH, Monday, April 15, 2002, 10:44:45 AM, you wrote: HP> i had to recently encounter of entering the movie HP> files in a database using the blob datatype. HP> the problems i faced are: HP> 1) while creating the table how do i mention the size HP> of the blob field. say.. HP>

Re: connect from foreign host

Gokce, Saturday, April 13, 2002, 1:19:26 PM, you wrote: GA> I can use mysql server with all ways from localhost. But, there is no GA> connection from any foreign host. I have two linux server. One of is mysql GA> server. I try to connect from other server to mysql server. GA> mysql -u user -h m

Re: new windows Tool

I have no objection to you promoting your wares in this group of to your entrepreneurial skills. But to get the message "This trial has expired" on the first run after installing the 9 meg plus download is a bit rough, isn't it? And definitely not the way to win customers! Pierre amr salah w

Re: problem

HITESH PATEL wrote: > > respected sir/madam, > > i had to recently encounter of entering the movie > files in a database using the blob datatype. > > the problems i faced are: > > 1) while creating the table how do i mention the size > of the blob field. say.. > > create table

RE: search problem

When I so a search on www.mysql.com I get this! <---snip---> Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /production/data/nweb/public/udmsearch/mysql.php on line 25 Error: Could not connect t

Optimizing Indexes and such in MySQL

I'm interested to know how people keep their MySQL tables up-to-date on a regular basis. what is the methodology used to keep up indexes up to date and tables optimized etc... thanks berber - Before posting, please check: ht

installation of mysql

Hello, I want to install the source distribution of Mysql on Solaris 2.7. I have make this: gzip mysql-3.23.45.tar.gz gtar xvf mysql-3.23.45.tar cd mysql-3.23.45 setenv CFLAGS "-O3" setenv CXX gcc setenv CXXFLAGS "-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/opuski

RE: RE: Writing to net

Does anyone have an idea about what this is? I see this sometimes in the process list of MySQL. thanks berber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

FULLTEXT index question

Environment: MySQL Version 3.23.42 FreeBSD 4.4 ISAM table of about 300,000 rows and 10 columns with a column structured as varchar(50) upon which exists a FULLTEXT index Behavior: The query select * from tablename where match(column_name) against('tree'); selects seven records. The query

Re: How does DISTINCT really work ?

Hi! Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed in 4.0. Regards, Heikki Innobase Oy - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "SDiZ (UHome)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL

Re: FULLTEXT index question

Hi! On Apr 15, Nicholas Murphy wrote: > > The query > > select * from tablename where match(column_name) > against('three'); > > fails to match any record. > > Ten to twelve records in the table are know to have > the distinct word "three" in them in the indexed column. > > Question: > >

Re: How does DISTINCT really work ?

Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql> \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch <(13:29:52) # This is a BitKeeper generated patch for the follow

Create table from results of a query

Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger -- Renger van Nieuwkoop [EMAIL PROTECTED] -

Create table from results of a query

Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger -- Renger van Nieuwkoop [EMAIL PROTECTED] -

Re: How does DISTINCT really work ?

Hi, Sorry finally there is no lock with 'use database', it only takes a huge amont of time because of the number of table in my database :) Regards, Jocelyn - Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[E

Newbie question: Create table from query or export query

Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger _ ECOPLAN Forschung und Beratung in Wirtschaft und Politik Econom

don't work search on www.mysql.org - no connect to mysql

Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /production/data/nweb/public/udmsearch/mysql.php on line 25 Error: Could not connect to mysql: Kokorev Alexey E-mail: [EMAIL PROTECTED] | http://w

Running multiple queries using "MySql" client

Hello all, I'm in a mysql client session and I want to do multiple inserts into a table (or run a multi-query script etc). This doesn't work so what's the correct seperator / methodology? INSERT INTO mytbl (a1) VALUES (12); INSERT INTO mytbl (a1) VALUES (13); INSERT INTO mytbl (a1) VALUES (14); \

Bad Handshake

Hi i need to access a MySQL Server via socket programming to check if it is alive. My script works fine but the mysql server blocks the host that is running the script after 10 connects because I get the bad handshake error. Is there any way to connect and cleanly disconnect to port 3306 without

Re: Newbie question: Create table from query or export query

Yes. Assuming you are comfortable using the mysql client program you could use: CREATE TABLE newtablename SELECT * FROM existingtablename; In addition, if you have an existing table and need to load data from a text file you could use: LOAD DATA INFILE 'textfilename.txt' INTO TABLE existingt

"gunk" in mysqldump output

In some recent release of MySQL, lines like this: /*!4 ALTER TABLE States DISABLE KEYS */; ...were added to the output of "mysqldump --opt". This causes my usually "load" statement: "mysql < dumpfile" ...to fail with "ERROR 1046 at line 11: No Database Selected". If I do "mydsql -f < dum

Re: How does DISTINCT really work ?

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> From: "SDiZ (UHome)" <[EMAIL PROTECTED]> >> I think every thing are documented. >> >> http://www.mysql.com/doc/B/u/Bugs.html >> a.. The optimiser may handle DISTINCT differently if you are using >> 'hidden' columns in a jo

Signal 11 after flush privileges

Hi Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com After deleting some users from user table and invoking flush privileges, I got "Lost connection to server during query" Resolved stack trace as follows: 0x806e2d4 init_signals__Fv + 16 0x82b12b8 _end + 271548 0x82d9f96

Re: Create table from results of a query

Your, Monday, April 15, 2002, 2:40:54 PM, you wrote: YN> Is it possible to create a new table from the results of a query, or YN> export the result directly to a file (txt, csv, excel or alike) using YN> MySQL? How is it done? Yes, it's possible. You can use CREATE .. SELECT statement for crea

Re: hello, i need help, about mysql MISSING charsets

Xuefer, Monday, April 15, 2002, 8:55:08 AM, you wrote: X> mysql-4.01 X> binary package X> windows X> also the same in linux source/binary package X> when SHOW VARIABLES X> got: X> - X> character_set gbk X> character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620

Re: mysql server not starting

Terrence, Monday, April 15, 2002, 12:26:31 PM, you wrote: TT> Description: TT> MySQL version 3.23.47 Darwin 5.x TT> When I run mysqladmin version, TT> I get the following message: TT> 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' TT> (2)' TT> Check that mysqld is running

Re: Ïðîáëåìà Mysql on FreeBSD

amber46, Monday, April 15, 2002, 1:21:54 PM, you wrote: a> Ïðèâåòñòâóþ òåáÿ, mysql, This mailing list is read by thousands subscribers in the world and most of them don't speak russian, so please use ONLY english here. a> 14350 mysql 57 0 53732K 30240K RUN365:15 79.88% 79.88% my

RE: Hi I'm a Newbie

sql,query I also looking for a good ASP 3.0 mailing list Peter Sampson http://www.cfcnet.co.uk The information contained in this email is intended only for the person or organization to which it is addressed. If you have received it by mistake, please disregard and notify the sender immed

Re: BUG using left join.

Hi, Note that if you are using a condition on a t_boxdaily field in the where clause, i think that your "left join" will not take the desired effect. If there is a record in table t_fund that it's not in t_boxdaily then the t_boxdaily fields would appear in the result with NULL values (because

Re: How does DISTINCT really work ?

Fournier Jocelyn [Presence-PC] writes: > Hi, > > I have the latest 4.0.2 source installed, and the problem is still here > AFAIK : > > mysql> \s > -- > mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) > > -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch > <(1

Re: MySQL counter for HIGH traffic site

Hello. First let me say, that I was talking about the MySQL side of things. If pconnect was broken in this regard - and I would call the behaviour you described as broken - just don't use it. On Mon, Apr 15, 2002 at 12:14:07AM -0600, [EMAIL PROTECTED] wrote: > Actually, with a pconnect, there wo

Uploading Korean Data

A while ago I was asking about multi-language support in MySQL. In the end we ran several instances of MySQL, each with it's own database, for each language. I can now run the website in Korean, enter, save and retrieve data through the webpage, but, I am unable to take a CSV file (in Korean) an

Boolean!

Hello! Well their you have it! It's a mysql freakshow out there..:) How can I set the domain of a attribute to a boolean value? T.T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:

Re: Signal 11 after flush privileges

Rafal, Monday, April 15, 2002, 4:54:23 PM, you wrote: RJ> Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com RJ> After deleting some users from user table and invoking flush privileges, I got RJ> "Lost connection to server during query" Resolved stack trace as follows: R

RE: Boolean!

Hi T., > How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking "how do I define a field as a boolean"... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to defin

Re: Signal 11 after flush privileges

> Rafal, > Monday, April 15, 2002, 4:54:23 PM, you wrote: > > RJ> Version Mysql-Max-3.23.49a for Linux, binary distribution from > www.mysql.com RJ> After deleting some users from user table and invoking > flush privileges, I got RJ> "Lost connection to server during query" > Resolved stack trace

Is there a sql query to Copying tables

Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? Thanks in advance PS how long has the sql,query requirement been on this list? - Before posting, please check: http://www.mysql

Re: MySQL counter for HIGH traffic site

Hello. On Sun, Apr 14, 2002 at 11:16:02PM -0400, [EMAIL PROTECTED] wrote: > On Sun, 2002-04-14 at 22:17, Craig Westerman wrote: > > I'm needing counter for site that receives 80 to 120 hits a minute at peak > > load. Many I [...] > I personally wouldn't recommend logging to mysql. 80 to 120 quer

RE: Boolean!

I use char(1) with 't' and 'f'. The JDBC-Driver I am using (mm.sql) recognizes this correctly as Boolean. Peter > -Original Message- > From: Jon Haworth [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 15, 2002 5:24 PM > To: 'T.Thiessens'; [EMAIL PROTECTED] > Subject: RE: Boolean! > >

Compile Problem - sql_lex.cc has undeclared functions (symbol, sql_functions, get_has_symbol)

I'm unable to get mysql compiled due to problems during my make. I am using gcc 3.04 on a Sparc 20 running Solaris: uname -a: SunOS primus 5.8 Generic_108528-06 sun4m sparc SUNW,SPARCstation-20 When I run the make I get the following problem with sql_lex.cc sql_lex.cc: In function `void lex_

RE: Boolean!

> > How can I set the domain of a attribute to a boolean value? > > OK, I'm not entirely clear with your terminology, but I think > you're asking > "how do I define a field as a boolean"... > > MySQL doesn't provide a boolean datatype as such, but in my experience the > best way to handle it is t

RE: Is there a sql query to Copying tables

Hi, You can just do "SHOW CREATE TABLE ..." and copy+paste it with a different table name in the command line.. See: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Or else, if you are using phpMyAdmin , you can do it with a mouse click. Gurhan -Original Message- From: Jason [mail

RE: Boolean!

ENUM datatype might help you... See: http://www.mysql.com/doc/E/N/ENUM.html Gurhan -Original Message- From: T.Thiessens [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Boolean! Hello! Well their you have it! It's a mysql freakshow out

Re: update question number in mysql

Hi, Steven and christopher, Thanks a lot for your help. I think i have to store the question number in table. my talbe questionbank store the questions related more than one course. every course has six question sets. so i use question set id and question number as primary key. There is one probl

Re: Is there a sql query to Copying tables

> Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? create table x select * from table y where 1=0; -Lance filter: sql - Before posting, please check: http://www.mysql.com/manual

Re: Is there a sql query to Copying tables

CREATE TABLE new_table SELECT * FROM old_table LIMIT 0; - Original Message - From: Jason <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 10:44 AM Subject: Is there a sql query to Copying tables Is there an easy way to copy/use the structure (not data) of a skele

Connection timing problem?

Hi, I have installed MySQL and everything runs great. Most of the apps I'm running are perfectly fine except one problem: Through a webpage of mine I send a request to the database. Works great and I get a return no problem with the correct response. But when I ask it again right away to do anoth

RE: Bill-of-Materials

So far I have seen this feature in Oracle and DB2 alone. I am yet to find any other RDBMS. Vivek Chaudhary > -Original Message- > From: len [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 13, 2002 7:10 AM > To: mysql > Cc: len > Subject: Bill-of-Materials > > > Hello! > > As a new

Problems with Make on 3.23.49 on Sun SPARC 20 with Solaris 2.6

>Description: Attempted to compile this version on a SPARC 20 running Solaris 2.6. Installed GNU gcc 3.0.2 and make 2.76 specifically for this installation. Normally use the make from SUN and the C compiler from Sun SparcWorks. Ran configure with the following set of command line options.

beginners question

I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd numb

Re: cron job help running mysql/php script

I am trying different options but everytime i make a change and type crontab mycron.txt in telnet it comes to the next promp without an error message. But it doesnot do what i want it to do. How can i even test if the cron tab is finding the file. Like the php file runs fine when run from a bro

mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)

>Description: I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then moved the data directory to a file server so it will be part of daily backups (/proj/we

RE: MySQL and stored procedures -> v4.1 :(

> > I'll trust a MySQL alpha release before the final production releases of > > most vendors. In fact, we're using 4.0.1 in our production > environment with > > great success. > Its your system, and if you think it worth the risc, it is of course you > decision to do so to, ;) but I would never

Uploading Korean Data - More detail

Apologies for sending again but though it may help if I add some more info. I can see my data in notepad in Korean, I have tried to save this as ANSI, Unicode, Unicode big enidian and UTF-8 and they all end up scrambled after I import the file. - A while ago I was asking

RE: MySQL and stored procedures -> v4.1 :(

> But I did ask for a release date of version 4.1. When it's ready. > A nice thing with a stored procedure is that you can lower the load > impact made by heavy queries on the database by using cursors to soften > the performance hit they are likely to make - e.g. make the query behave > like a

Sorting alphabetically using charsets other than Latin 1

Hello, I have a table with text data in English in one column, same data in Russian (cp1251) in another, and so on. I'd be happy to retrive that data sorted alphabetically according to the *respected alphabets*. I couldn't figure out how to perform this despite I compiled MySQL with alternative c

MySQLAdmin

Please, can anyone tell me where is the source code for MySQLAdmin.exe for Win32? Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

RE: MySQL and stored procedures -> v4.1 :(

> > But I did ask for a release date of version 4.1. > > When it's ready. That's a tautological answer. > > A nice thing with a stored procedure is that you can lower the load > > impact made by heavy queries on the database by using cursors to soften > > the performance hit they are likely to

Re: beginners question

show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 12:11 PM

RE: beginners question

actually, another member of this list has already helped me figure it out. thanks. -Original Message- From: Richard Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 3:42 PM To: Marcia Clover; [EMAIL PROTECTED] Subject: Re: beginners question show your table structures show

Re: cron job help running mysql/php script

crontab -l will list your current crontab entry. Cron is not running your job from a browser. If it won't run from your unix $ prompt, it won't run from cron. Harpreet Kaur wrote: > I am trying different options but everytime i make a change and type > crontab mycron.txt in telnet it comes

Re: Copying tables

I though everyone may wish to know, I found an easy way to do this. SHOW CREATE TABLE table_name This will give you the SQL syntax for a createtable... Thanks everyone - Original Message - From: <[EMAIL PROTECTED]> To: "Jason" <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 9:24 AM S

RE: Feature? (Not null and timestamps)

sql,query One of our developers pointed out something to me today and I can't explain. When we created a table with timestamp as one of the column types and "not null" the "describe table" command shows that nulls are allowed for the timestamp column. However, a "show create table" command shows

Timestamp and Load Data command

We are attempting to put records into a table using the "load data" or mysqlimport commands. One quirk is with columns that include a timestamp type. When we import the records we get zeros in the timestamp column. How can we get the current time inserted when using the "load data" or mysqlimpo

subselect query

I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE prod_type='foo'); But I get the error: ERROR 1064: You h

Re: subselect query

Read the manual. MySQL doesn't support subselects but offers you alternatives. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: > I'm trying to do a fairly simple select of a > column from a table where the date of that column > happens to be the highest value. I tried this: > > SELECT name

MySQL dying suddenly

I received the message that made our MySQL die sometimes now. Our mysqld is the binary package available @ www.mysql.com. Version is 3.23.49a The error message is below. key_buffer_size=16773120 record_buffer=1019904 sort_buffer=1048568 max_used_connections=284 max_connections=500 threads_conne

Re: subselect query

Yeah, that nasty thing with temporary tables and such? Or am I looking at the wrong page? If you could point me in the right direction, I'd appreciate it (slow modem connection, etc). Christopher Thompson wrote: > Read the manual. MySQL doesn't support subselects but offers you > alternatives.

Re: subselect query

http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Sub-selects On Monday 15 April 2002 2:49 pm, Jeff Shipman wrote: > Yeah, that nasty thing with temporary tables and > such? Or am I looking at the wrong page? If you > could point me in the right direction, I'd

Re: "gunk" in mysqldump output

Use option "-K or --no-disable-keys" with myqldump. > Date: Mon, 15 Apr 2002 09:37:43 -0400 > To: [EMAIL PROTECTED] > From: Bill Marrs <[EMAIL PROTECTED]> > Subject: "gunk" in mysqldump output > > In some recent release of MySQL, lines like this: > > /*!4 ALTER TABLE States DISABLE KEYS

Mysqld at Startup:

Dear MySQL People: I am having a difficult time trying to run mysqld during system startup on both Mac OS X (workstation) and Mac OS X Server. I have tried several combinations based on the Mysql.com documentation and the Apple Developer Connection article on startup items: http://develo

RE: MySQL counter for HIGH traffic site

*light goes on* You know, I think I've been confused about that. Thanks for clearing things up. I for some reason didn't make the connection (no pun intended) that each page would be getting it's own connection to the DB, and so couldn't interfere with the last_insert_ID queries. Matthew Walker S

auto_increment fields get mangled in some cases when doing an alter table

If you have a table with an auto_increment column and one of the rows has the value set to 0, doing an ALTER TABLE will change that value to either 2147483647 or the next auto_increment value. mysql> create table blah (id int not null primary key auto_increment,stuff char(128)); Query OK, 0 rows

does mysql support multi table update?

Hi, everyone, does mysql latest version support multi tables update? Thanks a lot __ Find, Connect Date! http://personals.yahoo.ca - Before posting, please ch

Re: Running multiple queries using "MySql" client

Hi insert into mytbl (a1) values (12),(13),(14); cheers Mark --- On Mon, 15 Apr 2002, Bill Adair wrote: > Hello all, > I'm in a mysql client session and I want to do multiple inserts > into a table (or run a multi-query script etc). Thi

triggers

What's the status of triggers in MySQL? Acording to the book, it's on the to-do list, but has anything been done with it since publication? --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

MySQL crashes is fulltext search on with some words.

I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... It terminates after the first query, but when I change the word 'think' to 'excel' or any other word it works flawlessy. I

Re: auto_increment fields get mangled in some cases when doing analter table

At 14:17 -0700 4/15/02, Tani Hosokawa wrote: >If you have a table with an auto_increment column and one of the rows >has the value set to 0, doing an ALTER TABLE will change that value to >either 2147483647 or the next auto_increment value. Storing anything other than positive integers in an AUTO

Handling Memo Fields from MS-Access?

Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a MS-Access database to a set of delimited text files, one for each table. Secondly: Load each of those text files into a MySql Table. Since I am new to MyS

RE: MySQL and stored procedures -> v4.1 :(

> > When it's ready. > > That's a tautological answer. You've already stated your lack of belief in the reliability of deadlines, so what did you expect? If someone had responded with "4.1 will be done on 5/1/2002" you'd respond that the only way that would happen would be if it were horribly bu

RE: Handling Memo Fields from MS-Access?

Hi .. Mysql's LOAD DATA INFILE will take newline character as the lines' terminating character, but you can always change by "LINES TERMINATED BY" clause. So, say you have | character as the line ending character in your text file, you can just add LINES TERMINATED BY '|' clause to your LOAD DATA

Re: Handling Memo Fields from MS-Access?/\t\n

Forgive me, I should have searched the archives first. Let me rephrase from what I have seen there: Do I understand that I should have my export routine Subsitute '\n' for newline ? Substitute '\t' for TAB? Thanks Again -tim- * Tim Johnson <[EMAIL PROTECTED]> [020415 15:13]: > Hello A

Re: MySQL and stored procedures -> v4.1 :(

Hi! I can disclose that there is actually some progress being made in stored procedures + triggers. Regards, Heikki Innobase Oy - Original Message - From: ""Jon Frisby"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, April 16, 2002 2:12 AM Subject: RE: MySQL and

Does MySQL support subqueries?

I have mysql 3.23.49a, and i wish know if does version support subqueries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

RE: Does MySQL support subqueries?

I think that feature is to be added on MySQL ver 4.xx That's what Im waiting for...lots of us waiting for it... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Amaury Cabarcas Alvarez [SMTP:[EMAIL PROTECTED]]

  1   2   >