Subject: Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today
> 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
> How do I run mysql_upgrade if the mysqld server won't start?
Please don't bother to answer, I di
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.
How do I run mysql_upgrade if the mysqld server won't start?
Man how stupid am I?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better.
Good luck,
Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
> If the return value of the UPDATE stmt is zero, the following stmt is ran:
By return value I assume you mean "rows affected" ?
> This is working great, and has been for many years; however,
> today I noticed it was not working on a particular MySQL server.
By "not working" what exactly is the
> if you define a column with any name and a type of
>
> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Thanks Lucio,
This is much better advice than the NOW() built-in function I would
have suggested.
Kind Regards,
-Bob
--
MySQL General Mailing List
your query. I don't see the
count "n" being output at all in the example. Are you sure you're
looking at count() and not something else? Count should count all
non-null instances of foo (or count(*) works too).
Thanks,
Bob
--
MySQL General Mailing List
For list archives: h
Cameron,
Did you run the recommended configuration script manually?
mysql_install_db
This is run once after install to put the "stuff" in your datadir= location
which I pointed out may be missing (and was "empty" upon your inspection).
Thanks,
Robert
Hi "Learner",
You might want to try reading about SQL JOIN and/or CLIENT_MULTI_STATEMENTS.
Using databases is all about conglomerating results, but it helps to know
the environment first.
Hi Cameron,
I've seen a similar error running on windows 7.
When you look in your datadir= specified in my.ini what is there exactly
(hopefully not empty)? Do you have a mysql folder containing plugin.*
files at this location? (say .MYI etc)
It sounds like your data folders were either not copi
pgrade -u root -p mysql
>
>
>
More details I'm sure, but just my initial thought.
Thanks,
Bob
On Fri, Aug 15, 2014 at 8:32 AM, wrote:
>
> mysql Digest 15 Aug 2014 12:32:06 - Issue 5209
>
> Topics (messages 230517 through 230517)
>
> Incorrect Infomatio
just fine against localhost on MySQL 5.6 Win7-64bit.
-Bob
delete b from icd9x10 a
join icd9x10 b on a.icd9 = b.icd9 and a.id < b.id
>...
> CREATE TABLE `ICD9X10` (
> ...
> id icd9 icd10
> 25 29182 F10182
> 26 29182 F10282
> ...
Good luck,
Bob
Hello *,
My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and
I backup my db from them.
If a problem occurs on the database, a recovery from a dump takes around 6H !
That's too long for us.
2 ideas :
1. Stop the slave and rsync the folder /var/lib/mysql to another
--+-+
| localhost| myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ | Y
|
| %| myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ | Y
|
+--+--+-------+-+
Your results should be similar.
HTH,
Bob
-ppassword < /Users/myname/Documents/testCount.txt
The result was:
COUNT(*)
12
without the decorations.
Bob
On May 14, 2010, at 11:35 PM, Dan Nelson wrote:
> In the last episode (May 14), Tim Johnson said:
>> I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
f 3.
I wonder if I am representing your situation correctly. What am I missing?
Bob
On May 12, 2010, at 8:00 PM, Keith Clark wrote:
> Hi Bob,
> No, actually it does not. I'm looking for the count of items. From
> your query example I only get two rows. This table has over 2 1/2
Keith:
Does this work?
SELECT products_date_available, COUNT(products_quantity)
FROM products
WHERE products_quantity > 0
GROUP BY products_date_available
Hope this helps,
Bob
On May 12, 2010, at 3:06 PM, Keith Clark wrote:
> On Wed, 2010-05-12 at 10:13 -0400, Keith
s -fno-rtti -fno-exceptions'
kenny# ./mysqladmin create databasename
/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.
sock'
I am working on a project where I have have several processes writing
records to an InnoDB table. There are two separate queries doing the
inserts. In maybe one out of a couple 100 inserts, I get an integrity
constraint violation error, complaining about a duplicate entry for key 1.
The first
ethernet
link between master and slave (nothing exotic). The load on the link
never seems to an issue, so we have never monitored it closely.
So, if you are happy with the situation then it is solved.
Cheers,
Bob Bankay
Baron Schwartz wrote:
Christopher E. Brown wrote:
On Sat, 3 Nov 2007
Couple of things to read that may help:
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
http://hackmysql.com/case3
On another note, you should really change all of those ip address columns
from varchar to int with the ip encoded as 4 bytes. You will save A LOT of
space in both
well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this hel
To you all,
Thanks for your input. The "TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')%
4" where statement worked perfectly. And, thanks for the reference to
the manual. It can be a bit daunting for a newbie.
Bob Cooper
> Dan:
>
> Thanks!
>
> Jim
>
>
Hi,
I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64.
I am new to both SQL and MySQL.
I have been able to query out most of the data I need from my tables
without any issues but his one has stumped me.
I am trying to query data associated with specific dates.
The dates are not sequential
Why would you want to do this? As data moves around within the table the
updates will be in error. Wouldn't it be easier to assign a unique key to each
row, search for the key or unique set of information and update the resulting
row?
Bob
-Original Message-
From: [EMAIL PROT
Considering there are a number of pieces that are involved in the connection
being ready why not create a small program that tries to connect and checks the
return value. If it fails sleep for 500ms to 1 sec and try again for up to
X-times before aborting altogether?
Bob
-Original Message
If you will excuse my ignorance. I have no immediate need for this, but have
often asked what the pros/cons there are writing a WEB based interface in PHP
vs. say Perl. Do you have any insight into that?
Thanks
Bob
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday
using Foreign keys in your other tables that require customer information.
Bob
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, May 19, 2006 8:57 AM
To: Mark Sargent; mysql@lists.mysql.com
Subject: RE: Is This A Redundant Info Example?
[snip]
Why have cus
w to do so with a query ? fields are client.idclient, article.idclient,
article.idarticle, article.startdate, article.enddate.
Please help me, I don't know how to retrieve those values and I need them to
get payed.
Bob
--
MySQL General Mailing List
For list archives: http://lists.mys
Sorry:-\ Meant to say
I do not understand why mySQL is pointing to this as an error
Bob
-Original Message-
From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 5:30 PM
To: 'mysql'
Subject: Unknown column 'testcase_root.Test' i
I am receiving an error "Unknown column 'testcase_root.Test' in 'order clause'
I do not understand why the error is pointing to this as an error, nor if it
means anything that the name of the column is correctly identified in the query
below as testcase_root.TestID. I have checked the DB and th
Scott Klarenbach wrote:
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances w
Michael Stassen wrote:
Bob Gailer wrote:
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The
product_table >has all the products, but the sale table is a subset
of the prod
User';
to get the id.
Is that the only way to do it?
hope it isnt a stupid question and thanks for any help in advance!
Cheers
Bob
-
Yahoo! Photos NEW, now offering a quality print service from just 8p a photo.
Peter Brawley wrote:
Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the product_table.
SELECT * FROM product_table p
LEFT JOIN sale_tab
Hi all,
Can anyone throw some suggestions at me for this problem?
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
>From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
What's th
A schema is a the database design. Sometimes textual, sometimes visual
definition of the database structure (tables, field types, defaults etc). The
database is the physical implementation of the schema that holds the data.
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
ql> select prod_name from Products where not vend_id = 'DLL01' order by
prod_name;
Empty set (0.00 sec)
Bob Rea
Dragon Networks
770-458-1350
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That may be true, but I don't think the augments provided by Joerg necessitate
a single column or multiple columns. His points, leading zeros, sorting, etc go
more to the native data type that should be used and are valid in either case.
Bob
-Original Message-
From: Sujay K
get called a Bone-head, than I have the
choice to clarify my question or move on, but coming back again and again
serves no-one.
Lets stick to the technical issues and hopefully all become better because of
it. For those of you that can't.there's always grandma:-))
Bob Bartis
-
count.
2) Is there some reason that my index trees would not be uniform? Is there
anything I can do about this?
3) For InnoDB tables, does it make sense to always keep max_seeks_for_key at
a low value (1, 100, ?)
Many thanks in advance,
-Bob
- Original Message -
From: <[EMAIL PR
InnoDB.
Since InnoDB has clustered indexes, is there ever a good reason for MySQL to
prefer a table scan?
Thanks,
-Bob
I believe 5.0 does.
-Original Message-
From: Andreas Ahlenstorf [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 2:55 PM
To: Jerry Swanson
Cc: mysql@lists.mysql.com
Subject: Re: View
Am 02.06.2005 um 20:31 schrieb Jerry Swanson:
> Does Mysql 4 supports "views"?
No.
Regards,
A.
That might explain it:-) The really said part is I remember running into the
same issue some months back and completely forgot.
Thanks
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 6:54 PM
To: Bartis, Robert M (Bob)
Cc: 'mysql'
S
--Original Message-
From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 6:29 PM
To: 'mysql'
Subject: Subquery question
I have a problem where I need to use a subquery in combination with a Left
Join. The SQL statement below works fine until I introduce t
I have a problem where I need to use a subquery in combination with a Left
Join. The SQL statement below works fine until I introduce the subquery
portion. Specifically,
WHERE testplans.plantriggers_ID_FK IN (SELECT plantriggers.ID FROM
plantriggers WHERE (((plantriggers.testplan_intro_PlanI
phone and
student/address separately and then create the student_info using keys from
these intermediate tables, but it more complicated and it not clear what the
constraints on your problem is.
Bob Bartis
-Original Message-
From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
Sent: Tu
Suggest you review the MySQL documentation
http://dev.mysql.com/doc/mysql/en/installing.html and in particular 2.3.13.
Testing The MySQL Installation and 2.3.14. Troubleshooting a MySQL Installation
Under Windows
Bob
-Original Message-
From: Terry Leung [mailto:[EMAIL PROTECTED]
Sent
foreign keys above. Would it be appropriate to remove the single
primary and replace with three multiple primary keys? Is there a performance
impact when doing this. this seems overly complex and wonder if I should be
breaking the table up to simplify? Any suggestions would be appreciated.
Bob
ed to do the import one or
twice.
Although this is somewhat convoluted it works for me. Start MS Access and
create linked tables to you MySQL DB. Then import the data from Excel into
Access. They're integrated fairly well so the import is basically a couple of
button clicks. Then you'
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will shed some light?
-Original Message-
From: Renato Golin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:48 PM
To: Richard Miller; Mysql
Subject: Re: CSV-to-SQL?
You could use the CSV table t
Sounds like the type for the field you're storing the number is not capable of
holding a number sized as 16996941. What's the field type you're storing the
number in?
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05,
Sounds like you need a 1:N relationship table to hold userInfo separate from
either the user or group table. Adding a infoIdentifier would allow the number
of rows added for a specific user to be sized based on the specific user needs.
This is effect would be the "key" part of a key-value pair,
I found a series of
7-books. MySQL had a number of book available, all of which seemed reasonable
straight forward and none of which came in a set. As I said, non scientific and
I am not a DB Admin, but for a small group such as mine it was critical to find
something with low overhead.
Bob
ld be to force User 1 to lock table b
even though the results of that query are stored in the query cache.
Is this possible?
Thanks,
-Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
does not allow you to use a table in a subquery
which is being updated. If anyone can offer any assistance with this, I
would greatly appreciate it.
Thanks,
Bob Dankert
Envision Information Technologies
Associate
[EMAIL PROTECTED]
v. 608.256.5680
f. 608.256.3780
try updating the table like this...
update TABLE set COLUMN = replace(COLUMN, >,);
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 3:30 PM
To: MySql
Subject: remove trailing character
I managed to mess up and email storage addresses are in t
e Linux x86 glibc static gcc RPMs from
mysql.com.
Thanks,
-Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > Return only four rows beginning at second row:
> >
> > SELECT count(*) AS count, name, year FROM a
> > GROUP BY name, year
> > ORDER BY count DESC, name ASC
> > LIMIT 4 OFFSET 1;
> >
> > count name year
> > --- --
I think you mean that you want to import .txt or .csv data into an mysql
table...
http://phpmyadmin.net can do that via a web form to upload plus has many other
good
admin features.
-Original Message-
From: Steve Grosz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 1:56 PM
Its my understanding you need InnoDB table types, but I do not know of the
single foreign key per table. I have a DB with multiple foreign keys per table
and its seems to work fine.
Bob
-Original Message-
From: Paun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 5:19 PM
To
x27;t using https to connect, to push them to the https
url.
Am I missing something here?
The only snage with the header function is that you must not print or
echo anything to the browser before you use it. In other words you
can't do this:
I moved you to another page.
http://someotherpage.
As suggested by Karam, please refer to
http://dev.mysql.com/doc/mysql/en/Replication_Implementation.html for additional
information.
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 31, 2004 1:29 PM
To: Eko Budiharto; [EMAIL PROTECTED]
Subject: Re: syn
Thanks, that was it exactly.
bob
At 02:25 PM 10/28/2004, Michael Stassen wrote:
Something like
SELECT uid,
AVG(number_grade) AS average_grade,
SUM(IF(letter_grade = 'A', 1, 0)) AS A_count,
SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count,
Aman Raheja wrote:
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
http://downloads.mysql.com/archives.php?p=mysql-4.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
,0, 0,1, 1
I can do this is a separate query for each grade, but that makes a lot of
little queries. Is there a way to do this in one query? Or am I just
going to have to break the average out and do the counts in one query and
the average in another?
Thanks,
bob
I have been working to configure MS Access 2000 as a front-end to an application
running MySQL 4.0.20-standard. Our thinking was to have a guest login with minimal
privileges (Select only) setup as the default on each users PC. This would allow
anyone on the team to access the DB using the front
I have a query that I have put together. The query is an attempt to retrieve records
from one table, main_db, whose keys are not present in another, featureenable. I am
using the NOT EXISTS keywords and continue to receive an ODBC---Call Fail error. I
traced the ODBC calls and see something very
Thanks for the tip. I'm still facing an issue where I think I have the right syntax
and I'm receiving an ODBC failure. Do you have any suggestions on how to go about
understanding why the failure and hence how to correct it?
Bob
-Original Message-
From: Martin Gainty [mai
I did find a reference to EXIST/NOT EXISTS clause in the SQL manual, but I get an ODBC
Failed call when I run the following simplified query
SELECT *
FROM main_db
WHERE NOT EXISTS (SELECT * FROM featureenable WHERE featureenable.FeatureKey =
main_db.FeatureKey);
Bob
-Original Message
I have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional, functionalsubgroup.SubGroup, main_db.Feature,
main_db.FeatureKey, functionalsubgroup.FSKey, featureenable.PlanName
FROM featureenable INNER JOIN (main_db INNER
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*.*' and page_body not regexp '.*.*';
bob
======
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING I
r the scripting language. ;)
Thanks,
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just can't figure out the right syntax. Any ideas?
Thanks,
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A friend of mine, who is not a member of the MySQL email aliases, is working toward
her Bachelors degree. She is currently taking a database design course. She mentioned
her current assignment to me and I suggested she allow me to forward this request to
this email alias. I understand this is no
Hi Eric,:
Thanks for responding. Preliminary tests indicate no problems, although it does of
necessity make assumptions about which of the new privileges existing users should
have when upgrading, but they were fairly safe.
Regards,
-Bob
> I would assume that you can since mysql proba
T CustomerId, CompanyName FROM Customer"
http://localhost/sql?sql=select%20CustomerId,%20CompanyName%20from%20Customers%20FOR%20XML%20AUTO
=
The above looks very much like what I have in
mind, but for MySQL. Anybody know how to do
this?
Many thanks in advance,
-Bob
--
MySQL General M
insert is not great, but it is a lot better than what we were seeing
before. So, we are planning on moving our MySQL database server to the
same site as the Oracle database.
Any other performance tuning suggestions would be be appreciated.
Thanks!
Bob
[EMAIL PROTECTED]
19-Jul-2004 11:35
much appreciated.
Thanks,
Bob Runion
--
Here?s the Oracle SQL Trace of the INSERT statement?
INSERT INTO [EMAIL PROTECTED] VALUES (:1, :2, :3, :4, :5, :6, :7,
:8, :9,
:10, :11, :12, :13, :14, :15, :16, :17, :18, :19
head, the select statement looks like this:
select t1.name, (select t2.value from t2 where t2.name=t1.name) as
all_values from t1;
Is there a way to do this with just one sql statement?
Thanks,
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
de handy to share, but if you need some I could probably
knock something out quickly.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sadvantages are there to one method vs. another?
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I recently added a column and Index to an existing table. I wanted to also add a
Foreign Key. I have done this before defining the commands outside MySQL and souring
the file in for new tables, but would prefer to not have to dump the current table
just for the modification. I tried to add one b
On 07/01/2004 11:48 PM [EMAIL PROTECTED] spoke:
I have MySQL 3.23 installed, which comes with RedHat ES3. I find that
innoDB is not enabled. Anybody knows can I enable it?
Thanks,
Joseph
Recompile the binary or upgrade to one that includes it.
I don't think there is a runtime switch.
--
MySQL Gener
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are more
rows than the limit.
Either do a SELECT COUNT(*) prior to your LIMIT query to see how many
total rows there are, or use
On 06/30/2004 02:46 PM Andrew Pattison spoke:
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
I'm not using PHP.
I'm loading tons of data with SQL statements from the command line
I'm running a ton of sql statements to load data.
Is there a way to not display successes:
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
and display failures and the query statement that failed?
There are 60 000+ of these and I'd ideally like to debug the inserts
witho
well,
you can easily output into a comma separated file but the INTO OUTFILE option will not
allow you to retain the headers. You will need to build the logic into a perl script
or language of your choice to get the headers there. Sounds like your fields records
are all on one line becausing yo
Had the same issue. I've bookmarked it, but its not clear why its so hard to find. Its
good stuff man put it out front:-)
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:13 PM
To: Chris Stevenson
Cc: [EMAIL PROTECTED]
Subject: Re: mysql c
again; locating "> gives me the position of the " in ">.
Subtracting 5 gives me the right length after discounting the and
the 2 positions I'm off from ">.
Someone more experienced that I can tell you if there's a more effecient
way. My inclination would b
On 06/21/2004 05:02 PM Brent Baisley spoke:
The opposite of the query would be a.type!='X' and there is no related
record in table b. Not sure if that is what you what
It isn't what I want because there could be other a.type other than 'X'.
Oops, that should be b.type
I need to return the a record
On 06/21/2004 04:26 PM [EMAIL PROTECTED] spoke:
I don't understand. You want every other record except .what?
By flipping the equality the way you did, you should see all of the records
where a.id = b.id (regardless of what the b.type value is) where a.type was
not 'X' which is one reasonably v
I have:
select name from a, b where a.type='X' and a.id=b.id;
I want a query to return all the rows that were NOT found by the above
query.
I can't simply do:
select name from a, b where a.type!='X' and a.id=b.id;
because there is more than one row in b for each type!='X' but there is
only one r
|
++
| 123-45 |
++
1 row in set (0.01 sec)
What I did here as to first strip all of the '-' out of the user string,
since we weren't sure where or if they were there. Then I rebuilt the
string to match the pattern ###-## using concat and substring. As I
said, this just seems far too clunky to deal with even if it does work.
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
qualed the result of the replace function that
replaced all '-' with nothing. So it matched 12 from the user input -1-2-.
If that works for you, let me know.
bob
Luke Majewski wrote:
Hi everyone,
ok, so I know how to use RLIKE to match regular expressions. However,
let's say I hav
Luiz Rafael Culik Guimaraes wrote:
Dear Friends.
when Creating the follow table
I got an Erro when defining Column DESC(same error even if DESC is between
"")
DESC is a reserved word, try something else.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
ns ones to stay away from?
Thanks in advance
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where is the syntax error in this?
select name from users where name like '%' and strcmp( substr(name from
1 for 3), 'abc' )=0;
Why should I use strcmp since "MySQL automatically converts numbers to
strings as necessary, and vice versa."?
--
MySQL General Mailing List
For list archives: http://
QL at port 3306 followed by the request for an ICMP
ping instead of the expected ACK. The ports are enabled in the etc/services file so
we're at a loss. Is there a setting to allow remote connections in Linux?
Still lost:-|
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
1 - 100 of 463 matches
Mail list logo