Mark Sargent <[EMAIL PROTECTED]> wrote on 04/06/2006 10:45:43 PM:
> [EMAIL PROTECTED] wrote:
> > I agree with the basic design: one table for all of your basic objects
> > (shirts, pants, coats, shoes, etc), one table for all of your
attributes
> > (see Barry's response), a sku table equating
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:59:39 PM:
> On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
> >
> >
> > > Dear Friends,
> > > I have linked tables from MySQL through ODBC DSN in Access 2003.
> > > wh
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
> Dear Friends,
> I have linked tables from MySQL through ODBC DSN in Access 2003.
> when I go for updating any record in any linked table then it gives me
> error as follows:
> Reserved Error (-7776); there is no message for this error.
>
Leonardus Setiabudi <[EMAIL PROTECTED]> wrote on 04/07/2006 05:33:50
AM:
> Hi All,
>
> I have a problem with my multi master replication plan.
> I have set my server (linux) to run 4 instance of mysqld, each with a
> different port, socket, tmpdir, log file, relay log file, master info
> and r
news <[EMAIL PROTECTED]> wrote on 04/06/2006 09:39:33 AM:
> IF I have a table like this:
> id int not null,
> field2 int not null,
> ..,
> primary key (id),
> key (field2)
> ) ENGINE=MyISAM;
>
> The primary key is id only or (id, field2)?
> If this is the case which constraint are aplied on f
Barry <[EMAIL PROTECTED]> wrote on 04/06/2006 03:52:53 AM:
> Mark Sargent wrote:
> > Hi All,
> >
> > I have the job of creating a DB for an online clothing company. I have
> > some experience with relational design and sql and php. I'm stumped as
> > they have products that contain numerous a
"NiCK Song" <[EMAIL PROTECTED]> wrote on 04/04/2006 11:05:57 PM:
> Hi, experts
>
> How can I make mysql database users password with expire date?
> Does mysql can do it?
>
> --
> NiCK
>
Sorry!! MySQL does not auto-expire any user accounts. You will need to
script something to do that manuall
"Ed Reed" <[EMAIL PROTECTED]> wrote on 04/04/2006 04:34:29 PM:
> Can someone help me simplify this query please? It's meant to return
> a single string result that looks something like this,
>
> "You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
>
> The relavent columns from th
"Mike Blezien" <[EMAIL PROTECTED]> wrote on 04/04/2006 02:47:50 PM:
> Hello,
>
> is there a MySQL function to determine the total days of any given
> month, IE if
> current month is April, is there a function or query to find the
> total days of
> the month?
>
> TIA,
> Mike(mickalo)Blezien
>
"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone,
>
> Please correct me if my understanding is wrong. Does the implementation
> of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
> Database Tables to Access?"
> (http://dev.mysql.com/doc/refman/4.1
Yasir Assam <[EMAIL PROTECTED]> wrote on 04/03/2006 11:09:01 PM:
> Hello,
>
> I need to be able to sum over distinct values but I can't seem to do it
> unless I use sub-selects (which I want to avoid doing).
>
> To see what I mean, I've constructed a toy DB:
>
> DROP TABLE IF EXISTS spell;
> C
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 04/03/2006 09:07:34 PM:
> This table holds latest data from an app:
>
> mysql> select * from ultimas_respuestas_snmp limit 10;
> +++---
> +-+---++--+
> | id
"H L" <[EMAIL PROTECTED]> wrote on 04/03/2006 01:53:37 PM:
>
> >The solution is to redesign your tables. You need to split into
separate
> >columns the values you want to maintain. You do not want to keep the
"flat
> >file" design you are currently trying to use.
> >
> >CREATE TABLE calendar (
[EMAIL PROTECTED] wrote on 04/02/2006 05:35:59 PM:
> > > Can you post your show create table tbl_name statement for
> > > these tables that involve slow queries?
> >
> > | old_crumb |CREATE TABLE `old_crumb` (
> > `link_ID` bigint(20) default NULL,
> > `dir_Travel` char(1) default NULL,
> >
"H L" <[EMAIL PROTECTED]> wrote on 04/02/2006 11:51:48 AM:
> Hi, i have a problem to select sum from same table using UNION. The
key
> question is there a way of combining two questions in one so the
resulting
> objectid in query1 is only used in query 2 in a smart way. Eg. if only
one
> o
Rich <[EMAIL PROTECTED]> wrote on 03/30/2006 09:11:56 PM:
> Hi there. Any quick way of killing duplicate records?
>
> Cheers
>
Yes. Some ways involve subqueries, others temporary tables. What version
are you on? What are your table definition(s) (use SHOW CREATE TABLE to
dump the defs)? How
We got the question. However what you ask isn't purely a database issue.
How does your authentication program (freeradius?) handle expiration
dates? If it doesn't then adding those to the database won't help a bit.
If it does, then there should already be a date column. (or two) in the
appropr
Sheeri is correct. Rich's statement should have worked. What Rich is
looking for is the syntax for doing what the manual calls "extended
inserts".
quoting TFM (http://dev.mysql.com/doc/refman/5.0/en/insert.html)
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(
Vinny <[EMAIL PROTECTED]> wrote on 03/29/2006 03:52:33 PM:
> Hello All,
> I am running across a very weird problem.
> Sometimes when a person paste text from a Worddoc
> into the text field of our webapp, the insert fails. Unfortunately
> I am not seeing the failure in the logs. There are a lot of
eth1 <[EMAIL PROTECTED]> wrote on 03/28/2006 03:04:13 PM:
>
> Hi All,
>
> I'm migrating to a contact relationship management system (CRM) for
one of
> my clients from a proprietary Access database. The CRM system can
import
> our donor's contact history, but only in a non-normalized format
"Mike Blezien" <[EMAIL PROTECTED]> wrote on 03/27/2006 03:39:15 PM:
> Hello,
>
> I'm alittle unclear on how too update multiple tables. We have two
> tables with
> the same column name:
> account.state
> account_service.state
>
> when we update the account table, we also need to update the
ac
"Mark" <[EMAIL PROTECTED]> wrote on 03/27/2006 09:45:57 AM:
> Hi i am emiling you hoping you can help me urgently,
> I have a football tipping script which works fine now except i want
> to update a field from one table to another.
>
> At the moment there is a table (leaderboard) which is update
"David Godsey" <[EMAIL PROTECTED]> wrote on 03/24/2006 12:55:29 PM:
> This is not a typically thing that anyone would expect Mysql to do,
> however with the application I am writing it would be helpful. Here
goes:
>
> The application stores raw data from a satellite, along with a
> configuratio
[EMAIL PROTECTED] wrote on 03/23/2006 02:20:00 PM:
> On 3/23/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
> > What does line 1189 look like?
> >
>
> Good question. Hard to tell, since it's the insert statement for a
> rather large table (25 million rows) and I have --extended-insert set,
> so it
OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you create
the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that p
You could try suggestion B) ;-)
Shawn
"Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 11:25:24 AM:
> * a) Verify that you have actually GRANTED permission for the
> account you are trying to authenticate with
>
> SELECT user, host from mysql.user where user ='radius';
>
>
>
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 11:10:04 AM:
> On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> >
> > The short answer is "no". The Record #2 already existed. It's current
> > status is "deleted". If yo
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> Hi,
>
> I have a question about autoincremend id:
> If I have an autoincrement id set on my first column field of my
> table and I have the
> following entries:
> 1
> 3
>
> And then I make a INSERT INTO foobar VALUES(''); , the next fie
"Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 10:38:57 AM:
> Good morning. I am trying to install Free Radius with MySql, but I
> either have a login issue or a permissions issue.
>
>
>
> I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
> and just about ev
Eugene Kosov <[EMAIL PROTECTED]> wrote on 03/23/2006 07:03:15 AM:
> Hi, everyone!
>
> I have transfer user's database and grants from one mysql server
> (4.1.15) to an older one (4.0.26). I don't know user's password and have
> only it's hash. How can I convert hashed password stored in
> mys
Luke Vanderfluit <[EMAIL PROTECTED]> wrote on 03/22/2006 08:29:02
PM:
> Hi.
>
> I've got mysql 4.0.18 installed on a sun X4100 running solaris.
> This is just a 32 bit version of mysql.
>
> I've reverted back to this version after trying mysql 5, 4.0.26 and
> 4.0.18 64bit.
> Those versions wer
"David Godsey" <[EMAIL PROTECTED]> wrote on 03/22/2006 01:21:07 PM:
> I'm in the process of writing my first UDF and would appreciate some
help.
>
> I am pulling data from a table like:
>
> SELECT payload_time,
> SUBSTR(BINARY(frame_data),
> FLOOR(foffset/8)+1,
>
"Ing. Edwin Cruz" <[EMAIL PROTECTED]> wrote on 03/22/2006 11:38:53 AM:
> Ok, and sorry for my poor explanation and my "spanglish"
>
> The ofac list is a database with thousands of names of persons who are
> forbidden to do transactions like change of dollars to mexican pesos,
they
> are trying t
Yesmin Patwary <[EMAIL PROTECTED]> wrote on 03/22/2006 09:56:20 AM:
> Dear All,
>
> First of all, I would like to thank Shawn Green, Peter Brawley and
> Josh for their kind help in my previous issue.
>
> I have a table named master_list with two field customer_id and
> list_code. I need to
"cybermalandro cybermalandro" <[EMAIL PROTECTED]> wrote on
03/20/2006 11:00:51 AM:
> I am trying to update a table with a file that has more than one update
> statements like this:
>
>
> UPDATE products set products_price="22.00" WHERE
products_model="5217-01"
> OR products_model="521701" AND
Chris Cowen <[EMAIL PROTECTED]> wrote on 03/20/2006 10:34:48 AM:
> Hi
>
> We have a mySQL database which is being used by a restaurant ordering
> system, in which many of the tables
> are being used to store menu item information, pricing etc.
> The restaurant started off as a single outlet, but
AAAUUUGGGHHH!!! You used the dreaded "comma separated list" !!! ;-)
A more explicit way to write the same thing posted by Sr. Cruz...
update TABLE1 a
INNER JOIN TABLE2 b
on a.id = b.other_id
set a.FIELD1=b.FIELD2
WHERE a.column1='literal';
Actually posting a real query (instead of a cl
"Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
> On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> >
> > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> >
> > > Hi Ariel,
> > >
> > > Maybe this example helps you to create CSV output from MySQL.
> > > The first SELECT gene
"Neil Tompkins" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:42:32
PM:
> Apart from this are there any other known issues. When trialing mySQL
on my
> XP machine, I noticed all the tables were created in lower case ? Is
this
> normal ?
>
> Cheers
> Neil
>
>
> >From: Mark Leith <[EMAIL PROT
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:16:11 PM:
> Hello Bruno,
>
> > well about the date default value being invalid, well it´s working
here in
> > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work
with
> > this...
>
> Yes, it's a valid value in MySQL, bu
Bruno B B Magalháes <[EMAIL PROTECTED]> wrote on 03/14/2006 12:41:35
PM:
> I am designing a simple accountability system so all the partners can
have
> direct access to it by intranet.
>
> I was designing the data model, and came up with this:
>
> CREATE TABLE `moviments` (
> `moviment_id` i
"ElkinFernando Ortiz" <[EMAIL PROTECTED]> wrote on 03/10/2006 12:26:57
AM:
> I will explain my problem in spanish and english.
>
> Se deben Presentar los consumos por 24 horas de energia para su ingreso.
Si
> el usuario ha digitado 10 registros, se deben presentar estos mas los
otros
> 14 corr
"fbsd_user" <[EMAIL PROTECTED]> wrote on 03/13/2006 01:10:17 PM:
> In my mysql 4.4 table definition the default attributes are (ON
> UPDATE CURRENT_TIMESTAMP). Reading the manual my understanding is
> this is saying that the auto timestamp update feature is active. The
> manual does not say what t
Alternatively, you might be able to re-render times and dates in their
"condensed" format by auto-converting them to a numeric value. Try adding
zero to your date columns in your select clauses. Once condensed, your
substring code should begin working as before.
SELECT datecol +0 as datecol
FR
"Jim Douglas" <[EMAIL PROTECTED]> wrote on 03/13/2006 12:24:56 PM:
> I can connect to mysql with
>
> mysql -u dbname -p
>
> When I start MySQL Administrator v 1.1.6 it says
>
> Could not connect to host 'localhost'.
> MySQL Error Nr. 2002
> Can't connect to local MySQL server through socket '/
Yes, a ranged query should respond faster than a negation. In some cases
you can seriously improve query performance for a negation query if you
split it into two range queries unioned together. Here is a pseudo
example:
This query should be slow due to the table scan it takes to test the
cond
"Robert DiFalco" <[EMAIL PROTECTED]> wrote on 03/11/2006 12:43:43 PM:
> In a previous database engine I was using an IN was more optimal than a
> <>. So, for example:
>
> SELECT * FROM table WHERE table.type IN (1,2,3);
>
> Where the possible values of type are 0-3, was appreciably faster th
Cory at SkyVantage <[EMAIL PROTECTED]> wrote on 03/10/2006 04:25:00 PM:
> [EMAIL PROTECTED] wrote:
> > Can you post the results of "SHOW CREATE TABLE pnr_segments", please
>
> pnr_segments | CREATE TABLE `pnr_segments` (
> `ID` bigint(20) NOT NULL auto_increment,
> `ID_pnr` bigint(20) NOT NUL
Cory at SkyVantage <[EMAIL PROTECTED]> wrote on 03/10/2006 03:52:56 PM:
> I need help, I'm somewhat new to indexing, I am joining two tables and
> need to optimize the speed of the query. I'm running the NDB storage
> engine so the foreign key stuff is disabled. With that in mind, here's
> the
"Nanu Kalmanovitz" <[EMAIL PROTECTED]> wrote on 03/10/2006 02:35:08
PM:
> Hi!
>
> Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL
> ver. 4.0.15a, PHP 4.2.3, all of them on same machine.
>
> I just finished create a new DB called TIULIM (InnoDB) with 3 tables
> (Sites, Tracks
Nestor <[EMAIL PROTECTED]> wrote on 03/10/2006 02:33:50 PM:
> I am getting this error and I do not know why?
> Could not connect: Client does not support authentication protocol
> requested by server; consider upgrading MySQL client
>
> I can access mysql from the command line and I can access it
"fbsd_user" <[EMAIL PROTECTED]> wrote on 03/10/2006 02:18:49 PM:
> In my reading of mysql tutorials I see many examples of mysql access
> with out first doing a connect. Comments say something about reusing
> open connections for faster processing and less resources usage
> overhead. What are they
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/10/2006 12:28:21 PM:
> Hello,
>
> I have been given a file to import into the mysql 5.0 database.
>
> This is how it is formatted:
>
> I created a database called "app" which is brand new.
>
> Right off, the bat, I noticed there is a field called
"Sara Woglom" <[EMAIL PROTECTED]> wrote on 03/10/2006 11:54:03 AM:
> I have just installed MySQL 5.0, and I am unable to connect to it from
my
> own (remote) machine. It all works fine when I open mysqladmin from the
> server itself, so I know the installation is OK. I am working on a
small
>
Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM:
> Hm... It seems to me In MySQL there's no such thing as "database owner".
> Or am I missing something?
>
> Mohammed Abdul Azeem пишет:
> > Hi,
> >
> > How to check for the database owner for a particular database ? The
way
>
[EMAIL PROTECTED] wrote on 03/10/2006 04:02:11 AM:
>
> It's not on the mysql site yet Greg.
>
> From [EMAIL PROTECTED] Sat Mar 4 23:00:04 2006
> To: [EMAIL PROTECTED]
> From: Alfredo Kengi Kojima <[EMAIL PROTECTED]>
> Subject: ANNC: MySQL Workbench 1.0.5 beta released
>
>
> MySQL Workbench 1.
"Robert DiFalco" <[EMAIL PROTECTED]> wrote on 03/09/2006 12:32:44 PM:
> I have some questions regarding InnoDB indices.
>
> Say I have a table with millions of records. On of the fields is a type
> field that has a possible value of 1,2,3, or 4. I sometimes query by the
> type field and may at ot
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 03/09/2006 09:59:32 AM:
> Are my emails not coming through? Or is this question way too 'newbie'
> and no one wants to touch it?
>
> -Ryan
>
> Ryan Stille wrote:
> > I'm still hoping someone can else can share their input on this.
> >
> > What do othe
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,sum(exim.count),stats.spam,stat
"J A" <[EMAIL PROTECTED]> wrote on 03/07/2006 12:31:57 PM:
> 1. Support for N-types for the future. UNICODE support for NCHAR,
NCLOB and
> NVARCHAR datatypes
> 2. Support for UCS-2 or UTF-16 for future.
> 3. Support for N-types in Stored Procedures
> 4. Automatic translation of N-type to
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 10:46:58 AM:
> Hello Shawn,
>
> Thanks for replying.
>
> INSERT_METHOD is an option valid for merge tables.
> See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
>
> From what I can see, the only way to get it, is parse the
> SH
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 09:57:17 AM:
> Hi,
>
> Anyone got a clue where to get a hold of "insert_method"
> after creating the table?
>
> Is the SHOW CREATE TABLE output the only way to
> get it?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebi
Dan Rossi <[EMAIL PROTECTED]> wrote on 03/07/2006 05:47:41 AM:
> yet just another multi-national gupling up its competitors, i stumbled
> across this blog
> http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
> innodb.html and had no idea, its just as bad the the latest Eola patent
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 03/06/2006 03:12:20 PM:
> When using select into outfile, I can only get the table data, but I
> can't find how to include the column names. I haven't been able to
> include the column names into the actual return of the query, and
> they don't get
I believe Daniel is correct. The passwords are hashed before leaving the
client. You may be able to capture invalid hashes but they are already
encrypted before they get to the server. I do not know of any event or
callback function you can use to tie into the server to trigger a logging
event.
jonathan <[EMAIL PROTECTED]> wrote on 03/05/2006 03:19:41 PM:
> is there a way to view the current number of connections in mysql?
> I'm developing a PHP / MySQL app and would like to be able to debug a
> few performance problems.
>
> Ideally, I'd like to be able to query the number of current
In fact, no time values in MySQL are fractional (yet). All times are
stored to the nearest second regardless of which date-time-like storage
type you use. They way Rhino phrased his answer, it sounded as though
TIMSTAMP would save fractional seconds. It doesn't. He is spot on about
needing a se
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 03/02/2006 12:42:01 PM:
> I am working with an existing compilcated query someone wrote years ago.
> When I dump the data from the query to try to figure out why I'm getting
> unexpected data, I have three fields named "id". Is there anyway to
> tell mys
2wsxdr5 <[EMAIL PROTECTED]> wrote on 03/02/2006 12:30:17 PM:
> Is there a way with mysqldump to instead of dumping the contents of a
> table dump the contents of a select so if you import that sql back in
> you will get a new table that looks like the select?
>
> --
> Chris W
> KE5GIX
>
> Gif
<[EMAIL PROTECTED]> wrote on 03/02/2006 06:55:14 AM:
> This might be a bit odd, but here we go..
>
> I have some data in a table that has the following structure:
>
> CREATE TABLE `gaugereportinglist` (
>
> `Updated` timestamp NOT NULL default
> CURRENT_TIMESTAMP on update
MySQL cannot handle more than one incoming binlog at a time. The
facilities are just not in the code.
You also run into a nightmare if a database exists on BOTH masters (same
name on both systems) and the PK values of any tables (also with matching
names) overlap. If both masters update the
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:08:10 AM:
> Does MySQL have support for temporary tables inside stored procedures?
>
> _
> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messeng
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:06:27 AM:
> What is the rowsize limitation in MySQL?
>
> _
> Don’t just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:04:50 AM:
> Does MySQL have the ability to send resultsets from stored procedures?
> (similar to ref cursors in Oracle).
>
> _
> FREE pop-up blocking with the new MSN Toolbar – get it
"Robert DiFalco" <[EMAIL PROTECTED]> wrote on 02/27/2006 04:53:06 PM:
> Is there a command to regenerating the selectivity statistics of indices
> with MySQL? Or does MySQL not have a cost based optimizer and this would
> make no difference?
>
> R.
MySQL uses a cost-based optimizer
http://dev.m
Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just
normally not available for reference until you bind your socket library to
at least one socket. Again, it's a cart and horse thing. You see, the
etc/hosts file counts as a "local" DNS server and the DNS protocol
requires a s
Yes, there is a very good, not so technical reason to only allow binding
by IP Address. Have you ever heard of "putting the cart before the horse"
?
If binding by hostname were allowed, that would mean that every time your
MySQL server started up, it would need to somehow resolve that name int
Twinkletoes <[EMAIL PROTECTED]> wrote on 02/24/2006 04:18:18 PM:
>
> I'm using MySQL 4.1 (I think... a late 4 anyway) on a Gentoo box. It's
only
> a semi-live situation and no need for security just yet.
>
> After messing with privileges a bit, I decided to revoke whatever
privileges
> are al
I hate remembering crap like this AFTER I hit send...
Because we want to limit our sum() to only those rows that match the ORDER
conditionals, we have to change our formula to recognized when to count
and when to not count an order_item.
SELECT p.id, p.prod_name, sum(if(o.id is null,0,oi.quanti
If you are looking just for duplicate (ID,vendort_no) combinations, this
will find them:
SELECT ID, vendor_no, count(1) as dupes
FROM table_name_here
GROUP BY ID, vendor_no
HAVING dupes >1;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Richard Reina <[EMAIL PROTECTED]> wr
Sorry - I am trying to cut back to just 2 pots of coffee per day and I the
lack of caffeine can make me a little fuzzy :-) Thank you for being
patient with me.
You have a working query, we just need to convert your INNER JOINs to
LEFT JOINs and move your join-specific WHERE conditions into th
Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM:
> Let's say I have a query that performs
>
> "select * from Account"
>
> one of the columns from "Account" (city) is actually a key which may
> be either numeric or character.
>
> There is a table called "City" which contains keys
Schalk <[EMAIL PROTECTED]> wrote on 02/23/2006 08:55:01 AM:
> George Law wrote:
> > Schalk ,
> >
> > You need to specify the unifying column between your ablb and abm
tables.
> >
> > ie - in your where, "and ablb.id=abm.id"
> >
> > Once you get this so it returns expected results, you can run the
James Harvard <[EMAIL PROTECTED]> wrote on 02/22/2006
08:53:56 PM:
> At 5:08 pm -0800 22/2/06, Scott Haneda wrote:
> >I think we are close, thanks
> >ERROR 1120: Cross dependency found in OUTER JOIN. Examine your ON
> >conditions
>
> > > SELECT p.id, p.prod_name, sum(oi.quantity) as qty
> >> FR
Scott Haneda <[EMAIL PROTECTED]> wrote on 02/22/2006 03:58:10 PM:
> > Is this what you mean?
> >
> > SELECT
> > p.prod_name,
> > count(oi.product_id) AS mycount
> > FROM ORDERS AS o
> > INNER JOIN products ON o.id=p.id
> > LEFT JOIN order_items AS oi ON (p.id = oi.product_id)
> > WHERE o.stat
"AM COMS" <[EMAIL PROTECTED]> wrote on 02/22/2006 09:16:24 AM:
> Has anyone here had any experience with Oscommerce?
>
> I am having problems with the style of queries they have used or am I
just
> seeing things the wrong way!
>
> andrew
>
Sorry! I have never used it.
Shawn Green
Database Ad
Scott Haneda <[EMAIL PROTECTED]> wrote on 02/22/2006 01:47:38 AM:
> Got myself a little stumped here, 4.0.18-standard
>
> Three tables in this mess, orders, order_items and products.
>
> orders.prod_id = order_items.prod_id = products.prod_id is how I relate
them
> all to each other.
>
> orde
[EMAIL PROTECTED] wrote on 02/21/2006 11:20:36 AM:
> Is there such a thing in mySQL ?
> I could not find anything anywhere.
>
> thanks,
> laszlo
Short answer: No
Long answer: MySQL has VIEWS but they are non-parameterized and
non-persistent. MySQL also has FUNCTIONS and STORED PROCEDURES, bo
A little less dodgy is to write a VBA routine within Access to do the
filtering. Alternatively, if you don't want to trust access to do it, you
can write a VBScript or JScript routine and run it through the shell (yes,
Windoze has shell scripts, too)
There are all kinds of things you can do.
S
"Guillaume Boissiere" <[EMAIL PROTECTED]> wrote on 02/21/2006 02:23:29
PM:
> This must have been asked before but I could not find the answer
searching
> the list archives.
> I have a simple table:
> CREATE TABLE `license` (
> `id` int(11) NOT NULL auto_increment,
> `firstname` varchar(100)
Patrick Duda <[EMAIL PROTECTED]> wrote on 02/21/2006 02:39:47 PM:
> Why, when I create a table as follows:
>
> mysql> create table requestid ( request_id int not null default
> 1, constraint requestid_innodb_pk_cons primary key(request_id) )
> ENGINE=InnoDB;
> Query OK, 0 rows affected
Ok, I get that. I have several tables just like that (I use mine as shadow
tables for change audits. Every change to the "normal" table ends up
creating new record in the "shadow" table thus documenting each state of
the normal table through time). However, shouldn't schema changes be very
rare
One problem with dual-master or multi-master replication is that you have
to be able to set and check a lock across all masters before performing a
schema change. How would you deal with this scenario using your "ALTER
TABLE" database dumps without such a lock?
Server A and B share a table X th
Once CHECK CONSTRAINTS are enabled, I am sure there will be a way to turn
them off temporarily. Right now, you can create tables that have them but
they are not enforced. To quote
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
InnoDB tables support checking of foreign key cons
Michael,
I have been following this thread from the beginning and I just don't see
the practical difference between what you propose and the replication
methods (SBR and RBR) already in place. How does what you propose differ
from the SBR (statement -based replication) that MySQL already suppor
Easier than that (though Sheeri's way would work):
ALTER TABLE yourtablename DISABLE KEYS;
SET FOREIGN_KEY_CHECKS=0;
... do your processing ...
SET FOREIGN_KEY_CHECKS=1;
ALTER TABLE yourtablename ENABLE KEYS;
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
http://dev.mysql.com/doc/refman/
"Jan Pieter Kunst" <[EMAIL PROTECTED]> wrote on 02/21/2006 04:54:46 AM:
> On 2/20/06, Eric Persson <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have a query which works fine for me in my 4.1 environment, but when
> > moved to the 5.0.18 environment, it fails with the result below:
> >
> > mysql> S
My suggestion: Modify the source of mysqldump yourself.
After all, it is open source. Make sure you adhere to any and all
licensing requirements and copyright notices and you will keep yourself
out of any legal trouble.
For the vast majority of users, replication is a better solution than wha
persant mpote <[EMAIL PROTECTED]> wrote on 02/16/2006 10:29:37 AM:
> hi,
> since 3 days, i'm trying to connect to MYSQL 5.0.18 from php
> scripts using Apache et Macromedia 2004 Dreamweaver.
> Could someone help me doing this?
> Best regard.
>
>
> -
> Nouv
gerald_clark <[EMAIL PROTECTED]> wrote on 02/14/2006
03:59:21 PM:
> [EMAIL PROTECTED] wrote:
>
> >"David Godsey" <[EMAIL PROTECTED]> wrote on 02/14/2006 03:28:41
PM:
> >
> >
> >
> >>Well, just thought I'd try one more time because I didn't get an
answer
> >>
> >>
> >to
> >
> >
> >>my quest
1 - 100 of 1593 matches
Mail list logo