Re: From SQL Server: Jobs
On Tuesday 30 March 2004 10:53 am, Matt Chatterley wrote: Hi all, hello. snip In-between lamenting the lack of views, one of the things I most miss from SQL Server, and which I need, is the Job System. For those unfamiliar with the concept from SQL Server, it is a way to set up one-shot or scheduled tasks to run within the database - these execute SQL statements when run, and can be started manually, from a procedure call, or from a schedule. /snip maybe I am missing something, but why not just use cron? you can even write 'command line' php scripts and have cron execute them at your convienience. Then, you can 1. run the scripts manually (from the command line), 2. have cron run them from a schedule or 3. exec them from a function. seems like what you want IMO. gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: just the list please!
On Tuesday 16 March 2004 02:19 pm, Tim Cutts wrote: This is something the list admins might be able to sort out. It's common for mailing lists to set a reply-to header... snip here we go again -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do test unique values in a MySql column?
On Monday 24 November 2003 03:25 pm, zzapper wrote: Hi Y'All I need to test if any values in a column are the same (or are unique) eg (my made up syntax Unique) SELECT * from tbl_addresses WHERE txtName is UNIQUE; SELECT DISTINCT txtName from tbl_addresses; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replace query + RTFM?
On Monday 17 November 2003 01:18 pm, Andrew wrote: Can someone kindly tell me what I doing wrong and help with this query? I want to replace / update the text for every record within table items field ItemDescription. This is what I have so far and its isn't corroect :( UPDATE items SET ItemDescription='A-Z Business Directory br /br / Please call 0870 199 4080 for further details br /br / Replace these details simply by calling 0870 199 4080 br /br / Unlike YELL we only list a maximum of 5 businesses per Business Category br /br / The chances of your business being called has been increased already. Be Seen by calling 0870 199 4080' WHERE ItemDescription= 'A-Z Business Directory br /br / Please call 0116 27 960 41 for further details br /br / Replace these details simply by calling 0116 27 960 41 br /br / Unlike YELL we only list a maximum of 5 businesses per Business Category br /br / The chances of your business being called has been increased already. Be Seen by calling 0116 27 960 41' should do it. gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing 3.23.57 version without root privileges
On Tuesday 04 November 2003 10:49 am, Fernando wrote: Hello, I need to install 3.23.57 version (i've downloaded the source code from the mysql page) in a system where i'm not the root. How can i install it in my account without getting errors while doing the make install? I get this message saying i can't write in the default folder because i do not have the privileges. Thanks in advance! you could try setting --prefix=/home/yourusername/test (or some other dir you have write access to) when you ./configure your mysql source do a ./configure --help for other possible changes you might need to make. no guarantees, but it's a start, gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Grant to Partially Specified Host
On Wednesday 17 September 2003 09:16 am, Randy Chrismon wrote: form is too restrictive for me. Will this work? grant ... to randy@'%.host.name' yup... sure will, this is exactly what we do, works like a charm. gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Terminology question
On Mon, 2003-07-21 at 16:38, Michel Albert wrote: I've read it now a few times around here and was curious what innodb means. Is it a table-type for MySQL or a completely different DBMS? It's a table type, see here: http://www.mysql.com/doc/en/InnoDB_overview.html for info gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT TOP
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote: Be careful! Phil wanted the top 20 and the limit 20 will only return a random 20 records. Actually, LIMIT x will return the first x rows of a query, not random records. In fact, you can even combine ORDER BY and LIMIT if you want to get the first x rows of some order. http://www.mysql.com/doc/en/SELECT.html http://www.mysql.com/doc/en/LIMIT_optimisation.html gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone had a chance to try an Opteron yet?
not exactly relevant to this discussion but... Apple did just release the new G5, 64bit PowerMacs. Could be another alternative for the inexpensive 64bit market. Granted, they don't ship until august, but they are nice to look at: http://www.apple.com/powermac/ from their site: The Power Mac G5 is the worlds fastest personal computer and the first with a 64-bit processor which means it breaks the 4 gigabyte barrier and can use up to 8 gigabytes of main memory. The new G5 processor available at speeds up to dual 2GHz with a new ultrahigh-bandwidth system architecture featuring AGP 8X and PCI-X makes the Power Mac G5 a breakthrough in desktop processing power. And models start at just $1999. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is it possible to refresh data in a mySQL data via a script?
On Fri, 2003-06-20 at 12:16, Barbara Andrew wrote: snip I have three books on mySQL, they all talk about how to construct SQL statements and I'm fine with that. What I can't figure out is how to get those statements to the right place without having to do it manually. This would be the domain of some other tool, such as a shell script, or a commandline php/python/perl etc script that could be run nightly using a scheduling tool ie cron, at etc. You could also have mysql do the import: use databasename; drop table if exists myTable; create table myTable ( Field1 varchar(50) not null, field2 varchar(25) not null, PRIMARY KEY (Field1), KEY names(field2) ) TYPE=MyISAM; load data infile '/tmp/dataFile' into table myTable FIELDS TERMINATED BY '|'; put the above (or some variation) in a file (filename.mysql), and then have mysql execute those statements nightly: by putting the following into either a one line bash script, or having cron run it directly: mysql filename.mysql Of course, you will probably want to run some checks to make sure the data is in the file before you start Dropping tables etc. Check these out for reference: http://www.mysql.com/doc/en/mysqlimport.html http://www.mysql.com/doc/en/LOAD_DATA.html hth, gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RAID hardware suggestions/experience
On Tue, 2003-06-17 at 09:58, David Griffiths wrote: Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000 IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good about 3Ware. If I had to choose between the two, I would go with the 3wares. They work very well under linux. I've used their 6xxx series 4 port controllers and their 7xxx series 8 port controllers. Pretty happy with both for inexpensive IDE RAID on linux. Make sure you install the linux drivers and software so you can access the 3ware functionality like rebuilding your arrays without having to enter the cards BIOS at boot. They're no SCSI RAID controllers, but they get the job done. The promise controllers are crap (IMO) but they have come a long way in the last couple of years... they are cheap though. gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Default Datetime?
On Mon, 2003-06-09 at 16:23, Trevor Sather wrote: How can I get the default value to be now()? The only way I've succeeded is by setting the type of field to VARCHAR, but that's not ideal. Trevor, take a look at the TIMESTAMP type: http://www.mysql.com/doc/en/DATETIME.html or, if you would rather not use that, then make sure you are formatting your now() in such a way that MySQL will use it. MySQL expects DATETIME fields to be : -MM-DD HH:MM:SS and if they are not, you will get the 00 you have been seeing. Basically, you have to format the date within your asp before you send it to mysql. hth, gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
