Re: Fwd: why must user variable in EXECUTE USING clause ?

to > avoid the "feature" (?) of Outlook that glues lines together. This > "feature" can be disabled/reverted (although this is not widely known) > > At 21.38 26/03/2012 +0800, Cifer Lee wrote: > > > >-- Forwarded message -- > >From:

Fwd: why must user variable in EXECUTE USING clause ?

-- Forwarded message -- From: Reindl Harald Date: Mon, Mar 26, 2012 at 9:17 PM Subject: Re: why must user variable in EXECUTE USING clause ? To: Cifer Lee would you PLEASE send to the list instead off-list and put your answer BELOW instead to-posting? is it really so difficult

Practical connection limits MySQL 5.1/5.5

Hey All, Can anyone provide some guidance as to what the practical connection limits to MySQL 5.1/5.5 are under linux? We're running a ruby on rails application that establishes 50 to 100 connections to our database upon startup resulting in around 1,000 persistent db connections. I've been told

Re: Error in mysql replication with LOAD DATA INFILE

Hi Anand, Just try 'load data local infile',it maybe work. Eric 2010/12/20 Anand : > Hi guys, > > i am facing a serious issue with my replication , i tried so many things but > no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in

No Need to Create Constraints?

there no need for me to actually add these constraints? -- Lola J. Lee Beno LinkedIn: http://www.linkedin.com/in/lolajleebeno Facebook: http://www.facebook.com/profile.php?id=714355583 Blog: http://www.lolajl.net/blog/

Re: auto_increment without primary key in innodb?

yah, mysql only allows one auto increment field n that's used as the primary key in tables. I don't think it has to be the primary key as long as it is a unique key i think that's okay. so u should be able to do : create table (myid int unsigned not null auto_increment., unique key (myid));

Re: query optimization question (my struggle against 'using temporary; using filesort')

ot be much better. Regards, Ciaran Lee 2009/9/24 Gavin Towey > Hi Ciaran, > > So I think there's a couple things going on: > > 1. The explain plan for your "slow" query looks wrong, such as mysql is > confused. It's possible your index statistics are incorrect.

query optimization question (my struggle against 'using temporary; using filesort')

Hi, I hope this is the right place to ask a question about query optimization. Background: I have a database which has events, which occur in places (listings). Places have addresses, and addresses belong to a city. I can select the latest event within a particular city very efficiently (less tha

Re: How to Use Cascade Delete Properly

LTER TABLE `jobsearchtwodb`.`jobposts` ADD CONSTRAINT `adsourcefk` FOREIGN KEY `adsourcefk` (`adsource_id`) REFERENCES `adsource` (`adsource_id`) ON DELETE RESTRICT ON UPDATE NO ACTION; ON DELETE RESTRICT having the behavior like ON DELETE CONSTRAIN? -- Lola J. Lee Beno - ColdFusion

How to Use Cascade Delete Properly

happen. I can't use triggers because for some reason I can't get the triggers working properly. Is there any way I can do this on the database side without having to write code in the application code I'm working on? -- Lola J. Lee Beno - ColdFusion Programmer/Web Designer f

Re: Trying to Create a Trigger

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if @counted >= 1 then SET dummy = 'Cannot delete this record' end if' at line 1 Query = if @counted >= 1 then SET dummy = 'Cannot delete this record' end i

Re: Trying to Create a Trigger

h a JOIN clause and to put your strings inside single quotes as per SQL standard, double quotes are really for object names. Right . . . I'll get the JOIN clause figured out after I figure out what's causing the above error message. -- Lola J. Lee Beno - ColdFusion Programmer/Web Designe

Re: Trying to Create a Trigger

and adsource tables BEFORE proceeding to delete the record. If so, what's the best way to do this? -- Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/ "In rivers, the water that you touch is the last of

Re: Trying to Create a Trigger

"id"? Maybe Yes. Jobpost_id. No, not a typo. It's primary key, jobposts.adsource_id is foreign key while adsource.adsource_id is primary key. -- Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire http://www.lolajl.net/resume | Blog at http://www.lolajl.net/b

Re: Trying to Create a Trigger

eting jobpost record - that's what I'm trying to do and thus is what this trigger is supposed to do. -- Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/ "In rivers, the water that you touch is the las

Trying to Create a Trigger

t delete this record" end if; end // delimiter ; When I run the set query without the "and old.jobpost_id" line, it runs correctly. So the syntax problem is elsewhere, but where? -- Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire http://www.lolajl.net/resume | Blog at http:/

performance question

All, Just curious as to which query would be better in terms of performance: select * from (select * from a union select * from b) as c; versus select * from a union select * from b; or would these 2 queries be the same ? Thanks, Yong. Yong Lee Developer [EMAIL PROTECTED] <h

RE: Replication for reporting

yes, one master to multiple slaves. I believe u can set up multiple mysql instances on a single machine with each mysql instance collecting from a different master. Yong. -Original Message- From: Andrey Dmitriev [mailto:[EMAIL PROTECTED] Sent: May 21, 2008 11:29 AM To: mysql@lists.mys

RE: Match/No Match query

chris, you're going to need a source for all the distinct codes that you may see in your product tableie: if you don't have a full list somewhere (like your temp table) you cannot do your query because you have nothing to compare against. assuming you had some table X which had a list of all

List queries

Hi all, Is there a problem with the mysql web page (http://lists.mysql.com/) where you can query mailing list archives ? I can't seem to get more than 20 results to any query. Thanks, Yong. Yong Lee Developer [EMAIL PROTECTED] http://www.eqo.com/ direct: +1.604.273.8173 x113 m

How to optimize this long query

Hello, I have several tables storing item information, keyword (mainly for searching), category and subcategory (also for searching). The query I am using now is: SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i LEFT JOIN iteminfo it ON i.id = it.id LEFT JOIN itemkeyword ik ON i.id =

log table advice

ed on current time before doing an insert) and then have a cron job to create new tables as needed and to also backup and remove older tables as they are no longer being used. Any thoughts on this ? Thanks, Yong. Yong Lee Developer [EMAIL PROTECTED] <http://www.eqo.com/&g

Re: Load Balance on MySql

Thanx for the information , but i wanted to go for a long term plan and for a fixed solution. bcause little by little that load getting high. please need some mysql expertise help. Thank you, Shaine. Ady Wicaksono <[EMAIL PROTECTED]> wrote: Hi Lee better you start to benchmark your

Load Balance on MySql

Hi Friends , I have huge WAP content database and it's included with wallpapers, ringtones, games ...etc.That content database getting hits more that 1000 /sec. This is actually massive. My Webserver s are Tomcat and apache , because some applications written in java and some are php . per

Re: mysql data into CSV file. / (Errcode: 13)

Thank you , that is working with /tmp/ directory. actually what is the issue behind writing that files into user defined folder , like /home/test/ ? have you find any solution for that ? Thank you, Shaine. Nils Meyer <[EMAIL PROTECTED]> wrote: Hi Shain, Shain Lee wrote: > ERROR

Re: mysql data into CSV file. / (Errcode: 13)

ioned above. really got stucked. how can i solve that problem ? is it a bug ? please help . Thank you, Shaine. Jake Peavy <[EMAIL PROTECTED]> wrote: On 1/4/07, Shain Lee <[EMAIL PROTECTED]> wrote: I wanted to get that info which has stored in relavent fields into a CSV fle . Can

mysql data into CSV file.

Hi For example , suppose i have a database - Music, and a table in it is mp3. under mp3 there is more fields , like, id, artist, name , mp3_file...etc. I wanted to get that info which has stored in relavent fields into a CSV fle . Can somebody help me to do that please ? Can i do it mysql co

rhel4 mysql max rpm question

Hi All, I noticed that there are RPM downloads for RHEL4 but that these do not contain the ndb storage engine (ie: these are standard builds). As such, I've resolved to just use the generic x86 rpm bundles that are offered but I'm curious if the ndb storage engine will ever get included into a

Contents storing in mysql

Hi , I wanted to store images , musics, videos ..etc in mysql database.storing contents as content type BLOB , i don't have any issues with that setup. But , now i need to store that contents in folders and should be kept the contents path with referrence ofcontents file name . for ea

utf8 charset question

Hi all, I'm fairly new to character sets and I'm trying to get a better understanding of how mysql deals with them. I hope someone out there can shed some light on a behavior that I am seeing. We're using mysql 4.1.12 with clustered tables. I have a table with a varchar and a text field w

mysql driver for C++

Hi , Could you please tell me , how can i install C++ , mysql driver in Fedora core 5 ? Is that available for any platforms ? does YUM supports for install mysql c++ ? please help me , its really urgent . Thank you, Shaine. - Yahoo! Cars NEW

Re: Finding the closest value

n-col1)), LEAST( ABS(MIN(@n-col2)), ABS(MIN(@n-col3)) ) ) FROM ... I think the formula is just right - very clever. But is it possible to make sure that col1, col2 and col3 are all from the same record? Thanks in anticipation Lee -- MySQL G

Finding the closest value

using a Kohonen network, but I would prefer to use MySQL. Many thanks in anticipation Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

udf configuration resources

Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time. I'm w

udf configuration

Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time. I'm w

mysql - multimedia database

Hi , I'm just behind a mulimedia database , that wanted to be online with WAP contents. So , i decided to go ahead with mysql , and i installed mysql latest 5.0 in fedora core 5 with innoDB .upto now every thing success. But , my worries is , how can i created huge mulimedia database wit

Re: Date Field Reverting to 0000-00-00 Format

Michael Stassen wrote: So, take a look at yarn_date.txt and let us know. Yes, you're right . . . there was an extra tab stop. When I deleted the extra tab, the date field were retained successfully. Thanks! -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www.l

Re: Date Field Reverting to 0000-00-00 Format

Michael Stassen wrote: Just a quick reply for now . . . Ummm, if you delete the numbers to the *left* of the decimal point, "2005-01-15 10:15:42.41837" will turn into ".41837", which is still not a valid datetime. You need to delete the numbers to the *right* of the decimal point (which I ex

Date Field Reverting to 0000-00-00 Format

I have a bunch of data where one of the columns is a date field. Here's a sample of the data that I have: 1 4 14 150 1 0 0 0 1 0 2005-01-15 10:15:42.41837 2 8 15 120 1 0 0 0 2

Re: Loading Data File into Database Table

Lola J. Lee Beno wrote: ERROR 13 (HY000): Can't get stat of '/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt' (Errcode: 13) Never mind . . . I figured that I needed to add LOCAL to the query. Should have gone back to the manual page for LOAD

Re: Loading Data File into Database Table

Peter Brawley wrote: >ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your >MySQL server version for the right syntax to use near 'standardwttype.txt` Use single quotes not (dreaded) backticks. This seems to have fixed one problem. Now, I ha

Loading Data File into Database Table

I'm trying to import a set of data into a database (MySQL 5.0.17-max). Here's the query that I tried to run: LOAD DATA INFILE `standardwttype.txt` INTO TABLE StandardWeightType FIELDS TERMINATED BY `\t` LINES TERMINATED BY `\r` (standard_wt_type_id, standard_wt_desc, standard_wt_lud); And here'

mysql_store_result() and MYSQL_ROW allocations

id rows.. Cheers, -- - Lee H // anfl -I code, therefore I break things. signature.asc Description: Digital signature

mysql++1.7.1 & vc++6 compile errors

thanks for the reply Jason, i have now added mysql++.lib to the linker and also copyied the libmysql.dll to the system folder. the program complies now with a few performance warnings but no errors. there is one link error LINK : warning LNK4098: defaultlib "LIBC" conflicts with use of other lib

mysql++1.7.1 & vc++6 compile errors

Hi I am using visual studio C++ 6, with SDK, my mysql database is 4.1.18, i downloaded mysql++ 1.7.1 as this is the compatiable version for vc++6. the example program compiles and runs. when i go to make my own project i use the wizard and create a basic dialog MFC app. at the top of the main

upgrade from 4.1 to 5.0

Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import

Re: Can't Create Foreign Key Constraints

Gleb Paharenko wrote: Hello. The query which is works is: Thanks - just what I needed. Looks like I'll need to be extra careful with sql scripts generated from Mysql Workbench, which is still alpha right now. -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www

Re: Can't Create Foreign Key Constraints

Peter Brawley wrote: Lola, />And got this following error message: >ERROR 1072 (42000): Key column '(not null)' doesn't exist in table / Yes, it's telling you what;s wrong: to define a constraint on a key, the table def must first define the key. Looking over the script again, RatingID is b

Re: Can't Create Foreign Key Constraints

Michael Stassen wrote: 1) I'm not sure what you are intending with "(`(not null)`)" in the middle of your foreign key definition, but that isn't valid mysql syntax. See the manual for the correct syntax . This is f

Can't Create Foreign Key Constraints

I'm trying to create foreign key constraints and keep getting an error message 1005 (I did look it up, but didn't see an obvious solution to fixing this for my database). The version I'm using is 5.0.17-max. I used Mysql WorkBench to create the database schema and had it generate the sql scri

Re: SSH tunnel for Mysql

to mysql. Your done. Not sure how you would do it with other pructs, but I don't imagine it would be much more difficult. Lee --- Jerry Swanson <[EMAIL PROTECTED]> wrote: > How to create ssh tunnel for Mysql? > TH >

Table_locks_immediate and Innodb Selects

Why would a simple select against an innodb db result in a bump of the table_locks_immediate variable? I've been debugging a different problem and I noticed this behavior. I don't believe it is a problem but can't explain the behavor and it seems odd. Regards, Lee mysq

compare tables from two systems

We have two clusters running the same data independently and saving output to databases on two systems (two hosts) respectively. We need to compare the output each day. Is there an easy way to compare tables from two systems? We are sure the structure of the tables are all the same and we need to c

Re: strange order by problem

5| 2005-09-23 | | SWAP5| 2005-09-22 | +--++ --- Hassan Schroeder <[EMAIL PROTECTED]> wrote: > Claire Lee wrote: > > I need to order a few names by the number > following > > the main name. For example swap2, swap3, swap10 in > the > > order of swap2, swap3, swap1

strange order by problem

I need to order a few names by the number following the main name. For example swap2, swap3, swap10 in the order of swap2, swap3, swap10, not in swap10, swap2, swap3 as it will happen when I do an order by. So I came up with the following query: mysql> select distinct secname, date from optresult

add a column if not exists

I want to check if a column exists in a table before I do an alter table to add it. How do I do this in mysql? Thanks. Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL Genera

RE: increment and update in one query

>> Hi all, >> >> I've a question to guru :) >> there're two tables: >> mysql> show fields from domains; >> ++--+--+-+-+ >> | Field | Type | Null | Key | Default | Extra >> ++--+--+-+-+

increment and update in one query

Hi all, I've a question to guru :) there're two tables: mysql> show fields from domains; ++--+--+-+-+ | Field | Type | Null | Key | Default | Extra ++--+--+-+-+ | id | int(10)

mysql and c

Hi all, is it possible to send from server to client a handle to MySQL connection. for example then i'm trying: server: Code: ... MYSQL mysql; mysql_init(&mysql); mysql_real_connect(&mysql,); ... send(socket,&mysql, sizeof(MYSQL),0); - client: Code:

MAX select problem

he right figure, but when I try to pull out the date that this occured on with, SELECT max(visits) as maximum, visit_date FROM visit WHERE (((visit_date >= '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id)) GROUP BY visit_date I get a complet

BOOLEAN Vs NON-Boolean

ave the biggest overhead, an could there be a better approach? Cheers, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Simple GROUP / ORDER problem

ding on my part, but does any one have any ideas? All the best, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Character Set Problem

Is it possible to change the character set just for an individual table and if so which character set should I try to display this european characters? Cheers, Lee - Original Message - From: "Sumito_Oda" <[EMAIL PROTECTED]> To: "Lee Denny" <[EMAIL PROTECTED

Character Set Problem

PHP to query the database, but would like to change the data in the DB if possible. I know this is a bit vague but I was wondering if anyone had any insight into this. Cheers, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Duplication of records within the same table.

text... page_id is already auto_increment. I'm sure that an INSERT .. SELECT statement should do it, but I'm unsure of the correct syntax. cheers, Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Upgrading from MySQL Max 3.23 to 4.1.x

ould be to do a seperate install and then let depot do the migration. However, if MySQL provides a simple 'upgrade' I would love to hear of it. Thanks! Lee __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com

Fulltext search Strategy - Need Help

earch once for 'ford' and then go through the record-set this returns for 'focus'. My first thought is use a temporary table - but is there a way of doing this with one query? Cheers, lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SOLVED: Read-Only DB User

nting a the password in hex format. Anyway, thanks again James! Lee --- James Weisensee <[EMAIL PROTECTED]> wrote: > Lee, > On the MySQL side: > > GRANT SELECT ON db.* TO user@'host' IDENTIFIED BY > PASSWORD 'password'; > > This will give 'user

Read-Only DB User

db itself. Anyway, if anyone can provide a lean and concise statement that will provide this, it would be very much appreciated. Thanks! Lee __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Can't connect to DB after upgrading to mysql 4.1.5

Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI->connect("DBI:mysql:$dbname;host=$host","$dblogin", "$dbpasswd") or die "Cannot connect to $dbname: " . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI->connect(dbname;host=host) f

Tricky Date Query

Hello, I need to perform a select that compares two dates I need to return all records that haven't had date_2 set after a given number of days since date_1. I'm sure this can be done in one query but I just can't get my head around this one. Can anyone help? Cheers, Lee --

need help for a query

Hi, Here's a table of mine namedate changeDate n1d1 cd1 n2d1 cd3 n2d2 cd1 n4d1 cd2 n1d2 cd5 n5d1 cd4 n6d2 cd2 I need to select every name for which the changeDate corresponding

distinct based on two fields--please help

I have a table like this name price type A10 1 B30 2 A20 1 B20 2 would like to distinct based on name and type, do a sum and get the following result name price type A 30 1 B 50 2 How do I do this with one sql qu

distinct based on two fields

I have a table like this name price type A __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

RE: how to write query to return records has the closest date to end of month

Hi Lam, Try and see whether following SQL work for you: create temporary table tmp as select product_id, min(abs(to_days('2004-6-30') - to_days(snapshot_date)) + if(snapshot_date > '2004-6-30',0,0.1)) as date_diff from product_tbl group by product_id; select product_tbl.* from product_tbl, tm

mysqladmin flush-logs

Hi, I would like to use logrotate to manage the log files generated by MySQL. I used the command "mysqladmin flush-logs" to close the log file. However, the sql command displayed on the query log is "Refresh". According to the information from this forum, command "flush logs" should be used in

File name of Binary Log

Hi, I have enabled the binary log on MySQL (4.0.20). The name of the binary log is hostname-bin.001, hostname-bin.002, etc ... What will happen if the suffix become 999? Will error occurs when flush logs is executed? Regards, Michael --

RE: INNODB transaction log size

nd issue the commits after `x` number of inserts. -Original Message----- From: Michael Lee To: [EMAIL PROTECTED] Sent: 6/28/04 1:21 AM Subject: INNODB transaction log size Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I wan

INNODB transaction log size

Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I want to use the command Load Data Infile to insert the data to MySQL. However, some table contains millions of rows. Can i control the batch size of the loading (e.g. commit

Select problem for column with Binary attribute

Hi, I am using MySQL 4.0.20. For a table of INNODB type, same query return different results when different query plan is used. select * from project_team where project_id = 'FMS '; --> 2 rows. (primary key used) select * from project_team ignore index (PRIMARY) where project_id = 'FMS ';

Notifying User when DB is Updated via browser

atest applications. Is there any way of using some sort client-server technology to alert the user, via the browser that a new entry has appeared in the DB - I'm already sending an email but this is still not the best solution. Thanks in advance, Lee Denny -- MySQL General Mailing Lis

Re: Newbie Can't Add a User to MySQL

problematic php snippets below, as well as the forumuser creation and authentication process. If somone could please point out my mistakes, that would be awesome! Thanks again, Lee TESTER ?php //Database connect script $dbhostname = "localhost"; $dbuser = "forumuser"; $db

Newbie Can't Add a User to MySQL

-+ | Database | +--+ | forums | | phpBB| | test | +--+ 3 rows in set (0.00 sec) mysql> USE forums; ERROR 1044: Access denied for user: '@localhost' to database 'forums' mysql> USE forums; ERROR 1044: Access denied for user: '@localho

Replication Can Master initiate replication to Slave?

The documentation I find describes the slave contacting the master to initiate the replication service.   I need the master to be able to contact the slave. Is this possible.   Thanks   lee   -- Lee Chalupa Something Else Enterprises, Inc. [EMAIL PROTECTED] 770 381 2377 -- MySQL General Mailing

SQL Query problem

Hi All, I have a query problem here. Say I have a table with employee records of three different departments. If each department manager wants to see employee info of their own department. Three different queries will be needed. Is there a way that I can write one single query and let SQL decide wh

MySQL version 4.1.x

anges in release 4.1.x (Alpha) > * C.2.1 Changes in release 4.1.2 (not released yet) > * C.2.2 Changes in release 4.1.1 (01 Dec 2003) > * C.2.3 Changes in release 4.1.0 (03 Apr 2003: Alpha) Thanks in advance! /lee = == /lee +-

tmpdir "round-robin" algorithm?

to the directories in the order listed in tmpdir? Or are all the directories functionally equal? Thanks in advance! /lee = == /lee +---+ | This concludes our broadcast day| +---+ __ Do

porting Oracle schema to MySQL

Hi, I'm a newbie working on a big project. The idea is to transport an existing Oracle database at http://www.ebi.ac.uk/arrayexpress/ to a local MySQL server. The Schema, scripts and loader for Oracle can be found in the website. But how to create an exactly same database with mySQL? I have no clue

replicate-ignore(d)-table continues to replicate

cate-do-table=radius.RADPOOL Cheers Lee Webb -- Systems Administrator DOT Communications [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database Design and Bianry Operations

is a more efficient method using binary operations (only one field populated with zeros and ones) but I can't find anything to help in the manuals. Any thoughts? Lee Denny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem starting up mysql

Hi all, I installed mysql 4.0.14 binary distribution on RedHat 8.0 following the instructions in the manual. But I can't get it to work. Please help. When I start mysql using the command: shell> bin/mysqld_safe --use=mysql & the following message shows: "Starting mysqld daemon with databases

Difficulty with thai columns

nrenderable characters for the Thai. So what do I do about this? Any help greatly appreciated. -- John Francis Lee 1/9-10 Thanon Trairat Muang Chiang Rai 57000 Thailand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Foreign Keys and InnoDb in MySQL

Hello, I have a problem about foreign key in using MySQL.com manual. According to the example in MySQL.com manual, one foreign key is ok. However, I have 3 tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more foreign keys, I have the following errors. Case 1: mysql> cr

why it run so slowly

Dear Sir: i am a user of mysql gui,version mysqlgui-win32-static-1.7.5-2. My pc is Petium 4 1.4G, on which most program run very fast. but when i use mysql gui, i find it run very slowly although i can get the result. I wonder how can i make it run faster. thank you for your helping. My OS: WI

Re: auto_increment in multiple tables...

Are you using PHP? There is a useful function in there that would give you the last auto-number, like this: (do your first insert) $insert_key = mysql_insert_id(); (do your second insert, using $insert_key as the new foreign key that you are putting in your SQL) Now each table has its own auto-

Re: Newbie question: Storing text

VARCHAR is limited to 256 characters. TEXT is much longer, like 6000 or 6 characters or so, don't actually know. I believe both TEXT and varchar both support full text searches. You can store HTML in the database, just be sure to addslashes and stripslashes going in and out. Your server may be

[newbie] how do I force a numerical comparison of two md5 strings

Am I right in assuming that comparing two md5 strings would be faster if they were compared as two hexadecimal numbers than if they were compared as two strings? If so, is there any way to insist on this in a SQL query? I am using PHP, and would like to know from that perspective if it makes an

JDBC problems

ously putting the class files in the wrong place - but this is my first crack at Java so need help. Thanks in advance, Lee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: COLDFUSION AND MYSQL

Hi marco In the administration page of coldfusion, usually something like: http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm go to your data sources and click the edit button. THen click the "show advance settings" button. Make sure that the Allowed sql pr

Re: help with syntax of left outer join

smond >From: "Desmond Lee" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: help with syntax of left outer join >Date: Tue, 13 Aug 2002 14:34:06 -0700 > >Hi there > > >I want to do a left outer join but i also have a bunch of where conditions >in

  1   2   3   >