Multiple Query Execution

2005-11-18 Thread Peter Burden
Hello, Am I correct in thinking that if there are no dependencies between the multiple statements then the various statements are executed simultaneously by separate threads in the server? If so is there any way to turn this behaviour off and just use multiple query execution

Re: MySQL Website

2004-04-21 Thread Peter Burden
Lehman, Jason (Registrar's Office) wrote: I should have been clearer. I can't reach the website. I can get to lists.mysql.com with no problem except for the fact that images won't pull form www.mysql.com but I definitely come to a grinding halt when I try to reach www.mysql.com. I can't do a

Re: Date Problem

2004-03-09 Thread Peter Burden
Richard Davey wrote: Hello Eric, Tuesday, March 9, 2004, 11:46:23 PM, you wrote: ES We have a table with a Date Time field and we need to update only the date ES portion of that field. ES We have table a with field Foo with value '2004-01-01 12:15:00' and a date ES '2004-03-01' and we need to

Re: SQ puzzle

2004-03-08 Thread Peter Burden
Jigal van Hemert wrote: Table: CREATE TABLE `age1` ( `age1` tinyint(2) NOT NULL auto_increment, PRIMARY KEY (`age1`) ) TYPE=MyISAM AUTO_INCREMENT=21 ; Data: INSERT INTO `age1` VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20);

Re: MySQL optimisations for search engine

2004-01-30 Thread Peter Burden
Jasper Bryant-Greene wrote: Hi I'm running a small search engine that indexes the web, but have been having trouble with optimising it to handle the load. There are two tables involved in searching - `pages`, which stores the ID, URL, title and crawl date, and `words` which has two rows -

Re: Euro Symbol ()

2004-01-19 Thread Peter Burden
Hassan Shaikh wrote: Hi, I've inserted the following currecy sumbols in my table (structure mentioned below). All symbols are displayed properly when I do select, expect for the Euro symbol, which just shows a question mark (?). Any idea why is it behaving like that? I am using MySQL 4.0.17 on

Re: C Programing: mysql_free_result

2003-12-31 Thread Peter Burden
of a process is usually the top address, this can be significantly larger than the actual memory used by the process. Thanks, folks!!! Leandro M Neves, Rocar Pcs Ltd, IT Manager Sete Lagoas/MG - BRAZIL -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General

Re: Images in a table

2003-12-01 Thread Peter Burden
Richard Bewley wrote: Yes, you can insert the binary into a table. Richard -Original Message- From: Zenzo [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 1:42 PM To: MySQL List Subject: Images in a table If your application is WWW based I've done some notes for students

Threads and signals in MySQL client

2003-12-01 Thread Peter Burden
on a per thread basis. Are any signals used internally in the MySQL client code? If so which? Does the library code manipulate thread signal handling facilities? -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http

Re: web data entry problem

2003-11-24 Thread Peter Burden
[EMAIL PROTECTED] wrote: I hope someone might be willing to help out. I'm trying [still] to learn MySQL and php - to create some simply web based database. I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database. When

Re: single quotes in database

2003-11-07 Thread Peter Burden
have to go back and redo all the ones that are already in the database. Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk

Re: How can I display images from a mySQL Database in a web page?

2003-07-16 Thread Peter Burden
out of the database. image start: jpeg /image Thanks in advance, Dan -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NEWBIE how can i store images in a database?

2003-07-09 Thread Peter Burden
? thanx for advance cheers christian -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: type casting help!!!

2003-06-25 Thread Peter Burden
Prem Soman wrote: hi!! i wrote a simple function that returns a string in C the function fetches values from a table and stores all the value in a string variable and then returns it ...This is small part inside the function i wrote! while((row = mysql_fetch_row(res))) {

Bug with 4.1.0-alpha Solaris

2003-06-23 Thread Peter Burden
Hello, After some moderately heavy usage, MySQL crashed on me. The problem seems to relate to the size of the innodb log file, alhtough I'm not currently using innodb files. [Still trying to debug client before exploring innodb vs myisam ] I've gathered up all the evidence in a

Re: PHP, MySQL and Apache

2003-06-13 Thread Peter Burden
... When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General

Newbie Question

2003-06-11 Thread Peter Burden
Hello, I'm sure there's an answer somewhere but the 900+ page manual is a bit overwhelming. I have MySQL 4.1 running on one machine and I'd like to access using the client software I alerady have on another machine which was built against 3.23.33. Access is via command line client (mysql),

Re: MySQL 4.1 and MyCC

2003-06-11 Thread Peter Burden
] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql