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

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: 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

drop down menu to a table

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

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

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'

. 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

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

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

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...?

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

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

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

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

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.

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.

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

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

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

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

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

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

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: 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]

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: 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

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: 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

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

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]

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]

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

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: 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

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

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

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]

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]

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

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

# 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

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

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

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

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

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]

Can't drop index.

Hi, I created an index on a foreign in a table before. I need to drop this index. but I got the following error: mysql> alter table transaction drop index prodcode; ERROR 1025 (HY000): Error on rename of './datacube/#sql-30e8_3' to './datacube/transaction' (errno: 150) mysql> mysql> show index f

Re: INNER JOIN across multiple tables appear very slow.

Hi Michael, Thank you for being so kind to explain the problem to me. Michael Stassen wrote: sam wun wrote: 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

create indexes for temporary table

our query:".$dbh->errstr."\n"; $sth_tmp->execute or print "Unable to execute our query PastSales:".$dbh->errstr."\n"; 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]

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]

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',

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: 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

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]

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]

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]

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

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

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: 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]

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

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

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]

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]

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

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

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

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]

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: 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

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:/

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

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

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

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]

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

tricky timetable based query

--- 1 Mat R1 Sci R6 2 Sci R6 Mat R3 3 Eng R2 Eng R5 4 Mat R7 Eng R9 Any help would be appreciated sam ** This message is intended for the addressee named and may

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: >

Mac OSX MySQL Client 4.1.1

My Mac mysql client does not appear to work correctly. The DB is fine and setup working great but I cannot use that version of the mysql client. Right now I'm using the 4.0.18 client on my mac. Are there known bugs with the 4.1.1 Mac OSX client? Sam Peterson

Oracle Listener Like Functionality

ady' state. Once the database is recovered then I'm reconfiguring the port. Has anyone else done something similar to this? I'm new to MySQL so any better suggestions would be appreciated. Sam Peterson

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: free software and open source

On Sun, 11 Apr 2004, Saurabh Data wrote: > Can anyone in your own words clarify the difference between "open source" > and "free software". Don't take our words for it, get it from the Gnu's mouth: http://www.gnu.org/philosophy/free-software-for-freedom.h

RE: How to turn-off the replication?

That was quick! I am trying to turn it off from master. --Sam -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 12:34 PM To: Sam Yathira; [EMAIL PROTECTED] Subject: Re: How to turn-off the replication? Are you wanting to turn off

How to turn-off the replication?

Hi, Everybody talks about setting up replication, but any documentation on turning off replication? Regards, Sam     This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privile

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

Re: Query was empty -- any ideas

Okay, I feel dumb. After seeing my message appear on the list, in a different font, I can see that here: $result = mysql_query($sq12,$connection) or die (mysql_error()); I typed "$sq12" instead of "$sql2" -- sorry! Works now. Sam Sam Folk-Williams wrote: Hi, This script

Query was empty -- any ideas

Hi, This script keeps returning the error "Query was empty" via php's mysql_error() function. I think this is just a run-of-the-mill query, of which I have hundreds on this site. I just can't figure this out... any ideas? I'm probably missing something small. I have tested the variables and th

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

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: 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: 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: 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

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: MySQL Package Install for Mac OS X 10.3 (Panther)

I used the MySQL Complete package from Server Logistics and it installed fine on my clean Panther install. Also, the MySQL Preference Pane and CocoaSQL work fine as well. Thanks, -Sam On Tuesday, October 28, 2003, at 11:08 PM, Sam Carpenter wrote: My bad, I should have been more precise. I

Re: MySQL Package Install for Mac OS X 10.3 (Panther)

My bad, I should have been more precise. I am not upgrading - I have done a clean install. So, now I need to re-install MySQL. -Thanks On Tuesday, October 28, 2003, at 11:00 PM, Kim Kohen wrote: I am upgrading to Panther -- MySQL General Mailing List For list archives: http://lists.mysql.co

MySQL Package Install for Mac OS X 10.3 (Panther)

I am upgrading to Panther and I need to install MySQL. Does anybody know if the Mac OS X Installer Package v10.2 (Standard) works with 10.3? If it doesn't then what would be the best installation method on a clean 10.3 installation? Thanks, -Sam Carpenter -- MySQL General Mailing Lis

Re: using OR in select statement with distinct results

Thanks everyone, I suspected it was something quite simple. Sam Matt W wrote: - Original Message - From: "Paul DuBois" Sent: Thursday, September 18, 2003 8:17 PM Subject: Re: using OR in select statement with distinct results At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrot

using OR in select statement with distinct results

te that if I only want results from one category (i.e.: SELECT t1.title, t2.auth_name FROM t1, t2, WHERE cat_id = 1 AND t1.auth_id = t2.auth_id) everything works just fine. Thanks for any help, Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

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

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]

  1   2   >