Web Page Hit Counter

I am trying to log activity on a web site and then display the activity. I want to be able to break it down by hour eventually. Right now I would like to get the total hits and the hits for today. I have created a table like the one below. create table hits (page_id INTEGER, htime DATETIME);

Re: Query problems

Create a merge table of the year 2000 and year 2001 tables as follows. Then run your select on the merged table. You can then drop the merge table if you don't need it anymore. CREATE TABLE table3 (name, distance, date) TYPE=MERGE UNION=(table1,table2); SELECT name, SUM(distance) FROM table3 GR

Re: bug report

Hello Aurelian, I do the same thing but use the following code and it works fine. SELECT @myvar := DATE_SUB( CURRENT_DATE, INTERVAL 1 DAY) ; Edward 5/1/2001 6:45:19 AM, "Aurelian Dumitru" <[EMAIL PROTECTED]> wrote: > > >Please record the following bug identified on the MySQL server: > >1

Query problem

Setup TITLES: TITLE_ID AUTHORS: AUTHOR_ID TITLE_AUTHOR: (TITLE_ID,AUTHOR_ID) Problem: Given a title, I need to find all the authors who aren't connected with that particular book. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Re: Query problem

Rhino wrote: - Original Message - From: "John Meyer" <[EMAIL PROTECTED]> To: "List: MySQL" Sent: Tuesday, May 30, 2006 5:09 PM Subject: Query problem Setup TITLES: TITLE_ID AUTHORS: AUTHOR_ID TITLE_AUTHOR: (TITLE_ID,AUTHOR_ID) Problem: Given a tit

Re: MySql GUI

Chris Sansom wrote: At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote: I would agree, I have found it useful as well. It does have a few limitations (well the versions I've used) BTW, what are the limits on OpenOffice's Base being used as a front end? -- MySQL General Mailing List F

Re: [PHP] corrupt pdfs

tedd wrote: Yes, I was wondering that myself considering the onslaught of "no-no's" one gets by suggesting placing images into a dB. A PDf file is really not that much different and probably better served via file system. tedd On the other hand, you get control of the images, as opposed to r

Re: Sad, I know...

tomáz rezistänz wrote: I wish I could uninstall mySQL and start over but I don't know how.. On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote: Do you know how to dump your mySQL databases? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Re: Re-importing a mysqldump file

Ian Barnes wrote: Is this possible? Or would the best way be to import the dumped file into a temp table and then select out of the temp table into my correct table ? Anyway to use a trigger? -- Online library -- http://pueblonative.110mb.com 126 books and counting. -- MySQL General Mailing

Re: PostgreSQL or mySQL

Chris White wrote: On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote: I have very little knowledge of either PostgreeSQL or mySQL. Please advise me as to which of these two software package to use? I need some specific examples as to superiority of one package over the other. I prefer using

Re: database back up

Joko Siswanto wrote: Dear All if myqsl service can't start, where can i found the file and back up it? [under windows and linux] Thanks, Joko Siswanto What file are you looking for? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: MySQL 4.1.21 has been released

;* The ref optimizer could choose the ref_or_null access method > in cases where it was not applicable. This could cause > inconsistent EXPLAIN or SELECT results for a given statement. > (Bug#16798: http://bugs.mysql.com/16798) >* ANALYZE TABLE for TEMPORARY t

RE: Database Return Errors

Have you checked out MyConnector/NET and the MySqlException class? -Original Message- From: Asif Lodhi [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 6:17 AM To: mysql@lists.mysql.com Subject: Database Return Errors Hi, I am developing a VB6 app with a MySQL-5.0.22/WinXP bac

Doing a join

I have two tables: MEMBERS: MEM_ID ... GROUPS: GRO_ID: ... And one joiner MEM_GRO: MEM_ID, GRO_ID I want to print out a list like this GROUP_NAME, NUMBER_OF_MEMBERS Even when the number of members is 0, how do I do that? -- MySQL General Mailing List For list archives: http://lists.mys

RE: Check out this Free software I found to document your IT infrastructure

You know this might be a little bit more convincing if you gave the name of the product and a little bit more personal reason why you recommended it other than "check out brand x product" I vote this is spam. -Original Message- From: itguy321 [mailto:[EMAIL PROTECTED] Sent: Wednesday, A

RE: Is this query possible?

I've dealt with this in terms of Books and Titles. Those two are separate: one title can have many book editions published in it. Also, you can have a book with multiple titles (anthology, for instance). I suppose it is possible for album not to be the same as cd title, particularly if you have o

RE: Doing a join

Yeah, I just figured it out ten minutes ago, one of those stupid little oversites on my part. -Original Message- From: Martin Jespersen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 3:40 PM To: John Meyer Cc: mysql@lists.mysql.com Subject: Re: Doing a join select

RE: Doing a join

Sorry, but that's how I was normally trained to use SQL and to name variables. I know netiquette, it's just how I was trained on the system. -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 11:35 AM To: John Meyer Cc: mysql@lists

Re: Check out this Free software I found to document your IT infrastruct

I think equating a tagline indicating something's been spam-checked with a full out message for a web product is a little absurd. On 8/3/06, Ian <[EMAIL PROTECTED]> wrote: You say you hate spam then spam the list with an advert for McAfee! Ian -- "I'm American, fatboy. What's your excuse?"

Re: AW: Query problem

SELECT DISTINCT username, time, download FROM table ORDER BY time DESC GROUP BY username André Hänsel wrote: > Hi Dan, hi Obed, > > of course I have no specific username, I want the last 5 downloads of each > distinct username in the table. :) > > Regards, > André > >> -Ursprüngliche Nachr

Re: AW: Query problem

ecting * limit 5 where username = view.username. See >> where that's >> headed? You may need a temporary table. > > Assuming I have a (temporary) table of usernames, how can that be of any > help? > > all right, here's how this goes. Cr

RE: Backup SQL

If you're using Myphpadmin, you can turn this option off when generating the dump file. -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 12:14 PM To: mysql@lists.mysql.com Subject: Re: Backup SQL On Friday 04 August 2006 10:35 am, Daniel da Vei

RE: Database design question

One table, USERS Another table MESSAGES With a foreign key referencing users. Maybe a second foreign key referencing the destinating user as well. -Original Message- From: James Tu [mailto:[EMAIL PROTECTED] Sent: Monday, August 07, 2006 1:56 PM To: mysql@lists.mysql.com Subject: Databa

Re: Can a row be refered using row number?

> Bob I don't know, maybe that's what Ravi was referring to. In which case, I'd direct ravi to the auto_increment attribute for an INT and the primary key. -- John Meyer http://pueblonative.wordpress.com http://pueblonative.110mb.com/board -- MySQL General Mailing List For

Re: mysql naming convention

s. Probably isn't the best system, but it's what I've worked with so far. That and naming the primary key on a table with the suffix ID. Foreign Keys have the same name as they do on primary keys. Simple, strong, ugly, and dignified -- John Meyer http://pueblonative.wordpress.com http:

Re: [PHP] switch()

[EMAIL PROTECTED] wrote: I have something like this: when I tried to use swiitch() it will give me only the first true case. if $result['col_1'] == 'value_1' is true 2nd case will never be executed? Does it mean I CANNOT use switch() in this case? -afan Why do you want to use a switch i

Re: [PHP] switch()

[EMAIL PROTECTED] wrote: Why do you want to use a switch in this particular instance. You're comparing apples and oranges (in this case, col_1 and col_2). You use swithc to evaluate one variable against a number of choice, not multiple variables against variable choices. I'm not compari

Re: Setting Up MySQL Administrator

David Blomstrom wrote: I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what "stored connection" and "Server Host" mean? I'm using Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is listed under "Port" by default. Also, what ar

Re: Setting Up MySQL Administrator

David Blomstrom wrote: OK, I'm halfway there. But I don't understand what you mean by "saved settings." Is there some sort of default value I can try? Also, if I can't recover my password, is there a file I can open and retrieve it from? I tried it with localhost, Port 3306, Username: root an

Re: New to MySQL

On Saturday 24 December 2005 1:05 pm, James Lumb wrote: > Hi, > I am new to mySQL and have mac OS X. Please could any other Mac users or > anyone for that matter tell me the best way of connecting to a mySQL > database? > Should I use terminal or a program like PHPmyAdmin? > > Cheers, > James Jam

Re: I'm new to mySQL

On Saturday 24 December 2005 1:05 pm, James Lumb wrote: > Hi, > I am new to mySQL and have mac OS X. Please could any other Mac users or > anyone for that matter tell me the best way of connecting to a mySQL > database? > Should I use terminal or a program like PHPmyAdmin? > > Cheers, > James Jam

Re: Need Help Writing a Trigger

On Tuesday 27 December 2005 2:34 pm, Jesse wrote: > I'm trying to write a trigger that will update the age of a camper when > ever a record is updated or inserted. I have a table named Campers which > contains basic information about the camper as well as their birthday. I > have another table na

Re: Force max query time, or max records returned

On Friday 30 December 2005 3:31 pm, Scott Baker wrote: > > How can I prevent this? > > Scott You know when I deal with users like this, I like to think about what Dennis Leary said about spanking children; "I don't need to spank them, I find that waving the gun around works just as well." -

Re: working w/UK postcodes

Mike Blezien wrote: Yes, after some further research, I found a Perl Modules that handles this queit nicely. thx's Please tell me where this module is, if you would. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: script error in program.

Jon Miller wrote: Having an error in a script that I cannot figure out why it's not working. The problem is on line 15 "while ($row = mysql_fetch_object" ($result)). What, exactly is the error? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Kinda OT: Book database question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm trying to develop my own book database, and I have a question about ISBN: Is that number linked to a book or to a title? That is, can one title (say, Huckleberry Finn) have several ISBNs associated with it through several book releases? -B

Re: A good US Hosting Site?

I haven't had a problem with Hostgator yet. Prices are fair and reasonable Also I've installed web apps through their portal and on my own and haven't had a problem yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?u

Re: Sun bought by Oracle

I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Sun bought by Oracle

Yep. In particular the anti-trust division of the DOJ. Kaushal Shriyan wrote: > > On Mon, Apr 20, 2009 at 11:14 PM, John Meyer <mailto:john.l.me...@gmail.com>> wrote: > > I'm wondering what the DOJ is going to think of that deal. > > -- > MySQL

Date Time

Is "Thu May 21 03:15:28 + 2009" a valid date/time string? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Date Time

Janek Bogucki wrote: Hi John, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes some information about acceptable literal forms for dates and times. 'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but this is how to parse it APART from the time zone com

Re: Date Time

Janek Bogucki wrote: Hi John, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes some information about acceptable literal forms for dates and times. 'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but this is how to parse it APART from the time zone com

Re: What OS is the best platform for MySQL ?

Ken Menzel wrote: > Dan Nelson wrote: >> In the last episode (Jul 06), Blog Tieng Viet said: >>> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of >>> problems related to thread management. And 1 year ago, I found that my >>> FreeBSD box does not go well with any MySQL revisio

Re: What OS is the best platform for MySQL ?

Carlos Williams wrote: > On Wed, Jul 8, 2009 at 12:21 PM, John Meyer wrote: >> Do we really need to bash OS's for MySQL. Rather than questioning what >> OS is best for MySQL we should ask how we can optimize MySQL for each OS. > > Did I mis-read an email or can someon

MySQL query working directly but not through .NET connection

Here's the query: INSERT INTO USERS(USER_ID,USER_NAME,USER_SCREENNAME,USER_DESCRIPTION,USER_FOLLOWERS,USER_IMAGE,USER_FRIENDS,USER_LOCATION,USER_CREATEDAT) VALUES('31264066','Justin Wienkers','BabyVegaz','I’m your secondhand news/yeah. That and an (aspiring) screenwriter, trained journalist,

show tables is slow/uncached

les" is so slow? Is there any way to speed this up? We can create our own table with a cached copy of the results of "show tables", but we would prefer to avoid that because it is kludgy. thanks! -larry Larry Meyer lar...@soe.ucsc.edu UCSC Genome

Re: Viable alternatives to SQL?

Kelly Jones wrote: Many sites let you search databases of information, but the search queries are very limited. I'm creating a site that'll allow arbitrary SQL queries to my data (I realize I'll need to handle injection attacks). Are there other viable ways to query data? I read a little on "Bu

Re: Database design - help

BobSharp wrote: As a complete newbie in MySQL, I need a database to store URLs related to Tenpin Bowling. There are several Categories ... Equipment Manufacturers, Organistations, (UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching & Instructional websites, etc. There

Natural join problem

Two tables: USERS: USER_ID (PK) . . .etc TWEETS: TWEET_ID (PK) USER_ID (FK) Trying to get the user information and the number of tweets each person has: SELECT USERS.USER_NAME, COUNT(TWEETS.TWEET_ID) AS 'TWEETCOUNT' FROM TWEETS NATURAL JOIN USERS; But it seems to be just rolling up all the

Re: Natural join problem

Thanks. That worked. Jason Trebilcock wrote: Methinx you need a "GROUP BY" in there. See below. -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Thursday, September 10, 2009 6:48 PM To: mysql@lists.mysql.com Subject: Natural join problem

Right Date format mask

I'm pulling in a date with the following format 9/14/2009 2:12:48 PM And using this mask to convert it using the str_to_date() function: %e %m %Y %r but it keeps giving me an error. Do I have the right mask? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: Right Date format mask

Dan Nelson wrote: In the last episode (Sep 14), John Meyer said: I'm pulling in a date with the following format 9/14/2009 2:12:48 PM And using this mask to convert it using the str_to_date() function: %e %m %Y %r but it keeps giving me an error. Do I have the right mask?

Datediff function

I'm trying to pull up a list of users who haven't tweeted in 7 or more days, and I'm trying to use this statement: SELECT USER_NAME, MAX(TWEET_CREATEDAT) FROM USERS NATURAL JOIN TWEETS WHERE DATEDIFF(NOW(),MAX(TWEET_CREATEDAT)) > 7 GROUP BY USERS.USER_ID But it says "invalid group function". H

Re: Datediff function

Gavin Towey wrote: Hi John, You can't use aggregate function in the WHERE clause, because they aren't evaluated until after the WHERE clause is applied. Wouldn't it be much easier to simply keep a last_tweet_date field updated somewhere then simply do SELECT USER_NAME FROM USERS WHERE last_tw

Re: What should it be in MySql? In C, it's an array of integers.

Pete Wilson wrote: Hi folks -- What would be the right approach in MySql 5.0? My table, USERS, has columns NAME and IP. Associated with each user is also a collection of from 0 to 50 INTs. What's a reasonable way to put these 50 INTs in the table without using 50 separate columns, INT01...INT

Re: What should it be in MySql? In C, it's an array of integers.

Pete Wilson wrote: Break them out into a separate table linked via the primary key. How elegant! Thanks. -- Pete it's nothing not taught in Database Design 101. Typically you would have a setup like this USERS USER_ID <--primary key USER_NAME USER_IP ASSOC_NUMBERS A_ID <--pri

Re: What should it be in MySql? In C, it's an array of integers.

Johan De Meersman wrote: On Thu, Sep 17, 2009 at 3:46 AM, John Meyer wrote: Alternatively, you can skip the A_ID and have a compound key of USER_ID and A_NUMBER on the ASSOC_NUMBERS table. I prefer the A_ID, though. Note that this would be marginally faster, because all your data is

Re: Questions on Database Design

Mark Phillips wrote: I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from their mobile phones and read/write data to a database. Say there are roughly 1

Re: Questions on Database Design

John, Thanks. The data is private to each user; there is no sharing of data. I am not sure what you mean by "are the actions related" Each user is reading/writing independently of each other. Would that argue for separate databases? Mark Are the actions of a similar nature (i.e. they're

Re: Questions on Database Design

Mark Phillips wrote: On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote: depends on the relationship of the Data Tables and the Users that use them for instance if I was to setup a table of outgoing calls from 2 distinct individuals : Me> calls to HarvardMedicalSchoo

Finding users who haven't posted in a week

I want to get a list of all users who haven't posted in a week. But when I use the following function. select user_id, max(tweet_createdat) from tweets where datediff(now(),max(tweet_createdat)) > 7; Is producing the error: Invalid use of group function

RE: Finding users who haven't posted in a week

l Dykman [mailto:mdyk...@gmail.com] Sent: Sunday, November 08, 2009 8:35 AM To: John Meyer Cc: mysql@lists.mysql.com Subject: Re: Finding users who haven't posted in a week the function max(), among others, makes no sense in the absence of a GROUP BY clause. try adding "GROUP BY user_id&q

RE: Finding users who haven't posted in a week

er_id having datediff(now(),max(tweet_createdat)) > 7; -Original Message- From: John Meyer [mailto:johnme...@pueblocomputing.com] Sent: Sunday, November 08, 2009 9:45 AM To: 'Michael Dykman' Cc: mysql@lists.mysql.com Subject: RE: Finding users who haven't posted in a week

Re: Record old passwords ?

On 1/18/2010 5:52 PM, Colin Streicher wrote: On January 18, 2010 01:34:15 pm Tompkins Neil wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last fou

Re: Record old passwords ?

On 1/19/2010 7:49 AM, Mark Goodge wrote: On 19/01/2010 14:44, Tompkins Neil wrote: Hi All, Following on from my earlier email - I've the following question now : I can enforce that the user can't use the same password as the previous four - when they change their password. However, the user ca

Re: 50 things to know before migrating from Oracle to MySQL

On 1/28/2010 3:21 AM, changuno wrote: Hi folks, Read a blog which states 50 things to know before migrating from Oracle to MySQL. Any comments on this? would it have been too much to just link to it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Good source for sample data?

On 1/28/2010 4:52 PM, Brian Dunning wrote: Hey all - I need a few million sample contact records - name, company, address, email, web, phone, fax. ZIP codes and area codes and street addresses should be correct and properly formatted, but preferably not real people or companies or email addre

Re: Good source for sample data?

If I may recommend: http://www.generatedata.com/#download On 1/28/2010 8:11 PM, Carlos Proal wrote: Google for "data generator", there are free and commercial solutions available. Carlos On 1/28/2010 5:52 PM, Brian Dunning wrote: Hey all - I need a few million sample contact records - name

Re: how to view all acounts in a database

On 2/5/2010 5:15 AM, Suresh Kuna wrote: In the mysql prompt, execute the below use mysql ; select user from user ; will show all the accounts in a MySQL database. Alternatively, you can use myphpadmin. I guess it all depends upon what you need the information for and to what purpose. --

Re: NOW() is stuck...

Well, if you want to get unstuck in time, maybe you need to call Billy Pilgrim ;-) Andy Wallace wrote: We've been having some issues with one of our MySQL servers lately, and currently the dang thing is "stuck". For at least the last hour, NOW() is returning the same value: mysql> select now(

Re: do I need two tables or one will do just fine?

Afan Pasalic wrote: hi, I have a employees table (first name, last_name, address, city, state, zip, phone,...). though, I got a requested to add additional info about people, like phone_extension, zip+4, nick, DOB... that will not be used very often. what would be better solution: a) add these

Re: MySQL Server not running

Given that FEHLGESCHLAGEN means "failed" and coupled with the proceding text, I would assume that you don't have mysql installed in the first place. If you are on an rpm based system, try the following: rpm -q mysql If you don't get anything back, you need to reinstall. Ananda Kumar wrote: > if

Re: OT: Sun to buy Mysql

Brett Harvey wrote: http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 No offense, but this is definitely not off topic when it comes to MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql Connection/NET and Visual Basic.NET 2008

I'm trying to start a connection to a mysql database, but even though I've installed the connector I don't see where the option to choose that data type of connection exists. I'm using Connection/NET v 5.1, btw -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: Automatic email to database member on X date?

Or, you can use cron/at to schedule the task Mauricio Tellez wrote: Hi Aaron, I'm not sure if what you want can be done with MySQL, but what you can do is a little script in python, php, etc, that query your database for the members that expire at a given date, and then email them. Then you tell

freeware tools for repairing myisam tables

I'm trying to help out a friend with repairing myisam tables. Does anybody know the best freeware solutions if CHECK TABLE and REPAIR TABLE don't do the job? -- Pueblo Bicycling http://www.pueblobicycling.com Actually looking forward to the daily commute -- MySQL General Mailing List For lis

Re: freeware tools for repairing myisam tables

Yep. Per Jessen wrote: John Meyer wrote: I'm trying to help out a friend with repairing myisam tables. Does anybody know the best freeware solutions if CHECK TABLE and REPAIR TABLE don't do the job? Did you try myisamchk ? /Per Jessen, Zürich -- Pueblo Bicy

Re: Trying to create a new table in memory.

Hi Charles, Charles Danko wrote: Each entry consists of 2 medium_int and 1 tiny_int variables, and the table contains just over 100,000,000 rows. By my count, this makes just over 700MB of data. The machine I am using has 2GB, but I am still getting an out of memory error. What am I doing wr

only update if values different

What is the best way to UPDATE a row only if values are different? We have a mainframe extract that literally has 100,000 rows and am worried about the performance of just running INSERTs each night. Is there a simple comparison command or would you have to nest a SELECT statement? Thank you,

Re: MySSQL on HP-UX

Hi, Nishant Gupta wrote: [/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w]scripts/mysql_install_db --user=mysql chown: unknown user id mysql Installing all prepared tables 061212 19:39:30 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! Did you do

Re: Does Update allow for aliases?

Hi Richard, Richard Reina wrote: I am trying to update from one table to another but I get a syntax error when I try: UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID; If update does not support aliases, is there another way to do this query? I am usin V3

Re: mysql data into CSV file. / (Errcode: 13)

Hi Shain, Shain Lee wrote: ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv' (Errcode: 13) I faced a problem as mentioned above. really got stucked. how can i solve that problem ? is it a bug ? Error 13 is Permission Denied. The MySQL daemon cannot write to your

Re: Load Balance on MySql

Hi Shain, Shain Lee wrote: Now , i have to think about any perfect load balancing method , i can't duplicate the databse in another machine. It's directly conflict with serving contents for each request. Why not use replication? If you don't want to do it on application level (seperate rea

Re: Visual Basic 6 + MySQL

Anybody in here think of http://www.vbmysql.com? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Visual Basic 6 + MySQL

Nuno Vaz Oliveira wrote: > Hello John, >> Anybody in here think of http://www.vbmysql.com? >> > > The site is not working correctly :( > > I've found a lot of references to that site but the articles are all > missing. > This article isn't missing: http://www.vbmysql.com/articles/vb6-mysql/ac

Re: How to "cast" a column ?

Hi Manuel, Manuel Vacelet wrote: I have query that joins 2 tables. I have an index on each part of the join but unfortunately the 2 columns don't have the same type so the index is not used for the join (I guess it's the reason why). On one hand I have an INT and on the other and a VARCHAR. This

Re: Query headaches

Hi Kim, Kim Christensen wrote: The error I get while trying executing is "Unknown column 'products.product_id' in 'on clause'. Since I am selecting all columns from that table (products), I can't really see why there's a fuss about it! I'm thankful for every tip I can get, and please let me kno

Re: error 99(?) : can't connect to MySQL server

Hi Faygal, Fagyal Csongor wrote: for (1..5) { $dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} ); my $sth = $dbh->prepare('SELECT * FROM users'); } I think you are simply running out of available outgoing ports with that. Here is some more insight on that topic: ht

Re: myISAM Max File Size?

Phil Butterworth wrote: > Can anyone please tell me what the Max size a myISAM file can grow too? > Thanks > Best Regards > > Phil Butterworth > > > http://lists.mysql.com/mysql/204119 Funny what google can do for you, wot say? -- MySQL General Mailing List F

Re: NOT EMPTY, like NOT NULL

Hi Js, js wrote: Is there any easy way to implement 'NOT EMPTY' constraint? There currently is no support for CHECK Constraints in MySQL, at least to my knowing. So you'd have to go with a trigger. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Query Two Databases

Neil Tompkins wrote: > Following on from the email below, if I run the query > > SELECT * FROM database1.table, database2.table > > I get the data back, but all the data is in the same row. > > How can I seperate the records ? > > Regards > Neil > > Barring an upgrade, it seems your best bet

Re: SQL_CALC_FOUND_ROWS using ODBC driver

Hi, Nuno Oliveira wrote: When I set the RS.Source to the first SELECT statement and open it, it run OK but I need to close the RS and open it again using the second SELECT statement. After any of this operations I get a Recordset->RecordsCount = 1 That is actually a correct figure, SELECT F

Re: SQL_CALC_FOUND_ROWS using ODBC driver

Nils Meyer wrote: > SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld got signal 11;

Hi, Michael Fernández M. wrote: key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=323 max_connections=800 threads_connected=55 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes of memory Ho

Re: mysqld got signal 11;

Hi, Michael Fernández M. wrote: i use 32 Bits kernel. Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. innodb_additional_mem_pool_size = 500 MB. innodb_buffer_pool_size = 8 MB Before the innodb_additional_mem_pool_size was 1 MB, (the default va

Re: mysqld got signal 11;

Michael Fernández M. wrote: Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? Yes exactly. Depending on kernel version you can allocate something between 2 or 2.7GB. Until 2GB it's sa

Re: unauthenticated user

Hi JM, JM wrote: i got this results from "show processlist" | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | That's jus

Re: Mysql and FOREIGN KEY

Hi, Micol lupen wrote: FOREIGN KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio) ^^^ check here! ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB; No comma before REFERENCES. REFERENCES is part of the foreign key definition. regards Nils -- MySQL General Mailing

Re: Growing innodb size

Hi, Jean-Sebastien Pilon wrote: I would like to grow my innodb table space, the only problem that I have is that I did not declare any size in the config file since we were not using it to start with. If I modify the config file, will this override the current innodb file or will it grow it ? Or

Re: InnoDB: Assertion failure

Hi, Michael Fernández M. wrote: 2 CPU Pentium III 700 Mhz Aprox. 4 GB RAM. Redhat 7.2 Mysql version: 4.0.14-standard-log Kernel: Kernel 2.4.18-17.7 (highmem) It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes of

  1   2   3   >