http://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.0/en/windows-source-build-cmake.html
step 4:
From the work directory, execute the win\build-vs8.bat or
win\build-vs71.bat file, depending on the version of Visual Studio you
have installed. The script invokes CMake, which generates the mysql.
Using deductive reasoning one would surmise that Effiong wants to
install the MySql Database on a laptop,
But then the question to Effiong is:
What Operating System is running on your LapTop?
NOTE: You'll need a MySql Server and a MySql Client, and maybe a Gui
Interface/WorkBench?
You can do
Database performance (like system performance) is always driven by a
give and take process, a trade-off between resources (this includes
design expertise) available, and the required results.
How many records are you dealing with?
How often are records are being added and/or updated?
How many u
Look at Nodejs, asynchronous server-side programming environment.
That combined with some basic MySql triggers could do it for you.
On 08/13/2012 04:07 PM, Rafael Valenzuela wrote:
Hi all,
i've a question about the mysql configuration, in my project, we need use
data in real time (read and ins
On Tue, 20 Oct 2009, DaWiz wrote:
I would try:
select max(object_id), term_taxonomy_id
group by term_taxonomy_id
order by term_taxonomy_id;
max(column) returns a single value so distinct is not needed.
The group by and order by should only have columns thaqt are displayed and
that are not agg
I'm trying to formulate a query on a Wordpress database that will give
me the highest 'object_id' with the highest 'term_taxonomy_id',
something like:
+-+--+
| max(distinct object_id) | term_taxonomy_id |
+-+--+
|
I wanted to respond with what I found:
APPARMOR blocks mysql from writing to any other directory than the data
dir and /tmp.
I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the
following:
/backups/mysql** rwk,
to the bottom.
Hope this helps someone.
Ray
--
MySQL General
night via cron
and feeding it back into Bar via cron.
Is there a way to set up real-time "replication" of that table?
--
WANT TO MODEL FOR MAC & BUMBLE? APPLY AT http://casting.macandbumble.com
-----
Eric And
query
>
> Just a thought, did you try running Optimize Table from the MySQL
> Administrator. I'm thinking that when you restarted it re-examined
the
> table statistics and was able to pick a better index.
> On Wed, January 17, 2007 14:31, John Anderson said:
_file_size=128M
innodb_additional_mem_pool_size=32M
innodb_thread_concurrency=16
innodb_commit_concurrency=4
innodb_flush_method=O_DIRECT
innodb_open_files=8192
innodb_sync_spin_loops=32
innodb_thread_sleep_delay=1000
innodb_autoextend_increment=1024M
innodb_file_per_table=TRUE
[client]
socket=/tmp/mysql.sock
John Anderson
Greetings,
It seems the lists.mysql.com imposes a 50KB limit on messages, so this
message will be sent in two parts. Thanks for your patience.
I'm in the process of converting most of my databases from MyISAM to
InnoDB, and I've come across the most peculiar problem. It seems that
after r
ome
computers), I'm in a bit of a situation. How does one setup a MySQL
account with no IP restrictions?
Thanks,
Brent Anderson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PPLY AT http://casting.macandbumble.com
-
Eric Anderson Mac and Bumble Bumble Cash
ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com
San Diego, CA<
AT http://casting.macandbumble.com
-----
Eric Anderson Mac and Bumble Bumble Cash
ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com
San Diego, CA<[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
yep, your're right
thanks for clearing that up :)
How do most mysql folks sync live and development databases ?
As an alternative, I could use a PHP script on a late-night crontab.
g
On Sep 13, 2006, at 1:11 AM, Chris wrote:
Graham Anderson wrote:
Is anyone using subversion to
Is anyone using subversion to sync live and development databases?
If so, how?
Is this desired or a best practice?
Everything except my databases are under version control.
In theory, I would like my databases to sync with the same subversion
'svn update' command.
That way, all web content up
Well if you'd share your specific problem I'm sure someone can help, but
more importantly why are you building from source anyway? There are
binary builds for most Solaris platforms, including 2.10.
Sorry I meant 10 theremy solaris experience comes from the 'old days'
before they went and
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prblem for some reason, I
I would like to withdraw my earlier bug report with the same subject
line. I discovered that an erroneous IP address for the server
machine had gotten into /etc/hosts (due to some IP changes in my
organization). Once the DNS error was resolved, I was able to connect
correctly and fix the password
>Description:
I'm sorry This is long, but it's because I've tried hard to fix this
myself; please bear with me.
Last week, for unknown reason, my root password for MySQL wasn't
working. I may have changed it without updating the "/root/.my.cnf"
file. So, I went to the online documentation (whic
Solved it with Union :)
SELECT images.id,images.name, playlist.title FROM images,playlist
WHERE playlist.image_id = images.id
UNION
SELECT images.id,images.name, media.title FROM images,media WHERE
media.image_id = images.id
ORDER BY id ASC
On Jun 23, 2006, at 6:44 PM, Graham Anderson
I am trying to build a query to
1) Get all the results from one table, 'images'
2) For each entry in the 'images' table, find the correct title from
the 'playlist' OR 'media' table where images.id = which_table.images_id
images table
id, filename
playlist table
title images_id
media table
t
many thanks Chris :)
g
On May 24, 2006, at 1:19 AM, Chris Sansom wrote:
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below
to use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT cat
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
AND page.category_id = category
utf8. Now I'm having this
problem.
I almost contacted you directly. Not sure if you recognize my name,
I'm with WNPRC.
--
Sterling Anderson
email/aim: sterling_anderson [at] mac.com
http://sterlinganderson.net/
608.577.7208
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stem is
not case sensitive but that shouldn't be an issued with varchar
fields should it?
--
Sterling Anderson
email/aim: sterling_anderson [at] mac.com
http://sterlinganderson.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ad on the slave.
--
-
Eric Anderson Mac and Bumble Bumble Cash
ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com
San Diego, CA<[EMAIL PROTECTED]>
es of connections also. Some are repeated queries to static tables
and others are dynamic read write to large tables.
Thanks in advance!
Ross Anderson
mysql 4.0.25
linux-2.6.14
key_buffer = 128M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 16M
thread_cach
Anderson wrote:
is there a way to make ORDER BY RAND() a bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.spanish as trac
is there a way to make ORDER BY RAND() at bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.sp
is there a way to make ORDER BY RAND() at bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.spa
Thanks in advance,
Ross Anderson
__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
got it to work
thanks
On May 10, 2005, at 7:22 PM, Graham Anderson wrote:
I have an ORDER statement like:
ORDER BY playlist.order_id ASC,RAND(playlistItems.playlist_order)
I am trying to get a random result very time the query is run ...
Unfortunately, this statement gives the SAME random
I have an ORDER statement like:
ORDER BY playlist.order_id ASC,RAND(playlistItems.playlist_order)
I am trying to get a random result very time the query is run ...
Unfortunately, this statement gives the SAME random result each time
how can I get mysql to randomly jumble the playlist items for a
r
how do I get the average number of hits per day
I have a table like:
DateTimeid ip
20050506190723 1 121.198.262
what I have so far
SELECT DateTime , count( * )
FROM userLog
GROUP BY DateTime
LIMIT 0 , 30
I assume that DateTime would have to be converted to a specific da
I have a query:
I am trying to get a percentage of the total for each city
SELECT userLog.city,userLog.region,
COUNT(*),
/*
Count(userLog.id) is always 1
was hoping to get the total row returned
*/
COUNT(*)/COUNT(userLog.id),
media.name,artist.name
FROM userLog,media,artist
WHERE userLog.medi
MySQL: 4.1.11
OS: Solaris
I have a database that stores Japanese in utf-8. I have NO problems if
the field is defined as VARCHAR, but if the field is defined as TEXT any
data after an extended character (Japanese, special symbols etc.) gets
truncated. Looking at the archives I ran the followin
Shawn :)
g
On Apr 13, 2005, at 11:00 AM, [EMAIL PROTECTED] wrote:
Graham Anderson <[EMAIL PROTECTED]> wrote on 04/13/2005 01:46:35 PM:
Hi
I am trying to set up my Match statements to filter the result of the
main query [which works]
If 'chris' does not exist in the first MATCH sta
Hi
I am trying to set up my Match statements to filter the result of the
main query [which works]
If 'chris' does not exist in the first MATCH statement [AND MATCH
(media.name, media.product)], then the results get a bit screwed up :(
If the first match statement finds something, then the quer
Here's a question for you guys: is it possible to have a replicated
table of type MERGE?
Scenario:
Server: WWW1
Table: A.local_table (MASTER)
replicates to:
Server: MEMBERS
Table: B.www1 (SLAVE)
and
Server: WWW2
Table: A.local_table (MASTER)
replicates to:
Server: MEMBERS
Table: B.www2 (SLAVE)
wh
how keys from
tbl_properties.php: Missing parameter: table
huh ?
On Apr 1, 2005, at 2:21 PM, Graham Anderson wrote:
In the simple query...
the city field showed the result 'Los Angeles' in every row
the distance field showed incorrect results to :(
City|
PM, Peter Brawley wrote:
What was wrong with Graham's simpler query?
PB
-
Graham Anderson wrote:
I upgraded my local mysql version to 4.1.10a and the below query
finally works :)
How can I now amend the query so it works on my remote server running
mysql 3.23.58 ? From one headache to ano
N ON C.CityID = N.PrimaryCityID
WHERE C.City = 'Los Angeles'
AND N.Distance <20
many many thanks to all those that replied :)
g
On Mar 31, 2005, at 11:49 PM, Philip M. Gollucci wrote:
Graham Anderson wrote:
What is the proper way to say this ?
SELECT C.City, N.Distance
FROM
What is the proper way to say this ?
SELECT C.City, N.Distance
FROM Cities C
JOIN Nearbycities N ON C.CityId = N.PrimaryCityId
WHERE N.CityId =
(SELECT Cities.CityId FROM Cities WHERE Cities.city = 'Los Angeles')
AND N.distance < 20
I am trying to enter in a city and get all the nearby cites with
this sql works on mysql version 3.23.58...my remote server
SELECT c.City, r.Region, co.Country
FROM subnets s, cities c, regions r, countries co
WHERE c.CityId = s.CityId
AND c.RegionID = r.RegionID
AND c.CountryID = co.CountryId
AND s.SubNetAddress = '24.24.172'
LIMIT 0 , 30
but the same syntax fa
I am trying to determine the average time that a Distinct IP address is
using the server
If I have 15 thousand records of ip addresses and access times like:
IP Now() media.id
--
10.1.7.205 20
I have 3 different tables I need data from
And, the tables have the potential to get fairly large
I am using mysql 4.1.3
This working query below pulls up all media requests for 'Yolanda
Perez' in Los Angeles
Is there a appreciably speedier way to say the below ?
I have begun dipping my toe
stupidly
My DateTime field is in this format:
March 23, 2005, 3:49 pm
If I want to run this sql
SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
FROM userLog
I gather I need some extra function like..
SELECT TO_DAYS(MAX(Convert _Function(DateTime))) -
TO_DAYS(MIN(Conv
how do you search for an empty field ?
I want to filter out records where the ipAddress field is empty
SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ?
many thanks
g
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
My server has mysql: version 3.23.58
// Performing SQL query
SELECT cities.city, regions.region, countries.country
FROM cities
JOIN subnets on subnets.cityid=subnets.cityid
JOIN regions on subnets.regionid=regions.regionid
JOIN countries on subnets.countryid=countries.countryid
where subnets.
I am trying to make a proper subqueryjust not sure bout the syntax
I use this this basic query to connect all of my tables:
# here is the basic query that connects all the tables..this works :)
$sql = 'SELECT playlist.name as playlist_name, artist.name as artist,'
. ' artist.'.$language.' as
36 AM
Subject: Re: Newbie: How to deal with multiple languages
Hello.
You can find an answer here:
http://dev.mysql.com/doc/mysql/en/Charset.html
MySQL supports column character sets on columns of some types
(char,varchar,text). Probably if I were you I would use Unicode
in my application.
Graham A
I am copy/pasting text from a microsoft word doc into phpmyadmin
are there any special tricks to avoid strange characters...most of my
text is in Spanish
The only thing that seems to work is converting the text to ASCII which
ditches all the Spanish formatting :(
is there some process to make t
many thanks :)
that was exactly what I needed
g
On Nov 26, 2004, at 4:27 PM, Rhino wrote:
- Original Message -
From: "Graham Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 6:28 PM
Subject: change field names in a query
what is t
what is the proper mysql syntax to change field names after the query
is done
if I have a table with:
id
englishText
spanishText
picture
And I query the table with:
select id, spanishText
from myTable
limit 30
how do I change the 'spanishText' field name to say 'language' ?
many thanks
g
--
MyS
I have a mysql db that contains tables with multiple language fields
for example...
Artist_id 'PK'
Artist_name
Artist_pictLink
Artist_purchaseLink
Artist_bio_Spanish
Artist_bio_English
Artist_bio_German
I have other tables with a similar layout...Is this needlessly
complicated ?
track_id 'PK'
I belive ive gotten mySQL installed, but im getting a few errors that I
cannot seem to figure out. When I try to test out the database by typing
bin/mysqlshow or bin/mysqlshow mysql I get an error that looks like this:
ryneanders01:/mysql# bin/mysqlshowbin/mysqlshow: Can't connect to local
MyS
FROM arp3_cam;
"
Why these query are much slow to me?
SET last_insert_id=(number);
SELECT LAST_INSERT_ID() AS id FROM arp3_cam;
Its necessary to examine all rows to get last id?
Its possible to change anything to speed up this query?
Thanks,
Anderson Oliveira.
--
MySQL General Mailing Lis
Sasha Pachev wrote:
Daniel R. Anderson wrote:
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
In theory, it could be
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: h
d slave respectively
and on his setup everything seemed to work - in any case there was no
error 1236.
My MySQL is 4.0.15-9, his is 4.0.17.
My Linux is SuSE 8.2, his is 7.3
Any further thoughts, we are snookered at the moment and haven't got
much of a notion what to do next (other than
Paul DuBois wrote:
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
"Duplicate entry '273' for key 1"
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had t
I got the following error on a perl script:
"Duplicate entry '273' for key 1"
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this happen, why did dropping and recreating work, and what can I do
ed.
Or should I exclude some or all of the contents of mysql from the
replication and maintain that database manually ???
Thanks for any tips.
Regards
Mike Anderson / Germany
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: MYSQL and PHP
I just noticed that my spam/virus filter is trapping and discarding
"Cc:"'s. If an email address is not in the "To:" line, you could also be
missing
some list traffic.
Just a comment!
thanks
dander
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I don't have much experience working with dates in Mysql; I've always
prefered to manage dates in code, so bear with me.
I've got the following definition (yes, no indexes right now):
CREATE TABLE se_t (
datestamp timestamp(14) NOT NULL,
remote_addr char(16) NOT NULL default '',
request_ur
> With such a small database it really boils down to just being tidy;
> you don't want indexes you're not going to use.
Well the database is going to be like 200MB and executing several
hundred queries a minute. Thus my concern about speed. Is a P4 w/ 1GB
RAM going to choke and die, or will inde
I have a database I'm using for a MMORPG (well, it isn't very
MM because I'm something of a noob), and I have a few questions about
indexing. I am storing world data in a database. In order to keep
everything as swift as possible, I have indexed everything. And I
really mean, e
I am using the Perl DBI to connect to a mySQL database. I am
using prepare and execute statements to send the query to the database
and then execute it. Is there any benefit to doing this versus using
do?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysq
libedit=undefined ]
)
! compile_readline=no
! compile_libedit=no
if [test "$with_libedit" = "yes"] && [test "$with_readline" = "yes"]
then
>Submitter-Id:
>Originator:Ric Anderson - SIRT
>Organization:
Ric Anderson, U of Ariz
> Is anything being logged in the error log?
Nope.
My 'wait_timeout' was set to 120 seconds, I reduced that down to 60
seconds but I don't think that will help because once it gets "stuck" in
this blocked thread thing, it never recovers.. any subsequent
connections never actually process, until t
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two
machines have a private connection between them (192.168.0.1 and
192.168.0.2).
The e450 is the master server, and the 1U has a copy (no replication)
of some basic data, so it can run server-intensive pages.
> Can you send show keys from campaign_t.
> I bet you can solve your problem by running analyze table.
mysql> show index from campaign_t\g
+++---+--+-+---+-+--++-+
| Table | Non_unique | Key_na
> Possibly because datestamp and 20041105 have different datatypes.
> There's an implicit data conversion required for the comparison, which
> in some cases prevents use of an index. Try writing '20041105' rather
> than 20041105 and see if that makes a difference.
Nope.. :-/
mysql> explain SELECT
> Can you send show keys from campaign_t.
> I bet you can solve your problem by running analyze table.
What's the syntax for 'show keys'?
--
--
Eric Anderson - ICQ: 3849549 - San Diego, CA
[EMAIL
Given the following table:
CREATE TABLE campaign_t (
acct_id int(11) unsigned NOT NULL default '0',
site_id tinyint(3) unsigned NOT NULL default '0',
ref_id int(11) unsigned NOT NULL default '0',
datestamp char(10) NOT NULL default '',
raws int(11) unsigned NOT NULL default '0',
uniqu
Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret this
stuf
The database is working fine, by the mysql command hangs indefinitely. Any thoughts
how I can determine the cause?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I should add that I can access the database via a java program, just not
using the mysql command.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'mysql -A sampdb' hangs as does every other mysql command. There are no
recent entries in hostname.err.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:52 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: R
.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 4:42 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem with MySQL and latest release of Mac OX X (Panther)
Can you post you're my.cnf options / your query in que
Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to
the latest release of Mac OS X this past weekend. As far as I can tell, the server
seems to be running, but when I attempt to execute the mysql command it just hangs.
Any ideas?
Thanks,
jim
--
MySQL General
Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of
a row that was just inserted? I'm using PHP, I don't know if that makes
a difference?
Something like:
INSERT INTO foo (bar) VALUES ("bar");
SELECT last_insert(id) FROM foo;
Also, are there any problems with using this in an
Is there one that's especially outstanding?
Thanks,
jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adam,
It works! I also had to run the initialization script...
Thanks very much for the help.
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE
l make the ownership/group changes you suggest below and let you
know the results.
Thanks!
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installati
tober 09, 2003 11:53 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem
James,
Yea, I have to agree its not starting.
Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe
ended
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem
James,
Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. Fir
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is
the server won't start and there don't seem to be any logs available to help diagnose
the problem. I've tried both
sudo safe_mysqld
Starting mysqld daemon with databases from /usr/local/my
I am having a problem in one of my scripts and I need to use
transactions to fix it. When I looked it up on the mySQL documentation
I found:
"If you are using transaction-safe tables (like InnoDB or BDB), you can
put MySQL into non-autocommit mode with the following command:"
Does this mean that
Well you could:
(assuming an installation in /usr/local/mysql)
# /usr/local/mysql/bin/mysqld --user=mysql > /usr/local/mysql/daemonlog
&> /usr/local/mysql/daemonerrorlog &
But you should probably consult the manual under the installation for an
explanation of exactly what the above does.
-Dan
> is there a way to find out which host I am connected
> from?
Does the solution have to be a function called within mySQL or would you
accept a function called by PHP or Perl?
-Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
I believe I saw something in the mySQL manual about going with a 64 bit
system if it was an option because mySQL uses lots of 64 bit data
types. So you will see a significant increase in speed with 64 bits
versus 32. :: drools at though of Apple w/ 8GB RAM :: :-D
-Dan
On Sat, 2003-09-20 at 08:1
I am creating a script which will grab a random row from a mySQL table.
Right now the way it is set up each time it calls COUNT(). I was
thinking of creating a script and running it as a cron job to update
count once every 10 minutes and store the number as an indexed array in
the table. It seem
I am trying to make my PHP script autodetect when a table in a mySQL
database exists, and when it doesn't, create it.
Is there some way to do something like:
SELECT * FROM tables WHERE name = "table_name";
And get a result I could test for truth, and thus run my script?
Thanks in advance,
Da
> There are 3.23, 4.0, 4.1, and 5.0 development trees, each at different
> stages of their lifetime.
Is there any reason not to use 4.0.15 and instead use 3.23 in a
production environment? I know MAX is unstable but I have 4.0.15
installed.
-Dan
--
MySQL General Mailing List
For list archives
Wasn't there just an announcement that 4.0.something was released?
-Dan
On Mon, 2003-09-15 at 12:52, Lenz Grimmer wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> MySQL 3.23.58, a new version of the popular Open Source/Free Software
> Database, has been released. It is now a
I am trying to update/insert a record into the table depending on whether it
exists in the table or not.
Something along the lines of...
IF (SELECT id FROM myable WHERE id="myid")
INSERT INTO mytable(id,name) VALUES ("myid", "myname")
ELSE
UPDATE mytable SET name="mynewname" WHERE
name would be returned and not
just products named only "foo"?
Thanks in Advance,
Dan Anderson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I think there is a way to insert binary image data in your html, but is
> there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic images are a /must
have/. :: bangs head against wal
1 - 100 of 178 matches
Mail list logo
