Changing character X to Y in a table

Hi, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? Jari Mäkelä mysql,query,select,insert - Before po

Case sensitivity in Mysql

Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name "temp" and linux "TEMP" while giving rights thru GRANTstatement , it fails in windows cause it exp

Antwort: RE: Re: Problem with MySQL, ODBC, MS Access

Hi, I´ve already tried using MyODBC 3.51.02 by enabling Dynamic Cursor, it didn´t help. Now I´ve sent a mail to the access newsgroup. I hope it will help. Many thanks for your help. Regards, Christine Hi !! I did looked into you issue and could able to see the behaviour whatver you descr

Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1?

Tomasz, are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no foreign keys. I tested this on mysql-max-4.0.1, and it worked. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ Speed up adding of features to MySQL/InnoDB t

Compiling problem 3.23.49 under linux (mysql.cc)

Hi all... I get: c++-303 -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc In file included from /usr/local/gcc-3.0.3/lib/gcc-lib/i686-pc-linux-gnu/3.0.3/include/curses.h:80, from mys

RE: mySQL connection problem!!!

Hi Todd Thanks.. I checked and did like.. from root mysqladmin shutdown and then again.. restarted the server from.. /etc/rc.d/init.d/mysqld start but of no use! --- As suggested by: Gerald Clark <[EMAIL PROTECTED]> FROM babul USER.. i can not go to /var/lib/mysql where all the databse direc

Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1?

At 16:57 2002-03-13, Rick Flower wrote: >Tomasz writes: > >>> >From section 16 of http://www.innodb.com/ibman.html you find detailed >>>information about every InnoDB version. For example, 4.0.1 == 3.23.47. >>> >>>Foreign keys should work in 4.0.1. > >>Hmmm... That's what I read, too. And afte

Retrive distinct data from two tables

I have 2 tables, let says, table A and table B. Each table record person name. select B.name from B, A where B.name = A.name Query above should return the name which recorded in both tables (duplicate name) In reverse, how can I retrive the name which recorded in Table B and not present in T

bugreports

END-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description:

Re: Unsigned?

At 3:10 + 3/14/02, Gary Griffiths (Citydesk) wrote: > Hi, sql,query > >Could someone please explain in detail or point me to where the detail can >be explained in full the implications and benefits or otherwise of the >attribute "UNSIGNED" in a field definition. It means the column cannot co

Re: Unsigned?

Hi, sql,query Could someone please explain in detail or point me to where the detail can be explained in full the implications and benefits or otherwise of the attribute "UNSIGNED" in a field definition. Thanks ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ Gary Griffiths (GG601

RE: ADO API & ODBC Alternative help

the problem is doing an Update after you've done one Update without doing a MoveForward or MovePrevious. It's an ADO issue, check the KB article I posted earlier on this topic, it explains the causes and the API versions that have it. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q29416

MySQL 4.1

When is MySQL 4.1 coming out? The web site says a 4.1 alpha in December/January - is that December of 2002 or the Dec that just passed? I think it would be great if a tenative MySQL release schedule was published and updated monthly (or so) with progress info included. Thanks, Rick --

RE: ADO API & ODBC Alternative help

Hi ! > -Original Message- > From: Nick Gorham [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 5:02 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: ADO API & ODBC Alternative help > > > > > > - When I hit the line setting value of "pass

Re: Converting MyISAM to InnoDB

Hey ! I think I found the problem.ibdata1 is only set to 64MB.which is the default size (stupid me :( )... I just deleted everythingand reconstructed my InnoDB files but this time, I have set it to 2000M :) I used mysqldump to create a file which will create all tables and insert da

Re: can not backup table

you're absolutely right ds :) I have solved this problem yesterday, i miss one thing that my mysql runs by user mysql.. thanks alot --- ds <[EMAIL PROTECTED]> wrote: > On Wed, 2002-03-13 at 01:48, Abi wrote: > > Hi, > > I have this following error when back up table : > > > > mysql> lock table

Re: ADO API & ODBC Alternative help

> - When I hit the line setting value of "password", I get the following > message: > Run-time error '-2147217887 (80040e21)': > Multiple-step operation generated errors. Check each status value. If you (or any one else) finds what causes this could you please tell me, I have just the same pro

Why I can not connect to mysql (using jdbc)

The code is: //Connect to MySql Server try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch(Exception e){ System.out.println("Can not get class Name"); } try { c = DriverManager.getConnection ("jdbc:mysql://localhost/dbname?u

Re: mysqlbug

I might be interested in hiring someone to do some PhP, and MySQL programming on SuSQ 7.3. anyone live near Raleigh North Carolina? I am not sure I can learn what I need in the time frame I need to do it in. Mark - Original Message - From: "Gregory Junker" <[EMAIL PROTECTED]> To: <[EM

Re: Where do I place a notice that my server hosts mysql databases?

Hi. How about http://www.mysql.com -> Portals -> Service Providers? Bye, Benjamin. On Mon, Mar 11, 2002 at 08:59:41PM -0700, [EMAIL PROTECTED] wrote: > Thanks for the info! I sent your link off to a friend in ca who's looking > for such a site. I think it would be of great help if MySQ

Re: ADO API & ODBC Alternative help

Hi! Check the "MySQL with ASP" Forum at www.dwam.net/mysql/ in particular a thread called "Multiple Step Error" You can also find working ADO code samples on the site (using AddNew method) Finally you should consider using the latest MyODBC drivers 2.50.39 if you want to stick to 2.xx version 3

RE: mysqlbug

error 2 says the file cannot be found...did you run the mysql_install_db script? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 7:05 PM > To: [EMAIL PROTECTED] > Subject: mysqlbug > > > Good afternoon > > > Please, i'll need

Re: Converting MyISAM to InnoDB

Hi there, I just created an InnoDB table mirroring the schema of the original table... But, I am getting the following... mysql> insert into NEW_TABLE select * from ORIG_TABLE; ERROR 1114: The table 'NEW_TABLE' is full I checked on the manual and I got the following. #Comment

mysqlbug

Good afternoon Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld & this is the bug that present (from my *.err file) /*/ mysqld started on Mon Mar

mysql

Hi, Has anyone used the command commit_update in mysql/php to save updated changes. thanks. - Valerie Brooks Fujitsu Software Voice: (408)456-7222 Email: [EMAIL PROTECTED] "There's no limit to what can be accomplished if it

RE: Selecting across servers, JDBC

Hi, all: I tried with JDBC, it seem that this is not working. mm.mysql JDBC will ignore the database name. Do anyone have the some issues? Zengfa --- David Buerer <[EMAIL PROTECTED]> wrote: > Gee guys, thanks for the quick answers. Juding by > the number of > responses you'd think that I ask

Re: Multiple Column Keys with Auto Increment

Hi BD! :) First of all, Thanks for the reply Anyway, actually what i would like to do is group data so that each group will have its own "increment" series when data is inserted for that group. For example SESSION_IDTRANSACTIONLOG_ID 0A0AA 0B0B

Re: Conflicting results using PHP/Mysql

I would guess it's because only three records match the ANDed tests in the WHERE clause (last 3 lines). Isn't that what you intended? Doug On Wed, 13 Mar 2002 16:08:43 -, George Pitcher wrote: >Hi all, > >Posted this yesterday and got no response. Trying again today. > >I'm having a smal

RE: Selecting across servers

Gee guys, thanks for the quick answers. Juding by the number of responses you'd think that I asked a simple question! I'm on a 48hr development spree using MySQL for the firts time so I haven't gotten knee deep in the documentation yet. It's a great program though...fast...not bloated..simpl

RE: Selecting across servers

SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across s

mysql coredumps

>Description: mysql-3.23.49 compiled from source on ultra sparc5. core seg faults and core dumps. i can move the binary to sparc20 and sparc5 and it works fine. truss output is: Incurred fault #6, FLTBOUNDS %pc = 0xEF70DD2C siginfo: SIGSEGV SEGV_MAPERR addr=0x0071FDD0 Received sig

RE: Selecting across servers

SELECT * FROM database1.table1 ... database2.table2 ... WHERE > -Original Message- > From: David Buerer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 6:14 PM > To: [EMAIL PROTECTED] > Subject: RE: Selecting across servers > > > How do you do it from different database

RE: Selecting across servers

At 15:13 -0800 3/13/02, David Buerer wrote: >How do you do it from different databases on the same server? Qualify your table names with the database name. SELECT db1.tbl1.*, db2.tbl2.* FROM db1.tbl1, db2.tbl2 WHERE ... If db1 or db2 happen to be the current database, you don't need to qualify

Re: Selecting across servers

At 15:00 -0600 3/13/02, Cal Evans wrote: >Is it possible to issue 1 select that gathers data from databases on 2 >separate servers? No. Every now and then, someone alleges that this can be done. But it always turns out to be someone who hasn't actually tried it. :-) > >=C= >* >* Cal Evans >* Jo

RE: Selecting across servers

How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across ser

SELECT is using wrong key AND getting wrong results

>Description: SELECT fullTextMatches.realname, fullTextMatches.address, fullTextMatches.address2, fullTextMatches.city, fullTextMatches.state, fullTextMatches.zip, fullTextMatches.country, fullTextMatches.email, fullTextMatches.homephone, fullTextMatches.workphone, full

Please help! - About doing a delete.

Hi everyone, I've got a really annoying problem with mysql, and I was hoping someone could help. I've got 2 tables in Mysql: Table 1 - "Topics" | topic_id | name | subject | comment | - | 1 | john | weather| the

RE: How do I get the time?

Hi Kathy, Are you trying to get current time in mysql ?? If yes, you can do it by issuing: SELECT NOW(); statement... Gurhan -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:17 PM To: [EMAIL PROTECTED] Subject: How do I get the time? I

RE: How do I get the time?

* Kathy Reyes > I'm trying time a export process but I cant figure out what the right sql > statement. > I tried using getdate() but it gives me an error. getdate() is not a valid mysql function, try NOW() or CURTIME(). http://www.mysql.com/doc/D/a/Date_and_time_functions.html > -- Roger query

RE: ADO API & ODBC Alternative help

>From your point of view it's off-topic (and it is), but from his the problem could be anything, including MySQL. You did, however, produce the proper answer, since this is an ADO issue, and I further provide a link to the relevant Knowledge Base article: http://support.microsoft.com/default.aspx

How do I get the time?

I'm trying time a export process but I cant figure out what the right sql statement. I tried using getdate() but it gives me an error. Any Ideas??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnolo

Re: ADO API & ODBC Alternative help

Get your VB Manuals out, or test your programme against an Access Data Base. Once you have issed an Update statement, you need to either retrieve the record for further update or set all the fields then issue the Update statement! This is very 'Off Topic" Clive Smart Kelvin Lam wrote: > Hi, >

ADO API & ODBC Alternative help

Hi, I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter). Here is my configuration: - mySQL ODBC Version 02.50.38 - mySQL server Version 02.50.38 - Windows NT 4.0 with SP6 It seems like, mySQL does not

Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1?

Tomasz writes: >> >From section 16 of http://www.innodb.com/ibman.html you find detailed >>information about every InnoDB version. For example, 4.0.1 == 3.23.47. >> >>Foreign keys should work in 4.0.1. >Hmmm... That's what I read, too. And after several unsuccesful attempts >to create my ow

Solaris, MyODBC, Access DB converter

Does anyone know if the MyODBC binary for Solaris 2.7 will work ok on 2.8, or will I need to compile from source? For anyone who's interested, we're in the process now of migrating from Access/ColdFusion/NT to MySQL/ColdFusion/Solaris in our web development environment. As far as software to c

Re: Selecting across servers

Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers > > Is it possible to issue 1 select that gathers data

Re: constraints in InnoDB, or is 3.23.43b _really_ < 4.0.1?

At 08:13 2002-03-13, Heikki Tuuri wrote: >Tomasz, > >InnoDB in 3.23 and 4.0 is the same codebase. InnoDB versions are best >counted from the 3.23 series, because they appear more frequently. I am >sorry that this is confusing. > >MySQL/InnoDB-3.23.50 has not been released yet. It will probably be

Re: problem with installing

On Wed, 13 Mar 2002, Mohamad Waluyo wrote: > I tried to run mysql.server start on mysql that I just installed. > > OS I use is SCO Open Server Rel 5.00 > > The error I received is > [EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start > ./support-files/mysql.server: @HOSTNAME@: not found > [EM

Re: Multiple charsets

At 13:26 2002-03-13, Victoria Reznichenko wrote: >Alex, >Wednesday, March 13, 2002, 7:16:02 PM, you wrote: > >AK> I'm very much interested to know how do you manage multiple language >support with >AK> mySQL. > >AK> I haven't found how i can define different character sets for >different tables

Re: varchar attributes

Sorry, please excuse this post. I found the problem. A single space in front of the account number. Thanks Richard D. Williams [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must includ

Selecting across servers

Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * sql, query - Before posting, please check: http://

Re: mysql hotcopy

Thanks Dan - Quick question - I have a db named content with user "admin" and pass "mypass" Do I still use -u root p maypass ? or would I use mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to Thanks again for your help. Mark -Original Message- From: Dan Patnaude <[EMA

[bug] MySQLGUI 1.7.5-1 crash with "year" column type

Heya, I've managed to repeatably crash mysqlgui by running a query that returns a column of type "year." Though it dumps core, gdb does not provide a useful stack trace. Though this is not a serious bug, it is a bit of an annoyance. - Alex Vandiver -- Networking -- only one letter away from

adding administrative users in mysql

Hello, I am attempting to add the ROOT user as a MYSQL administrator using the following syntax: mysqladmin -u root password 12345 and I recieve the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' an

problem with installing

I tried to run mysql.server start on mysql that I just installed. OS I use is SCO Open Server Rel 5.00 The error I received is [EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start ./support-files/mysql.server: @HOSTNAME@: not found [EMAIL PROTECTED] [/usr/local/mysql]:Starting mysqld daemo

a quick sanity check...

Hi all -- I just need a quick sanity check on a query. I have two tables: CREATE TABLE users ( userID VARCHAR(10) NOT NULL PRIMARY KEY, [many other fields] ) CREATE TABLE subscriptions ( userID VARCHAR(10) NOT NULL, listID INT NOT NULL ) In these tables, users.userID == subsc

RE: starting mysql

ensure that /tmp has correct read-write-execute permissions -Original Message- From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:57 AM To: '[EMAIL PROTECTED]' Subject: starting mysql i'm moving MySQL over to unix and i can't for the life of me get

RE: MySQL and MSAccess

Haven't done a great deal of this but it does work pretty well. Obviously connection speed is a bit of an issue especially where you are dealing with INSERTS into several linked tables from a form. I couldn't find an equivalent field in MySQL for the Yes/No type in Access so it you create an a 2

Re: Create database if does not exist.

On Wed, Mar 13, 2002 at 09:40:44AM -0800, Radhakrishna Mohan Tadepalli wrote: > I want to "create a database "test_db1", if "test_db1" does not exist in the > server" using sql script. Is it possible? >From 6.5.1 CREATE DATABASE Syntax CREATE

Re: Sub-select look-alike?

If I understand your question, you just need to join with the languages table twice, using aliases: select LF.language, LT.language from language_pairs P, languages LF, languages LT where LF.id = P.from and LT.id = P.to; > From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= <[EMAIL PROTECTED]> > T

history of MySQL

Alan, Wednesday, March 13, 2002, 2:05:40 PM, you wrote: AF> Does anybody know the evolution of MySQL. I understand it evolved from AF> mSQL, but the company is unwilling to discuss this history. AF> I write a computer encyclopedia and am trying to trace back the product. AF> Can anyone help? Y

Multiple charsets

Alex, Wednesday, March 13, 2002, 7:16:02 PM, you wrote: AK> I'm very much interested to know how do you manage multiple language support with AK> mySQL. AK> I haven't found how i can define different character sets for different tables or AK> even for separate databases. AK> Do i have to run se

Delete problem

Riccardi, Wednesday, March 13, 2002, 5:48:28 PM, you wrote: RM> Hi all, RM> I'm trying to delete records with this query on php program: RM> delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where RM> ID_GROUP = '$group') RM> I use it on MSSQL and work fine but on mysql don't work

Composite primary key in MySQL

nagendra, Wednesday, March 13, 2002, 1:06:18 PM, you wrote: np> Dear all, np> Will MySQL supports "composite primary key" constraint? If so what np> is the actual syntax? Yes, MySQL supports composite primary key. CREATE TABLE table1( id1 int NOT NULL, id2 int NOT NULL, PRIMARY KEY(id1, id2));

Unicode support for MySQL

Victoria, Monday, March 11, 2002, 11:24:00 AM, you wrote: RT>> I am just wondering if the latest stable build of MySQL has support RT>> for Unicode character set so I can use it to store english, chinese and RT>> korean characters. If so please let me know. And also if there is going RT>> to

RE: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)

Hi !! > -Original Message- > From: Markus Lervik [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 1:22 AM > To: [EMAIL PROTECTED] > Subject: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie) > > > Hello, list! > > > I'm not quite sure that this is the right pl

Re: Multiple Column Keys with Auto Increment

At 01:02 AM 3/13/2002, you wrote: >Greetings!!! > >I would just like to know if the following is normal: > >I created a file TRANSACTION_LOG.sql to create an InnoDB table with MULTIPLE >KEYs with one AUTO COLUMN. > >The file consists of the following SQL commands: > >drop table TRANSACTION_LOG; >c

JDBC and applet

Hello friends, I am having a problem using the MySQL JDBC driver from an applet. In my local machine's browser and on very few remote machine's browsers the applet works correctly, however in most remote machine's browsers it cannot find a suitable driver. What is wrong with my Java code? Or my

Create database if does not exist.

I want to "create a database "test_db1", if "test_db1" does not exist in the server" using sql script. Is it possible? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---

Multiple charsets

I'm very much interested to know how do you manage multiple language support with mySQL. I haven't found how i can define different character sets for different tables or even for separate databases. Do i have to run several mySQL servers, one per each charset? Maybe, it is the solution for yo

Re: mysql hotcopy

Try the following: mysqlhotcopy -u root -p /path/to/copy/the/data/to so, if you want to copy the db "foobar", you do the following: mysqlhotcopy -u root -p foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002

Re: mysql hotcopy

Try the following: mysqlhotcopy -u root -p /path/to/copy/the/data/to so, if you want to copy the db "foobar", you do the following: mysqlhotcopy -u root -p foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002

starting mysql

i'm moving MySQL over to unix and i can't for the life of me get anything to work. i just want to use MySQL from my directory. no root users or anything like that. i just want to noodle around with the db as a 'local' user. so i installed the binaries, created my symbolic link, configured the

Problem with openSSL and MySQL

Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few

An opinion about indexes

Hi, I need your opinion about optimizing this query... I would really appreciate your help on this: The following table saves data about views to certain object identified by (cod-campanha,cod_tema,cod_canal,tipocanal,localizacao,seccao) from users. Each tuple (cod-campanha,cod_tema,cod_canal,

Re: installation problem

Hi, Try to start mySQL daemon like service in init 3. Good luck, Gelu - Original Message - From: Aman Raheja <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 12:00 AM Subject: Re: installation problem > This is what's going on > > > [root@coolnis-ar mysql]#

Re: MySQL Quits in Replication

From: "Al Johnson" <[EMAIL PROTECTED]> > We are having a serious problem with a simple replication setup using > MySQL. One small database with 12 tables is being replicated one way - > one master, one slave. Write transaction load is small, about 1 record > per second, usually on only one of the

Re: Error running scripts/mysql_install_db While installing AIX binaries

[EMAIL PROTECTED] writes: > >Description: > shr.o not found in libz.a when running mysql-install_db > >How-To-Repeat: > Output from mysql_install_db: > > >scripts/mysql_install_db > exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the >following errors: >

mysql hotcopy

Can anyone give me an example of how to run mysqlhotcopy from the command line? What can I expect as the output and where is the file created/ stored? Thanks Mark -Original Message- From: Michael Grassman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, March 1

Re: history of MySQL

On Wed, Mar 13, 2002 at 07:05:40AM -0500, Alan Freedman wrote: > > Does anybody know the evolution of MySQL. I understand it evolved > from mSQL, but the company is unwilling to discuss this history. It did not evolve from mSQL. It copied the mSQL API, but the code itself evolved from Unireg.

Re: Losing connection during a REPAIR TABLE

I believe I needed to upgrade at least to version 3.23.42. There was a bug fix where certain record lengths killed the REPAIR (See D.2.9). So I tried an upgrade & problem is gone... whether or not my diagnosis was correct. I want to thank all that replied for your dead-on help. Also I have to say

Re: Problem in instalation

I am not at all familiar with Cobalt. But your gcc version is pretty old. Everything compiles without error on my RedHat 7.2 system with gcc 2.96. Or, you might want to consider the binary...since upgrading gcc might not solve the problem. On Wed, 2002-03-13 at 11:20, Roberto C. Salazar M. wrote

Re: Delete problem

Hi, If you expect only 1 result you can try: select (@myvar:=ID_ALBUM) from Bands where ID_GROUP='$group'; delete from Bands where ID_ALBUM=@myvar; Good luck, Gelu - Original Message - From: Riccardi Moreno <[EMAIL PROTECTED]> To: Php List <[EMAIL PROTECTED]>; Mysql List <[EMAIL PROTECTE

Re: Problem in instalation

I work with Linux Cobalt (like to RedHat) My gcc version is gcc-2.7.2 RCS - Original Message - From: Jim Philips To: Roberto C. Salazar M. Cc: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 11:18 AM Subject: Re: Problem in instalation You could probably save yourself some trouble by

Error running scripts/mysql_install_db While installing AIX binaries

>Description: shr.o not found in libz.a when running mysql-install_db >How-To-Repeat: Output from mysql_install_db: scripts/mysql_install_db exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/lo

Re: Problem in instalation

You could probably save yourself some trouble by installing binaries. But what version of Linux? And what version of gcc? There are many problems associated with using gcc 3.x that I won't get into here. But it helps to pass along these details. On Wed, 2002-03-13 at 11:04, Roberto C. Salazar M.

Re: Transactional sql tables with columns that can have NULL values

Hi! Where did you read that? That text should be updated! At least InnoDB supports indexes on columns which can have a NULL value. Regards, Heikki Tuuri Innobase Oy -Original Message- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Wednesday, March

Re: Foreign keys in mysqldump?

David, a Solaris version of InnoDB Hot Backup is planned, as well as a FreeBSD version. Currently I am working with beta testers trying to get the Large file support on Linux to work :). Regards, Heikki Tuuri Innobase Oy -Original Message- From: David Felio <[EMAIL PROTECTED]> Newsgro

MySQL Quits in Replication

Hi, We are having a serious problem with a simple replication setup using MySQL. One small database with 12 tables is being replicated one way - one master, one slave. Write transaction load is small, about 1 record per second, usually on only one of the tables. Read load is also light. The repli

Conflicting results using PHP/Mysql

Hi all, Posted this yesterday and got no response. Trying again today. I'm having a small problem with a biggish query. The query: $Itemlistquery= "select [a whole load of fields from 3 tables] ending with "; $Itemlistquery.= "transactions.Pdownload "; $Itemlistquery.= "from bib_extract,scanra

Problem in instalation

Hi all, I'm sorry my English. I 'm install mysql 3.23-49 en Linux and I have the next problem during to instalation: I execute : make creating libmysqlclient.la (cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/home/mysql/instala

R: [PHP-DB] Delete problem

Yes i review manual many times without success -Messaggio originale- Da: Rick Emery [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 13 marzo 2002 16.52 A: 'Riccardi Moreno'; Php List; Mysql List Oggetto: RE: [PHP-DB] Delete problem MySQL does not currently support sub-selects. The manual

RE: [PHP-DB] Delete problem

MySQL does not currently support sub-selects. The manual says: DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows] Did you review the manual first? -Original Message- From: Riccardi Moreno [mailto:[EMAIL PROTECTED]] Sent: Wednes

MySQL / MS Access subforms

Hi, I've been migrating an MS Access database from Access to use a MySQL linked-table backend. Most problems have been fixed by the advice on the MyODBC FAQ and other resources but I am having trouble with a sub form to which I cannot find an answer... The database is a customers/stock/orders da

Delete problem

Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all ---

RE: Sub-select look-alike?

Hi Greg, > SELECT f.language as From, t.language as To > FROM language f, language t, language_pairs lp > WHERE f.id = lp.from > AND t.id = lp.to; I really need to get some sleep I think. So simple, and yet my buggy mind didn't come up with that solution. Thanks, //andreas (sql, query - just

RE: Sub-select look-alike?

Is that what you want? SELECT languages.language, languages.fieldN, .., language_pairs.fieldX FROM language_pairs INNER JOIN Languages ON languages.id=language_pairs.id WHERE /* conditions */ -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13

RE: Sub-select look-alike?

SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; --Greg Johnson -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject:

Transactional sql tables with columns that can have NULL values

Hi, I would like to use transactional sql tables that support columns with NULL values. I think that only BDB and InnoDB tables types support transactions, but I have read that: "Only the MyISAM table type supports indexes on columns that can have NULL values. In other cases you must decl

Sub-select look-alike?

Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id

  1   2   >