Using mysql v4.0.x on linux.
Given three tables...
CREATE TABLE Departments (
DeptID int(10) unsigned NOT NULL auto_increment,
DeptName char(30) default NULL,
PRIMARY KEY (DeptID)
)
CREATE TABLE UserDept (
CoreID int(10) unsigned NOT NULL default '0',
DeptID int(10) unsigned NOT NULL
I'm curious if USING() works with more than one join. I can't seem to get it
to work.
http://dev.mysql.com/doc/mysql/en/JOIN.html
The USING (column_list) clause names a list of columns that must exist in
both tables.
The following two clauses are semantically identical:
a LEFT JOIN b USING
DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 03, 2004 7:56 PM
At 18:32 -0700 6/3/04, Daevid Vincent wrote:
How come this one works:
SELECT wifi_list,IFNULL(wifi_list, 0) as wifi_list_new,
FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id
How come this one works:
SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new,
FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id =
wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac
WHERE last_seen = CURRENT_DATE AND wifi_list IS NULL;
This one
-Original Message-
From: Steve Meyers [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 7:42 AM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject: Re: Feature Request: UPDATE 'error codes' or
mysql_affected_rows() to be more accurate
http://dev.mysql.com/doc/mysql/en
I'm developing a program where I try an UPDATE ... LIMIT 1 and if
mysql_affected_rows == 0, then I know nothing was updated and so I do an
INSERT. I find this is much cleaner and the majority of the time, I'm going
to do UPDATES, so I didn't want to waste a SELECT (even though I hear
they're
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as
active FROM wifi_table WHERE active = 1;
It's so obnoxious, especially since I can do this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0)
PROTECTED]
Subject: Re: Drop all keys / indexes on a table?
Daevid Vincent [EMAIL PROTECTED] wrote:
It has come to my attention that we have maxed out our keys
due to a stupid
update script bug. It seemst that we've not been explicitly
naming our keys
and therefore mysql tried to be helpful
Thanks for the reply, however looking at all those options and none seems to
do what I need.
-Original Message-
From: PeterWR [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 11:55 AM
To: Daevid Vincent; [EMAIL PROTECTED]
Subject: Re: Drop all keys / indexes on a table?
Hi
And the answer to this is, YES, the whole ALTER query FAILS and NONE of the
indicies are dropped. *sigh*
mysql ALTER TABLE poop DROP INDEX name_2, DROP INDEX name_3, DROP INDEX
name_4;
ERROR 1091: Can't DROP 'name_4'. Check that column/key exists
-Original Message-
From: Daevid Vincent
]
Sent: Tuesday, March 30, 2004 1:49 PM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject: Re: Drop all keys / indexes on a table?
I've been using comand line piping through awk to handle
mass tables modifications and listings. E.g. in your case
something like the following would hit every index
Just make a symbolic link... Probably it's in /tmp
So as root,
ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock
This is always an annoyance with mysql and redhat it seems. *sigh*
-Original Message-
From: Sami Maisniemi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 3:11
It has come to my attention that we have maxed out our keys due to a stupid
update script bug. It seemst that we've not been explicitly naming our keys
and therefore mysql tried to be helpful and adds a new key each time!
*sigh*.
Is there a SQL command to DROP ALL keys on a table, so I can just
Dude.
http://www.phpmyadmin.net/
Daevid Vincent
http://daevid.com
-Original Message-
From: Mark Manning [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 7:38 AM
To: [EMAIL PROTECTED]
Subject: Wish List of Features
I downloaded MySQL and began playing
is this counter reset?
Is it ongoing until a FLUSH HOSTS?
Is it until mysql is restarted?
Is it something else?
Daevid Vincent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql select count(*) from atoms_in_universe;
+-+
| count(*)|
+-+
| 30204541410292874012341 |
+-+
1 row in set (0.07 sec)
Daevid Vincent
http://daevid.com
-Original Message-
From
I'm sure this won't matter, but did you try putting a order by date_close
DESC or ASC?
Daevid Vincent
http://daevid.com
-Original Message-
From: Elton [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 9:04 AM
To: [EMAIL PROTECTED]
Subject: Re: datetime ORDER BY is erred
You can't INSERT, but with mysql 4.0.15 and better, you can ON UPDATE
CASCADE and ON DELETE CASCADE
Daevid Vincent
http://daevid.com
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 1:24 AM
To: [EMAIL PROTECTED]
Subject: Re
I'm generating a dynamic UPDATE command in a loop. The problem is the stupid
comma.
Given this general idea, how do I handle the pesky comma. It's either in the
front and in the way, or on the trailing end and in the way...
I either end up with something like this:
mysql UPDATE contact_table SET
}
$SQL = UPDATE table set .implode(',',$upd). Where blah = 3 LIMIT 5;
//now do it
$result = mysql_query($SQL,$db);
Daevid Vincent
http://daevid.com
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 4:54 PM
To: [EMAIL PROTECTED
Have a need to do several queries, probably about 1 per second or so, and
the result of these queries will give me a # completed and a number total =
percentage done. I have an external program populating a db table and I want
to show progress on a web page till the program is done populating.
.
A Java applet is my alternative choice, but java is kind of pokey,
especially to load, and not so good with the graphics side of things.
Daevid Vincent
http://daevid.com
-Original Message-
Flash is executed in the client. Even if possible to connect to a db,
it would be a bad idea
an
UPDATE and set it back?
Daevid Vincent
http://daevid.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry for the double post. I sent this yesterday without any replies, so I'm
wondering if it made it out there?
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:29 AM
To: [EMAIL PROTECTED]
Subject: Upgrade from 3.23.52 to 4.0.15 all
I'm not normally one to panic, and I know I can revert back to an old
3.23.57 version, but this is concerning and was hoping a guru could tell me
what is wrong here. After the rpm upgrade, all my databases show up (ie. In
phpMyAdmin for example), but they all show (-) for the tables -- in
months ago I
wouldn't be able to do this huh ;-)
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 11:33 PM
To: Daevid Vincent; [EMAIL PROTECTED]
Subject: Re: Foreign key update and Error :: 1217 with v4.0.15
Daevid,
CONSTRAINT
| DIO, Inc. | |
| 91 | Bunk Company| bunk4321 |
[snip]
|276 | InteractNetworks, Inc | interact |
++-+--+
-Original Message-
Daevid Vincent [EMAIL PROTECTED] wrote:
ALTER
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, September 11, 2003 9:10 PM
Subject: RE: Foreign key update
I see there is a way to DELETE or NULL a cascade, but is there a way to
UPDATE?
Here's what I mean. Given these rough table schemas. I'd like to be able to
UPDATE the company_code in the company_table, and have it update the same
rep_company_code in the rep_table. Ie. So a company has a certain
Thanks Victoria for the pointer. I should have looked there first. Duh!
Now for the help... I tried:
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
But get ERROR 1216: Cannot add a child row: a foreign key constraint
one b/c it seems there needs to be
some logic in there to work. Perhaps that is something I will just have to
manually UPDATE?
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 7:34 PM
To: [EMAIL PROTECTED]
Cc: 'Victoria Reznichenko
TD cells.
If it's output to the terminal window, then try using a \t character to
tab to the next spot for columnar output.
Daevid Vincent
http://daevid.com
-Original Message-
From: Ooks Server [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:38 PM
To: [EMAIL PROTECTED
:11 AM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject: RE: AES 256-Bit Encryption and /etc/my.cnf
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, Daevid Vincent wrote:
It would be really nice if ANY of these kinds of
configuration options
were settable
What I've done is insert a bogus record at ID 999, then the next one will be
1000 and upwards. You can then delete the 999 record if you wish. mySQL will
NOT fill in the 1-999 spots automatically.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
mySQL should stop supporting SCO after their ridiculous allegations.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It would be really nice if ANY of these kinds of configuration options were
settable via the /etc/my.cnf file. I use RPM's almost exclusively for their
ease of maintenance, compatibility and stability and I certainly wouldn't
want to go and have to re-compile anything just to change a value from
Use sessions in PHP (super simple, just call session_start() at the top
of every page i.e. like in an include file) and use
$_SESSION['loginname']
I would strongly recommend using mod_auth_mysql for your authentication.
It's easy and probably more secure than anything you can write ;-) Plus
it
Look into mod_auth_mysql -- this module rocks and I use it all the time.
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 3:33 PM
To: 2Hosts.com
Cc: [EMAIL PROTECTED]
Subject: Re: Thousands of users? Newbie question
I think
escalate this into a flame war Jeremy, or you can retract
your rude statement by apologizing and let it be bygones...
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 7:58 AM
To: [EMAIL PROTECTED]
Cc: Daevid Vincent
Subject: Re: my backup
AHHH! I bet that is why I was having such a horrible time last night
trying to upgrade! I finally said fsck it and reverted back to
3.23.55...
I don't use a root password on localhost... Now I'll try your
suggestions and see if it works. *sigh* *crosses fingers*
-Original Message-
find for the differentials, is mtime a better
choice or does it really matter? Will ctime find all the mtime files
too?
Daevid Vincent
http://daevid.com
Ps. And yes, I sent that as a link in my resume because I'm unemployed
and would love any offers for coding work with PHP, Linux, SQL, etc
I don't have the answer to your question, but I find your question very
interesting.
One observation,and I could be wrong, is that deleting 1 has to delete
1,2,4,5' doesn't seem to be legal as far as Foreign Key constraints go.
As I read your table, 1/aa has no father (-1), 2/bb has father
so then the next obvious question to ask is... is this just not
implemented yet, or is it not even on the radar as a 'feature'?
Out of curiosity, do other SQL implementations (RDBMS) allow this
syntax?
On Wed, 2003-04-02 at 08:06, Egor Egorov wrote:
On Wednesday 02 April 2003 04:04, Daevid
Is this a bug or just not implemented in 3.23.56-Max?
mysql SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS
alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date),
alarm_date_format) AS contact_name, contact_email, contact_phone FROM
alarm_table LEFT JOIN
http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql SELECT HEX(abc);
++
| HEX(abc) |
++
| 0 | this should return 616263 according to the docs.
++
mysql SELECT HEX(255);
I think this works too:
Select * from Tablename where drinks 'pepsi';
-Original Message-
From: Andrew Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 4:49 PM
To: '[EMAIL PROTECTED]'
Subject: where drink is not equal to pepsi
Hi guys,
Hopefully have an
I wouldn't say I was a newbie at all. I've been coding in PHP, mySQL for
like 6 years now. But I just never learned (or maybe had a reason to) why I
would use KEY (a_id, b_id) rather than KEY (a_id) and KEY (b_id).
Would someone be so kind as to point me at an online tutorial or just
explain what
Ah ha!
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5) unsigned auto_increment,
`rep_login` varchar(15) NOT NULL default '',
`rep_password` varchar(15) NOT NULL default '',
`rep_fname` varchar(255) NOT NULL default '',
`rep_lname` varchar(255) NOT NULL default '',
Why such a hater?
This is not SPAM. It's totally relevant to this list, and I for one am glad
to see all new mySQL related products announced here. In fact, I just set
them color coded to green in my Outlook, so that EMS's post will be
highlighted for me in the future.
d
-Original
Yeah, I notice this too, especially after upgrading to MAX. I really find it
annoying.
My guess is that the RPM is slightly different than the God given RH
version, so there are TWO KXXmysqld in /etc/rc.d/init.d or in one of the
rc.3 or rc.5 or something and so one shuts it down, then the other
Can I have multiple foreign keys in a table? Like this... I ask because I
can't seem to get it to work. Errno: 150.
CREATE TABLE `dept_table` (
`dept_id` mediumint(8) unsigned NOT NULL auto_increment,
`dept_timestamp` timestamp(14) NOT NULL,
`dept_company_table_id` mediumint(8) unsigned NOT
If I create a table that uses REFERENCES in it, then mysqldump it, the
REFERENCES isn't there
Notice the `contact_dept_table_id` field in both of the below outputs:
CREATE TABLE `contact_table` (
`contact_id` mediumint(8) unsigned NOT NULL auto_increment,
`contact_timestamp` timestamp(14)
http://www.mysql.com/doc/en/CREATE_TABLE.html states Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE.
Is this ever going to be fixed? I often find myself using this when
http://www.mysql.com/doc/en/SEC457.html states that there must be an index
where the foreign key and the referenced key are listed as the FIRST
columns. Will this restriction be lifted soon? It is incredibly
frustrating. I don't see why they have to be indexes, and more importantly,
I don't see
In the last episode (Mar 05), Daevid Vincent said:
http://www.mysql.com/doc/en/SEC457.html states that there
must be an
index where the foreign key and the referenced key are listed as the
FIRST columns. Will this restriction be lifted soon? It is
incredibly frustrating. I don't see why
Given this table, I want to count the number of distinct targetranges.
CREATE TABLE job (
job_id int(10) unsigned NOT NULL auto_increment,
customer_id int(10) unsigned NOT NULL default '0',
scanner_id int(10) unsigned NOT NULL default '0',
status_id int(10) unsigned NOT NULL default '0',
Having a bit of a sticky wicket here... I'm sure the answer is simple
but I'm just not seeing it.
Basically I want to return all the TargetRanges and ScannerIDs. You
would think it's simple, here's the snag. See how ScannerID has 0 in
some rows. Well, we used 0 to mean any scanner in our PHP
What language are you using? In PHP use this:
http://www.php.net/manual/en/function.session-id.php
You could also experiment with mySQL's built in
NOW or CURRENT_TIMESTAMP or UNIX_TIMESTAMP
or ENCRYPT or MD5 or SHA or AES_ENCRYPT
or RAND
And some combination of those (hint hint)
-Original
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
-Original Message-
From: Zysman, Roiy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 19, 2003 11:16 PM
To: [EMAIL PROTECTED]
Subject: What is the best known practice for insertion...?
Hi All,
I'm trying to
and/or the ORDER BY is not working.
Out of curiousity, did you try it like gentradedb.gpatomdb instead of
`gentradedb`.`gpatomdb`
Mebbe the ` are confusing mySQL?
-Original Message-
From: Horizon [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 3:48 AM
To: Daevid Vincent
Cc: Mysql
I would suggest appending an ORDER BY atomtype first of all.
I say this because if you scan your results, you have duplicates...
| 165 |
| 166 |
| 167 | ---
| 168 |
| 169 |
| 170 |
| 171 |
| 172 |
| 173 |
| 174 |
| 175 |
| 167 | ---
|
Also, don't confuse the RANGE of values that the atomtype can be (0-255)
if set to be UNSIGNED with the NUMBER OF ROWS in your output. The
TINYINT is working. You have no values greater than 255 in there. You
just have duplicates which gives you more rows than you were expecting I
think. ;-)
(10) unsigned NOT NULL default '0',
RunEvery char(50) default NULL,
NextRun datetime default NULL,
LastRun datetime default NULL,
PRIMARY KEY (ScheduleID)
) TYPE=MyISAM;
SQL;
It works. However I'm dreading doing this one table at a time. Grr.
Daevid Vincent wrote:
I need to use PHP
.= Error creating
.$V2DB...$row[0]. tableBR\n.mysql_errno($linkI).:
.mysql_error($linkI).BR\n;
}
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 1:16 AM
To: [EMAIL PROTECTED]
Cc: 'Bill Lovett'
Subject: RE: How can I duplicate
mysqldump --no-data db1 | mysql db2
(You may have to add host/user/password options but I just wanted to
show the idea).
Hope this helps,
Joseph Bueno
Daevid Vincent wrote:
Seems to me there should be a built in SQL command to duplicate a
database. Jeepers. Or to read in a .sql file from
You mentioned a
echo PRE.$sql./PREP;
in your first post; what do you see?
I see exactly what I expected to see. Basically the contents of a db.sql
file read in that looks like this roughly:
CREATE TABLE table1 (
blah int(10),
foo char(5)
);
CREATE TABLE table2 (
blee int(10),
I need to use PHP to duplicate the schema of a mysql database. This
seems like it should be a simple task -- taking a 'template' db and
cloning it with a new name.
I've tried things like:
$filename = myDB.sql;
$fd = fopen ($filename, r);
$sql =
figured they just
didn't work b/c I had a router and the internal LAN and stuff. ;-)
I still have no idea why Mascon worked the whole time however.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 1:38 PM
To: Daevid Vincent
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
[root@daevid]#
mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive
But as I see, you tried the ping from the local host (i.e.
you connected from the same machine where the MySQL server is
running). What happens if you try
]]
Sent: Friday, December 06, 2002 8:55 PM
To: Daevid Vincent
Subject: RE: Can't connect error 10061 - nothing but Mascon
works remotely.
Can you send me some details like:
- The error msg. that SQLYog is reporting.
- Are you using SSH or SSL?
- Are you able to connect thru mysql.exe
: Sunday, December 08, 2002 1:53 PM
To: Daevid Vincent; [EMAIL PROTECTED]
Cc: 'Karam Chand'
Subject: Re: Can't connect error 10061 - nothing but Mascon
works remotely.
Can't connect to MySQL server on 'daevid.com'(10061)
Try mysqladmin ping -h mysql_host_name. This is the most
basic thing I
. The problem lies either with RedHat 8.0 and
their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com
site are not statically linked as they say they are.
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 08, 2002 7:05 PM
To: Daevid Vincent
it.
[root@daevid root]# uname -r
2.4.18-14
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 08, 2002 8:26 PM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]; 'Insanely Great'
Subject: RE: Can't connect error 10061 - nothing but Mascon
works remotely
I'm looking for something that will take mySQL databases and show me
graphically how the tables all relate to each other. At the very least,
show me boxes with the schema in each one and allow me to draw lines as
I see fit (or use the foreign keys of InnoDB tables). This could then be
printed to
I'm having a strange problem connecting via remote to mySQL. This is an
internal LAN, so there should be no firewall issues. I'm running RedHat
8.0, but I've installed the latest mySQL rpms which I thought were
statically linked to avoid the earlier problem of this same nature. The
peculiar thing
I notice that I see mysql failing to stop on reboot of my machine,
however I believe it's because it already was stopped at an earlier
runlevel:
[root@daevid rc3.d]# locate mysql | grep /etc/rc.d/
/etc/rc.d/init.d/mysqld
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc0.d/K12mysqld
Well, it seems there are some glitches with and snags and other fun
stuff to deal with when doing a straight RedHat 8.0 install. It turns
out you have to edit your /etc/php.ini and uncomment out the
extension=mysql.so line for starters. It also helps to set
short_open_tag = On.
Another fun thing
According to http://www.mysql.com/doc/en/Column_types.html
BIT BOOL -- These are synonyms for TINYINT(1).
DÆVID.
-Original Message-
From: Oluwagbamila Oyekanmi
Use the data type BOOL which takes a 1 or 0 character or use
CHAR and then you can use Y or N for Yes/No.
Or how
Assume my db will have millions of records and frequent selects.
If I plan on have a field that can be one of multiple states (A, B, C or
All), is it better to store as ENUM or TINYINT (as a mask, such that A =
1, B = 2, C = 3 and if I know that, then All = 6, and none = 0). I'm
only talking
Well, you could have the Canadian admin add your pakistan IP
address/host to the mysql database in the hosts table, along with
the proper user and db I'm sure. Then you can use any 3rd party
mySQL client to connect and do whatever you want.
Something I just did recently is to install phpMyAdmin
I tried this and got a different result:
[root@daevid root]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
?Host 'daevid' is not allowed to connect to this MySQL serverConnection
closed by foreign host.
[root@daevid root]# telnet
I have the exact same problem. Nothing has changed other than I upgraded
from RH7.3 to RH8.0. I've tried at least five (5) different mySQL
windows clients and all refuse to connect. However I can use phpMyAdmin
locally (via web) and also all my web based database pages work fine
too. I've tried
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this SQL command, but it doesn't work right. I
get multiple permutations
In order to save space in our database, we designed our tables to use
enumerated datatypes. For one column, we have about 2,800
different values,
each of which is about 30-40 text characters long. Now, all the MySQL
documentation I have read states that the limit for the number of
hey, how do I DELETE all these Contract_Table records in mySQL?
SELECT contract_id, client_contact, contract_percent
FROM Contract_Table, Client_Table
WHERE contract_client_id = client_id
AND client_contact = 'corricello' AND contract_percent = 0;
I see this page, but didn't know if it was
If I recall it right the statement should be following:
DELETE FROM Contract_Table, Client_Table WHERE contract_client_id =
client_id
AND client_contact = 'corricello' AND contract_percent = 0;
I made a copy of the database and tried this one, but it caused an error.
I'm thinking something
301 - 386 of 386 matches
Mail list logo