MySQL Database Forum

------=_NextPart_000_003E_01C34934.FBC032B0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello, I'm looking for a solution to write a sql query that inserts a set of = data if the data id is not present and otherwise update the set.

I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a field? Like: week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS NULL The clicks table has 31 instances of url that match 5 instances of url in the urls table. When I run the following I get a syntax error

I've tried this with both the RPM's and the source code and I have the same problem. I'm running Slackware Linux v8.1, and on the last attempt I built mysql from the source code by doing the following: (after unzipping the tarball) ../configure --prefix=/usr/local/mysql make make install scripts/mysql_install_db

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand. I've tried using Crystal Reports and SQLyog but...

We have the three tables below and for each customer, we need the following information; Result expected: Month | Sales total | Payment | Oustanding Jan | 1200.99 | 200.99 | 1000 Feb | 0.00 | 1000.00 | 0

We have the three tables below and for each customer, we need the following information; Result expected: Month | Sales total | Payment | Oustanding Jan | 1200.99 | 200.99 | 1000 Feb | 0.00 | 1000.00 | 0

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long these things take but the box shouldn't become...

I have written a database for a quote of the day. When my php script pulls it into a table, it doesn't wrap. The cell that it is in is wrappable. To see what it looks like, goto twhs-physics.org. Any ideas? Thanks -- ------------------------ Erik Thompson ethomps2@columbus.rr.com http://twhs-physics.org

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long these things take but the box shouldn't become...

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any database when login as root. Is there any other...

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any database when login as root. Is there any other...

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mysql/mysql.sock" to...

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mysql/mysql.sock" to...

Hi, I just joined this list and would like to search the archives before I ask a = question. I there a way to search. Thanks=20 -- MySQL General Mailing List

Hi, I just joined this list and would like to search the archives before I ask a = question. I there a way to search. Thanks=20 -- MySQL General Mailing List

I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the site are allowed to different parts of the database. I need to provide public information, including some contact details from the database, to unauthenticated (non-member) users and to provide a...

When I execute the following SQL statement at the mysql> prompt, I get a random result: SELECT proxy FROM proxies WHERE active = 1 ORDER BY RAND() LIMIT 1; When I wrap it in my perl code, I always get the first row in the database. my $dbh = DBI->connect("dbi:mysql:$db:host=$db_host", $db_user, $db_pass); my $sql = "SELECT proxy FROM...

Hi MySQL Fans ;-) I would like to list all courses with have less than lets say 10 participants. Does anybody know how I would have to modify the code below to get this to work ? schedule_id is the course itself SELECT schedule_id,count(schedule_id) FROM attendance WHERE

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

Hi, I'm trying to setup a webpage that will allow me to use similar results to that of show tables, show index from table_name, describe table_name and select * from table_name. I know that this can be done in php (Beginning PHP4 Databases has sample code). But can it be done with server-side javascript and ODBC/JDBC (I'll even look at...

Hello, Is there a way to specify MyISAM for all tables in a given file rather than having to specify it at the end of each table declaration. I think this would make porting databases back and forth to MySQL somewhat easier since including MyISAM as part of the table declaration is not compatible with standard SQL syntax, so I would like to...

have a table CREATE TABLE `pics2003` ( `ID` int(11) NOT NULL auto_increment, `Title` varchar(255) NOT NULL default '', `ShortDesc` text, `LongDesc` text, `Image` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=3DMyISAM; and after a while someone wanted something that would always be first in =