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 relay
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.
What
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.
when I go for updating any
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 objects
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 attributes,
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 field2?
--
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 manually on a
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 (
objectid,
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 |
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;
CREATE
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?
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
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 the two
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
object
[EMAIL PROTECTED] wrote on 04/02/2006 05:35:59 PM:
snip
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,
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 do
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
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
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 with up
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 updated weekly
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
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
configuration of how
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 were all
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
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 everywhere I
[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 field
[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 you had other
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';
mysql
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
[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's all on
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 insert
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 to avoid
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,
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 is now
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
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
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
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` int(20)
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, but it's an
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 PROTECTED]
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 generates the headerline; the
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 than:
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
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
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
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 the
[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.0.5 beta
Косов Евгений [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
show
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 numeric. So I
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
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 from
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 Pathes).
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
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 NULL,
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,stats.ham
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 other people
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 other
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
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, Firebird, MySQL,
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
SHOW CREATE
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 SP’s
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
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
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
[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
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
Gift Giving
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 mysql to
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
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 now!
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/
I checked
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!
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
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 into
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
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
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 already
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
FROM Products p
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
query,
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 and names of
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
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]
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
[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, both
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.
order_items
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
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.status NOT IN
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 SELECT r.uid,
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
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
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
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
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
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 (0.02
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) NOT NULL
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.
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.
-
Nouveau :
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
I haven't tried the migration toolkit so I don't know what it can or
cannot do. I am assuming that you have hand-transferred a few users from
your old system to the new one.
What I can suggest is that you generate two sets of data. The first is a
list of your users, their hostnames, and
Vinay [EMAIL PROTECTED] wrote on 02/14/2006 02:29:45 PM:
Hi,
I am trying to create a view by joining two tables.These tables
have a common column which references their parent table. I get the
following error when I try to create a view.
create view trn2 as select * from
1 - 100 of 1587 matches
Mail list logo