RE: Can AUTO_INCREMENT return from INSERT function into a table ?

Hi Son, On Monday, April 08, 2002 2:37 PM, Son Nguyen [SMTP:[EMAIL PROTECTED]] wrote: --- BD [EMAIL PROTECTED] wrote: Son, At 09:48 PM 4/7/2002, you wrote: mysql desc threads; +-+--+--+-+-++ | Field | Type |

Re: Can AUTO_INCREMENT return from INSERT function into a table ?

Check out this: http://www.mysql.com/doc/L/O/LOCK_TABLES.html User 1 must do a 'write lock' on the table, before calling the insert statement. Then User 2's qery will have to wait till User 1 calls Unlock. USER 1 === WRITE LOCK USER 1 === INSERT STOP == due to process

RE: regular backup database in mysql

EZ... Step 1. Create a BATCH FILE. backup.bat D:\YourPath\Mysql\Bin\mysqldump --opt DB1 C:/BackupDBS/DB1.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB2 C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB3 C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB4

Got error 127 after using the alter table command

Hello, I am using MySQL 3.23.39 (on Windows NT and Windows 2000) and the = mm_mysql 2.0.4 JDBC driver. I encountered following problem: 1. I first create some tables via JDBC 2. then I fill in some data via the command line 3. I execute an alter table command (adding a

Question about Cross Compiling MySql

Hi EveryOne I Wonder If Cross Comile is Possbile. I was trying to make Makefile by using configure shell script(Mysql 4.0.1 Alpha version). Target was Linux PPC and Compile Platform was Solaris Sparc. But test program could not be runned in cross compile environment. That resulted that Makefile

Re: Security

John: Since you host your application(s) with your ISP, don't worry about it. It's a useful and valid question, but you're not in a position to address it completely while security is in control of someone beside yourself. Look here to make yourself better educated about MySQL security:

foreign keys

i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . then i have tried the delete cascade feature but it didn't work . I don't know why ? have you any suggestions ? . - Before posting, please check:

Re: last_insert_id gives 0

Hi Paul On Monday 08 April 2002 12:56 am, Paul DuBois wrote: You're inserting a specific value into the AUTO_INCREMENT field, which doesn't result in the creation of a new automatic sequence number. If you want to insert a record with a specific value in that column, *and* you want the

Problem with binlog (bug?)

Hi there! I'm having a little Problem with the mysql binary log which I think could actually be a bug of some sort, though I wasn't able to try it on a new Version of MySQL. My system configuration is: MySQL 3.23.41´, Win32 binary Release WindowsNT 4.0 Service Pack 6 PII, 256 MB Ram I am using

Re: Problem with binlog (bug?)

UPDATE satzungen SET titel='title', inhalt = 'context', content_type='text/plain', data='data',kuerzel='kuerzel', kennung='kennung', last_change = NOW() WHERE rowid = @rowid; User variables are not replication safe in 3.23 :( MySQL -- _/_/ _/_/_/ - Rafa Jank

Updated: Lost data problem Was: Corrupt .FRM files

Hi all, Some days ago (March 11) permissions were broken in catalogue of the mySQL database. Even though the permissions were not correct any more, MySQL continued to work. We think MySQL started to work with cache (with image of tables in RAM...) instead and all this time our backup system

UNIQUE index on nullable collumn - can't alter table

MySQL 3.23.47: I want to change a column that is currently non-indexed. SessionID is a nullable int column: alter table tbl_Orders add unique SessionID(SessionID); results in Column 'SessionID' is used with UNIQUE or INDEX but is defined as NOT NULL (A throwback to version 3.22???) I have

OLAP TOOLS

Good morning friends. We have the a project, what is search the OLAP SYSTEM for SUPORT DECISION. I like to know if anybody have the knwoledge about FREE OLAP SYSTEM TOOL and any what use the MYSQL with DW ? - Before

OpenBSD and MySql

Hi, I am using OpenBSD 2.8 and spent a frustrating evening last night trying to make MySql come to heel. Installed just fine - the first sign of something not right was inability to complete the run-all-tests scripts - just hung there gobbling up 95% CPU. Gave up on that eventually, and

200 milions records

HI, I want to insert into db 200.000.000 records of type (int6,int6).. the structure is: CREATE TABLE word_page ( IDword mediumint(6) NOT NULL default '0', IDpage mediumint(6) NOT NULL default '0', KEY IDword (IDword) ) TYPE=MyISAM; What do you think of it,, how would be

ignore the first sting in order

Hi all, I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files Thanx Bernd

adding 8-bit character encoding to mysql-max-3.23.49-win

Is it possible to add new 8-bit character encoding to compiled mysql (version 3.23.49-win) without recompiling? I would like to add ISO8859-15 encoding that seems not to be present in default installation. with best wishes, Taavi

Which list should I ask

I have a question about a script that generated a SQL script from Access 97. Is this the right list, or do I need to write to another one? Thanks. Jim Swanson - Before posting, please check:

help with asp/mysql

this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in

RE: help with asp/mysql

whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price= 1234.673264 and productdetails.price= 0 and (product.instore = 0 or

mysql_install_db locks after Installing all prepared tables

Hi, I'm having some trouble with mysql.. Running the mysql_install_db renders this... Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables At this point the script locks at

Re: Uninstalling on MacOS X

Your binary distrubution downloaded from mysql.org installs in /usr/local/mysql If you remove everything from that directory, you can just install the binary distribution again into that directory. Don't forget to run the mysql_install_db script after installation so to set up your

Re: ignore the first sting in order

Hi, Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files select * from movies order by trim(leading from replace(movetitle, '_', ' ')); Regards, Sasa »mysql, select, database«

Re: Security

Since you are using a hosted database you probably can't change any of the security. What I would do is create a table of usernames and passwords (and any other releveant user data). When your users login, check their password and proceed accordingly. Craig At 02:44 AM 4/8/2002, you wrote:

Re: ignore the first sting in order

On 8 Apr 2002, at 13:52, Bernd Menzel wrote: I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie

Re: Do any of your applications work?

me thinks hmmm, it's gotta be a troll. I'm so gullible I don't even know if it is or not. If it is, life is good. My favorite it the church lady who storms the linux groups and demands that they stop supporting this operating system because she has ample proof that it is being run on web

Re: How can I kill the slow query automatically?

Hi Marc, Thanks for the suggestion. I hope you would be kind enought to provide another. My application is transactional, in the business sense, in that, at the point of sale, the transactions must be quick. So inventory must be updated quickly to move the people through the line. The

Re: Can AUTO_INCREMENT return from INSERT function into a table ?

At 21:36 -0700 4/7/02, Son Nguyen wrote: --- BD [EMAIL PROTECTED] wrote: Son, At 09:48 PM 4/7/2002, you wrote: mysql desc threads; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: ignore the first sting in order

Hi, Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files After reading your message again, look like this is what you've been searching for. Sorry :( select * from movies order by substring_index(movietitle, '_', -1); And if

RE: Do any of your applications work?

-Original Message- From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL

char() function

Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values

Re: 200 milions records

Subject: Re: 200 milions records From: Vic Cekvenich [EMAIL PROTECTED] === 1. Use PostgreSQL. 2. Use multi channel disk cache controller 3. Get rid of not NULL. 4. index a primary seqnecy key It should be subsecond. Vic ddd wrote: HI, I want to insert into db 200.000.000 records of type

RE: Do any of your applications work?

The only thing I wish is to know who his client was or is and set them straight on MySQL and get some extra work ;). Probably trying to sell them the hacker proof Oracle..LMAO. MySQL Select * - Before posting, please check:

RE: char() function

nevermind...instead of using '||' to concat the fields i needed to use the CONCAT() function. So the syntax should have been: insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string')); still...I wonder why I got a 'Query OK, 1 row affected' message -Don

Re: char() function

Hi. Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html (rather at the end). || has a different meaning in MySQL started without explicit --ansi. Also see http://www.mysql.com/doc/A/N/ANSI_mode.html. Bye, Benjamin. On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL

no subject

Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before

Re: adding 8-bit character encoding to mysql-max-3.23.49-win

Taavi, Monday, April 08, 2002, 3:39:29 PM, you wrote: TT Is it possible to add new 8-bit character encoding to compiled TT mysql (version 3.23.49-win) without recompiling? No, you should re-configure and re-compile after adding new character set. You can read instruction how to add new

Re: Question about Cross Compiling MySql

豤Èñ, Monday, April 08, 2002, 10:44:47 AM, you wrote: I Wonder If Cross Comile is Possbile. Yes, it's possible, but this case needs deep involvement and a long-time check-up works... Maybe Monty will clarify something. I was trying to make Makefile by using configure shell script(Mysql

Re: FOREIGN KEY Constraints

Carl, Monday, April 08, 2002, 3:16:26 AM, you wrote: CS From the mysql docs, it looks like you can only use foreign keys if your CS tables are type InnoDB. Is this correct? Yes, you are right. In MyISAM tables you can use REFERENCE clause, but it does nothing. CS Carl -- For

Re: Help restoring data with mysqlbinlog

balteo, Sunday, April 07, 2002, 3:50:05 PM, you wrote: b I am trying to restore some data from the binary log and I am not sure on b how to proceed. b I understand restoring data is a two-stage process: b 1. You start by restoring data saved with mysqldump. b 2. Using mysqlbinlog, you restore

Re: foreign keys

root, Monday, April 08, 2002, 12:24:42 PM, you wrote: r i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . r then i have tried the delete cascade feature but it didn't work . I don't r know why ? have you any suggestions ? . InnoDB does not yet support ON DELETE

Re: RE: Help with Tables Please

Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS Thanks for the tip Dan, SS I changed it, but it still gives me the same error. SS Any other suggestion? hm ... I have tested your example and it worked fine ... What version of MySQL server do you use and how did you changed column

Re: mysql_install_db locks after

Chris, Monday, April 08, 2002, 4:52:26 PM, you wrote: CL I'm having some trouble with mysql.. Running the mysql_install_db renders CL this... CL Installing all prepared tables CL At this point the script locks at this point won't go any further. CL I am using CL MySQL-3.23.49a-1.i386.rpm

Replication: Slave performance

Hi there, currently I am using a single server for my webapp. Within the next days I get another box which will host the mysql-database (which is currently running on the other server). I want to set up replication between the 2 ones, using my current server as SLAVE and the new on as master.

Re: no subject

On Monday 08 April 2002 9:49 am, Chuck \PUP\ Payne wrote: Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. SELECT field1, field2 FROM

Re: no subject

Chuck, Monday, April 08, 2002, 6:49:20 PM, you wrote: CPP Ok, I know I am going to get yell about this but how can I do an SQL and CPP only show to fields from a table. For example I only like to see the names CPP and birthday? Or will as so all fields for a given table. If you want to see data

mysql

mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the

RE: no subject

SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields

Re: no subject

select name, birthday from ??? order by name; Along those lines anyway. Chuck \PUP\ Payne wrote: * This Message Was Virus Checked With : SAVI 3.54 Feb 2002 Last Updated 25th March 2002

RE: mysql

SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02

RE: mysql

sometimes, all you can say is LOL and walk away shaking your head...thinking... *...the poor guy actually went to the trouble of defeating the filter, only later to invite the flames of hell upon his head* -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: show to fields from a table

6.6.2 DESCRIBE Syntax (Get Information About Columns) http://www.mysql.com/doc/D/E/DESCRIBE.html ... aka MySQL(homePage)-Search::subject. C:~ -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:04 AM To: 'Chuck PUP Payne'; MySQL Mailing List

Re: no subject

Thanks, I got it :) I am using phpMySQL and command line and I couldn't see anything because it was showing everything but now I am cool. Again everyone thanks. Chuck Payne On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote: SELECT name,birthday FROM mytable -Original Message-

Newbie Question on Replication

After a orderly system and MySQL shutdown and restart of both slave and master, replication failed to start on the slave. Any suggestions on how to get replication going again without shutting down, taking a snapshot and starting replication would be greatly appreciated. The error logs on

Benchmark test

Hello! On your homepage i have seen that you did Benchmark tests with MYSQL and MS Access 2000(on Windows) and compared the Benchmark results. I also want to do this but i dont know how to do such Benchmarktests on MYSQL and Access because i am a beginner in working with these databases. so

RE: RE: Help with Tables Please

Thanks, It worked :) It was my mistake! Thanks again, Soheil Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS Thanks for the tip Dan, SS I changed it, but it still gives me the same error. SS Any other suggestion? hm ... I have tested your example and it worked fine ... What

MySQL won't keep running on my Mac OSX

I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run

Help restoring data with mysqlbinlog

Victoria, Thanks for replying. How does one know what parameter to pass on as position, in other words how do I know from what point to start the roll-forward from the binlog? What's more what format is this parameter? (timestamp, integer??) Thanks, Balteo. P.S. I tried mysqlbinlog --help but

RE: SQL Script stopping

You have a semicolon(;) after the line Service CHAR (80) Besides after CREATE TABLE tablename syntax you have to define the columns and their datatypes in parenthesis. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -Original Message- From: Jim Swanson [mailto:[EMAIL

RE: SQL Script stopping

ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at line 1 - perhaps you'd prefer the semicolon to complete your query - C:~ -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: SQL

Best field type for ID?

Hi everyone, What is the best field type to use for an ID field which is the primary key and auto-increment? I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was wondering what happens when it reaches 65535, does the auto-increment go back to 1 or will it cause an error?

Concurrent Connections Ceiling?

Anybody have any idea what kind of concurrent user load MySQL is (or at least should be) capable of handling? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Reg MYSQL and JAVA

Hi, I don't know is this is the correct form. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or

MySQL and GCC

I have a system here based on Red Hat's 7.2 distribution and I am wanting to get MySQL up and running. After browsing your web page it seems that I will have go to a different version of gcc. Would I be safe to go to the latest version (3.0.4) of gcc? Barry Blatz Pason Systems Corp. (403)

Re: SQL Script stopping

The semi-colon (;) after Service CHAR(80) should be a comma (,). On Mon, 8 Apr 2002, Jim Swanson wrote: I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0,

Re: MySQL won't keep running on my Mac OSX

I have the same exact setup down to the hardware (believe it or not). Your best game plan is to install the MySQL binary distro into /usr/local/mysql as the root user. And then run the MySQL server as root. You'll have to start the MySQL Server when you start the laptop. Otherwise, you can log

Re: SQL Script stopping

Also, the CREATE TABLE statement doesn't look right. It should probably be: create table 185_s_Prices ( PriceID INT NOT NULL DEFAULT 0, Service CHAR (80), Category CHAR (20) ); See the MySQL Manual section on CREATE TABLE. On Mon, 8 Apr 2002, Jim Swanson wrote: I have a script I'm

database setup

Hi, I am setting up a mysql database, with two tables. One keeps the user authentication info such as user name, password and user level. The other table with contains files for upload and download. Is there a good way to setup the user authentication table so it can check appropriate user

binlog and replication stuff

Hello. I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master and 4 mysql slave, every write is made on the master and then replicated to the slave. The problem is that if one client crash or must be rebooted i've to: - on the mysql master stop mysql, delete binlogfile, tar

RE: Help with Tables Please

FieldID INT UNSIGNED DEFAULT '0' NOT NULL, -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 11:10 PM To: [EMAIL PROTECTED] Subject: RE: Help with Tables Please Thanks for the tip Dan, I changed it, but it still gives me the same error.

RE: Best field type for ID?

* Luke van Blerk What is the best field type to use for an ID field which is the primary key and auto-increment? I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was wondering what happens when it reaches 65535, does the auto-increment go back to 1 or will it cause

Re: MySQL won't keep running on my Mac OSX

At 12:48 -0400 4/8/02, Jay Hill wrote: I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in

RE: Concurrent Connections Ceiling?

* Tab Alleman Anybody have any idea what kind of concurrent user load MySQL is (or at least should be) capable of handling? This depends on a lot of factors, the application and the hardware beeing the most important ones... the recent benchmark test in eweek may give you some hints: URL:

RE: database setup

First, I assume that the same value for userlevel may be used by multiple users. That is, multiple users can have userlevel equal to 1 or equal to 2 or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY. PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be

CREATE TEMPORARY TABLE

If I want to use temporary tables I know I can create tables that are unique without using CREATE TEMPORARY TABLE table_name. What I want to know, because it might be more efficient, is if I use CREATE TEMPORARY TABLE table_name and more than one person hits the page (I am using PHP

RE: FOREIGN KEY Constraints

Hi, Yes, you are right but be aware with the delete cascade feature, maybe in the way?. Regards - Original Message - From: Carl Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 7:16 PM Subject: FOREIGN KEY Constraints From the mysql docs, it looks like you

RE: Best field type for ID?

On 8 Apr 2002, at 20:20, Roger Baklund wrote: The best type to use is the one big enough to hold your expected biggest value, but not bigger. But when calculating your expected biggest value, keep in mind that the autoincrement counter increases on every attempted insert, even if the insert

Re: char() function

Hello. On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote: [...] still...I wonder why I got a 'Query OK, 1 row affected' message [...] insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00

Uninstall Mysql

Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up my permission. I dont know what is is that i'm doing that makes me loose my previleges. I keep getting the access denied error Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103

RE: CREATE TEMPORARY TABLE

Thank You. That is what I was hoping for. I would assume that this would be faster than actually coming up with a random name, using srand and rand, for a table, creating it and deleting it when done. Thanks Steve Buehler At 02:19 PM 4/8/2002, you wrote: Yes a TEMPORARY TABLE is specific to

Re: CREATE TEMPORARY TABLE

On Mon, Apr 08, 2002 at 01:40:02PM -0500, Steve Buehler wrote: If I want to use temporary tables I know I can create tables that are unique without using CREATE TEMPORARY TABLE table_name. What I want to know, because it might be more efficient, is if I use CREATE TEMPORARY TABLE

Running mysql on a certain IP

I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the other on 10.0.0.11:3306 how do I tell mysql to run only on a certain IP

Re: Running mysql on a certain IP

On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote: I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the

HELP!

Dear all of member, Would you help me, how to install, setup, and configure MySQL in my server with O/S windows 2000 server and IIS v. 5 Thank you, Best Regards, - Before posting, please check:

Re: Uninstall Mysql

Hi, You give up so quicly? What OS use for MySQL? - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, April 08, 2002 10:10 PM Subject: Uninstall Mysql Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up

mysql and java

Hey Guys, I'm not sure if this is the right place to ask this question, but to be honest I didn't know where else to turn since my script deals with mysql. Here's my problem: I am using stylesheets and javascript to display a small blurb about a review on my site and it display is in a

MySQL 3.23.43-nt stop working after approx 10 days.

I have a problem with my MySQL server, it has started to stop working after approximately 10 days of uptime. After a reboot it works fine again. The users get the error can't connect to server on localhost. I also have a testserver with similar setup, on that MySQL has run for 54 days with no

DBD and Mysql

WinXp Crashed my D: drive and I had most everything backup.. So when I reinstalled ActivePerl 5.6.xx I downloaded via PPM (perl package installer) the DBI, DBIx::AnyDBD but could not find DBD:mysql. Where is the package for Windows.. I did find, at CPAN, the mysql.gz.tar version which I use

RE: mysql and java

this is actually OT, btw, but I'll try to answer... need to make it smaller. Is it possible to somehow store these descriptions in a mysql table or on another page and then have them linked to when you put your mouse over the link? No. There are methods of accessing databases from the

RE: Running mysql on a certain IP

Yes, I found this about 2 seconds after I sent my email.. However, I still can not get mysql to run on either a) different ip address on port 3306 or b) same ip address on port 3307 Either way, I get the error: 020408 15:47:00 mysqld started 020408 15:47:00 Can't start server: Bind

Re: Reg MYSQL and JAVA

Hi, Thanks for the reply. I also need few 'doc' features such as 1. Bold letters 2. Formatted paragraphs The document I want to take a report is a student declaration form where on top it will display student details in the middle the declaration and at the end Signature. The document

Strange behavior

I have a table with the following fields: id=autoincrement, int (11) ts_h=decimal ts_pid=int (11) ts_day=text There is a unique record where ts_pid=60 and ts_day=2002032800 (ts_h=0). If I do [update t_timesheet set ts_h=0 where ts_pid=60 and ts_day=2002032800 ],

RE: Reg MYSQL and JAVA

still OT, but here goes anyway... you can in fact use PHP or ASP or whatever to generate PDFs. See http://www.pdflib.com/pdflib/index.html -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:04 PM To: Christopher Thompson; [EMAIL PROTECTED]

RE: Strange behavior

it worked for me: mysql describe t_timesheet; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | id | int(11) | | PRI | NULL|

sum function doubling

I have MySQL v. 3.23 The SUM function seems to be doubling one of my values when used in conjunction with another SUM function. Here I show that I have only 95 in insFreq: mysql select t2.andersonStart_pos, sum(t2.insFreq) from InsertionFreq t2 where t2.andersonStart_pos = 1072 group by

MySQL++ (?) bug

Hi, I've built MySQL++ 1.7.9 libs on an smp machine. But every application which is built using mysql++ crashes with segfault when invoking connect() method. For example: #include iostream #include mysql++ void main() { try { Connection con( use_exceptions );

Re: sum function doubling

On 8 Apr 2002, at 18:18, Ari B Kahn wrote: OK. Now notice that insFreq has DOUBLED when used in conjunction with with delFreq! mysql select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq) from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos = 1072) and

Re: MySQL Power ?

On Friday 05 April 2002 11:32, Steve Rapaport wrote: I'm currently running MySQL for a big, fast app without problems. BUT: I'm in the middle of specifying a new application with a high load, and I'm consideing looking for alternatives to MySQL because without InnoDB, it gets really slow

Re: MySQL vs. MS SQL

On Friday 05 April 2002 02:25, David Williamson wrote: Hi there, I will shortly be installing a MySQL server at my place of work, the box I will be installing it on currently has MS SQL server running as well. (I believe its a wintel box). Anyway, I am wondering if there are any known

Re: MySQL vs. MS SQL

If your databases have any size to them (like more than 1/2 the amount of ram you have), you'll need to manage memory. SQL Expects to be an only child. Check out sp_configure in books on line to learn how to limit the amount of RAM sql will take At 06:56 PM 4/8/2002 -0500, Tod Harter wrote:

  1   2   >