Re: How to find missing record?

Hi, Both tables should hold the same number of records. However, I've discovered that 'Close' is one less than 'Open' (1693 vs 1694). How can I find out which record is missing from 'Close'? I know it's not the case of an extra entry in 'Open' because 1694 divides evenly by 7, whereas 1693 does

How to find missing record?

I have 2 tables 'Open' and 'Close' with this structure: mysql> describe Open; +---+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+--+---+ | ID| int(10) unsigned

MySQL Replication

Hi There, I have a replication setup on my local network (so any updates can be transported at around ethernet speed). Here's the behaviour I see: * MySQL Master - I do a whole slew of drop table and create tables * MySQL Slave - It doesn't pick them up ... until ... - I restart the slave It does

Re: update random date

On Apr 3, 2005, at 6:45 PM, Jerry Swanson wrote: How to update randomly field date of datetime? I need to update randomly on 300 records Thanks Use RAND(). Se the manual for details . If that's not enough to get you going, you'll n

update random date

How to update randomly field date of datetime? I need to update randomly on 300 records Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Optimizing server variables for unindexed queries

Greetings, I sent this mail to the list a week ago, but haven't seen any replies ... surely someone on this list must have some ideas? Suppose I have a MySQL server which processes lots of queries that cannot use indexes on VARCHAR fields because they involve REGEXP clauses and LIKE '%...%', most

Re: Multiple Select storing

On Apr 3, 2005, at 12:50 PM, Robb Kerr wrote: Please excuse the length and complexity of this post. I am facing a complicated problem and need to find a solution. Also, I have posted this on both PHP and MySQL boards so please overlook the possibly slightly off-topic subject. I have got one tabl

Re: Multiple Select storing

- Original Message - From: "Robb Kerr" <[EMAIL PROTECTED]> To: Sent: Sunday, April 03, 2005 12:50 PM Subject: Multiple Select storing > Please excuse the length and complexity of this post. I am facing a > complicated problem and need to find a solution. Also, I have posted this on > b

Re: I am stupid>>

I had managed to land a job that required me to learn MySQL quickly. I was used to working with access though, so what I did was find a utility for access called MyAccess which enables you to work in access but you are actually affecting a MySQL db - it has a few funny things that could put you off

Re: create database+tables=ThanX!!

thank you all for your help! http://nikilambropoulos.org Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multiple Select storing

Please excuse the length and complexity of this post. I am facing a complicated problem and need to find a solution. Also, I have posted this on both PHP and MySQL boards so please overlook the possibly slightly off-topic subject. I have got one table that contains personal information about us

Re: I am stupid>>

Hey there It's alright - everyone starts someday. Go on to start with the docs on mysql's website. If there's something you don't get, come back here. This is a great list to help newbies. For your qns Log in to mysql; mysql> create database db; mysql> source db.sql; (this considers your db.sql

Re: I am stupid>>

I would suggest to take a look at the documentation http://dev.mysql.com/doc/mysql/en/index.html 1. create a DB : http://dev.mysql.com/doc/mysql/en/index.html 2. using a SQL file to create those table. on the mysql commqnd line : source db.sql; So as a whole, you'll do something like : create d