Matthew S. Hamrick ([EMAIL PROTECTED]) writes:
> Interfacing MySQL with "standard" crypto libraries: BSAFE, BDANGEROUS,
> CRYPTIX, CRYPTLIB, CRYPTO++, or even PAM?
Why? What's the purpose? Export laws being what they are, it's probably not a good
idea, anyway...
> Using any crypto li
jason bailey ([EMAIL PROTECTED]) writes:
> I'm consistently getting the error (2002)
> : Can't connect to local MySQL server through socket
> '/var/mysql/mysql.sock' (111)
You mean "/var/lib/mysql/mysql.sock"? Details are IMPORANT.
> I've deleted it and running something above has brought i
I used the binary with Red Hat 6.2.All the functions except table related functions
(specially table create functions) are working
Do let me know what i should do to make the table create function work
regards
venkatesh
e mail [EMAIL PROTECTED]
---
Ed Carp ([EMAIL PROTECTED]) writes:
> The obvious solution is to force, in the client library, for my.cnf to exist,
>correctly configured, in a published place. Any other ideas on how to solve this
>problem? I've already mentioned why relinking as a dynamic binary isn't feasible.
This won't
muttaqin ([EMAIL PROTECTED]) writes:
> >Description:
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
> >Fix:
> lines)>
"ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock" is the easy fix :)
--
Ed Carp, N7EKG - [EMAIL
> Everything works great, except that I can't access a database created
> by root as another user. When I grant privileges, from the command
> line or phpmyadmin, things seem to work fine (no error message), but
> access is still denied. I did restart MySQL after granting rights.
You can also che
Gary Huntress ([EMAIL PROTECTED]) writes:
> In the past few days 3 different people have asked me about "xml support" in
> mysql. I was unsure what to tell them actually, beyond saying "you can
> easily export recordsets to xml documents".Obviously you can store
> entire XML documents in a T
Here is what we have found while working on the 0.2.1 version of Escapade:
Because Escapade is not open source, and is in the following sense similar to
prepackaged Perl and PHP systems, Escapade is distributed as a static binary (because
of library incompatibility issues among various Linux sy
Hi all.
When is supposed the 3.23.42 mysql version released?
Iago.
__
mensaje enviado desde http://www.iespana.es
emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros
--
George Pitcher ([EMAIL PROTECTED]) writes:
> Similar for me. Except that I can do all the usual SQL stuff as root but if
> I try and access via PHP I get the '/tmp/mysql.sock' missing message.
>
> Is a complete re-install of MySQL the only solution or is there something
> else that can be done t
Gary Huntress writes:
> In the past few days 3 different people have asked me about "xml support" in
> mysql. I was unsure what to tell them actually, beyond saying "you can
> easily export recordsets to xml documents".Obviously you can store
> entire XML documents in a TEXT field, but I'm no
Similar for me. Except that I can do all the usual SQL stuff as root but if
I try and access via PHP I get the '/tmp/mysql.sock' missing message.
Is a complete re-install of MySQL the only solution or is there something
else that can be done to solve this problem, which, from scanning archives,
i
I figured out the answer. It is:
SELECT * FROM users WHERE added > (CURRENT_TIMESTAMP()
- INTERVAL 24 hour);
--- Andrew Tomazos <[EMAIL PROTECTED]> wrote:
> I am running MySQL 3.23.39.
>
> I have a column called "added" of type
> "timestamp(14)"
> in a table called "users".
>
> I set "added"
Would you be so kind as to do that step by step? I'm very new to this and
don't know half this stuff (although I am starting to learn books, etc.).
Please. Not tryin to get you mad or anything but I dont have a clue on how
to go about doing that.
- Deryck H
- http://www.comp-u-exchange.com
)-Original Message-
)From: Deryck Henson [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 04, 2001 9:55 PM
)To: Joshua J. Kugler
)Cc: MySQL
)Subject: Re: What does this error mean??!!
)
)
)I know that!!! But how do I fix it? On the DSN, I put uid and
)pwd to blank
)because I did the
I know that!!! But how do I fix it? On the DSN, I put uid and pwd to blank
because I did the same in the ODBC UserDSN setup window.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>; "Der
I installed linux and mysql 3.23.40.
Root installed and started mysql and user (charley) wants to connect mysql.
When charley enters "mysql",
"Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)"
message appears.
Of course root can connect to mysql server with above command.
I am running MySQL 3.23.39.
I have a column called "added" of type "timestamp(14)"
in a table called "users".
I set "added" to NULL on INSERTs in order to set it to
the current time.
I now want to SELECT all rows added in the last 24
hours.
SELECT * FROM users WHERE added > ... ?
What is the
>Description:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
>How-To-Repeat:
my activities :
1. install with tar procedure
./configure --prefix=/usr/local/mysql --> fail
and then remove /usr/loca
Hi.
Maybe a permission problem? Does the user MySQL is running under have
the rights to see and access the database files?
Bye,
Benjamin.
On Tue, Sep 04, 2001 at 07:43:55PM -0700, [EMAIL PROTECTED] wrote:
> I have a major problem. I have the databases backed
> up with tables. I had t
Hello.
On Tue, Sep 04, 2001 at 03:53:00PM -0700, [EMAIL PROTECTED] wrote:
> Dear When I try to create this if show the below
> mentioned error msg .Can some light on it?
> mysql> create table usermaster(user_name varchar(50),
> user_id varchar(40) Primary Key,
> user_level varchar(8), password v
In the past few days 3 different people have asked me about "xml support" in
mysql. I was unsure what to tell them actually, beyond saying "you can
easily export recordsets to xml documents".Obviously you can store
entire XML documents in a TEXT field, but I'm not sure thats really the
functi
Hi.
On Thu, Aug 30, 2001 at 07:01:35PM -0600, [EMAIL PROTECTED] wrote:
> On Thu, Aug 30, 2001 at 05:21:57PM -0700, Igbar Foosenhopper wrote:
> > Thursday, August 30, 2001, 2:13:56 AM, you wrote:
> >
> > CT> A quick question: How come the mailing list software
> > CT> doesn't add a reply-to heade
I have a major problem. I have the databases backed
up with tables. I had to reinstall mySQL and copied
the databases and tables back to the mysql directory,
it sees the database names but does not see the tables
within the databases. Is there a recovery method for
this? Please help. I know s
From: Lance Rochelle <[EMAIL PROTECTED]>
> SQL question which I am new to.
> How would I count the number of times a specific entry is in field. For
> instance I have a table that has the following two fields
select count(*) as number, hostname
from your_table
group by hostname;
---
Rodney
select count(hostname), hostName from tableName group by hostname
Cal
http://www.calevans.com
-Original Message-
From: Lance Rochelle [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 8:57 PM
To: [EMAIL PROTECTED]
Subject: SQL question
SQL question which I am new to.
How w
> SQL question which I am new to.
> How would I count the number of times a specific entry is in field. For
> instance I have a table that has the following two fields
> numberhostname
> 1 10.1.1.1
> 2 10.1.1.2
> 3 10.1.1.3
> 4
At 9:57 PM -0400 9/4/01, Lance Rochelle wrote:
>SQL question which I am new to.
>How would I count the number of times a specific entry is in field. For
>instance I have a table that has the following two fields
>numberhostname
>1 10.1.1.1
>2 10.1.1.2
>3
SQL question which I am new to.
How would I count the number of times a specific entry is in field. For
instance I have a table that has the following two fields
numberhostname
1 10.1.1.1
2 10.1.1.2
3 10.1.1.3
4 10.1.1.1
and
On Tue, 4 Sep 2001, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > Tony Bibbs <[EMAIL PROTECTED]> writes:
> >
> > > 7.1 doesn't install php with mysql support enabled.
> >
> > Yes, we did.
Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
mysql function c
I have decided to use mySQL as my database server. And I would be
grateful if anyone has the sample or guidelines on how to efficiently and
effectively setup the users?
My database is resided in one server. All other users will be connected
to this database server remotely.
Thank you.
Regard
At 7:59 AM +0800 9/5/01, Steve Doig wrote:
>Hi Folks,
>
>I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
>In the batch file, can I specify that values are separated by commas instead
>of tabs?
No, but if you have Perl installed, you can create a file named csv.pl
that c
At 5:03 PM -0700 9/4/01, Chad Berryman wrote:
>I am trying to create a MySQL SELECT statement using PHP where I am
>getting a filtered list back by a date in the database formatted as
>-mm-dd where the date falls between a one week window that is in
>constant motion.
>
>For example, take to
MySQL crashes almost every time we try to use it through a PHP
script.
We use 4.1 BSDI BSD/OS 4.1 Kernel #0
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Yes, the same way you would with the INFILE syntax
Steve Doig wrote:
>
> Hi Folks,
>
> I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
> In the batch file, can I specify that values are separated by commas instead
> of tabs?
>
> Cheers,
> Steve
>
>
It means that access for the user connecting from the domain something.com
has been denied. You don't have permissions set up properly.
j- k-
On Tuesday 04 September 2001 15:59, Deryck Henson wrote:
> [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database
> 'dbasename'
>
I am trying to create a MySQL SELECT statement using PHP where I am getting
a filtered list back by a date in the database formatted as -mm-dd
where the date falls between a one week window that is in constant motion.
For example, take todays date (as a julian calendar number) and a date th
Hi Folks,
I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
In the batch file, can I specify that values are separated by commas instead
of tabs?
Cheers,
Steve
-
Before posting, please check:
http:/
[TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database
'dbasename'
I get this every time I try to connect with mysql.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.my
Thanks, Ken.
> Your return of Poll 1 seems to indicated that there is a descriptor
> ready to be serviced (hence the going in continuosly) but that the
> daemon does not seem to be able to complete the servicing of that
> descriptor.
I've noticed rare occasions (about 1% of the time) when pol
hello all,
i'm having an unusual problem with mysql here in a bioinformatic
application. in these cases, the server "hangs" upon receiving a query. i
can't predict which queries will trigger the problem, but once one comes up,
even restarting the server doesn't keep it from happening. i also eras
Andrew Ward wrote:
> As I said, not all organisations were asked the same questions so I can't
> just put the data in directly
>
> The only way I can see of dealing with this is to create tables like
> ID,QUESTION,RESPONSE
> 1,"YEAR",2001
> 1,"SEX",1
>
> This doesn't strik
Problem Type: multiple servers using different mysql.sock/socket file
Hello,
I'm attempting to run 3.23.41 on a box that uses 3.22.21. Ultimately, the
3.23.41 version will replace the older version. In the meantime, I want to
run them concurrently during the upgrade process.
How should I go a
"jason bailey" <[EMAIL PROTECTED]> writes:
> HI,
>
> I'm a new user to Linux and am interested in MySQL and PHP. I currently use
> both as a developer elsewhere and am now trying to set up a test server at
> home.
>
> I've searched the MYSQL lists and notice that alot of people are getting a
>
Dear When I try to create this if show the below
mentioned error msg .Can some light on it?
mysql> create table usermaster(user_name varchar(50),
user_id varchar(40) Primary Key,
user_level varchar(8), password varchar(20), user_sex
varchar(1), user_dob varchar(10),
user_street varchar(50), user_
HI,
I'm a new user to Linux and am interested in MySQL and PHP. I currently use
both as a developer elsewhere and am now trying to set up a test server at
home.
I've searched the MYSQL lists and notice that alot of people are getting a
similar problem as myself and I'm not sure if any have got t
Andrew Ward writes:
> The only way I can see of dealing with this is to create tables like
> ID,QUESTION,RESPONSE
> 1,"YEAR",2001
> 1,"SEX",1
> 1,"AGE",3
> 1,"RATING A", 7
> 1,"RATING B", 6
> ...
>
> This doesn't strike me as very smart. I would greatly
At 4:10 PM -0400 9/4/01, Gil G. wrote:
>Hello,
>
>I recently started using MySQL on FreeBSD.
>Everything works great, except that I can't access a database created by root
>as another user. When I grant privileges, from the command line or phpmyadmin,
>things seem to work fine (no error message),
At 4:42 PM -0500 9/4/01, Islam, Sharif wrote:
>I have this two table.
>
>table1:
>
>ID NamePhone someother fileds
>1 Bob1234
>2 Joe 5678
>3 Mary5678
>4 John 6789
>
>table2:
>
>ID NameEmail
>1 Bob [EMAIL PROTECTED]
>2 Joe [EMAIL PROTECTED
Islam, Sharif writes:
> I have this two table.
LEFT JOIN
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
On Thu, Aug 30, 2001 at 01:44:56PM +0200, Sergei Golubchik wrote:
: Hi!
:
: On Aug 30, Alexander wrote:
: > Hello, mysql team!
: >
: > Any chance (in the near future) to get FullText indexing working with innodb
: > table handler?
: >
: > Alexander
:
: I doubt it will be done it the near futur
Hello MySQL users,
I've just started out with MySQL, and have already bought and read Paul
DuBois's excellent book. Nevertheless, I'm not exactly sure how to start
making a database for all the data I have.
What I have are responses from questionnaires administered to several
organisations over
Hi People,
I'm trying to connect to Mysql server using Access2k, VBA and DSN less
connection, and mysql v3.23.36.
All queries sent to the server exceute or returns records just fine except
one simple query.
"DESCRIBE Employees" Employees is a table in my database. the server
responds by :
"D
I somehow doubt this will work but try this::
Select * from t1, t2 where...
Yeah, that wont work. i havent tried it but I think it aint gonna help. I
send this anyway just as a what if.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Islam, Sharif" <[EMAIL PRO
I have this two table.
table1:
ID NamePhone someother fileds
1 Bob 1234
2 Joe 5678
3 Mary5678
4 John 6789
table2:
ID NameEmail
1 Bob [EMAIL PROTECTED]
2 Joe [EMAIL PROTECTED]
3 Johnjohn@
the query :
select t1.Name, t1
Hi, this is my first time posting to the list. I've followed mysql
replications how-tos to a tee...and I am still not able to get it to work.
the master mysql is running on a sun sparc station (SunOS 2.8) with mysql
3.23.41
the file /etc/my.cnf is as follows:
# The following options will be pa
- Original Message -
From: "chrish shea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 5:05 PM
Subject: installation and configuration!
> Hi
> I am new to this group.I want to install MySQL on win 2000.Let me know
from
> where we can get more information o
>currently, to list the last 100 records in a table I use this sql command:
>
>select * from test order by T desc limit 100;
>Note: "T" is the name of a field in my table "test" .
>
>can I instead use record number or use the count function to get the
>same result?
MySQL doesn't really have the
Hi
I am new to this group.I want to install MySQL on win 2000.Let me know from
where we can get more information on Installation and Confugration.
If some one has detailed list please send it.
Thanks
-Chris
_
Get your FREE download
currently, to list the last 100 records in a table I use this sql command:
select * from test order by T desc limit 100;
Note: "T" is the name of a field in my table "test" .
can I instead use record number or use the count function to get the same
result?
I don't have an index field in my tab
One problem:: Im new and dont know how to ping there. Help!!!
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Venu" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 3:09 PM
Subject: RE: Tro
Hello all,
I am trying to integrate the mysql with php. As I am
using the Red Hat 7.0, I know that they come
pre-installed and pre-configured. When i created
test.php with the line, the page
shows that the php is able to recognize mysql. I
created a small table 'namelist' in a database named
'ne
One problem might be if you are uploading it from a windows machine
where the lines are terminated by '\r\n' rather than a normal unix type
'\n'. I am not familiar with PHPMyAdmin so I am unsure whether or not
it accounts for that in the parsing of the file.
Curtis
-Original Message-
Fr
Hello,
I successfully populated a single column in a new table with a text file I
had using LOAD DATA INFILE command. I know that there are redundant entries
in the list that I would like to eliminate.
I would like some help designing a query to identify redundant entries and
then to delete the
Hello Sir,
I will delete most of your original message for brevity (to save
bandwidth). I do have a couple of suggestions, first is too back off
the optimzation (-O3 ) that you used to compile MySQL (probably in
make.conf) go with just -O. On an Idle system here kdump gives me a
call 'cloc
At 12:45 PM -0700 9/4/01, Curtis Spencer wrote:
>I have a text file with around 25 fields but I only want 5 of them.
>They are not the first 5 fields that I want. Is there a way to skip
>fields using LOAD DATA INFILE so I don't have to build a 25 field table
>and then cut it down?
>
>Thanks,
>Cu
I am just getting my feet wet in PHP and MySQL.
I'm using PHPMyAdmin to administer my databases online, and I'm having
trouble importing data from a textfile over the Internet. It imports
one record perfectly and then stops. It gives me no errors.
I have checked access privileges, and indeed
Hello,
I recently started using MySQL on FreeBSD.
Everything works great, except that I can't access a database created by root
as another user. When I grant privileges, from the command line or phpmyadmin,
things seem to work fine (no error message), but access is still denied.
I did restart MyS
)-Original Message-
)From: Deryck Henson [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 04, 2001 10:54 AM
)To: MySQL
)Subject: Trouble w/MySQL Server
)
)
)Well, I've fixed the problem with mysqld.exe and innodb, but the
)server wont
)connect with my ASP pages. Any ideas? Go to my
On Tue, 4 Sep 2001, Curtis Spencer wrote:
> I have a text file with around 25 fields but I only want 5 of them.
> They are not the first 5 fields that I want. Is there a way to skip
> fields using LOAD DATA INFILE so I don't have to build a 25 field table
> and then cut it down?
Read the manual
OK. Here are lines in between 60-70 about::
<%
Dim CheckUser
set CheckUser = Server.CreateObject("ADODB.Recordset")
CheckUser.ActiveConnection = dbpath
CheckUser.Source = "SELECT * FROM Members WHERE Username = '" +
Replace(CheckUser__myuser, "'", "''") + "' AND Confirmed = TRUE"
CheckUser.Curs
I am trying to load number of records into a database on a remote server.
For some reason, the loading always stops after about 500K records (538,328
to be precise). So, now I have a table with that many records. At the
mysql prompt, I try to insert a single, simple record, and it just hangs.
No
I have a text file with around 25 fields but I only want 5 of them.
They are not the first 5 fields that I want. Is there a way to skip
fields using LOAD DATA INFILE so I don't have to build a 25 field table
and then cut it down?
Thanks,
Curtis
Hello all,
I'm new to the list... Been using MySQL for various things for a year
now, but have never ran into the following situation...
I have a flat text file that I have exported from FileMaker Pro. I want
to import that into MySQL, but there's a catch... There are two tables I am
Hello,
This message is being sent to you because you either sent / or requested
this information from me. We are offering a full or part-time position using our
program. You can work at home. I do require that you have a computer and
are familar with internet/email functions. As to the salar
Carl Schrader wrote:
> Field Special 1 has a related field with a Start Date and another field
> for End date.
> Field Special 2 has a related field with a Start Date and another field
> for End date.
> Field Special 3 has a related field with a Start Date and another field
> for End date.
>
IMN
Thanks for all the prompt answers to my question. I logged in as root then
was able to use chown ; later found that chown wasn't in my PATH setting .
thanks again,
Bruce
-Original Message-
From: Paul DuBois <[EMAIL PROTECTED]>
To: Bruce W. Perry <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EM
Following the manual at http://www.mysql.com/doc/R/e/Resetting_permissions.html, I
still get the following error:
# mysqladmin -h 127.0.0.1 -u root password 'newpass'
mysqladmin: unable to change password; error: 'You must have privileges to update
tables in the mysql database to be able to cha
Just a thought - if your serial numbers have fixed format, then
programmatically remove the hyphen and store the number without it. Add it
back when displaying data on the screen. That way FULLTEXT will work on the
whole number without splitting it into two parts.
Vadim.
Marty McCoy wrote:
>
>
- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 10:54 AM
Subject: Trouble w/MySQL Server
> Well, I've fixed the problem with mysqld.exe and innodb, but the server
wont
> connect with my ASP pages. Any ideas
Well, I've fixed the problem with mysqld.exe and innodb, but the server wont
connect with my ASP pages. Any ideas? Go to my web site and try to log in
to get a better understanding of what I mean. This always comes up::
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC
> > Also my master.info ends up being wrong whenever the
> server is
> > rebooted. (binlog.100 becomes binlog.100\n).
>
> Can you expand on that problem a bit?
When I do a "show slave status" before a reboot I have this:
+-+-+-+---+-+-
Hi,
Thanks to all who responded to my previous question on how to get the
FULLTEXT search to consider hyphens as part of a word. Now my question is,
Is there a way to allow other special characters to be part of a
'word'? For example, we have the word "+x-axis" as part of a short
descriptio
Does anyone have an idea when MySQL will support Unicode? I know the
documentation says near future, but is that the next release or later?
Thanks,
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (th
Hello all,
I'm new to the list... Been using MySQL for various things for a year
now, but have never ran into the following situation...
I have a flat text file that I have exported from FileMaker Pro. I want
to import that into MySQL, but there's a catch... There are two tables I am
This question involves table setup questions as much as it involves a
query question. Bare with me, this seems hard to explain.
I have a table that includes records with 3 (relevant to this
conversation) fields (actually 9..more on that later). Each of those
fields have 2 other related fields. i.
MYSQL DATABASE BLA BLA BLA (I really hate that filter)
Ravi Raman writes:
> if i'm understanding what you mean, it seems like you're getting a little
> too complicated.
>
> select Title, IF(Title LIKE "%TOMMY%", 1, 0) as check
> from inv where...
> ... order by check desc, Title
Even s
At 8:47 AM -0400 9/4/01, Bruce W. Perry wrote:
>hello,
>
> I have installed MySQL 3.23 on Mac OS X 10.0.4 . I now have to change the
>ownership of the newly installed MySQL databases ( /usr/local/var ) to the
>"mysql" user that I have created in NetInfo Manager , in order to start up
>the databas
I'll bet somebody did a
cat afile > /usr/local/mysql/bin/mysql
instead of
cat afile | /usr/local/mysql/bin/mysql
That is why you should not be doing stuff as root.
s . keeling wrote:
> On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
>
>> so how to fix the error ?
>>
>> Ho
if i'm understanding what you mean, it seems like you're getting a little
too complicated.
select Title, IF(Title LIKE "%TOMMY%", 1, 0) as check
from inv where...
... order by check desc, Title
this will return rows like this:
+-+---+
| title | check |
+-+-
Close. Now I need to get the order correct. I need the order like
Tommy
Tommy Lee
Baseball(matched with Tommy in the Content or Notes field)
World Series (matched with Tommy in the Content or Notes field)
I've been playing with something like:
select Title, concat(IF(Title LIKE "%TOMMY%", 1
On Fri, 31 Aug 2001, Ary Medeiros wrote:
> I'm porting an application to MySQL and I need to support transactions.
> I will appreciate so much if someone could give me some impressions about
> which one is better. BerkeleyDB or InnoDB?
I have to agree with the other poster on this. When I first
At 11:16 AM -0400 9/4/01, Nick Willey wrote:
>Hi all,
>
>Is it possible to use a tape drive (/dev/ht0 in my case) as the destination
>for mysql logging? MySQL manual only mentions outputting to disk file.
>Example:
>
>% safe-mysqld --log-update= tar -czvf /dev/ht0/mysql-update.log
>
>I've tried t
Hi Sinisa,
Sinisa Milivojevic wrote:
>
> Peter Duffy writes:
> > Hi Sinisa,
> >
> >
> > Do you know of any which are specifically accessed by multi-threaded
> > client applications via ODBC? (If so, I'd really like to know, so that I
> > can try to get hold of copies of the client applications
Peter Harvey <[EMAIL PROTECTED]> writes:
> > That depends on what you install. MySQL isn't (like many other
> > packages) in any of the premade installation categories - you can
> > select it in a custom install, or do a "everything" install.
>
> I bet a product like Data Architect ( http://www.
I see... if adding "ORDER BY articleId DESC LIMIT 0, 20" causes a query to
start returning 0 rows, then that sounds like something is wrong.
Try using the REPAIR TABLE command on all your tables from inside MySQL,
e.g.:
REPAIR TABLE article;
REPAIR TABLE asubject;
REPAIR TABLE atype;
REPAIR TABL
> That depends on what you install. MySQL isn't (like many other
> packages) in any of the premade installation categories - you can
> select it in a custom install, or do a "everything" install.
I bet a product like Data Architect ( http://www.codebydesign.com )
would be a great fit in this dist
Hi,
I'm trying to install the mysql for Compaq Tru64 Unix 4.0f. I did the
download of file < mysql-3.23.41.tar >
# ./configure.
# make
...
...
+ rm -f ./typelib.c
+ /sbin/ln -s ../libmysql/typelib.c ./typelib.c
+ rm -f ./violite.c
+ /sbin/ln -s ../libmysql/violite.c ./violite.c
echo times
Hi all,
Is it possible to use a tape drive (/dev/ht0 in my case) as the destination
for mysql logging? MySQL manual only mentions outputting to disk file.
Example:
% safe-mysqld --log-update= tar -czvf /dev/ht0/mysql-update.log
I've tried the above with the following error in the error log:
C
Hi Everyone..
I've been doing a little bit of work on the intersection of crypto and
databases. MySQL is my favorite database, of course, but I've always been a
user rather than a developer. My current project involves authenticating a
user to mysqld using a smart card. I did a google search a
1 - 100 of 131 matches
Mail list logo
