Re: Blob implementation question

id=123; > This probably will (if foo is not indexed): > SELECT myblob FROM mytable ORDER BY foo; > > > -Original Message- > > From: Adam Ilardi [mailto:mastaskill...@gmail.com] > > Sent: Wednesday, March 13, 2013 9:16 AM > > To: mysql > > Subject: Blob

mysql/sql server migration

I'm involved with a project that is migrating data from sql server to mysql. The project will take up to a year to complete. During that period of time, we will need to synchronize data from sql server to mysql as we migrate windows based functionality to linux based servers. What is the rec

mysqldiff resurrected and 0.43 released

ittle project. github forks are of course welcome too ;-) Cheers, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Variables in stored procedure

aph', '31', 'yes'), ('310', '0', 'statpress_donotcollectspider', 'checked', 'yes'), ('311', '0', 'statpress_autodelete_spider', '1 day', 'yes'), ('312', '0'

Variables in stored procedure

n; while v_counter <= v_max do SET TABLENAME = CONCAT('wp_',v_counter, '_options'); INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap', 'edit_posts', 'yes'); set v_counter=v_counter+1; end while; commit

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

eft the old ones there). Thanks again. -- Adam PAPAI Grapes Communication Kft. http://www.grapes.hu E-mail: papai.a...@grapes.hu Phone: +36 30 33-55-735 (Hungary) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

73 Sep 4 18:38 master.info but the date is: [root@tungsten /var/db/mysql]# date Sun Sep 4 19:11:13 CEST 2011 And it's delayed 1 hour. No data is transferred to the slave. It says: Secords behind master 0. What the hell is going on here? -- Adam PAPAI Grapes Communication

Messed up mysql-server, cant reinstall?!

I accidentally drop the database mysql. I now cannot restore tables to the database or do much of anything some details can be found here http://serverfault.com/questions/234321/i-accidently-dropped-the-mysql-db/234340#234340 after a few unsuccessful uninstalled/reinstalls i wrote whereis mysql an

Share To My Love x--)

Dear: I would like to share with you my recently shopping experience: I found a very excellent e-site, the above is the latest and most popular products. By their staff, understanding that they have stable supply channel, so the price of products is shock your eyeballs burst. Certainly I will not m

Split string by regex

RA | 65 | +++ | RP |2 | +++ etc Could this be done in MySQL? I want to do something along the lines of set class2 = SUBSTRING_INDEX(class,'[A-Z]',-1) but I understand this is not possible. Any ideas? Regards Adam -- MySQL General Mailin

Re: opening a server to generalized queries but not "too" far

in the PHP script itself (which would be rather weak security imho). -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:48, Don Cohen wrote: > Adam Alkins writes: > > Sounds like you just want to GRANT access to specific tables (and with > > limited commands), which is ex

Re: list rows with no recent updates

. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 16:02, MadTh wrote: > Hi, > > > I ran a update command on around 2700 rows inside a mysql database table > which has around 3000 table rows to change the ( say) price of each item ( > with unique ID. unique product code). &

Re: opening a server to generalized queries but not "too" far

only SELECT privileges to a specific table for a specific user. -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:17, Don Cohen wrote: > > This seems like a topic that must have been studied, but I'm having > trouble figuring out what to search for in Google, since the

Re: help with group by

works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, probl

help with group by

I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql> select distinct accepted_by

Re: restoring mysql db doesn't restore user passwords

you're a genius! I had old_passwords=1 in my.cnf, changed it to 0, restarted mysql, and then the users worked like a charm. thanks! Little, Timothy wrote: My theory would be that it's an OLD-PASSWORDS issue. It would seem that you might have used the old_passwords=1 in your original configur

restoring mysql db doesn't restore user passwords

rior to the reinstall: mysql -u adam -px ERROR 1045 (28000): Access denied for user 'adam'@'localhost' (using password: YES) but in the mysql.user table, adam exists and has his password set from the dump file: mysql> select User,Password

Solaris 10 bug with mysql_install_db

>Description: running mysql_install_db does not correctly fill grant tables >How-To-Repeat: run mysql_install_db; attempt to connect, fail. >Fix: Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL** >Submitter-Id: [EMAIL PROTECTED] >Originator:Adam Thompso

Re: Floor Decimal Math

11.11),2)>=0.11; +---+ | ROUND(11.11-FLOOR(11.11),2)>=0.11 | +---+ | 1 | +---+ Thanks for all your help, Adam Jerry Schwartz wrote: Don't feel bad,

Floor Decimal Math

1-FLOOR(11.11))>=0.11 | ++ | 0 | ++ Any help would be appreciated, Many thanks, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: % wildcard host permission not working

Yes, I did "FLUSH PRIVILEGES" and I think I only have one username/host entry for this user. Adam Erik Giberti wrote: Did you "FLUSH PRIVILEGES"? I'd also check that the username and passwords are the same for each host entry, I've had problems if passwor

% wildcard host permission not working

I set up a user and entered % for the host. I am not able to connect. However, if I change the host value to my FQDN it works fine. Shouldn't the wildcard allow me to connect from any host? Thanks, Adam -- Adam Gerson Assistant Director of Technology Apple Certified System Administ

Re: how to "drop index if exists"

. ALTER IGNORE TABLE table_name DROP INDEX index_name; ALTER IGNORE TABLE table_name ADD INDEX UNIQUE index_name(column_1,column_2); Thanks - Ada Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote: Folks How can one conditionally drop an index in

Re: how to "drop index if exists"

Fantastic, thanks very much! Adam Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote: Folks How can one conditionally drop an index in MySQL? Googling shows that the "drop index" does not support an "if exists" qualifier -

how to "drop index if exists"

Folks How can one conditionally drop an index in MySQL? Googling shows that the "drop index" does not support an "if exists" qualifier - apparently a bug has been raised but as far as I know its not fixed yet. Does anyone know of a work-around? TIA - Adam -- MySQL

Re: Need help with a "natural sort order" for version numbers and release code names

2.7.0 | +---+-+ 20 rows in set (0.00 sec) Adam. On Oct 12, 2007, at 3:56 PM, Adam Randall wrote: Here's my full test solution: use test; drop table if exists releases; create temporary table releases ( releaseid int(10) unsigned not null auto_increment primary key, name varchar(25

Re: Need help with a "natural sort order" for version numbers and release code names

d locate( '.', name ) > 0, replace( replace( substr( name, locate( ' ', name ) + 1 ), '(', '' ), ')', '' ), if( locate( '.', name ) = 0, name,

test - please ignore

RE: Character sets

As habit I only use UTF in anything I do... and it has paid off many times over. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: List of ports which should be opened for IPTABLES

When it comes to clustering.. doesn't matter if it is MySQL, MS SQL Server, MS Exchange or a big bad Beowulf Cluster you need an independent switch for the cluster. Here is why, There is so much traffic to and from the nodes, and on the network that it will slow down your network, and the cluster.

RE: SQL Translation

ggestions, notice how I had to keep the qp.location_id in the on portion to keep them equivalent. Regards, Adam Adam Trimeloni Project Leader Quality Systems [EMAIL PROTECTED] (949) 255-2600 -Original Message- From: Trimeloni, Adam Sent: Thursday, February 15, 2007 2:32 PM To: '

RE: SQL Translation

I should have mentioned it is a short hand for a join. *= is a left outer join. =* is a right outer join. Adam Trimeloni Project Leader Quality Systems [EMAIL PROTECTED] (949) 255-2600 -Original Message- From: Gary W. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, February 15

SQL Translation

ll returns a row but populates all the group_payers columns are NULL. After our translation attempts returns no rows. (I am running the test cases in SQL Server 2000 first, to show our changes will still work with the current setup) Thanks, Adam

RE: SQL Query Question

Ah, that would work. Looks like I was making the problem too complex in my mind, thanks for your help. Adam Bishop -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: 22 January 2007 07:07 To: Adam Bishop Cc: mysql@lists.mysql.com Subject: Re: SQL Query Question In the

SQL Query Question

to optimise a script from 3 queries to 1, so the gains by using nested queries would be negligible. I'm guessing that this isn't possible, but I thought asking some people that know more than myself couldn't hurt. Any assistance is appreciated. Thanks, Adam Bishop

Re: Retaining last primary key value

Thanks for the reply but that didn't do it. I believe I've got this to work by performing the following steps: DELETE FROM table_name (1000 rows) INSERT INTO table_name(column) VALUES(value) DELETE FROM table_name Now when I perform another INSERT, the primary key starts at 1001. A

Retaining last primary key value

Hello, When I run a DELETE FROM table_name, my primary key field is reset back to 1. Is there any way for it to not do this? Preferably, if there were 1000 records in table_name, and I ran DELETE FROM table_name, that the primary key field would start at 1001. This is an InnoDB table if

java mysql alias is being displayed blank?

k you, Adam JSP: User ID First Name Last Name User Name Phone Number phone_name login Status Number of Con

Re: Drop Index if Exists

Thanks What I am getting at is: does the "IF EXISTS" qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks

Drop Index if Exists

Folks, Does this work in MYSQL 5? I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your syntax". Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql/syslog - 100,000s of log messages on restart

d as it is coming up. My my.cnf is attached -- it's fairly standard. Thanks for any tips. -- Adam Rosi-Kessel http://adam.rosi-kessel.org # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "/var/lib/

RE: MySQL commercial licence

Checking. I don't think the customer bought the "network" version. Apparently its MySQL Pro Licence V4. It's a bit rich not to offer upgrades at a discount IMO. Adam -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: 12 May 2006 11:52 T

MySQL commercial licence

have experience of this? Upgrading commercial licences? What's the story? Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: searching for words with special chars

On 2006-04-01, at 13:17, Octavian Rasnita wrote: Hi, Is it possible to create a query that searches for records which contains words with special chars and with their english correspondents? For example, if a user searches for "mata", I want to return all the records that contain the wo

Re: Sum of counts

You could you use UNION to make this all execute in a single query. On 5/10/06, Rhino <[EMAIL PROTECTED]> wrote: Hi Chris, Joerg, and everyone else following this discussion, Joerg, you are correct; the best way to sum the tables is individually and then add the sums together with program logic

Re: slow query

column: > http://dev.mysql.com/doc/refman/5.0/en/alter-table.html > Also note that as you add or delete rows the table does not stay in order. > > Hope this helps! > > Dan > > > Adam Wolff wrote: > > I have a very simple table that looks like this: > > CREATE

slow query

| SIMPLE | contacts | ref | user_id,user_id_2 | user_id_2 | 4 | const | 506222 | Using where | ++-+--+--+---+---+-+---++-+ In other words, it *is* using an index for this query. Anyone have any advi

Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a g

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

Well, I hadn't known about the spatial features of MySQL. If you're ok using vendor extensions then that definitely looks like the way to go: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html A On Apr 24, Nick Hill wrote: > Hello Adam > > Adam Wolff wrote: > &

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

Actually I think this should be an INNER JOIN -- not a LEFT JOIN. A On Apr 23, Adam Wolff wrote: > I didn't look through your code very carefully. Have you confirmed (using > EXPLAIN) that your select query is using the index? > > I don't much about the mysql optimizer,

Re: Optimising for many rows and returned records (de-coupling query time to record set size for range queries)

I didn't look through your code very carefully. Have you confirmed (using EXPLAIN) that your select query is using the index? I don't much about the mysql optimizer, but it's possible that this query: > $query1="SELECT lat,lon from integer_test WHERE lat>$lat1 and lat<$lat2 > and lon>$lon1 and l

Re: Why does this query takes a lot of time

On Apr 22, Philippe Poelvoorde wrote: > alter table s add index(login_name); > alter table c add index(recordID); To make this much faster, I think you may want: alter table s add index(recordID, login_name); alter table c add index(recordID); Because after the join, the engine can use the

Re: newbie optimization question

Hey! I figured out this one myself: On Apr 19, Adam Wolff wrote: > * Question 2: > Why does introducing an extra WHERE clause make things slower? > If I do this: > SELECT * FROM contacts WHERE fullname LIKE "j%" AND user_id=1 > ORDER BY fullname LIMIT 10; >

finding a record within a sort order

CT contacts.*, (SELECT COUNT(*) FROM contacts AS c2 ... but that's conceptually what I'm looking for. Thanks! Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: newbie optimization question

lly have 3! combinations of filters and sort orders. Adam On Apr 20, Alexey Polyakov wrote: > On 4/20/06, Adam Wolff <[EMAIL PROTECTED]> wrote: > > > How can I optimize the case where I filter on one key but sort on another? > > This is fast: > >SELECT * FROM co

newbie optimization question

About 95% of the records of in the table have user_id=1 Any insight will be greatly appreciated. Thanks, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: differences between varchar and text fields

On 2006-01-20, at 01:13, Tucker Cunningham wrote: So, my question is: what are the pros and cons of using varchar vs. text/longtext? Right now, longtext seems to be the best option (it provides most flexibility in data that can be stored, at only a 2-byte-per-row storage premium) There

Problems with importing the british pound (£) an d euro (€) sign

vely. I have tried forcing the encoding by using "mysql --default-character-set=latin1 -u -p < datadump.sql" but this produces the same results. Any ideas? TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with UTF and MySQL

On 2006-03-20, at 16:12, Gabriel PREDA wrote: One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!

Re: Easy regex replace?

On 2006-03-20, at 12:11, Pooly wrote: 2006/3/19, Adam i Agnieszka Gąsiorowski FNORD <[EMAIL PROTECTED]>: On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp

Re: Easy regex replace?

On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g. replace all '%20' with ' ' leaving the rest untouched?) You know that proverb - "For a man in possession o

Re: setting the data directory.

Hi, There's a mysqld startup option --datadir=/path/to/data which you can use to alter your data directory. Simply adjust your startup scripts to suite. Regards, -Adam On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote: > Hi All, > > I am trying to find out how to change

Mysqldump INSERT statements (Was Mysqldump line endings)

ne on a separate line? E.g. : INSERT INTO t1 VALUES (1,2,3), (1,4,5), (1,6,7); TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqldump line endings

persuade mysqldump to produce one file (with "insert into" statements) and also use Windows style line endings? TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

backwards compatibility when exporting M

rt '
' to 1, '\0' to 0. Does anyone know a way around this? TIA - Adam Lipscombe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Administrator on 10.3 Server -HELP

Did you drag it from a network drive, or copy in some other way? If so, that may be the problem. I haven't used the MySQL Administrator, but am pretty well versed in application troubleshooting. Send me an email privately if you need some direct help. Adam. -- Adam Randall &l

Locks acquired with get_lock() persisting, even after MySQL thread has exited

Description: We have distributed applications which make extensive use of the get_lock() function to acquire a system-wide lock. Occasionally, all copies of a given application block attempting to acquire a lock on the same lock string. Using is_used_lock() reports

Re: Sarge problems with MySQL and DBI / DBD::mysql

n the sql statement with error > $DBI::errstr"); > >How can I debug or fix this problem, please? > > Instead of doing this, you might want to try setting RaiseError (see man DBI) which would cause DBI to detect errors and throw exceptions. Alternatively, you migh

RE: How to set trabnsaction isoloation in my.ini file

#x27;cos the mySQL installer created the file in the installation dir. Many thanks - Adam -Original Message- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 17:23 To: Adam Lipscombe Cc: mysql@lists.mysql.com Subject: Re: How to set trabnsaction isoloation in my.ini

How to set trabnsaction isoloation in my.ini file

REPEATABLE-READ. I can set it manually from the mysql command line and that works. The tx_isolation is then reported as READ-COMMITTED. Its almost as if the server is not reading the my.ini file. How can I set the tx isolation level on startup? Does anyone have any ideas? Thanks -Adam

Re: utf8, 4.1, and character length truncation in mysql system tables

le. This was done through the stock mysql client, which defaults to latin1 even if you set the server character set to utf8 (which makes sense, as most terminals don't support utf8). Is there something else I should be doing to create new users post 4.1? Is this behavior something I should be wor

utf8, 4.1, and character length truncation in mysql system tables

ea, but seems like what's recommended for other tables in the manual. Also, on a related note, these are really big tables, and running alter table on them to modify the column lengths is taking a LOOONG time. Any hints on speeding this up? -- - Adam ** I

Re: problems with 4.1.11 on Solaris

On Apr 8, 2005, at 12:21 PM, Adam Arrowood wrote: I just installed the 32-bit SPARC Solaris package (mysql-standard-4.1.11-sun-solaris2.9-sparc.pkg.gz) in made a symbolic link to the install directory as /usr/local/mysql . I am having the following problems: 1) when I start mysql with the

problems with 4.1.11 on Solaris

package and make these changes manually) ... thanks, adam a -- Adam Arrowood :: http://www.gatech.edu/adam :: adam AT oit.gatech.edu Office of Information Technology/O&E/CS :: (404) 894-0372 Georgia Institute of Technology, Atlanta, GA USA -- MySQL General Mailing List For list archives:

Hex data in VARBINARY fields -- Is it me, or MySQL?

- I'd appreciate any Ideas anyone has any ideas/suggestions... I'd hate to unnecessarily submit a bug report, if it's something on my end. THANKS!!! --Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

dataKiosk 0.6 released

new features. Flash demos of dataKiosk in action can be found here: http://web.mit.edu/~treat/Public/datakiosk.html and here: http://web.mit.edu/~treat/Public/datakiosk-editor.html Cheers, Adam Treat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Encodings

le strings. (This PHP script is called by a desktop app, so I can guarantee the encoding is UTF.) What should I do when retrieving the data from the database and outputting it to a PHP page? For example, how do I convert é to é (or whatever is appropriate)? Adam Ernst -- MySQL General Mailin

Help: Index performance on moderately sized table

seconds (depending on what I'm up to). It seems like the where and the order don't play nice, and I can't seem to figure out how to get an index that applies to all the criteria. I've tried multicolumn indexes, forcing indexes, setting the max_seeks_for_key to 100, etc.

Error in Complex SELECT

s.results_id = 'MyID') And even: SELECT * FROM matches WHERE question_id IN (SELECT q.server_id FROM questions as q WHERE q.results_id = 'MyID') But no go--in all cases, I get an syntax error near the first parentheses. Any suggestions? This is on MySQL 4.0.22-standard. Tha

Re: Excel 2 mysql

Ziggy, I'm not sure what you need help with. If you want to get data into MySQL from Excel, consider saving the data (I assume it is a table) as a CSV then using the LOAD DATA command to bring the data into a temporary table in MySQL. Take a look at the command in the help pages. Regards,

Re: Trying to dump from GUI client

mma delimited file. Good luck! Regards, Adam Eve Atley> > > I'm not sure how best to proceed in dumping data from 1 database and getting > a copy of the export, in order to transfer it to another server. I usually > use phpmyadmin to do an export, which nicely creates a .zip f

Re: Database/Table Structure

tudio/index.html) There are many other some are probably free. Look around! I hope you find something you like. Cheers, Adam Ferguson, Michael> > G'Day All, > > Can anyone recommend an application that will read/probe a MySQL > database on a Linux server and gener

Re: Problem connecting to MySQL 4.1.7 running on another machine

---+ Hope this helps some. Cheers, Adam Kevin Barry> > I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot > connect remotely from a Mac OSX machine running Navicat or a Win XP machine > running MySQL Admin. I can ping the machine with no problem and have op

Re: syntax question..

nt to achieve? (2) What are the details of the tables in the join (column names & data types)? Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to turn on auditing for mysql

Is there any way to log all the activity in a mysql database? I would like to know every single delete insert or select on all tables for my database. Regards, Alex

RE: frecvent table corruption

-Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 12:40 PM To: [EMAIL PROTECTED] Subject: Re: frecvent table corruption "adam" <[EMAIL PROTECTED]> wrote: > The actual error message we get is: > > " SELECT

frecvent table corruption

Hello. My company is using mysql as a backed to Bugzilla. However, recently, as the number of users that are logging bugs increased we are experiencing frequent table corruption and loss of data. The actual error message we get is: " SELECT query FROM namedqueries WHERE userid = 4 AND n

mysqldump under cron

Hello. I am using mysql 4.0.18 on rh3, and I would like to daily save db state. I have this small script under the cron directory that when executed from the prompt works fine. Basically the dump is done by: mysqldump --user=root --password= --opt bugs > $BACKUPDIR$BACKUPSQLFILE My

how to uninstall mysql

Hello. I have installed MySql on RH Linux, however since I have installed in the wrong location I would like to uninstall. Basically I have installed the binary version from the "mysql-standard-4.0.18-pc-linux-i686.tar.gz" and I have followed the instructions in the INSTALL-BINARY, in partic

Re: Create table results in (errno: 121)

, I'd reference the message, and if that doesn't help bring the message to the group. Regards, Adam On Apr 22, 2004, at 9:29 AM, Tom Brown wrote: Hi, I'm trying to create a table with the following syntax CREATE TABLE TNSession ( SessionID int(11) NOT NULL auto_increment, IPAdd

Re: Mysql for Family History (genealogy)

Don't know if it's specifically MySQL or not. The current release of GRAMPS stores its information in an XML file. Adam Stein -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED]

Re: Datetime Default Value - I want to know too!

This is a great question! I also work on SQL Server (2k) databases as well as Access and MySQL. I run into the same problem. So far, I've just changed the SQL in my applications, but I also would like to know if a default can be set. Regards, Adam On Apr 18, 2004, at 12:01 AM, Stormblade

Fwd: Trying to run multiple statements through MySQL monitor

All, I've got data listing people's identification details including first and last name, social, and status in the application. Given this data, I want to know how many duplicate socials I have. Normally I'd write a query with a sub select to get that information - something like this: SELECT

MySQL Cluster

ms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Thanks, Adam Erickson -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Why can't I use an "AS" value in the WHERE clause.

MIchael, Point well taken. Cheers, Adam On Apr 8, 2004, at 2:47 PM, Michael Stassen wrote: Good point. I was focused on the question of using the alias to restrict results, so I left the function in the SELECT part. As you say, in this query, that would just give a useless column of '1&

Re: Why can't I use an "AS" value in the WHERE clause.

t move the expression in the `IF` to the HAVING clause? So take my old statement and ditch the where clause. You'll get: SELECT * FROM wifi_table HAVING unix_timestamp()-unix_timestamp(last_seen) < 600; A little easier on the eyes no? Cheers, Adam On Apr 6, 2004, at 9:42 PM, Michael St

Re: Why can't I use an "AS" value in the WHERE clause.

Daevid, SELECT * FROM wifi_table WHERE active = 1 HAVING unix_timestamp()-unix_timestamp(last_seen) < 600; Regards, Adam On Apr 5, 2004, at 8:29 PM, Daevid Vincent wrote: I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(l

Re: Using Access as client all fields are marked "#Deleted"

avior when executing DDL queries to MySQL. Regards, Adam On Apr 1, 2004, at 4:14 AM, Patrick Kirk wrote: Hi all, My setup is windoes 2000, Access 2000 and Mysql built from source on Debian. Some tables can be seen but all new entries are marked "#Deleted". If I close the table in Access

Re: My backup scripts and how reliable are they?

On 02/26/2004 09:02 AM Scott Haneda wrote: As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local

  1   2   3   4   5   >