Hello Sam,
Thursday, March 28, 2002, 10:21:39 AM, you wrote:
SI The good solution for this would be to put OOPS behind of apache.
SI What is OOPS ?
The OOPS is squid-like PROXY application which mostly used as WEB
accelerator (server side proxy). The main idea of using it with
PHP/MYSQL
Hi there
The database is now running, i've created my tables and put the data
inside. This is fine.
Next step is to create a PHP-Website which communicates with the
database, but i am not able to connect over my apache (this is what it
seems to me).
to log into the database I use
Hi!
Check your my.cnf file for the line :
socket = path to sock
Then change the path to /tmp/mysql.sock or create a symbolic link
/tmp/mysql.sock to the path that was inthere.
Restart mysql and that should get you going.
EG
Hi there
The database is now running, i've created
Correction!
Look for the line socket in the [mysqld] section!
EG
Hi!
Check your my.cnf file for the line :
socket = path to sock
Then change the path to /tmp/mysql.sock or create a symbolic link
/tmp/mysql.sock to the path that was inthere.
Restart mysql and that should get you
* Chetan Lavti
Is it possible to run the MySQL Server from the remote machine..??
Mysql provides a Api's for shutting down the server from the remote
place i.e. ( mysql_shutdown(mysqlhadler))
but I can't see any api for starting the Mysql server from the remote
machine.
The client
Hi can someone confirm that one does not need to create a tld file ie
tag lib descripter and deploy to my META-INF subdirectory of my root
application. Also does one need to add the taglib element to my web.xml
file and a jsp page directive.
The reason is i didn't require any of these
Thank you very much
it workes now.
Could you tell me, how come, that the search-path points to /tmp/mysql.sock?
I've just created a link, but isn't it possibly to change the apache of
trying to connect to /tmp/mysql.sock?
thnax
dcp
Me wrote:
Correction!
Look for the line socket in the
Hi!
I was running an application that connected to a MySql server on the same
computer (workstation W2K). There was no problem.
However, I've tried to install the same system (application and MySql
server) on a Windows server, and the application fails to connect to the
server.
With the
Hi can someone confirm that one does not need to create a tld file ie
tag lib descripter and deploy to my META-INF subdirectory of my root
application. Also does one need to add the taglib element to my web.xml
file and a jsp page directive.
The reason is i didn't require any of these
On 27-Mar-2002 Ken Anderson wrote:
What is the fastest way to check if a table exists?
Do a select and catch the error?
Try to create the table, and catch the error?
Other options?
Thanks,
Ken
Yes, in php:
function tableexists($tbl) {
$res = @mysql_query( SELECT
Hi!
I'm not very used to php but its in php.ini :
mysql.default_socket
EG
- Original Message -
From: Dennis Peyerl [EMAIL PROTECTED]
To: Me [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 1:00 PM
Subject: Re: New Problem with LAMP (CORRECTION)
Thank
thien,
Thursday, March 28, 2002, 11:05:27 PM, you wrote:
t I am a developer of My SQL, and I am developing an application use unicode
t so I would like to ask you which version that support Unicode and where can
t I get it.
t Now I am using My SQL version 3.23.49
t thanks alots
MySQL doesn't
Voytek,
Thursday, March 28, 2002, 6:54:13 PM, you wrote:
VE I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with
VE it,
VE the installed MySQL did NOT have InnoDB support;
VE I then d/l off mysql.com
VE MySQL-Max-3.23.49a-1.i386.rpm
VE I installed it using:
VE rpm
I am a new comer to the sql world. I have some but brief knowledge of perl.
here goes!
I am using mysql on a Winnt platform and I have perl 5 installed on it. I
did setup dbi in perl and I know that mod is working. I have been trying to
get one of the scripts that came with the copy of mysql
Hi all,
I am in the process of designing a MySQL database that will run on Redhat
7.1, but I am fairly sketchy on MySQL and performance.
What I want to do is have a database that keeps track of large distribution
lists. Each list has a unique ID, an owner (which is a reference to an ID in
On Thu, 28 Mar 2002 14:46:01 +0200, Egor Egorov wrote:
You must first install original MySQL (rpm) package and then you can
install MySQK-max RPM. You can read about mysqld-max at:
http://www.mysql.com/doc/m/y/mysqld-max.html
If you want to use InnoDB tables you should specify InnoDB
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
- Original Message -
From: Harry Rorarius [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 7:46 AM
Subject: sql
I am a new comer to the sql world. I have some but brief knowledge of
perl.
here goes!
I am using mysql on a Winnt platform and I have perl 5
rpm -e the mysql product from the CD's to uninstall the originals.
then rpm -ivh MySQL-Max-3.23.49a-1.i386.rpm to install the mysql-max
product and you're golden.
Curtis
Voytek Eymont said:
I need some newbie help...
I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came
- Original Message -
From: Harry Rorarius [EMAIL PROTECTED]
To: Mysql list [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 9:18 AM
Subject: Fw: sql
- Original Message -
From: Harry Rorarius [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 7:46 AM
On 3/28/02 1:39 PM [EMAIL PROTECTED] wrote:
What I want to do is have a database that keeps track of large distribution
lists. Each list has a unique ID, an owner (which is a reference to an ID in
another table) and a creation date.
My question is this: Would it be more efficient to have
You can try to force an index with:
SELECT * FROM Posts USE INDEX(index4) WHERE Board = 'board1' ORDER BY
Board DESC, Number DESC
Mike
-Original Message-
From: Michael Bonfert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Problem
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
-Original Message-
From: Ben Holness [mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
...
My question is this: Would it be more efficient to have each entry in the
list stored in this table in the database, or would I be better
off having a
reference to a file that is
Hi Ben:
Performance would definitely be better if you store the data in the
database as opposed to simply storing references to files. Sounds like you
could solve this with 2 tables with one for the actual lists (assuming the
structure of all your list is the same) and the other for the list
J,
Wednesday, March 27, 2002, 4:46:08 PM, you wrote:
JvDBKA I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the
JvDBKA mysqld.log grows very rapidly.
JvDBKA Is there a way to turn it off ?
JvDBKA Logrotation is not really an option in this case, the only
JvDBKA possibilities are
erich,
Wednesday, March 27, 2002, 5:22:00 PM, you wrote:
e Does anybody have an idea how to select data from a local database into another
e host server ?
e For information, I'm currently using mySQL 3.23.
mysqldump?
You can read about mysqldump utility at:
voytek,
Thursday, March 28, 2002, 3:45:48 PM, you wrote:
You must first install original MySQL (rpm) package and then you can
install MySQK-max RPM. You can read about mysqld-max at:
http://www.mysql.com/doc/m/y/mysqld-max.html
If you want to use InnoDB tables you should specify InnoDB
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Bonjour,
J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la
base de donnée est de 1Go 5.
Quelles sont les limites pour le bon fonctionnment de mysql ?
Existe il un moyen plus rapide de faire des copies de bases que le dump ?
Merci
Cordialement,
Tony Jarriault
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
2 - Do I have to do anything special like stop requests to the
server while I add the index.
having problems working out sql where exists syntax.
Tried
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 269
Here we speak english.
Ici on parle anglais.
Tu peut copier les fichiers binaires des tables de mysql (*.MYD *.MYI *.frm)
dans le DATADIR
ex : linux /var/lib/mysql
par contre il doit y avoir
des problemes avec l intégrité des données.
Je te conseil de lire la doc de mysql en francais ss
Whoa,
I've had this message 3 times now. Is there a problem somewhere?
George
- Original Message -
From: Ben Edwards [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 3:38 PM
Subject: where exists sql problem
having problems working out sql where exists syntax.
Since I never saw much people speaking french using
this mailing list I though translating this message
for english users
Hi,
I use MySQL 3.23 under Solaris 7. The size of the Database
is 1Gig 5.
What are the limits for propoer MySQL operation.
Is there a faster way to copy a DB than using
mySQL does not support nested 'selects'. Read the manual, please :)
Ben Edwards wrote:
having problems working out sql where exists syntax.
Tried
select *
from sections s
where exists (
select 0
from pages s
where s.page =
Hi Chris/Nick/Scalper,
Thanks for the replies. I am not too sure how to implement this in tables,
so I will give an example:
Let's say I have three lists - a,b and c. List a contains 10,000 entries,
list b contains 2,500 entries and list c contains 75,000 entries.
I have a table of lists, with
ok
I thought Mysql was a server that could be used as a online database?
If it is, is there some material I have not read that tells me how to do
this?
I understood most of the information I read about Mysql. I was under the
understanding sql is the way to make a online database
Harry
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
I thought Mysql was a server that could be used as a online database?
Yes
If it is, is there some material I have not read that tells me how to do
this?
What are you trying to do? You have not been at all clear in
hi,
I've downloaded mysql-max-nt v.3.23.49, have setup InnoDB startup support. I
am now in the process of creating tables. When these are standard tables no
problem, eg:
create table test (id integer not null, primary key(id)) type=InnoDB;
works fine !
I have problems when I have tables with
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or
* Harry Rorarius
I thought Mysql was a server that could be used as a online database?
Yes, it is...
If it is, is there some material I have not read that tells me how to do
this?
Probably :o)
I understood most of the information I read about Mysql. I was under the
understanding sql is
Hi
$query = 'SELECT *
FROM Table
WHERE
FirstName LIKE %'.$firstname.'%' ;
if($lastname)$query.= ', AND LastName LIKE %'.$lastname.'%';
if($region)$query.= ', AND Region LIKE %'.$region.'%';
if($loan_officer)$query.= ',
Is there something similar for Greeks too?
(not that matters very much as I run on internet host but in case..)
Makis
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 10:25 PM
To: Philip Semanchuk
Cc: [EMAIL PROTECTED]
Subject: Re:
By the way you're using the terms, I would guess you're hoping
to make a new database, and place it on the web.
In that case, Mysql is probably at too low a level of
detail for your needs. To solve your problem you
would need to learn:
HTML
CGI
middleware (ASP, PHP, etc)
MySQL
SQL
database
Well after some pondering I found a pretty easy work around:
SELECT main.id, description, maincat.name, subcat.name from main
LEFT JOIN maincat ON maincat.id=main.maincatid
LEFT JOIN subcat ON subcat.id=main.subcatid
WHERE MATCH (description) AGAINST ('keywords')
OR
WHERE MATCH (maincat.name)
I am quite new to coding and have managed so far but, i've been havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out, and
haven't found any helpfull documentation
I have a mysql database, and i want to sort a table by date Where the
resulting records
Hey David.
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending order..)
Replace 'table' with the name of your table and date_column with the
name of the column that contains the
Sorry to repost. I got one answer and stumped the guy trying to help (thanks
again btw). If anyone has seen this or has any ideas, any help would be
greatly appreciated.
---
RH 7.2.
mysql-3.23.44
I have a single server running mysql. I have added one database I use. For
some unknown
Hi,
I have setup a table with user login name and password. The password is
encrypted with the MySQL's password(). How do I compare these info with the
user's input.
I had
$query = select * from auth where
usrname='$logname' and usrpass=password('$logpass');
mysql_query($query);
But I can't
David, Steven,
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending
order..)
Replace 'table' with the name of your table and date_column with the
name of the column that
Is there a master.info file somewhere?
What's your my.cnf look like?
If you want, you can email me the file and I'll be happy to try and
help.
--
sh
On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote:
Sorry to repost. I got one answer and stumped the guy trying to help (thanks
again btw).
D'oh. Forgot he wanted after now :)
Thanks.
On Thu, 2002-03-28 at 10:46, DL Neil wrote:
David, Steven,
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending
order..)
Mark, Peter,
The query below assumes that the user will search of FirstName and none
or more of the other fields - which was not how the question reads (to
me).
To answer the question it would be useful to know how you are accessing
MySQL - are you using PHP (as per example code below) for
In your situation (or any situation, IMHO),
multi-value fields defeat the purpose of good database
design.
I think you are on the right track if you are willing
to tolerate a little redundancy for the sake of
simplicity (as a one-to-many relationship). If you
really want to structure it as a
DL -
Points well taken -
I am using php and doing simple validation
EX - if ($fname !=) {
add fname string to search variable;
}
And if none of the fields have been filled out I'll return an error msg.
As you mentioned, Peter's logic still applies here and it has given me
enough to work
Nick,
This is pretty familiar to me because I'm analyzing the behavior of
people
in on-line discussions, so I'm gathering such data.
Which begs the questions:
- in what way are you analyzing behavior? and
- in what way are you analyzing this list-community?
=dn
MySQL list busting
Hi Makis,
default-character-set = greek
Try that, best wishes,
Ken
P.S. also for anyone else asking here are all the charsets included
in MySQL by default. You can also create your own.
mysql show variables like char%;
++
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
...
Which begs the questions:
- in what way are you analyzing behavior? and
- in what way are you analyzing this list-community?
There's too much to read, is the simple answer to the first question.
Over the last few
Mark,
Tutorials: Start at the PHP home page and look for the links page.
DevShed would be a good start.
Regards,
=dn
- Original Message -
From: Mark Stringham [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]; Peter Lovatt
[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: 28 March 2002
Suppose I want to select items 10 to 30 from a table tab, which has 36 rows.
What could be the sql query ?
Thank you.
Aman
PS: I am using cgi-perl.
_
MSN Photos is the easiest way to share and print your photos:
Olivier,
please check that the data types of corresponding columns in the referenced
tables are the same, and that you have created the necessary indexes in also
the referenced tables.
I tested the following:
C:\m\client_debugmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;
There's probably a better way to do that though.
tyler
- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items in sql
Hey thanks i got it to work sort of
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date DESC LIMIT
3;
that works
but i want it to show them ascending and when i change it to
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC; DESC
LIMIT 3;
it doesn't work
any
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = SELECT *
From: Aman Raheja [EMAIL PROTECTED]
Suppose I want to select items 10 to 30 from a table tab, which has 36
rows.
What could be the sql query ?
Thank you.
Aman
PS: I am using cgi-perl.
How are these items identified as items 10 to 30 in the table?
Does that mean that when you SELECT *
If you only want it ascending, take out the DESC as in:
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
- Original Message -
From: David Rice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part II)
Thanks very much to every who helped me with my MySQL problem!
I will probably go with the three table solution as it also eliminates the
need for yet another table!
Cheers,
Ben
-
Before posting, please check:
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount of hits for a row value?
My table is structured as follows:
Name, Url, Author,
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount of
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Yeah, but thats not what I'm asking, how can I get this info from the table?
Does mysql have a built-in feature that stoes the hit information and if so,
how do I pull this info from the table?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Hi all,
I ve got a database with the name
db-name
when making :
select * from db-name.table;
I get a error.
something is wrong in your syntex near : -name ...
How can I tell mysql that db-name is a database name ?
Thanks.
_
Do You
we have to escape name
select * from `db-name`.`table-name`;
works.
great mysql.!
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
I am trying to configure mysql for redundancy using replication and the
built-in mysql master/slave configuration. What I don't understand, even
after much reading, is how to recover from a failure. If host B is slave to
host A, and A goes down, B could then be manually or automatically
You need to use the use command
Mysql \u [databasename]
Now you may run the query
Mysql select * FROM dbname.table;
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:25 PM
Cc: [EMAIL PROTECTED]
Subject: pb while querying in strange db
Ok thanks guys.
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
Hi all,
I make a huge sql dump to mysql client
ie :
mysql dump.sql
the dump.sql is nearly 650 MB.
I get some strange file near my table files :
12 -rw-rw1 mysqlmysql8678 mar 28 22:26
/var/lib/mysql/doz/#sql-9a8_17.frm
63428 -rw-rw1 mysqlmysql64880640
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
Let's say A and B are running together.
Then someone does a large update query and A is done with, while B is in
the middle of it, and A crashes.
You can switch over to B, which won't contain the data, but it'll have a
good snapshot of what the data was before the crash.
When you recover the A
At 06:20 AM 3/28/2002, you wrote:
On 27-Mar-2002 Ken Anderson wrote:
What is the fastest way to check if a table exists?
Do a select and catch the error?
Try to create the table, and catch the error?
Other options?
Thanks,
Ken
Yes, in php:
function tableexists($tbl)
Joe,
Replication is pretty much instantaneous (depending on network speed),
since the servers communicate using the binary log files. Having said that,
there is no replication scheme for any database product that can guarantee
(over asynchronous replication) that some data won't be lost or
Hi all,
I have a uge table data about 700mb pii 333 200mb ram. mysql 4.02.
I try to add a full text index
alter table listing add fulltext (about,title,description);
but it seems to do noit effect the ib files in the datadir seems to keep the
same length no grow.
when querying it say no full
Ian Linekrans [EMAIL PROTECTED] writes:
Hi All !
The configuration:
- Redhat 7.2 (Enigma) pre-build installation.
- Mysql with the following rpms installed:
MySQL-3.23.49a-1.i386.rpm
MySQL-client-3.23.49a-1.i386.rpm
The installation and
This is my first time posting to this list, so please forgive me if I am not
doing this correctly. I will break this into post into two parts: what i
want to know and why. Is there a way to get auto_increment fields to fill
in gaps in the numbering sequence if some records have been deleted?
Hi. How can I import a text file containing all fixed-length records into
MySQL? Is there a way to do it with LOAD INFILE? The text file was
originally designed for import into Oracle. Thanks.
David
-
Before posting,
On Thu, Mar 28, 2002 at 09:37:47AM +0300, Peter Zaitsev wrote:
Also a good thing with DRBD you will not have to store and track
replication log files and the setup will not require to take MySQL
down to copy the snapshot of database.
Why would you need to take down MySQL for a backup
Hello mysql,
So nobody here (even at MySQL AB) knows how to set a timezone for a
MySQL client ? Not for whole server but per client? (or maybe for
database???)
I already posted this question here few days ago - and didn't get any
reply.
Please! Somebody help!
--
Best regards,
Maxim
I have a new client that wants to use filemaker on his mac to enter data
for site information. I'm sure that I can take that and export the
files and import into the site's MySQL database...but I'm wondering if
it is possible to link his filemaker database to the MySQL database
using ODBC? I
Per client? Per database? The only timezone setting in the MySQL manual is
for the server (tz), and permits you to set it to your local timezone so it
does not return values in GMT.
If you want clients to have different timezones, perhaps you should write
that capabilty into your front-end
Hello Gerald,
But how people build web-applications then ? How can you use
web-hosting in GMT+1 if web-application will be in use in GMT+5 for
example?
Have anybody an experience of resolving this problem (without
embedding this functionality to backend app, because backend app is
allready
Hello Gerald,
But how people build web-applications then ? How can you use
web-hosting in GMT+1 if web-application will be in use in GMT+5 for
example?
Have anybody an experience of resolving this problem (without
embedding this functionality to backend app, because backend app is
allready
What i want to do seems simple, but i can not for the life of me figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get this:
SELECT
--
1,1,Bob
I have a question about determining which case
occurred when there are no matches - using two tables.
Scenario:
- two tables, one for photos, and one for collections
- zero or more photos can belong to a collection
- the database may not know the collection_id requested
(i.e. the user on
*** WYSYKA JEDNORAZOWA - PRZEPRASZAMY JEELI NIE TRAFILIMY W PASTWA ZAINTERESOWANIA
***
Wraz z najlepszymi yczeniami witecznymi przekazujemy za porednictwem Pastwa konta
e-mail ([EMAIL PROTECTED]) krtki przegld atrakcji z naszej oferty:
1. Dla Twojego DOMU I RODZINY proponujemy projektor
Subject: database design
From: deco [EMAIL PROTECTED]
===
I'm having a problem getting this to fit...
I have a file with a bunch of data stored... This data represents messages,
one after the other, with message header followed by message data.
I'm porting this to a mysql database. The thing
Depends on the language you are writing in, and the level of your
programming skills.
If your users/guests have database entries, it would be a rather trivial
task to set their timezone in a column in the database, then write your app
to calculate their local time based on the offset from GMT.
Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql
Jeff Habermann asked:
well. Now, because of this deletion, there are sequence gaps in the "idx"
field. We would like to be able to use those numbers again for incoming
clients...Is this possible?
It looks like you can, but IMHO, it would probably be more effective to add
a DELETED flag to
David Yee queried:
Hi. How can I import a text file containing all fixed-length records into
MySQL? Is there a way to do it with LOAD INFILE? The text file was
originally designed for import into Oracle. Thanks.
http://www.mysql.com/doc/ 'import' SEARCH/
1 - 100 of 101 matches
Mail list logo