| |
thread by: binary-nomad |
last post Nov 23 '05 by: www.1-script.com
Hello,
When I do a "AND" in a SQL query, eg. SELECT NAME WHERE SEX="male" AND
AGE= "30", MySQL does a sub-search, right? i.e. it does the "WHERE
SEX=male" first, and then searches through the list of *those* results
to see if AGE=30?
Does it do this from left to right? i.e. in the query above, would the
table always, and necessarily, get...
|
thread by: griemer |
last post Nov 23 '05 by: Bill Karwin
I have a database like this
id, field1,field2,field3,field4,field5
Database contains 100 rows, some rows have no fields filled, some
1field , some 2 fields etc.
How would i count the number of fields filled in total?
So the outcome is (number of fields filled in row1)+(number of fields
|
thread by: Gregory.Spencer |
last post Nov 23 '05 by: Gregory.Spencer
Hi there,
Using PHP and MYSQL I changed one of my MySQL search queries to allow a
situation where the user gets much more information returned then
previously
However, it has now given me the error message:
Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to
allocate 42 bytes) in /usr/share/pear/DB/mysql.php on line...
|
thread by: Marc DVer |
last post Nov 23 '05 by: Marc DVer
I am at kind of a loss on how to design a certain database project I am
working on. Basically, we have a proprietary program with a standard
backend (though we do not have direct write access to the backend).
What I am working on is a project to take certain data from the
database, send it to certain vendors, process the data, and send it...
|
thread by: Ian Davies |
last post Nov 23 '05 by: Ian Davies
how can I retreive the path to a mysql database. I need to use it as a
string in my program to find image files that are stored in the same
directory?
Ian
|
thread by: My SQL |
last post Nov 23 '05 by: My SQL
Hi
Can I trigger an external program to run when a new record is added to
the mysql table?
The external program is in C and instead of scanning the table
continuously for new insertions, it will be better if an external
program could be triggered.
Any suggestions?
|
thread by: MattPF |
last post Nov 23 '05 by: Felix Geerinckx
I have a table that is --
30 Megabytes
90,000 rows
~65 columns
My query goes
SELECT city FROM table WHERE zip = 90210;
It will then find about 10 matching records.
|
| |
thread by: Richard Ragon |
last post Nov 23 '05 by: Gordon Burditt
I dont profess to be a master at SQL statements. Thanks for your help,
if anyone can give it.
I have a database that has a run column. A user can place in that
column a number, such as 1, 2, or 3.
I want to organize me list by this run number. The problem is that when
I call the query it places all the rows that have no number on the...
|
thread by: Todd Cary |
last post Nov 23 '05 by: Markus Popp
My client is using a shared server running MySQL 2.4, however the in
house server is 4.1.12 with mysqldump 10.9. Is there a way to have the
10.9 version output a format that is fully compatible with 2.4?
Some of the CREATE TABLE statements in 10.9 are not accepted by 2.4.
Currently, I am not using any of the switches in creating the...
|
thread by: areejan2000 |
last post Nov 23 '05 by: Bill Karwin
Experts/Programmers please advice on these questions.
1. Is Mysql secure than MsAccess (there are softwares avilable to
retrieve Ms Office Password)
2. Which 3rd Party tool Would You recommend for Administration,Query
creation.... Etc
3.Any tools for setup Mysql database to ship with ApplicationProgram
(Access need not be installed...
|
thread by: lagj |
last post Nov 23 '05 by: lagj
Using MySQL 5.0.15
I am no expert so maybe I am deeply misundertanding how this should
work. I have a relatively complex quey with joins and a subquery (it is
probably far from optimized, but that is another issue; right now I am
more interested in correctness than speed). If I do not put a GROUP BY
clause then the query returns a number of...
|
thread by: Ian Davies |
last post Nov 23 '05 by: Ian Davies
hello
can anyone help me with an sql statement that will work for mysql to take
data from two tables where the two tables are linked with a common field. As
you can guess im new th mysql
Thanks
Ian
|
thread by: kalika patil |
last post Nov 17 '05 by: ANWAR ALHENSHIRI
--0-413911351-1058468110=:5477
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Hello
I want to know if there is java API to mySQL like its available for C and C++.
Bye
Kalika
|
thread by: Curt Larsson |
last post Nov 16 '05 by: mkatkin
Hi, I have a problem to connect to my local server
After I have done:
c:\mysql\bin>mysqld --standalone
I try:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
|
thread by: Good Man |
last post Nov 11 '05 by: Markus Popp
Hi there
I'm developing a large web application. Part of this web application will
be storing numerical chart data in a MySQL table - these numbers will be
already calculated, and are just being stored for reference.
In this particular table, the stored data will never be deleted or
changed. The only actions performed will be SELECTs and...
|
| |
thread by: unc27932 |
last post Nov 11 '05 by: unc27932
I'm famililar with other DB systems, but for some reason am having a
problem with the simplest of queries.....
SELECT *
FROM table1
WHERE famc NOT
IN (
SELECT familyID
FROM table2
)
|
thread by: Asteras |
last post Nov 11 '05 by: Asteras
This is my Table Tb that has a composite key (ID and Pr are both
Primary Keys):
ID | Pr
1 | A
1 | B
1 | C
2 | B
3 | A
4 | A
|
thread by: Ike |
last post Nov 11 '05 by: Markus Popp
I have a text file with about 90,000 insert statements (as below). Is there
an easy way I can get these into my mysql database in one fell swoop? Can
anyone tell me how and perhaps that the syntax is? Thanks -Ike
INSERT INTO `lastnames` VALUES ('OFFENBERGER');
|
thread by: news.sf.sbcglobal.net |
last post Nov 10 '05 by: Bill Karwin
Is there a GUI interface that is easy to install to manage MySQL on linux?
I'm trying add a user account and password to the db server but I'm not
having any luck from the command prompt. I'm trying to setup the nexus
discussion software. Any help appreciated
|
thread by: Jorge King |
last post Nov 10 '05 by: Jorge King
qim
----KZbS7hrbznJi92oKn
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE=
: 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar=
ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE=
CORATION: none...
|
thread by: foo |
last post Nov 10 '05 by: Bill Karwin
Can someone please tell me how I can do this:
I have an appointment table which has appointment_id, client_id,
appoinment_time (as unix timestamp). Clients can have multiple
appointments.
I want to select all appointments from the appointment table but only
one appointment (the latest one) for clients that have multiple
appointments. How...
|
thread by: charles |
last post Nov 9 '05 by: charles
What is the proper procedure for promoting a Slave into a Master
replication server?
We want to do some fail-over testing. When we tried this in the past, the
former master would not replicate. We got an error: "master and slave
have equal MySQL server ids".
The fail-over procedure includes renaming the slave and exchanging IP...
|
thread by: steve |
last post Nov 9 '05 by: uli
Hi,
When I import mysql data from a dump file into mysql, then phpmyadmin
under structure shows sizes as unknown. I googled for this, but could
not find a good answer.
How do I get the information to show in phpmyadmin?
Thanks!
--
|
| |
thread by: Matthias Stern |
last post Nov 9 '05 by: Matthias Stern
Hi!
I'm using the MySQL "Load data" command to load big .csv files into a MySQL
database. Sometimes there are special characters within these .csv files
which cause some kind of "displacement" of the loaded data.
(1) Is there a way to check if the data from the .csv file was loaded
correctly ?
(2) I'd also like to know in which line an...
|
thread by: rhamlin |
last post Nov 8 '05 by: Jeff North
I'm fairly new to creating complex sql statements and need a little
help.
In plain english I want to do this: Select menu rows where the row's
userGroupIDs equal the user's userGroupIDs.
Menu.userGroupID has multiple values seperated by commas.
User.userGroupID also has multiple values seperated by commas. I
realize some may want me to...
|