e* a_procedure* ?
You can pass the argument directly as long as it is not an INOUT parameter.
Antony T Curtis
atcur...@gmail.com
0523 C487 9187 6972 6894
AEC7 3087 F819 B477 B687
::1 is the IPv6 address for localhost.
On 18 Dec 2011, at 09:17, lourenstcc wrote:
Hi,
I installed mysql for mac os x. Now I am inspecting mysql.user and I
see entries for root which I am not to confident with.
On a debian installation there is no host=::1 entry
Can you explain this entry? (C
mysql> select date_format(now(),'%m-%d%-%y
%h:%i:%s') AS time;
+---+
|
time
|
+---+
| 11-11-11 11:11:11 |
+---+
1 row in set (0.00 sec)
Something you're doing is creating a very large temporary table as
part of handling it's query. Usual culprit would be something doing a
full table join combined with an "order by" or "group by" which would
typically cause MySQL to need to create a temp table.
You should do EXPLAINs on your
#x27;m seeing a slow down when I use LOCK TABLES versus
running the same queries without it. I'm just trying to find a
reason why that might be the case.
-Hank
On Thu, Sep 22, 2011 at 12:42 AM, Antony T Curtis > wrote:
LOCK TABLES...WRITE is very likely to reduce performance if you
LOCK TABLES...WRITE is very likely to reduce performance if you are
using a transactional storage engine, such as InnoDB/XtraDB or PBXT.
The reason is that only one connection is holding the write lock and
no other concurrent operation may occur on the table.
LOCK TABLES is only really usef
Alas, I mothballed my old RS/6000 AIX machine a few years ago. It was
getting quite old and only ran AIX 4.3
I had toyed with the idea of getting a more modern machine from ebay
but to be honest, I haven't had much time recently.
On 9 Sep 2011, at 08:22, Peter Gershkovich wrote:
I notice
in your code, you can define ranges of say if the model year being
looked for is 2002, then present model years 2000 thru 2004.
--Curtis
blackwater dev wrote:
Thanks but doing it in code would require me to pull in the entire car table
and process it. With potentially tons of rows, seems
I think what's really being sought after, here is clustering.
--C
Eric Bergen wrote:
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
conne
I figure that they'll either kill mysql or they'll limit the commnunity
version in ways that will make you purchase a commercial version if you
want to continue to use it. I figure there will be heavy migrations to
open source alternatives.
--C
Andy Shellam wrote:
I've just been made aware b
http://www.mydigitallife.info/2007/04/23/remove-or-trim-first-or-last-few-characters-in-mysql-database-with-sql/
Richard Reina wrote:
Hello All,
I can't get trim to trim the blank space from a TEXT field in the query below
and was wondering if someone could tell what I am doing wrong?
SELECT
it considering
> that the Access version of the database is already used in an ASP
> website?
>
see: http://dev.mysql.com/doc/refman/5.1/en/data-types.html
--Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
$driverresult = mysql_query($driverquery, $mysql_link);
print("\n");
while ($driverrows = mysql_fetch_array($driverresult))
{
print(" '$driverrows[0]'>$driverrows[1]\n");
}
print(" \n");
}
HTH
Curtis
or as the docs read:
shell> mysqladmin password
John Daisley wrote:
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> FLUS
I believe such things already exist, for example the Nitro storage
engine. There is a presentation about it at the coming MySQL
conference...
http://en.oreilly.com/mysql2009/public/schedule/detail/6984
Regards,
Antony
On 6 Feb 2009, at 14:50, Daevid Vincent wrote:
When our database reache
I'm not plugging the product, but I just ran into this:
http://www.dbconvert.com/product.php
It's $79.00.
--Curtis
Dan Nelson wrote:
In the last episode (Dec 29), mos said:
Someone has given me an Access 2007 file *.ACCDB and I don't have Access
2007. Is there a (preferab
but that might get reduced due to server load. I'm assuming mysql
doesn't like having ram taken away from it and get into a tizzy about it.
I've been forced to restart mysql hourly in order to get smooth operation.
--curtis
Alexey Vlasov wrote:
Hi.
One client from my shared h
You need the mdac components. free download from MS.
Sivasakthi wrote:
Hi all,
I have tried to import the excel to db , but i get the following error,
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
how can i install the Microsoft.Jet?
System Info:
OS Name Microsoft(R
rking on their own storage engine as well as the pluggable storage system.
Curtis
David Giragosian wrote:
On 7/21/08, Moon's Father <[EMAIL PROTECTED]> wrote:
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cub
I just checked my ubuntu config and I have:
Port = 3306
Bind-address = 0.0.0.0
Pid-file = /var/run/mysqld/mysqld.pid
Socket = /var/run/mysqld/mysqld.sock
Nothig is in upper case. My phone is doing that for me.
-Original Message-
From: "Jesse" <[EMAIL PROTECTED]>
To:
stead of a named
host, I've found that you have to code your grant statement to have an
ip address instead of a hostname.
Curtis
Jesse wrote:
Obvious question: Did you restart MySQL? netstat -l should show you
what's listening for connections. you'll want to see if its
li
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I gra
gnize two different sets of client libs.
Unless you're telling me that having them use the 5.0 client libraries
won't break working 3.23 apps...
On Wed, 2 Jul 2008, Curtis Maurand wrote:
Did you rebuild php against the 5.0 libraries as I suggested
yesterday? If you didn't it wil
Did you rebuild php against the 5.0 libraries as I suggested yesterday?
If you didn't it will only recognize the 3.23 version. It will not be
able to talk to the 5.0 version.
Curtis
[EMAIL PROTECTED] wrote:
It would appear that the problem isn't getting MySQL 3.23 and 5.0 to
On 20 Jun 2008, at 06:43, James wrote:
On Fri, June 20, 2008 9:12 am, robert rottermann wrote:
Hi there,
is it possible to define an update trigger that calls a webservice
(or
just some external method that would do it).
we have a web frontent, that does the indexing of data in its own
c
x27;s hope we include this
support in coming future.
Also, there is not enough documentation for the project mentioned:
http://forge.mysql.com/wiki/ProjectPage_External_Language_Stored_Procedures
Thanks again !!
Abhay Grewal
On Thu, Jun 5, 2008 at 11:04 AM, Antony T Curtis <[EMAIL PROTECTED]
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
indows and MacOS.
Regards,
Antony Curtis,
(Not speaking on behalf of my current or any prior employer)
On 4 Jun 2008, at 01:39, Abhayjeet Singh Grewal wrote:
Thanks Martin,
I looked at the link, but I guess I was not able to put my question
in the
right way.
Basically I have a Java Packa
Hi,
Currently there is no way but there is a WorkLog for implementing such
a feature,
It may be possible to encourage someone to implement such a feature
request.
Regards,
Antony.
On 6 May 2008, at 14:58, Bryan Cantwell wrote:
Is there no way to step thru a stored proc in order to de
Missing feature not mentioned...
Falcon works on PowerPC and UltraSparc.
Regards,
Antony
On 10 Mar, 2008, at 11:53, Joerg Bruehe wrote:
Dear MySQL users,
MySQL 6.0.4-alpha, a new version of the MySQL database system
including
the Falcon transactional storage engine (now at beta stage), ha
I think that I'd set up a varchar column and store a tab separated
list in it.
Then parse it upon retrieval.
Curtis
Dan Buettner wrote:
> Waynn, I've used
both schemes 1 and 2 as you describe, and in my
> experience
> 2 is the best way to go. It's easy to scale
I'm doing the above migration as mentioned in the subject line. I
figured I would use the MySQL Migration Toolkit to help it along but it
won't let me connect to my 3.23.49 server. Is there any other way to
migrate all my data easily.
Thanks,
Ed
--
MySQL General Mailing List
For list archiv
I need to get some duplicate record information from a table and I
haven't found any way to do it yet. I figured there might be some type
of query I could do using a "for each" type command.
What I have is a table with names and companies. Some people have
multiple entries for different compan
a that you need.
Thanks,
Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just checked it again and its working.
Francesco Riosa wrote:
> Heikki Tuuri ha scritto:
>> Bill,
>>
>> we are moving the DNS of innodb.com from Capnova to Oracle Corp.
>>
>> I can now view http://www.innodb.com through my ISP, Elisa. Does
>> anyone still have problems accessing http://www.inno
you?
They have absolutely no interest in helping MySQL survive.
Sounds pretty fishy to me no matter what they're saying publicly.
Curtis
Bill MacAllister wrote:
>
>
> --On Friday, November 10, 2006 08:46:50 AM -0500 Curtis Maurand
> <[EMAIL PROTECTED]> wrote:
>
>
http://www.oracle.com/innodb/index.html
Riemer Palstra wrote:
> On Thu, Nov 09, 2006 at 09:26:52AM -0800, Bill MacAllister wrote:
>> What happened to the Innodb web pages? What comes up for be is a
>> search page with a bunch of related links on it. I wanted to pull
>> down a copy of ibbackup d
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Oops, also the $this_date
>
> UPDATE this_table SET
> this_date = '$this_date',
> future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
Got it going guys, thanks again
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Please check your syntax.
> It should look like this:
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
>
> Don't forget your WHERE clause or else you populate every row.
Tried it, this is what
On Wed, 11 Oct 2006, Mark Leith wrote:
> Ed Curtis wrote:
> > I'm having some trouble setting a future date within a table. I have one
> > column 'this_date' which is a DATE field and I'm trying to add 90 days to
> > it and set a column named 'fu
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
the 'this_date' and
I'm trying to do a keyword search within a phrase saved in a table.
Here's the query:
SELECT * from closedtickets WHERE
keyphrase LIKE '%$keyword1%'
OR keyphrase LIKE '%$keyword2%'
OR keyphrase LIKE '%$keyword3%'
The problem I'm having is that the query is returning every record in th
You were right. Its a global privilege not a table one. I granted it at
a global level. it can't be granted at the databae level
Dan Buettner wrote:
> Curtis, you might need to make sure 'admin'@'localhost' has 'FILE'
> privileges in the proper d
just locks up when I go to manage users. i've been working it from the
command line.
Curtis
Dan Buettner wrote:
> Curtis, you might need to make sure 'admin'@'localhost' has 'FILE'
> privileges in the proper database, for load data infile. Note that
>
rror messages you get?
>
> Dan
>
>
> On 8/15/06, Curtis Maurand <[EMAIL PROTECTED]> wrote:
>> This may sound like a stupid question, but I have to ask. I've been
>> running a script that goes like the following.
>>
>>
>>
>> use ecommerce;
_tmp;
at which point the script fails for permssion reasons. It seems that this
user can create a temporary table, but not load data into it?
What did I miss on permissions to allow this to work?
Thanks
Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I'm the author of the O'Reilly book "Backup & Recovery," due to be
released in Q3 of this year.
Among other things, it has a chapter on backing up MySQL.
I'm looking for a few MySQL-knowledgeable folks to provide a technical
review of this chapter. Obviously I'd want you to be experience
I have a column in a table I need to replace a value of certain records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy way to do this. There are way too
many records to do it one record at a time.
Thanks,
Ed
--
MySQL General Mailin
select into outfile
The path for the output file must be writeable by the user underwhich
mysql is running.
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Fri, 24 Mar 2006, Pure Web Solution wrote:
you can manipulate mysqldump using the where clause (check the
Does anyone on the list know what REITF stands for? I'm guessing it's
some type of data format for real estate information but I can't find any
information on it anywhere.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
mysqladmin -u root password
Curtis
sheeri kritzer wrote:
> Hi Alaister,
>
> Your root password is not actually set. If you do
>
> mysql -u root -p
> and it fails, it means that the password is not
>
> if you do
>
> mysql -u root
>
> the mysql clien
I could be wrong but this may have something to do with ownership and
permissions of the socket file. I recently upgraded my MySQL version and
had basically the same problem. I can't remember though if I had to change
the ownership to root.root or mysql.mysql.
HTH,
Ed
On Mon, 26 Sep 2005, San
software. Server 2K3 has been much more
stable than Windows NT and its security is better, but still not great.
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
go to
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/information/
benchmark-results/result-mysql-platform
On Wed, 22 Jun 2005 [EMAIL PROTECTED] wrote:
> You were SO close!!!
>
> SELECT
> FROM
> WHERE CHAR_LENGTH(varcharfield) >= 60;
Thanks so much. I knew I was close but couldn't remember the exact
command.
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
I've been cruising the docs for a while now and can't find what I'm
looking for. I know it has soemthing to do with value or LEN or something
easy like that but I just can't find the right command structure.
I need to list the rows in a table where the length of a field, lets say
field1 is a mini
the socket file is created in the spot specified in /etc/mysql/my.cnf.
In my case its:
socket = /var/run/mysqld/mysqld.sock
as always ymmv.
Curtis
ganesan malairaja wrote:
>
> is it possible a firewall is denying mysql to create the mysql.sock file
>
> if not where i
While you're at it, take a look at Gentoo Linux
(http://www.gentoo.org). I've been having very good luck with it on
everything from a Duron 1GHz to Opterons. Very responsive. It compiled
a kernel on an opteron in about 5 minutes.
Curtis
Atle Veka wrote:
>Excellent, I'll
Using ODBC, however, you can link Access tables to MySQL tables and use
Access as the front end to MySQL. It works very nicely.
Curtis
Martijn Tonies said:
>> > > Alternatively you could use OpenOffice.org
> (http://www.openoffice.org/)
>> > > which
= fake.id; it
> simply doesn't know where to get fake.id
>
>
> >From: Ed Curtis <[EMAIL PROTECTED]>
> >To: mysql@lists.mysql.com
> >Subject: SELECT ERROR
> >Date: Wed, 23 Feb 2005 08:02:21 -0500 (EST)
> >
> >
> >I'm trying to com
I'm trying to compare 2 tables and keep getting an error.
SELECT * from listings where listings.id = fake.id;
The error is "Error 1109: Unknown table 'fake' in where clause"
or "Error 1109: Unknown table 'listings' in where clause" depending on
the table order at the end of the query.
Both tabl
I know this is possible but I'm not real sure of the command to use. I
have 2 tables that are pretty much identical except for one column. What I
want to do is moved data from one table column to the other table column
based on a matching id number that is also a column in both tables called
"id".
> > I am trying to connect to my mysql server through an SSH tunnel.
> > On the server, I have a local instance of mysql running, but one of the
> > hosted domains needs to access another remote mysql server. For security,
> > I want to connect to the remote server via an ssh tunnel.
> > I am crea
I am trying to connect to my mysql server through an SSH tunnel.
On the server, I have a local instance of mysql running, but one of the hosted
domains needs to access another remote mysql server. For security, I want to
connect to the remote server via an ssh tunnel.
I am creating the tunnel usin
There are several PHP scripts that develop graphs. You'll have do some
work to feed the data to them, but I found them at:
http://www.hotscripts.com/PHP/Scripts_and Programs/Graphs_and_Charts/
Curtis
Jim wrote:
Jason Martin wrote:
Does anyone know of a web-based tool that will let you
I've been searching the docs and can't find examples how to do what I
need to do. I need to exclude some records from my SELECT statement
results but it appears I can't use (=, != or LIKE) for it.
What I have is a result set having a column name 'path'. I need to
exclude any record reulting in
If you follow the instructions properly, you can get the ISAPI version
of PHP to run and it it runs pretty well once installed.
Curtis
Don Stefani wrote:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev
Use the ODBC connector and write it in VB.
Curtis
Chris Mason wrote:
I have a mysql database runing on an internal linux server and I need to
connect to it with an appliication running on a windows workstation. The
application must start another application with command line informaiton
from the
OK, now I really feel stupid. It helps to change the ownership of the
files to mysql:mysqlduh.
Curtis
Curtis Maurand wrote:
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and th
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created
ones, the database is recognized, but i
es are not recognized.
I'd really like to get this data back is there a way?
Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you would be using
Apache 2 as it has some quirks that haven't been worked out yet.
I've been using Apache 2 with PHP 4 for quite some time. Its been
working fine for me and my customers.
Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database. I'm using php and a form select list to get this value from
a pre
You have to rebuild PHP against the new MySQL libraries.
Curtis
Greg Donald said:
> On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
> <[EMAIL PROTECTED]> wrote:
>> This more of a php mysql question. I have installed PHP ( 5.01) with
>> Apache(1.31) and it runs.
>
> I think a quick way to write this query would be
> (http://dev.mysql.com/doc/mysql/en/UNION.html):
>
> ( SELECT magazine FROM pages )
> UNION DISTINCT
> ( SELECT magazine FROM pdflog )
> ORDER BY magazine;
Thanks for all the help on this one. I just also realized that the server
I'm working wi
> What he is really missing is the WHERE clause that matches something from
> pages with something from pdflogWithout it he is requesting a
> Cartesian product of his tables (every combination of each row from both
> tables).
>
> I prefer to define my JOINS *explicitly*. It makes it harde
On Mon, 9 Aug 2004 [EMAIL PROTECTED] wrote:
> He does have a join. He has an *implied* INNER JOIN
> (http://dev.mysql.com/doc/mysql/en/JOIN.html):
>
> FROM pages, pdflog
>
> What he is really missing is the WHERE clause that matches something from
> pages with something from pdflogWithout
>
> Feel stupid again ;-)
>
> Where's your JOIN?
>
> With regards,
>
> Martijn Tonies
Thanks, that makes me feel better :)
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
God, I feel real stupid this morning and know I should know this. I have
2 tables in the same database and I'm trying to select distinct data from
a row with the same name in each table.
SELECT DISTINCT company FROM pages, pdflog ORDER BY company ASC
I'm missing something I'm sure because it doe
Yes,
Linux RH9 2.4.08
When I run the /opt/lampp/lampp start
command, Apache starts, SSL, starts and another service, mysql seems to
start. But when I try to connect to mysql with admin or cc or other
tools, so I can setup databases and tables, it tells me mysql is not
running.
Then I issue /opt/l
erver through socket
'/opt/lampp/var/mysql/mysql.sock' (2)
Any suggestions ?
Curtis Seyfried
[EMAIL PROTECTED]
Bronx, NYC, NY. USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think that I'd look at postfix and dbmail. Postfix and dbmail both
allow userdata to be stored in MySQL databases. dbmail will also put the
message store in a mysql database. Very nice, very fast. RH9 has hit
eol. Gentoo rocks.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
Reiser is good for lots of small files. ext3 would is better for
large ones. At least that's what I get from the benchmark data that I've
seen posted in various places.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Wed, 12 May 2004, Roy Butler wrote:
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Usernames, passwords, and then perform the queries select ... where
customerid = "" Its all handled by your app.
Curtis
On Wed, 10 Mar 2004, Mulugeta Maru wrote:
> Hi Mike,
>
> I am sorry for the confusion I might have caused. May be it would help to
> give a cle
their user id for them via cookies or sessions or something though.
Ed Curtis
On Tue, 9 Mar 2004, Mulugeta Maru wrote:
> Thank you for the kind response. May be I did not clearly ask the question.
> The user table in mysql database is used to set-up a user and password. Once
> I set-up
There's a whole list of all the functions at http://www.php.net
Curtis
On Thu, 4 Mar 2004, James Marcinek wrote:
> Rhino,
>
> I know this is an off topic; however I see that you have DB2 experience.
> Most of the information I have a question you might be able to answer. Ar
WHERE password = password('1234');
Curtis
On Thu, 4 Mar 2004, Victoria Reznichenko wrote:
> Scott Haneda <[EMAIL PROTECTED]> wrote:
> > Here is what I am doing now...
> >
> > SELECT id, first_name, last_name, password FROM account WHERE password =
I know, I get it, I was trying for humor.
Curtis
On Wed, 3 Mar 2004, Michael Stassen wrote:
>
> Curtis Maurand wrote:
> > :-)
> >
> > someflag enum('TRUE','FALSE');
> >
> > Not quite boolean, but it works.
> >
> > Curt
:-)
someflag enum('TRUE','FALSE');
Not quite boolean, but it works.
Curtis
On Wed, 3 Mar 2004, Mark Warner wrote:
> The thing which bothers me most about MySQL is the lack of a proper
> boolean. I don't like having to abstract a tinyint(1) into true or
>
rpm -e
Curtis
On Tue, 2 Mar 2004, Rafael Diaz Valdes wrote:
>
> Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to
> install MySQL, but how can I delete it.
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
There are many companies that develop on MySQL then market the product
with Oracle for the same reasons you statethe name.
curtis
On Mon, 1 Mar 2004, Leo wrote:
> After two years of developing a new system based on MySQL
> for the company i work at...
>
> it turned out to fa
SELECT into OUTFILE "
Should get you a tab delimited file there are more options for using
different delimiters and field encapsulations, etc. Its in the manual.
curtis
On Sun, 29 Feb 2004, Joshua Beall wrote:
> Hi All,
>
> I am wondering if anyone can point me to a uti
ultiple transactions outstanding. Is this something that might be added
> to MySQL in future or am I totally overestimating the expense of using
> one thread per connection?
>
> Regards,
>
> Chris
>
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.m
Did you install PHP-mysql*.rpm?
Curtis
On Tue, 10 Feb 2004, Eric W. Holzapfel wrote:
> Hello Listers,
>
> I have a problem with my PHP/redhat setup, and possible problem with my
> Mysql setup.
> I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system.
Have you tried "explain?" Have you indexed the table?
Curtis
On Sun, 8 Feb 2004, ___bug wrote:
> Hello,
>
>
> What is the best way to search a table with about 500.000 rows of varchar
> type.
> ---
> / id / time / name /
>
g.orig_id = pages.mls_11 OR
> changelog.orig_id = pages.mls_12
> )
>
> John A. McCaskey
>
>
>
> -Original Message-
> From: Ed Curtis [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 10:20 AM
> To: [EMAIL PROTECTED]
> Subject: Query matching
>
mls_6
changelog.orig_id = pages.mls_7
changelog.orig_id = pages.mls_8
changelog.orig_id = pages.mls_9
changelog.orig_id = pages.mls_10
changelog.orig_id = pages.mls_11
changelog.orig_id = pages.mls_12
Would I nest these as an OR statement and how would I go about it?
Thanks,
Ed Curtis
--
MySQL Ge
I didn't know if this was possible and haven't tried yet. My boss wants
me to sort results by 3 columns (city, county, price.) He would like city
and county in alphabetical order a-z and have price from highest to
lowest. I told him I didn't think it was possible to sort two different
fields one
select last_insert_id();
or in php use the mysql_insert_id() eg:
$somevalue = mysql_insert_id();
print ("The last auto incremented number was: $somevalue\n");
Cheers
Curtis
Paul Fine said:
> Greetinsg.
>
> If I have a table like with a column being the PK for the table
Matthew Stanfield said:
> Hi,
Usually, i'll use "enum('0','1')" in place of a boolean type.
Curtis
[snip]
> well. The only annoying thing I can think of, from a programming
> perspective, is MySQL's lack of a Boolean type - the manual says u
1 - 100 of 216 matches
Mail list logo
