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?
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
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 antonycur...@verizon.net
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
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
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
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
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
/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
= mysql_query($driverquery, $mysql_link);
print(select name='pick$i'\n);
while ($driverrows = mysql_fetch_array($driverresult))
{
print( option value =
'$driverrows[0]'$driverrows[1]/option\n);
}
print( /select\n);
}
HTH
Curtis
Afan Pasalic wrote
or as the docs read:
shell mysqladmin password your 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');
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
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 (preferably free) way
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 hosting periodically informs me
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)
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.cublog.cn
Maybe
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
listening on port 3306
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: Curtis Maurand [EMAIL
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 granted privileges
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 will only recognize
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
run
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
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]
wrote
.
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 Package and I want
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
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
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),
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 up as you add users
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
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
.
Thanks,
Curtis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
Please quit
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.innodb.com?
If
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'
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 'future_date', also a DATE field.
I don't know
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 I get
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/mysql
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
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 database, for load data infile. Note that
'admin
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
To unsubscribe
' into table
customer_tmp;
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using
password: YES)
Dan Buettner wrote:
Or possibly that the mysql user on the box does not have access to the
data file in question. Can you post the error messages you get?
Dan
On 8/15/06, Curtis
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
'admin'@'%' is not the same as 'admin'@'localhost'
See http://dev.mysql.com/doc
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 experienced
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
select criteria into outfile name of output file
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
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:
mysqladmin -u root password new password
Curtis
sheeri kritzer wrote:
Hi Alaister,
Your root password is not actually set. If you do
mysql -u root -ppassword
and it fails, it means that the password is not password
if you do
mysql -u root password
the mysql client will parse
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,
of 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
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
On Wed, 22 Jun 2005 [EMAIL PROTECTED] wrote:
You were SO close!!!
SELECT field list
FROM table references
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:
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 be waiting to see
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 can get this file
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 has built in MySQL support.
Alternatively, you
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 tables
; 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 compare 2 tables and keep getting an error.
SELECT * from listings where listings.id = fake.id
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 creating the tunnel
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
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 graph
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
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
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
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 get errors
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 then put
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]
to 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 unsubscribe
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
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 have install Mysql (the latest
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
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]
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 it he
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 harder to
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 with has
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]
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
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]
http
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:
Jacob,
I'd
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:
Usernames, passwords, and then perform the queries select ... where
customerid = the variable name you feed 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 clear
of
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 my tables
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 =
ENCODE(1234, 'foobar') ORDER BY last_name LIMIT
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. Are
you using PHP
:-)
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
false. As much of my work involves
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.
Curtis
On Wed, 3 Mar 2004, Mark Warner wrote:
The thing which bothers me most
rpm -e package
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
--
MySQL General
SELECT rest of query into OUTFILE some place the mysql user can write
to
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
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 face a failure
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.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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.
I have MySql installed
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 /
---
Like '%blah%' and x Like '%blub%' is too
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 General
-Original Message-
From: Ed Curtis [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:20 AM
To: [EMAIL PROTECTED]
Subject: Query matching
I've been challenged to write a matching query in a project and do not know
how to handle a part of it. The criteria
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: $somevaluebr\n);
Cheers
Curtis
Paul Fine said:
Greetinsg.
If I have a table like with a column being the PK for the table and
being an Auto
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 use
TINYINT(1) which works fine but is slightly
1 - 100 of 211 matches
Mail list logo