Re: INNODB database size

2006-04-25 Thread Pure Web Solution
://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html Regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services Todd Smith" <[EMAIL PROTECTED]> wrote: > Hello > > I have inherited an INNODB database. I am new to MySQL and ma

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Pure Web Solution
I dont think that it is possible to specify the engine when creating a table this way, you could however create the table using the: CREATE TABLE old AS SELECT * FROM request_log and then issue an alter table command setting the engine to whatever you like. Pure Web Solution http

Re: Complicated select query

2006-03-28 Thread Pure Web Solution
try something like this select customer,max(time),name from customers join projects on projects.parent_id=customer.id group by customer; regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services Barry <[EMAIL PROTECTED]> wrote: > Gabrie

Re: How to take dump of a query instead of table / database

2006-03-24 Thread Pure Web Solution
you can manipulate mysqldump using the where clause (check the man) You might find the following usefull, but would not be so good for restoring. from the command line mysql --database=db_name --execute="select * from users" -u username -ppassword > output.file Pure Web

Re: Very large from

2006-03-15 Thread Pure Web Solution
Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services "fbsd_user" <[EMAIL PROTECTED]> wrote: > Thank you Gabriel, more background information may result in a > better concept, so here it is. > > The web based application I am writi

Re: How to build a client?

2006-03-15 Thread Pure Web Solution
you can add --old-password when starting MySQL manually or try adding the following to the my.cnf file [mysqld] old-password regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services My /etc/my.cnf does not have this option? Is this something I can

RE: insert into... select... duplicate key

2005-09-25 Thread Schimmel LCpl Robert B \(GCE 2nd Intel Bn Web Master\)
Actually, both of your solutions worked. Thanks much for the input guys. Rob -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:20 AM To: Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) Cc: Danny Stolle; mysql@lists.mysql.com

RE: insert into... select... duplicate key

2005-09-25 Thread Schimmel LCpl Robert B \(GCE 2nd Intel Bn Web Master\)
rds, Danny Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote: > That is the effect that I am looking for, but exactly the method that I > am trying to avoid. If I type the column names into my INSERT... SELECT > and someone later adds a column to the table, I would have to go bac

RE: insert into... select... duplicate key

2005-09-25 Thread Schimmel LCpl Robert B \(GCE 2nd Intel Bn Web Master\)
has autonumbering -> insert into table1 (field2, field3) select (field2, field3) from table1; autonumbering will automatticaly be applied :-) Danny Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote: > Here is the problem that I am having. I am trying to make a copy of a > full

insert into... select... duplicate key

2005-09-24 Thread Schimmel LCpl Robert B \(GCE 2nd Intel Bn Web Master\)
Here is the problem that I am having. I am trying to make a copy of a full record in a table that has a primary key with auto-increment. The real problem is that I want the statement to use SELECT * so that if columns ever get added to the table the statement will still work for the full record. I

Re: Replication only DB

2005-03-11 Thread Deluxe Web
do a replication of only 1 DB? > > thank Arcangelo > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Deluxe Web [EMAIL PROTECTED] -- MySQL General Mailing

INNODB MONITOR OUTPUT

2005-03-03 Thread Deluxe Web
Hi Do you see any problems? = 050303 12:51:11 INNODB MONITOR OUTPUT = Per second averages calculated from the last 20 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 14266, signal count 14261 M

innodb_buffer_pool_size - max_connections?

2005-02-28 Thread Deluxe Web
Can I assume that that with a innodb_buffer_pool_size of 1G I can accept only 500 max_connections (stack size 2M*500 connections). Also, I noticed that I can't set a innodb_buffer_pool_size > 1G. Ideas? Max -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

my.cnf and InnoDB

2005-02-28 Thread Deluxe Web
Can you help me figure out the max connections # for a 2GB ram (2GB swap mem) server running myslq 4.0.16-Max-log and fedora core1. [mysqld] max_connections= ? innodb_buffer_pool_size=1G The database size is approx 100 Mb with 1,700++ tables, increasing daily.. ulimit -a core file size

Re: Mysql tuning - server Crash 1

2005-02-28 Thread Deluxe Web
> - Original Message ----- > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, February 28, 2005 11:44 AM > Subject: Re: Mysql tuning - server Crash 1 > > > Hi > > I understand.. I should switch to debian :)

Re: Mysql tuning - server Crash 1

2005-02-28 Thread Deluxe Web
p://www.innodb.com/order.php > > - Original Message - > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, February 28, 2005 9:13 AM > Subject: Re: Mysql tuning - server Crash 1 > > > In my .err. file

Re: Mysql tuning - server Crash 1

2005-02-27 Thread Deluxe Web
essage- > > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > > Sent: Sunday, February 27, 2005 2:58 PM > > To: mysql@lists.mysql.com > > Subject: Re: Mysql tuning - server Crash 1 > > > > Max, > > > > - Original Message - > > From: &q

Re: Mysql tuning - server Crash 1

2005-02-27 Thread Deluxe Web
is currently down. > > Oh well. > > Donny > > > -Original Message- > > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > > Sent: Sunday, February 27, 2005 2:58 PM > > To: mysql@lists.mysql.com > > Subject: Re: Mysql tuning - server Crash

Re: Mysql tuning - server Crash 1

2005-02-27 Thread Deluxe Web
ons, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > http://www.innodb.com/order.php > > > - Original Message - > From: "Deluxe Web" <[EMAIL PROTECTED]> > Newsgroups: mailing.d

Mysql tuning - server Crash 1

2005-02-26 Thread Deluxe Web
Hi there, I have a problem with mysql. I have an application basically to track clicks to my website and last night it crashed. Can you have a look aty my situation? I run a server with 2GB RAM and a XEON processor! Thank you. - Max - error log - InnoDB: Warning: a long semaphore wait: --Thre

Fwd: Mysql tuning - server Crash 2

2005-02-26 Thread Deluxe Web
show status (now) +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 2| | Bytes_received | 18819744 | | Bytes_sent | 67675629 | |

Re: Excessive Server Load Problems

2005-02-24 Thread Chris Aitken (The Web Hub)
happy to help you. :) Its highly possible as this is the first database ive had to use with a large number of records. I shall look into indexing part of databasing now. Any suggested places to start that explains it helpfully ? Regards Chris Aitken The Web Hub Designer and Programmer Phone : 0

Excessive Server Load Problems

2005-02-23 Thread Chris Aitken (The Web Hub)
d down? My understanding of "nice" is that it puts mysql's cpu usage priority at the lowest. But if nothing else on the box needs the CPU, it'll still run full and bring load over 5 making sendmail crash anyway. Any responses would be appreciated. Regards Chris Aitken The W

Re: EXPLAIN: Select tables optimized away

2005-02-17 Thread O&#x27;K Web Design
Hi Counts are extremely fast and since you have no WHERE statement, it takes the count value straight from the internals and does not look at the tables or an index if I remember correctly. Mike - Original Message - From: "Gabriel PREDA" <[EMAIL PROTECTED]> To: Sent: February 17,

Re: query performance

2005-02-17 Thread Coz Web
If you do I suggest you also include relevant table definitions and possibly a little sample data (plus an indication of total table sizes) and expected output, this will greatly assist anyone who my be able to help. Oh yes, and don't forget to state the version of MySQL you are running. Coz On

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
g the dump file and then processing that dump file on the > >recipients box. > > Thanks again > > I couldn't find the thread but I manage to save the dump file on my > local server (at the same location as the php script) by running a > mysqldump on my local server to fetch

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard <[EMAIL PROTECTED]> wrote: > >On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote: > >> Hi > >> > > > I use mysql/php on several client web sites (each client has its own > >&

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote: > Hi > > I use mysql/php on several client web sites (each client has its own > db). For development purpose, I have a local web server with > php/mysql. When a web site is still in development, th

Re: Query problem

2005-02-08 Thread Coz Web
On Tue, 08 Feb 2005 15:52:02 +0100, Joachim Klöfers <[EMAIL PROTECTED]> wrote: > Oh, oh, Joachim, > not able to calculate, but asking questions about queries. > > Coz , of course its supposed to be 1955 (id 13 & 47) > > Joachim > > > Coz Web schrieb: >

Re: Query problem

2005-02-08 Thread Coz Web
On Tue, 8 Feb 2005 11:37:20 +, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote: > > Hi, all > > > > I hope somebody can help me. > > > > > > Many thanks in advance > > Joachim > > That is a very thorny problem. May I observe that you wi

Re: Query problem

2005-02-08 Thread Coz Web
Just to confirm, is amount2 for region 1 supposed to be 1630 (id 47) or 1955 (ids 13 & 47)? Coz > What I would like to have is a result like this: > ++---+--+ > | region | sum(amount1) if current=J | sum(amount2) | > ++---

Re: MySQL upgrading

2005-02-06 Thread Coz Web
Helena, have you tried this link: http://dev.mysql.com/doc/mysql/en/upgrade.html It starts: "2.10. Upgrading MySQL As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currentl

Re: Removing 3.23, installing 5.02

2005-02-02 Thread Coz Web
I know it's not quite the same, but I recently upgraded 2 FC2 boxes from MySQL3.23.xx to MySQL4.0.23 simply by using (as Gleb suggested) : rpm -U mysql* I had downloaded the following rpm files from the MySQL site : Linux x86 RPM downloads --- Server

Re: MySQL & Perl

2005-01-14 Thread O&#x27;K Web Design
Hi Gerald Looks like you need a username Jerry not gjw, here is the format I use to connect. Mike $dsn = "DBI:mysql:host=$host_name;database=$db_name" return (DBI->connect ($dsn, $username,$password, {PrintError => 0, RaiseError => 1})); - Original Message - From: "Gerald Pr

Re: [Bulk] Re: MySQL speed

2004-09-14 Thread O&#x27;K Web Design
You have not mentioned the use of a multiple column index, for that matter, no indexes at all. I would suggest a multiple column index in the form of hidden, touser. That index form should speed up your queries and solve the problem. Mike - Original Message - From: "Fagyal Csongor" <[E

Re: mysql /dbi issues

2004-07-24 Thread O&#x27;K Web Design
Hi When building my server I came across a similar situation. The .10 and .14 are builds of the same library but are complied using a different C library when building the kernel. If your kernel was built and needs .14 you should be able to find builds for your kernel. In the end, I tried

mysql action history

2004-06-22 Thread web tur
Dear Sirs, I have mysql database on the web server. Is there any way to see mysql actions from any log? I want to see what my visitors did on the sql databases. Any idea Best Regards __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB

Re: oracledump.pl error

2004-02-19 Thread O&#x27;K Web Design
Hi Maybe I am missing something. Why not install MySQL on a windows box and use one of those porters. Then just copy your tables to the Linux box. Mike - Original Message - From: "J. Allen Crider" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Fe

Re: PHP or Perl?

2003-08-16 Thread O&#x27;K Web Design
P or Perl? > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably > a better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > >

Re: connection

2003-08-14 Thread O&#x27;K Web Design
he /usr/local/mysql/bin directory. Is there a way to > connect if I am root. thanks for your help. > -aaldrik > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com >

Re: Running two Servers?

2003-08-09 Thread O&#x27;K Web Design
Hi Why would you need two servers running when you could just have separate databases?? Is there a reason why these two cannot share?? Mike - Original Message - From: "Ola Ogunneye" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: August 7, 2003 8:46 AM Subject: Running two Ser

Re: Books advice

2003-07-31 Thread O&#x27;K Web Design
Hi I guess I will plug Paul's books. I have his MySQL book and his MySQL and Perl for the Web. I really enjoyed the second one but the MySQL book was very well written. I also have read Sam's teach yourself MySQL in 21 days which seemed pretty light weight and I never look up a

Re: ARGGH! - User password problems

2003-07-31 Thread O&#x27;K Web Design
Hi Did you remember to flush??? - Original Message - From: "Adam Fortuno KOVICK" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 31, 2003 4:33 PM Subject: ARGGH! - User password problems > All, > > I've been attempting to assign a password to a user with the following > sta

Re: LEFT SELF Join -- LEFT join on same table

2003-07-14 Thread O&#x27;K Web Design
Hi Let me take a stab at it. I don't think you need a join at all. Check the syntax but I think you can do it like this. SELECT *,concat(slm,item,cust,year) as result1,concat(slm,item,cust,2003) as result2 from sales where result1!=result2 AND date>2001 year would be taken from your date

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-12 Thread O&#x27;K Web Design
Hi Your first statement looks ok to me but the one you have below has no space before AGAINST. Otherwise, I cannot see the problem myself. Mike - Original Message - From: "Francis Van-Lare" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 12, 2003 2:42 AM Subject: MATCH AGAINS

Re: mysqldump

2003-07-07 Thread O&#x27;K Web Design
Hi Just read this last night. Try mysqldump databasename -u username --password=yourpassword > /to/a/directory/dump.sql Mike - Original Message - From: "Kalle Saarinen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 7, 2003 8:21 AM Subject: mysqldump > Hello > > I'm tryi

Re: error message

2003-06-26 Thread Martin';s - Web Dept.
Just a guess from a raw newbie, but try using: `traffic.trafficdb` instead of `traffic`.`trafficdb` Ryan Thursday, June 26, 2003, 1:13:03 PM, you wrote: SD> can someone help me with this error, with my database in MySQL 3.23.49 SD> SD> SQL-query : SD> SELECT * SD> FRO

Re: Big problem with autoincrementing

2003-06-22 Thread O&#x27;K Web Design
Hi First, auto increment is a column type. You set the column to add one to the highest value in that column. If you would like the records to start at 10, either enter you "first" record with the Client_ID value explicitly set at 10 or enter a dummy MySQL statement like "INSERT INTO Client

Re: Can't drop a database

2003-06-19 Thread O&#x27;K Web Design
Hi I really don't have an answer but would question whether MySQL will allow zero db's with it's own grant tables. Usually there is a test db, at least after an install. Why not try adding a database and then try to drop clone_updater??. Mike - Original Message - From: "Leo Genyu

Re[2]: RAID hardware suggestions/experience

2003-06-18 Thread Martin';s - Web Dept.
Wednesday, June 18, 2003, 2:38:53 PM, you wrote: -->>-Original Message- -->>From: Adam Nelson [mailto:[EMAIL PROTECTED] -->>Sent: Tuesday, June 17, 2003 11:56 AM -->>To: 'Bernd Jagla'; 'mysql' -->>Subject: RE: RAID hardware suggestions/experience -->> -->>We recently bought a kick $%#%% ma

Re[2]: Syntax question

2003-06-17 Thread Martin';s - Web Dept.
Hello Jeff, Monday, June 16, 2003, 1:13:27 PM, you wrote: JS> On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote: >> I am quite willing to acknowledge that I'm new at this ... >> >> But I can't find the syntax error in this query: >> &

Syntax question

2003-06-16 Thread Martin';s - Web Dept.
I am quite willing to acknowledge that I'm new at this ... But I can't find the syntax error in this query: SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb') desc is a field name, usb is the keyword I'm searching for. MYSQL version 4.0.12 Thanks for your help. Ryan -- MySQL Genera

Re: mysql: bug in update (?)

2003-06-08 Thread O&#x27;K Web Design
Hi Your problem lies in your columns. A timestamp field has the special property of recording when a record is created or modified. However, only the first timestamp column in a row is treated this way. I hope this helps. Mike - Original Message - From: "Dmitry Kosoy" <[EMAIL PROT

Re: I thought single UPDATE statements were atomic

2003-06-06 Thread O&#x27;K Web Design
Hi You are not defining num so you are adding 1 to 0 to get 1 and you already have that record. Sounds like you need an autoincrement field. Mike - Original Message - From: "Mark Rages" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: June 5, 2003 7:52 PM Subject: I thought single

Rating rows only with FULLTEXT

2003-06-02 Thread O&#x27;K Web Design
something might be done in the myisam/ftdefs.h source file to remove the dataset weighting feature. Thanks Mike O'Krongli O'K Web Design -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

$13.95 Domain Names are here!!

2003-03-18 Thread Web Hosting
hostname. - 10 page web site - Layouts, backgrounds, WYSIWYG (What You See Is What You Get) interface, etc. - 100 personalized email addresses - Create up to 100 personalized email addresses and forward them to other email addresses. - Web/URL forwarding - Forward

Re: Replication problem (alter table fails)

2003-02-26 Thread Kirill Peskov (WEB-EU)
esday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: > Coud you, please, give an advice to solve following problem: > > I've got two Mysql Servers: > > * Master: Sparc Solaris 8, MySQL 3.23.32 > * Slave: RedHat Linux 7.2, MySQL 3.23.32 > > Replication o

Replication problem (alter table fails)

2003-02-25 Thread Kirill Peskov (WEB-EU)
Dear gurus, Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all "insert into" and "delete from" made on master successfully change the

Re: Problem with Query based on HTML form values - Clarification

2002-12-17 Thread web-dev
RE (condition='new' OR condition='used') AND type='sail' You probably don't need to use LIKE since the form fields will always supply you with the same values. -bill web-dev wrote: Hello, I am attempting to search a table based on information passed from

Problem with Query based on HTML form values

2002-12-17 Thread web-dev
Hello, I am attempting to search a table based on information passed from a submitted form. The form contains details as follows: (radio buttons) Condition: O new O used Type: O powerO sail (textbox) Make: [ ] etc. etc. etc. ( it's a long list!) If I write

Root pass

2002-07-02 Thread Page Works Web Solutions
Hi, any ideas on this one [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> UPDATE user SET Password=PASSWORD(testpassword) -> WHERE U

a little closer

2002-07-02 Thread Page Works Web Solutions
Hi all, First, thanks for the patience and the help I've been getting. I'm at this point. I think this is where I'm getting stuck at -p[password], --password[=...] Password to use when connecting to server If password is not given it's asked f

root passwords

2002-07-02 Thread Page Works Web Solutions
new GRANT command! You can start the MySQL daemon with: cd / ; /usr/bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information a

Re: root password

2002-07-01 Thread Page Works Web Solutions
Hi, I'm still stuck. If anyone has time, please take a look at this session I had and any pointers would be great. I just went to mysql.com to search the problem, but no site there..Weird. thanks all, Shawn [root /root]# mysql -u root -p Enter password: ERROR 1045: Access denied for user: '

Help?

2002-07-01 Thread Page Works Web Solutions
Hi all, anyone know why this error would come up. This is running on a Linux box [admin admin]$ scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory Shawn - Before posting, please check: h

Root pass

2002-06-29 Thread Page Works Web Solutions
Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am

install

2002-06-29 Thread Page Works Web Solutions
Hi all, I'm a newbie at this, so here's a newbie question. I have installed MySql on a Cobalt Raq 4 running Linux via a .pkg file. All seemed to go well, I am able to get into the MySql directory via telnet but no commands seem to work. See session below. Can anyone help me with putting a r

Re: Query Help

2002-02-20 Thread Web boy
Is there another way as I do not have that version of MYSQL installed on my server? THanks- KCK --- Tod Harter <[EMAIL PROTECTED]> wrote: > On Wednesday 20 February 2002 09:20, Web boy wrote: > > You want to use UNION. If I remember correctly its a > fairly new feature for

Query Help

2002-02-20 Thread Web boy
Hello I have a query that goes through and gets the data out of three tables without a problems. Now the task at hand is to compair that out put against three identiacal tables not displaying any duplicate date. Tables: a a.aocode , a.CaseNo , a.CaseName b. b.ao_code , b.initials c c.CaseNo

Re: Replication, update log, mysqldump???

2001-07-04 Thread Web Mailing List
I think you can check this link http://www.mysql.com/documentation/mysql/bychapter/ - Original Message - From: "Joe Taraba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 1:47 PM Subject: Replication, update log, mysqldump??? > Hi; > > I'm trying to learn M

Help please, create table, and set Auto field

2001-07-04 Thread Web Mailing List
I move from MDB to mySQL, I got a question concern how to create a auto digital number field in mysql table, create table namelist ( name char(60), ID auto, date date());

Please help with this!

2001-06-29 Thread Web Mailing List
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy

Re: MySQL on NFS?

2001-06-29 Thread Web Mailing List
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy - Original Message - From: "Kelsey Cummings" <[

Re: Looking for only unique records

2001-03-18 Thread Web master
try distinct(column name) JCampbell wrote: > I want to know if it is possible to build a MySQL query which will only > return the unique values of a specific column. Ie if I had this table: > > id | name |date___ > 1 | Jon | 2001-01-03 > 2 | Bob | 2001-01-04 > 3 | Jon | 2001-01-05 >

Re: Key Word Query

2001-02-27 Thread Web master
I agree, I don't think there is a function in MySql, it will do the job. May be you can use the following algorithm 1. fetch all rows item description. 2. Split into words and put it in a array. 3. Create a counter array of the same limit of word array. 4. in a for loop, count number of time tha

Re: Can anyone do this ?

2001-02-14 Thread Web Depressed
Hi Bob/ All, I cannot get the creation of the TEMPORARY Table to work: The select statement works fine: mysql> SELECT table1_id, Count(date) as c FROM Table2, Table1 -> WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" -> AND Table2.table1_id=Table1.id -> GROUP BY Table1.id HAVI

Re: mysql/php

2001-02-14 Thread Web master
or you can try the following code $result=@mysql_db_query($db_name,$query,$link); $num=@mysql_num_rows($result); if($num<=0): echo "No records found"; endif; Martin Cloutier wrote: > Try this: > > $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE > '%$keyword%'"); > >

Problem using COUNT & DISTINCT together

2001-02-05 Thread Web Depressed
Hi, Woh ! This is very strange. Any ideas ? mysql> SELECT * FROM Table2; ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 |

Re: Can anyone do this ?

2001-02-05 Thread Web Depressed
Hi Bob, Many thanks for that. I was hoping (through absolute naiveity) not to have to go and calculate the number of days with the specified range. Unless, of course I could have mysql do this for me. Can anyone tell me how I could generate such a list. (ie something like: SELECT BETWEEN "20

Re: Can anyone do this ?

2001-02-05 Thread Web Depressed
; wrote: > Can you explain what difference between dates > 2001-02-04 and 2001-02-06 for > item2 and 2001-02-04 and 2001-02-06 for item1? > > - Original Message - > From: Web Depressed <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, Februa

Can anyone do this ?

2001-02-04 Thread Web Depressed
Hi, I've been trying for a while now and I can't figure out how to do the following: In regular English, I wish to show all items for which I have allocations greater than one for all days encapsulated between the user input range. User Input: --- Date_from (ie. 2001-02-04) Date_to

Re: How to set the date format to dd/mm/yyyy for all tables in MySql for insertion, selection etc.,

2001-01-26 Thread Web master
Thank paul. I know about Date_format, but was curious if there is some setup parameters would allow us to define the MySql date format . Paul DuBois wrote: > On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote: > >> Hello, >> >> I would like to change the d

How to set the date format to dd/mm/yyyy for all tables in MySql for insertion, selection etc.,

2001-01-26 Thread Web master
Hello, I would like to change the default date format MySql from /mm/dd to dd/mm/. Does anyone know, how to make this change in MySql? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Joins to one table form two columns

2001-01-23 Thread Web master
select a.id, status1, detail from history a, statusText b where a.id = b.id; rob anderson wrote: > I am new to MySQL so don't laugh! > > > I have a table 2 fields that relate to another table (that stores the > description) > > i.e > > history > id > status1 > status2 > > > statusText > id

Re: jdbc driver

2001-01-23 Thread Web master
Couple of things 1) is the listening port number correct ? 2) If you are using windows, make sure the class path has 8.3 file name format instead of the long file name. other than that it should work fine kerry finn wrote: > Hi, > > What do I use to identify the default jdbc driver for mysql

Re: SELECT FROM TABLE WHERE ?

2001-01-22 Thread Web master
select max(rating) from singlemalts will give you the highest value or select * from singlemalts order by rating desc will give all the rows ordered by rating and the first row will have the highest value Richard Reina wrote: > I've tried the manual (and the Oreily MySQL book) and played arou

newbie question on Driver and java

2001-01-22 Thread Web master
Hello, I am using MySql in my ISP, this is the first time I downladed the big guy himself in my machine. It is working fine as stand alone. My question is , how to use MySql using java programs. I downloaded RESIN1.1 and copied the JAR file to the following directory c:\resin1.1\lib and I adde

Unable to set mysql root password

2001-01-18 Thread Web
Unknown >Submitter-Id: wptraine >Originator: Web >Organization: Web Performance Inc. www.webperformanceinc.com >MySQL support: none >Synopsis: Unable to set mysql root password >Severity: serious >Priority: high >Category: mysql >Class:

Re: I need to migrate MSSql database with relations to MYSql

2001-01-11 Thread Web master
I am trying to do the same thing. The best bet so far is mysqldump. You can find more detail in http://www.sql.com/document and do search on mysqldump Pär Lindhe wrote: > Hello > > I need to migrate the structure of my MSSql database with its relations and > tables to MYSql. Is it possible? And

mysqldump question!

2001-01-10 Thread Web Master
Hello, can any one help me with my following mysqldump question. I want to dump a complete database from one server to another server. I am trying the following comment mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase when I tried, the remote host is failing with invalid log