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 skd.trimur...@gmail.com wrote: From: Pothanaboyina Trimurthy skd.trimur...@gmail.com Subject: Re: Convert SQL Server Compact data to MySQL To: sam asu_...@yahoo.com Date: Thursday

Re: from excel to the mySQL

  visit this site :   http://www.daniweb.com/forums/thread119197.html   --- On Tue, 8/3/10, Marc Guay marc.g...@gmail.com wrote: From: Marc Guay marc.g...@gmail.com Subject: Re: from excel to the mySQL To: HaidarPesebe haidarpes...@gmail.com Cc: MySQL Lists mysql@lists.mysql.com Date:

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'

, 2009, 1:58 PM Easy. 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

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

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: Duplicate entry '0

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

2, 2009, 2:32 PM 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 samc...@yahoo.com wrote: Are you talking about Length/Values1 --- On Mon, 3/2/09, Gary Smith g

drop down menu to a table

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

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

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

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.

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 -

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'form'; $query = SELECT column1 FROM table;

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

Announcing the MySQL Journal

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, and Sprocket Co. Publisher, Tabula email: [EMAIL PROTECTED] aim: samflywheel

Announcing the MySQL Journal

, 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 to forward this to others. Thanks! Sam Publisher, Tabula email: [EMAIL

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: Problem installing mysql on Debian linux

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

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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

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

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 to myself

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 that involves searching in more tables

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 Filesystem

Resetting lsn/trx for an .ibd file

-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 issue? -- Sam Sgro [EMAIL

Re: Optimizing a big query...

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.

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]

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

=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e show databases| sed 's/ /%/g'` Thank you in advance Sam. mel list_php wrote: Yeah, I have looked at it, but not sure whether I need to repopulate the mysql.host db file. If I do that, I may be also need to recreate all db

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

(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 archives: http://lists.mysql.com/mysql

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

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 to recreate all indexes for db

Re: copy DB data from FreeBSD to Redhat9.0

-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 idea? Thanks Sam sam wun [EMAIL PROTECTED] wrote

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 dump

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

SQL runing very slow after restore

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

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]

Re: copy DB data from FreeBSD to Redhat9.0

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

copy DB data from FreeBSD to Redhat9.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: http://lists.mysql.com

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 data

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]

create indexes for temporary table

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]

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', ROUND(avg

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

INNER JOIN across multiple tables appear very slow.

AND i.basename = '$basename_param' WHERE i.prodname is not NULL and i.basename is not NULL GROUP BY c.salescode, i.basename, t.prodcode ORDER BY SalesDiff desc; Thanks Sam -- MySQL General Mailing List For list archives: http

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', ROUND(avg(tt.salesvolume

Error with Storage engine

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]

optimize mysql 5.01

the 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

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

, 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 minutes) give out a result. Any comment? Thanks Sam Shawn Green Database Administrator Unimin

sub query is extermely slow

-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 your query\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

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 query' 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 add

Re: sub query is extermely slow

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: create view not working on mysql 4.1.8

. 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

where prodcode=$prodcode and custcode=$custcode and date=$transdate;}; $sth = $dbh-prepare($update_sql) || die prepare: $update_sql: $DBI::errstr; $sth-execute || die Unable to execute query: $dbh-errstr\n; $sth-finish; Thanks Sam -- MySQL General Mailing List

Re: Insert if Update failed without Select

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 Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

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

=' at line 3 at insert-inventory-mysql.pl line 55, INVS_FH 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]

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 General

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 list archives: http

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 affect the view tables

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]

traverse the recordset more than once

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://lists.mysql.com/[EMAIL PROTECTED]

Re: traverse the recordset more than once

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://lists.mysql.com/mysql To unsubscribe:http

Re: traverse the recordset more than once

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]

User can't login to his DB.

; $username = hubert; $pw = password; $dbh = DBI-connect(DBI:mysql:$database,$username,$pw); die Unable to connect: $DBI::errstr\n unless (defined $dbh); What is wrong with this error and how to fix it? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

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

Comparison SQL always return false

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

Sum on Float type

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

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

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: No. From where I copy this file from? Is it stright copy or something

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

. 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.html -sam -- MySQL General Mailing List

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 privilege

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

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

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

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 keeps returning

Re: MYSQL Database

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.com/[EMAIL PROTECTED] -- Sam Vilain, [EMAIL PROTECTED] Only the ignorant man becomes angry

Re: MySQL GPL License Question

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 cover impotence. -- Mahatma Gandhi -- MySQL General

Re: VARCHAR 255 versus TINYTEXT

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 Vilain

Re: Deciding whether to convert to InnoDB

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 so, would it be enough to justify the extra space required for innodb? -- Sam Vilain, [EMAIL PROTECTED] Please

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 purposes. I'm only

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

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:

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

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 List

using OR in select statement with distinct results

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

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

Re: query challanged newbie

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 -- MySQL General Mailing List

  1   2   >