Convert SQL Server Compact data to MySQL

Hello, I have data file written in SQL Server Compact.I need to Convert it to  MySQL. Does anyone know how to do that? Thank you, Sam

Re: Convert SQL Server Compact data to MySQL

Unfortunately they don't have MySQL Migration Toolkit  for Ubuntu --- On Thu, 4/5/12, Pothanaboyina Trimurthy wrote: From: Pothanaboyina Trimurthy Subject: Re: Convert SQL Server Compact data to MySQL To: "sam" Date: Thursday, April 5, 2012, 4:56 AM hello sam you can convert

Perl DBI does not print error.

rstr: Dan anyone please tell me how to prints how a description of the error from DBI when sql executed failed? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problem with installation

Hi guys. I bought a script .And guys ,who make an installation on my data-base have a problem with it.Installation is completed but My SQl can not read it.When I trying to open my database trough internet explorer I see error : My user name KOSTA turns to [EMAIL PROTECTED] I don't know why .And

User can't login to his DB.

ssword'; GRANT ALL ON hubertsdb.* TO hubert; Perl DBI commands: $database = "datacube"; $username = "hubert"; $pw = "password"; $dbh = DBI->connect("DBI:mysql:$database",$username,$pw); die "Unable to connect: $DBI::errstr\n" unless (defined $dbh

easy way to drop a tempoary table created by Create view?

Hi, What is the easiest way to drop a table created by "create view"? I m using mysql 5.0. I would like to execute the drop from Unix commandline. Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stored Procedure for advance reporting

Hi, Can anyone tell me where I can download examples for creating Stored Procedure in perl DBI? It seems that I can't create advance reporting with basic operations (select, create) in perl dbi, so I m looking for whether Stored Proc in MySQL can solve my problem. Thanks Sam -- MySQL Ge

How to protect MySQL server from intruders ?

from the outside world, except one particular application (with one username and password) which I would like to give access to , that would be running in the same system as the database Bottomline restrict the outside world traffic for the database !!! = Sam

RE: MySQL does not automatically start at BOOT time??

he script at system startup by adding to the chkconfig list chkconfig --add mysql chkconfig --level 345 mysql on For more information read http://dev.mysql.com/doc/mysql/en/Automatic_start.html Good luck... Sam --- "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: > Brian: >

Re: Can not write to a file in /home/.....

le Permissions" and still have a problem. I created a my.cnf and when I put in the line: set-varibale = UMASK=0777 in the {mysqld} section - the deamon will not start. I created a script as follows: UMASK=0777 export UMASK UMASK_DIR=0777 export UMASK_DIR

Re: Cluster/replication

Does any one have any advise about clustering and replication with of course mysql. Are there any third party products? Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

installing RPM RedHat 8.0

I am getting the following message when submitting the following: how-to-repeat: [root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD expected(ba03cefd50c27d9d993ce693457c072d

Re: error with 4.0.9 "c" API or user

common.o: common.c common.h $(CC) -c $(INCLUDES) common.c listener: main.o common.o $(CC) -o listener main.o common.o $(LIBS) clean: rm -f listener main.o common.o I am getting the following message when submitting the following: [sam@linux sam]$ make

binary log not recording 4.0.9

idea what to do. Should I sent this to bugs@mysql? Any ideas? sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: binary log not recording 4.0.9

s. I appreciate any help you can offer, Sam Pizzuto - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "sam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 9:20 AM Subject: Re: binary log not recording 4

Re: binary log not recording 4.0.9

file. Is this what you meant. Thanks sam - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "sam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 2:40 PM Subject: Re: binary log not recording 4.0.9 > Y

mysqld crashes immediately during mysql_install_db or alone

I had install today THE RPM version 2.23.49 of MySQL, files I took from MYSQL.com (and mirrors). I have a linux computer, RedHat version 7.2 I had no problem with rpm -i, except with the bench rpm file. When I do the command 'mysql_install_db' I have a message who begins by 'Installation of grant

mysqld crashes immediately during mysql_install_db or alone : signal 4

I had install today THE RPM version 2.23.49 of MySQL, files I took from MYSQL.com (and mirrors). I have a linux computer, RedHat version 7.2. I had no problem with rpm -i, except with the bench rpm file. When I do the command 'mysql_install_db' I have a message who begins by 'Installation of gran

Re: Re : mysqld crashes immediately during mysql_install_db or alone : signal 4

Thanks for your answer; This morning, as I had no answer, I loaded the binary mysql-3.23.49a-pc-linux-gnu-i686.tar.gz from mysql.com and I run it with success. There is a contradiction with the first point of your explanation "the .49 was compiled for i686 by accident; .49a is compiled for i386"

Bind on unix socket: Permission denied

Complete 011228 12:18:51 mysqld ended I read document that it is because of port already in use. but no application using the port. i tried with configuring different tcp port but got same error. Please guide me to over come this problem. T

Re: Bind on unix socket: Permission denied

Hello Caryen, Thanks ps -A | grep mysqld shows no process running on that name. but i did not get any errot on log files. wiating for solution thanks -Sam - Original Message - From: Carsten H. Pedersen <[EMAIL PROTECTED]> To: sam <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[

Database Connections - permanent or something else?

Hi, I have several web pages that are built with php and mySQL. I use a new connection for each script. Should I be using a permanent connection? Or is there a better way around this? Regards, Sam Rose - Before posting

Displaying Date correctly

Hi all, I was wondering how I can display a date in this format 'DD/MM/YY' As when I do a select statement and display the date I get it in this format 'DD-MM-YYY 00:00:00' Which is kind of annoying. I am using mySQL and also PHP. Thanks i

Announcing the MySQL Journal

o try and answer the most pressing questions that authors and advertisers tend to have. If you have any questions, please send me email. You are welcome to forward this to others. I look forward to your ideas, suggestions, and contributions! Sam Flywheel, Principal The Flywheel, Gadget, an

Announcing the MySQL Journal

, please send email to [EMAIL PROTECTED] I know this email is long, but I wanted to try and answer the most pressing questions that authors and advertisers tend to have. If you have any questions, please send me email or send me an instant message on AIM at samflywheel. You are welcome

RE: datetime/timestamps/4.1.12

Mike, Have you tried creating a new table with a field for some sort of date? Try adding some data and see if the new date time format you specified in the my.cnf file. See if that works. -sam > Hello, > > Nevermind - duh -datetime is not timestamp (oneday I fullfill my promise > t

Re: more queries vs a bigger one

Hello, approx. how long does it take your "big" query to run as it is now? Are these queries appending a table? or are they buiding a result (from a "chain" of queries)? Have you tried separating them out? Any difference? -sam > Hi, > > I have a big query th

Re: Why does query load faster after executing 2nd time? (Query Caching DISABLED, Key-Cache already fully loaded)

Hello therei have seen this question before, I cannot exactly remember when but it was a while ago. My advice is to go to the mysql.com website and do a search thru the mailing list using a search term something like "must execute query twice" or something to that effect. -sam &g

sql-bench and results

. But I cannot find this folder at all. I looked inside the binary installation package and the source installation package. Any idea where I can find these results? Thanks in advance. Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Problem installing mysql on Debian linux

othing happend... > > Does anyone know what's going wrong..? > Please help me... > Gregory, You need to install the termcap libraries. What version of Debian are you using? Why don't you install MySQL 5.0.18? Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Debian and "localhost.localdomain"

EMAIL PROTECTED]" is not allowed to connect. I suppose > it's a Debian 3.1 issue since it worked on Debian 3.0. Does anybody know > how I can get that "localdomain" out of my computer? Using MySQL 4.0. > What do you have in your /etc/hosts file? Sam -- MySQL

Re: how to change root password

On 2/26/06, Arnel Pastrana <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I was installing drupal on my webserver with mysql after i followed > instructions on how to configure and setup drupal i cant't access the > root password of my mysql. my password won't work all. > > Any idea how to change my

Error: Duplicate entry '0' for key 'PRIMARY'

Error: Duplicate entry '0' for key 'PRIMARY'   how can i fix it ?

Re: Error: Duplicate entry '0' for key 'PRIMARY'

. Ensure that all in the primary key have unique values. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Dup

Re: Error: Duplicate entry '0' for key 'PRIMARY'

y have unique values. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for k

Re: Error: Duplicate entry '0' for key 'PRIMARY'

Are you trying to do an Insert On Duplicate Key? Do ou want to insert a new row if it doesn't already exist or update one if it does? On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan wrote: > Are you talking about Length/Values1 > > > > --- On Mon, 3/2/09, Gary Smith wrote: &g

drop down menu to a table

How do I insert data from a drop down menu  (select box) to a table

Re: from excel to the mySQL

  visit this site :   http://www.daniweb.com/forums/thread119197.html   --- On Tue, 8/3/10, Marc Guay wrote: From: Marc Guay Subject: Re: from excel to the mySQL To: "HaidarPesebe" Cc: "MySQL Lists" Date: Tuesday, August 3, 2010, 7:34 AM > I'm needs a way to upload data from excel to th

The time of last updated field

I have to two different fields Last_Updated and Story. I want whenever Story Field got updated (modified) the time and date of the modification get recorded (insert) in Last_Updated Field - No need to miss a message. Get email on-the-go with Yahoo! Mail fo

insert data in to columns base on the selection of the list box.

Can you help me please? 1-I have created a while loop to populate the list box with the information of column1. 2-I need to update (insert data) in to column2, column3, column4 base on the selection of the list box. echo''; $query = "SELECT column1 FROM table"; $res

append information

I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append information - Looki

Importing data from excel sheet

I have created table in mysql with 12 fields Field1Field2 Field3 Field4 ……… Field12 I have an excel sheet with 12 columns and 150 rows. My question is how can I import all of the columns from the excel sheet to my table without losing any information.

Object-Oriented database

Is there such thing call Object-Oriented database for mysql? Basically can I store an item as an object in myql? - Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

Mysql and Textarea

Can someone show me the mysql query statement to update the Text Area (the Text Area is populated with information from mysql) basically I want to allow the user to change or add information to the original data. scroll down to read the code. The text area I need to update is red font. ht

index number of a specific cell

Is there a function in mysql to view the index number of a specific cell/field? For example if I want the index number for info4 or info7. Is it possible? Column 1 Column 2 Column 3 Column 4 Column 5 Info1 Info2

Mysql and Textarea

I'm just a php beginner. So please be patient with my stupid questions. What am I missing in this code that causing the function can’t update the textarea? Update button erase the old information from mysql database and replace it with nothing. Basically it can’t read what is ins

LAST_INSERT_ID & LAST_UPDATE_ID

How can I select (retrieve) the last updated cell (field). Basically I need to pull the new information only. I'm using for updating my database: UPDATE table SET column = CONCAT_WS ('column,'" . $column."') WHERE column= value; I need to select data: SELECT * FROM table WHERE column=What

Mail not being accepted

When I try to email to this list my email is reject with the following message? Error: 552 Mail with no Date header not accepted here My Mail has a date header in it...?

download Mysql4 for Redhat9.0

Hi, Can anybody tell me where can I download Mysql4 rpm for Redhat9.0? I cannot confirm the specific version in rpmfind.net is for Redhat9.0/ Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

download mysql 4 in rpm for Redhat 9.0

Hi, I realised that install mysql 4 thru rpm is the best way for a smooth installation. Can anyone please point me to a site where I can download mysql 4 rpm for Redhat9? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

copy DB data from FreeBSD to Redhat9.0

.0 in the FreeBSD box has database and tables with indexes. I don't want to rebuild the entire database from scratch in Redhat, how can I "transfer" all db files from FreeBSD to Redhat and in another version of MySQL? Thanks Sam -- MySQL General Mailing List For list archives: ht

Re: copy DB data from FreeBSD to Redhat9.0

sam wun wrote: Hi, I just fresh install mysql4.1 in Redhat9.0. I have another MySQL5.0 installed in FreeBSD5.3, and just tried to copy all data in /var/db/mysql/ from FreeBSD5.3 to /var/db/mysql/data/ in Redhat9.0. After finished copied the data over to Redhat, MySQL4.1 can't start. The DB

Re: copy DB data from FreeBSD to Redhat9.0

user account info. Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: copy DB data from FreeBSD to Redhat9.0

# mysql < mysql_2005-03-01.Tuesday.sql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have looked thru the mysqld script in /etc/init.d/ directory, but didn't get a cule about start up mysqld with unix sock. You got any id

Re: copy DB data from FreeBSD to Redhat9.0

sam wun wrote: Gleb Paharenko wrote: Hello. I used the following command backup database: mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST --quote-names --opt I don't think this command backup user account info. If you add --all-databases option it would also dum

Re: copy DB data from FreeBSD to Redhat9.0

-11 Thanks Sam sam wun wrote: sam wun wrote: Gleb Paharenko wrote: Hello. I used the following command backup database: mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST --quote-names --opt I don't think this command backup user account info. If you add --all-data

SQL runing very slow after restore

ew database (mysql 4.1.10). How do I know all my previous indexes are in-placed with the restore? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Silly mistake

qld ended How can I start mysqld now? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Looking for start stop script

Hi, Does anyone have a working start/stop script for mysql4.1.10? The mysql.server script come with the mysql4.1.10 package does not work with argument (start/stop). Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Silly mistake

mel list_php wrote: Hi Sam, To shutdown mysql I just use mysqladmin shutdown. http://dev.mysql.com/doc/mysql/en/server-shutdown.html Thanks for this help. I will surely use this command next time. About you restart problem, have a look in mysql/data/host.err file, it should give you a reason

Re: Silly mistake

s the versioning problem or missing indexes or something else... With MySQL5.01 in FreeBSD 5.3, it takes 2 seconds finish the query, but with MySQL 4.1.10 in Redhat, takes forever... Thanks Sam Since all DB data in this server are restored from the FreeBSD system in MySQL 5.0. I don't know how

Please help - MySQL4.1.10 don't run properly after data restored from 5.0.1

upport-files/my-huge.cnf to /etc/my.cnf. The second question is how to make sure all indexes are in-placed after the data restore? I used the following script backup all data from MySQL5.0.1: DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

d mysqladmin -u root password (yourpassword) for the creation of password. I m not sure, not expert in DBA. Sam and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. -- MySQL General Mailing List For list archive

Re: Optimizing a big query...

de it. And separate Sql Count would be too slow. Mike This require the change of Mysql engine. I wish Mysql has such configuration option for that in future release. Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Resetting lsn/trx for an .ibd file

sql/en/multiple-tablespaces.html We have massive InnoDB data structures where building indexes can take days; it would be very convenient if we were able to cleanly move .ibd files to our slaves, and I'm sure I'm not the only one interested in this. Has there been any work done to solve this

Binary Log replay utility?

Hi there, Is there a utility out there to do transaction-at-a-time view and/or replay with MySQL's binary log ? Primarily for audit / debug purposes. I'm only interested in using it with the proper database back-end, not ISAM. -- Sam Vilain, [EMAIL PROTECTED] In married life

Re: Binary Log replay utility?

No-one out there doing step-by-step replay of binary logs ? On Tue, 30 Dec 2003 17:52, Sam Vilain wrote; > Hi there, > > Is there a utility out there to do transaction-at-a-time view and/or > replay with MySQL's binary log ? Primarily for audit / debug > purpose

Re: Deciding whether to convert to InnoDB

Mysql runs at 100% pretty > much constantly. > > Now would InnoDB help in this situation? Would it allow us to increase > the thread count to push more through in a shorter amount of time > (because the tables wouldn't be locking)? > > And if s

Re: VARCHAR 255 versus TINYTEXT

w-like object, that requires another access to the tablespace to retrieve. Based on this possibly rash assumption, it would seem that it is a good idea to use a TINYTEXT if you have a column which is usually not selected, if you are scanning the entire table (via unindexed columns) a lot. -- Sam

Re: MySQL GPL License Question

avoiding the SQL server - then you would need to purchase a commercial license from MySQL AB to avoid the requirement for the derived work to be covered by the GPL. -- Sam Vilain, [EMAIL PROTECTED] It is better to be violent, if there is violence in our hearts, than to put on the cloak of nonviolence to

Re: MYSQL Database

Jochem > > -- > I don't get it > immigrants don't work > and steal our jobs > - Loesje > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql

binary log

ries. It would stand a better chance of being able to keep up. I'm not expecting real-time replication but after 24 hours, the slave is already 5 hours behind. Sam Jumper Director of Data Acquisition eRealty.com 713-490-7512

LONGTEXT size problem?

r max allowed packet and buffer size? Can anyone point me in the right direction? Thanks, Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: query challanged newbie

d = b.afrom AND b.ato = b.id; The same thing can be done with LEFT JOIN for a little added style, but this should work fine as-is. -sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: query challanged newbie

On Wed, 23 Jul 2003, Sam Tregar wrote: > SELECT a2.name > FROM alpha AS a1, bravo AS b, alpha AS a2 > WHERE a1.name = 'fred' AND > a1.id = b.afrom AND > b.ato = b.id; Whoops, that last line should read: b.ato = a2.id; -sam

Sum on Float type

t;Sub-Total" from customer c, transaction t where c.custcode = t.custcode group by t.custcode I don't know why the Sum function returns more than 2 precision number. If I should not use Float type for the Cost field, what type should I use? Thanks Sam -- MySQL General Mailing List For list

Comparison SQL always return false

ustcode;}; I may be using incorrect way to split the tokens, here is the function to extract a list of the token: $outlet_str = $in{'outlets'} Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

value of array to sql statement

Hi list, There is problem when with executing the sql statement in mysql 5.0. I m not sure whether version 4.x has the same problem. The problem is if I use static (hardcoded) values in the SQL statement, mysql returns result for each element in the array. If I use dynamically allocated value tha

How to determine a field is part of the primary key in a table?

Hi list, I m writing a perl program and would like to use it (wiht mysql command) to determine whether a field name is (or is part of) a primary key of a table. If you know how to handle this, please drop me a line. Thanks and Happy New Year. Sam -- MySQL General Mailing List For list archives

traverse the recordset more than once

when the "for" loop is finished, the pointer of the recordset is point to the end of the recordset. How can I revise the point to the beginning of the recordset ($sth)? Thanks Sam. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: traverse the recordset more than once

script in. If you are using PHP, you might look into the reset function. I "think" that might do what you want. At least it is a startmaybe http://us3.php.net/manual/en/function.reset.php I m using Perl DBI. Thanks Sam -- MySQL General Mailing List For list archives: http://lis

Re: traverse the recordset more than once

et, it will need to take extra time to do the copies, I assumed this is not shadow copies. Sam Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: easy way to drop a tempoary table created by Create view?

Gleb Paharenko wrote: Hello. Use -e command line option for mysql client program. For example: mysql -u root -p test -e 'drop view v' Hi, does it take wildcard? something like: mysql -u root -p test -e 'drop view v*' Thanks Sam -- MySQL General Mailing List For

Re: easy way to drop a tempoary table created by Create view?

sam wun wrote: Gleb Paharenko wrote: Hello. Use -e command line option for mysql client program. For example: mysql -u root -p test -e 'drop view v' Hi, does it take wildcard? something like: mysql -u root -p test -e 'drop view v*' Or even drop all view tables (only af

Error in Insert on Duplicate Key Update

basename=Revlon, vendorname=,cost=' at line 3 at insert-inventory-mysql.pl line 55, line 1. Unable to execute query: DBI::db=HASH(0x864a988)->errstr Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Insert if Update failed without Select

Any example would be very apprecated. Thanks Sam. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Update does not doing updates

returnreason="$returnreason" where prodcode="$prodcode" and custcode="$custcode" and date="$transdate";}; $sth = $dbh->prepare($update_sql) || die "prepare: $update_sql: $DBI::errstr"; $sth->execute || die "Unable t

Re: Insert if Update failed without Select

o execute it, the update statement update the record instantly. I don't know what is happening here, why perl dbi does not do what the update statement supposed to do? Have I missed a commit statement? but I don't have idea how to place a commit statement to perl dbi. Thanks Sam

Re: create view not working on mysql 4.1.8

without any problem. Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sub query is extermely slow

not NULL and(date(tt.date) >= "2005-01-01" and date(tt.date) <= "2005-01-31"))) order by i.basename Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sub query is extermely slow

Clint Edwards wrote: Sam, Can you send the output of the following: #>explain \G Thanks for the suggestion, here is the output of the explain query: mysql> explain select DISTINCT i.basename from inventory i, transaction t, customer c where i.prodcode = t.prodcode and c.custcode = t.custcod

Re: sub query is extermely slow

Clint Edwards wrote: Sam, Can you create an index on transaction.date, then run your query again? If that is not better send me the output of 'explain ' again. This index may not be a good idea, depending on how many transaction are in the table on a specified date. May I ask how to

Re: sub query is extermely slow

nk simply take out the join for i.prodcode = t.prodcode and i.prodcode = tt.prodcode and use left/right join will yield the desired result? Thanks Sam Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

optimize mysql 5.01

search? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

indexing operation running for few hours

? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sub query is extermely slow

erent temporary tables with "create view as select ..." for 2 differnet period, the join between this temp tables is also much faster than this series inner joins approach. With 16 records in the transaction table, the series inner joins takes very long time (more than 15 minut

INNER JOIN across multiple tables appear very slow.

INNER JOIN inventory i ON i.prodcode = t.prodcode AND i.prodcode = tt.prodcode AND i.basename = '$basename_param' WHERE i.prodname is not NULL and i.basename is not NULL

Re: INNER JOIN across multiple tables appear very slow.

sam wun wrote: Hi, Can anyone tell me how to optimize the following sql statement? $sql_1 = " SELECT t.prodcode 'Product Code', t.prodname 'Product Name', ROUND(avg(t.salesvolume),2) 'PastSales Quantity',

Error with Storage engine

w can I correct this error? I musing mysql5.01 Thanks Sam. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

show temporary table

Hi, How can I see all temporary tables that created by Create Temporary Table command in mysql 5.01? thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >