Hi!
>>>>> "Ed" == Ed L writes:
Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
Ed> replication. Here's my scenario...
Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
Ed> master-slave configuration t
gt; times.
>
> Regarding snapshots, how long are snapshot locks held? These are ext4
> filesystems. Assuming the lock is not held for long, what's the
> recommended way to do snapshots on ext4?
>
> Thanks,
> Ed
>
>
>
> On Thursday, August 29, 2013, Ed L. w
. <mailto:mysql@bluepolka.net>> wrote:
>
> Mysql newbie here, looking for some help configuring 5.0.45
master-slave replication. Here's my scenario...
>
> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
master-slave configuration to a new, beefier se
Why don't u try snapshot backups, where the lock held for less duration. Or
can't u take mysql dumps during Night time when there is less bd activity
On Thursday, August 29, 2013, Ed L. wrote:
>
> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replica
Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my scenario...
We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
master-slave configuration to a new, beefier server running same mysql
5.0.45, and then cutover to the new s
I can understand your point, however, as stated, I am using a ppc
architecture and am not afforded the luxury of binaries in the most up to
date versions. I know using 5.1.59 isn't the most up to date, but I was also
having issues with the most current version. I might start with the most
current b
I can't help directly with the error message (the warning seems fairly
harmless), but may I inquire why you are building MySQL instead of using one
of the prepared binaries? Compiling under OS/X can be pretty harrowing.
- michael dykman
On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock wrote:
> I
I am trying to install mysql 5.1.59 on my ppc running os x and I get this
error message in the term.c file.
cc1: warnings being treated as errors
term.c: In function ‘term_set’:
term.c:946: warning: passing argument 1 of ‘tgetflag’ discards qualifiers
from pointer target type
term.c:947: warning:
2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables "events" and "categories" which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 |
ID also have multiple
> event id ?
>
>
> --
> Cheers
> Dhaval Jaiswal
>
>
> On 01/03/2011 5:53 PM, Wagyu Beef wrote:
>
>> Hey guys,
>>
>> Am a newbie here and need a little help.
>>
>> Part of the database con
Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables "events" and "categories&q
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables "events" and "categories" which
look like this
+---+-+
| eventID | eventName |
+---+-
Thanks all... I got this to work! Much appreciated..
And thanks for patience with a newbie!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 9/10/10 12:31 PM, Jerry Schwartz wrote:
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
My
September 10, 2010 12:09 PM
>To: mysql@lists.mysql.com
>Subject: newbie question database tables
>
>I'm working on a database that needs to do a few things and getting
>brain freeze on one part.
>
>Scenario:
>
>
>I want to compile a db of articles with these tables
, but then I couldn't expand
later.
Reverse is true if I add user_ID to the Topics.
So, need an idea how to solve this so it doesn't matter how many new
users I keep adding, I can still see who is using the topics.
As I said, a newbie question. Thanks much.
--
Patrice Olivier-Wi
On Fri, Jun 18, 2010 at 16:30, Dave wrote:
> SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
> name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a WHERE...IN statem
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did wrong.)
Jerry Schwartz wrote:
[JS] This is just a shot in the dark, but Excel can be rather surprising when
it puts out a CSV file. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what happ
>-Original Message-
>From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
>Sent: Sunday, September 27, 2009 10:19 AM
>Cc: 'mysql'
>Subject: Re: Newbie question: importing cvs settings
>
>Back again... I have 192 records to import, and tried my extra lin
6, 2009 11:02 AM
To: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using
base Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 27 September 2009 15:19
Cc: 'mysql'
Subject: Re: N
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
Yep, typo ...:-(
I did
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greetings:
I have a project for which need to import cvs file
fied MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greet
Greetings:
I have a project for which need to import cvs files into db.
I can do so up to a point. The import will only do 16 lines,
consistently. Error is failing at line 17.
Steps:
create table fields in Excel document, where they all match database fields
enter information in several of t
Hi Walter,
Walter Heck - OlinData.com wrote:
Hey Tim, all
On Wed, Jun 24, 2009 at 10:03 AM, Little,
Timothy wrote:
Why, you might ask, index on physmessage_id? Because then the db won't
have to do a fetch on items from the table since it's in the INDEX
itself, saving any unnecessary reads.
F
wever, making the index might take a serious bit of time.
>
> Please let us all know how it does or does not work.
>
>
> Tim...
>
>
> -Original Message-
> From: Ken D'Ambrosio [mailto:k...@jots.org]
> Sent: Wednesday, June 24, 2009 11:07 AM
> To: mysql@li
Hey Tim, all
On Wed, Jun 24, 2009 at 10:03 AM, Little,
Timothy wrote:
> Why, you might ask, index on physmessage_id? Because then the db won't
> have to do a fetch on items from the table since it's in the INDEX
> itself, saving any unnecessary reads.
FYI: That only holds true for InnoDB, not for
-
From: Ken D'Ambrosio [mailto:k...@jots.org]
Sent: Wednesday, June 24, 2009 11:07 AM
To: mysql@lists.mysql.com
Subject: Indexing? (Warning: relative newbie.)
Hi, all. I'm a long-time MySQL user who's only recently had to start
learning some administrative stuff, largely because I
e
direction for stuff like this?
Sorry for all the newbie questions, but I haven't done serious database
stuff since Foxbase/dBase III days. Things have changed a little since
then.
Thanks!
-Ken
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believe
I have written a .cfm to output a listing of columns with Name, Format, Size,
NULL, KEY, etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query ... ?
effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
> CC: win32-h...@lists.mysql.com
> Subject:
Hello Bob,
BobSharp wrote:
Picture does not seem to have been carried in the message, posts with
attachment did not seem to get through either.
So hope the link works.
Below is the ER diagram in an exercise I am trying to do.
http://www.probowluk.co.uk/images/er_ECA_001.jpg
It's been going
Picture does not seem to have been carried in the message, posts with
attachment did not seem to get through either.
So hope the link works.
Below is the ER diagram in an exercise I am trying to do.
http://www.probowluk.co.uk/images/er_ECA_001.jpg
It's been going well so far, and several Col
Below is the ER diagram in an exercise I am trying to do.
It's been going well so far, and several ColdFusion pages written already.
Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders
My problem is in the CFquery - unders
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) s
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> H
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button says:
HELP
Help isn’t available for MySQL Administrator.
Really, no help or did I screw-up the install somehow?
2. - I tried to create my first Table in MySQL Administrator but got
this me
or as the docs read:
shell> mysqladmin password
John Daisley wrote:
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> FLUS
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> FLUSH PRIVILEGES;
mysql> EXIT;
Where newpwd is your desired password.
Best to
I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the
stupid questions ...
1. I have just downloaded and successfully installed MySQL v5.1 on my
MacBook Pro running OS X 10.5.6
2. I have also downloaded and installed MySQL Tools: Administrator &
Query Browser
(I come from
Hi Dave,
that's easy. Either install
http://www.phpmyadmin.net/home_page/index.php on the server, the best
tool to manage a mysql server.
Or use XAMPP, a complete package from
http://www.apachefriends.org/en/index.html
Guenther
Dave Stevens wrote:
> Hello all,
>
> I have set up a little serve
Dave,
Log in as the user you intend to set up for them. Issue the following:
show grants;
select @@sql_mode;
If you aren't sure how to interpret the information I will direct you
to the manual: http://dev.mysql.com/doc/refman/5.0/en/
Side note: I would upgrade. 5.0.45 has some pretty serious
Hello all,
I have set up a little server and am pitching to an organization to host their
upcoming new site. The box is Centos 5.2 up to date and mysql 5.0.45. The
requirements below must be met but I don't know how to verify their status.
Can someone point me in the right direction. Will read
Hi Mário, all !
Mário Gamito wrote (re-ordered):
Sebastian Mendel wrote:
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 10:19 AM
To: mysql@lists.mysql.com
Subject: Newbie question, how do I respond to post
Hello,
I feel stupid here... How do I respond to a specific post?
I posted last night, I got a response... now I want to post a response to the
response.
Don't see a way to do that...
Thanks,
Lee
**
Start the year off right. Easy ways to stay in shape.
http://body.aol.com/fitn
I think this change will get you what you want:
SELECT comment_approved, COUNT(comment_agent)
from wp_comments
WHERE comment_agent LIKE '%Linux%' AND comment_approved=0
GROUP by comment_approved
andy
Mário Gamito wrote:
Hi,
I'm trying to get a single number out of a SELECT statement:
SEL
Hi Michael,
I've tried your tip, but I get the error:
"#1054 - Unknown column 'ct_ct_comment_agent' in 'field list'"
Any ideas ?
Warm Regards,
Mário Gamito
Michael Cole wrote:
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(
Hi Sebastian,
Thank you for your answer.
I tried your way, but still, I get a column with two values:
|-
|COUNT(comment_agent)|
||
| 1|
--
| 47|
--
What I need is just the 47.
An
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(ct_ct_comment_agent) from (SELECT comment_approved,
COUNT(comment_agent) as ct_comment_agent from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comme
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comment_approved
But instead i get two rows:
|
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by comment_approved
But instead i get two rows:
|--
|comment_
ated root on this machine (I understand that
> Apple, by default disables it), perhaps there's something I'm missing
> in my lack of knowledge of the way the Mac OS uses root?
>
> I'm sure this is a stupid newbie issue, but I'm a bit wrapped around
> the axle here
Mac OS uses root?
I'm sure this is a stupid newbie issue, but I'm a bit wrapped around
the axle here. Do I need to use sudo? (I've even attempted this with
no success). I've searched on a few lists to see if anyone has had
this problem, but not seen it yet.
Should I just re
Hi Sebastian,
That was it alright. I commented out the socket lines from mysql.ini
(restarted it) and changed my php command to:
$mysqli = new mysqli(".", $username,$password, $database);
and all seems to be working fine now.
Thanks again for your help, much appreciated.
Regards,
John
John Comerford schrieb:
> Hi Sebastian,
>
> I did read somewhere that sockets was not valid for windows, and
> '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
> tried the following commands:
>
> $mysqli = new mysqli(".", $username,$password, $database);
> or
> $mysqli =
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(".", $username,$password, $database);
or
$mysqli = new mysqli(".", $username,$password, $
John Comerford schrieb:
> Thanks Sebastian, that did the trick.
> The full command I use is:
> $mysqli = new mysqli(".", $username,$password,
> $database,null,"/tmp/mysql.sock");
there is no need for the socket, their are no sockets on windows
$mysqli = new mysqli('.', $username, $password, $dat
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(".", $username,$password,
$database,null,"/tmp/mysql.sock");
Regards,
JC
Sebastian Mendel wrote:
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable netwo
John Comerford schrieb:
> Hi Folks,
>
> I have a database running on Window XP, that I want to disable network
> connections to and enable 'named pipes'. I am running MySQL 5.0.27
> and my.ini looks like...
>
> [...]
>
> I can connect to the DB using the GUI tools if I set my pipe name to
> '
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[client]
#password= your_password
port= 3306
socket= /tmp/mysql.sock
[mysqld]
#port= 33
RELEASE is a reserved word, and if used as column-name, it
must be quoted (back-tick) `release` char(255) .
On Tue, May 8, 2007 12:09, Shahbaz Khan wrote:
> This is the exact error that mySQL reported:
>
> ERROR 1064 (42000): You have an error in you sql syntax; check the
> manual that corres
This is the exact error that mySQL reported:
ERROR 1064 (42000): You have an error in you sql syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'release char(255) bunary not null,
primary key (fileid,relea' at line 3
MySQL server versi
This portion of the script gives error.
reate table lxr_releases
(fileid int not null references lxr_files,
release char(255) binary not null,
primary key (fileid,release)
The script is present as attachment if needed. I suspect this script
is for mysql 4
, 2006 4:29 AM
To: mysql@lists.mysql.com
Subject: Complete newbie (OSX Server - MySQL)
Complete newbie here.
Purchased software for my OSX Server 10.4.8 to use with MySQL and PHP. I
get an installation window that opens and asks for Host: (with a default of
localhost).
User: site
Password: (the one
Complete newbie here.
Purchased software for my OSX Server 10.4.8 to use with MySQL and PHP. I
get an installation window that opens and asks for Host: (with a default of
localhost).
User: site
Password: (the one the person who sold me the script provided).
Database: site
License key
On 11/24/06, Algomez <[EMAIL PROTECTED]> wrote:
Hello,
I have an application that stores the information in several MySql databases
and I am starting to look at the information and I found a problem.
Information is stored everyday in threed different sessions. Each session
creates a new databas
do so?
thnaks in advance.
--
View this message in context:
http://www.nabble.com/Newbie---View-several-databases-as-one-tf2697982.html#a7524188
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
before all thank you for your answer,
next
while waiting for an answ3er I backup the db then tried to convert tables
in Inno db format
everything run fine now, the same query execute ok
but i prefer myIsam format i use it as default,
then I'd like to understand what is the problem,
here are al
Adriano -
MySQL names temp tables like that (starting with # sign), in paticular
while storing a result set to be sorted. I would guess that your
query is returning a result set large enough to hit a filesystem limit
on your box. How big are you expecting the results to be? Perhaps
you are mis
Hy thank you all, I'm getting the following err msg
-> The table '#sql_2c52_0' is full
running a complex query (and only running that query) with three outer join
it is a simple db that stores mail msgs
my query is about mail msg->recipients->sender
the biggest table mail_archive has 90467
Grass Cake wrote:
I'm still unsure about foreign keys..even after reading the doc file and
Paul Dubois 3rd edition
My doubt is...how much constraint is applied.( probably a bad
explanation)
If i have a table 'Customers' with the primary key being 'CustID'
Then i have a table 'LastVisit' wi
I'm still unsure about foreign keys..even after reading the doc file and
Paul Dubois 3rd edition
My doubt is...how much constraint is applied.( probably a bad
explanation)
If i have a table 'Customers' with the primary key being 'CustID'
Then i have a table 'LastVisit' with a foreign key 'C
Naser, Md Abu wrote:
Hi All,
I am very new. I wish to do some exercise before I go to real business.
Could anyone advise me any tutorial link or resources for beginner?
Some tutorials are listed at
http://www.artfulsoftware.com/dbresources.html. Also you might want to
look at
http://www.a
Hi All,
I am very new. I wish to do some exercise before I go to real business.
Could anyone advise me any tutorial link or resources for beginner?
With best regards,
Abu Naser
School Of Life Sciences
Heriot-Watt University
Edinburgh EH14 4AS
Email: [EMAIL PROTECTED]
Phone: +44(0)13145182
While this is offtopic, just a side note:
You probably want to store your images on disk with the filename in
the database rather than the actual image binary data in the db.
Filesystems are very good at storing and retreiving chunks of binary.
Databases do it because... well... I'm not really su
At 04:22 PM 7/21/2006 Friday, Scott Haneda wrote:
> I'm going throught some tutorial about uploading and displaying
> images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
Yes, it's cross-posted. I j
> I'm going throught some tutorial about uploading and displaying
> images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
--
-
Scott Haneda
Hi All,
I'm going throught some tutorial about uploading and displaying
images files. But the display script isn't working. Here's what I have:
Table setup is:
CREATE TABLE `image` (
`ImageId` int(10) NOT NULL auto_increment,
`Image` longblob,
`FileType` varchar(32) default NULL,
PRIMARY KE
Rob Desbois schrieb:
I agree that it's often better to point someone in the right direction rather
than just writing the query for them, but in this case it was a newbie question.
And therefore it's most important that he tries to learn how to look at
the doc.
Remembering my ow
>> I agree that it's often better to point someone in the right direction
>> rather than just writing the query for them, but in this case it was a
>> newbie question.
>And therefore it's most important that he tries to learn how to look at
>the doc.
Remember
y for them, but in this case it was a newbie question.
And therefore it's most important that he tries to learn how to look at
the doc.
Or your newbies will start asking every shit on List because the don't
know what to do else.
From where I saw it, the difficulty was in concate
for them, but in this case it was a newbie
question. From where I saw it, the difficulty was in concatenating values from
2 rows, not the concatenation itself. That is why I thought your response was
not sufficient.
Apologies if I cau
Rob Desbois schrieb:
To those who responded - read the question.
He wants to combine the values from the data column of *2* rows into one, not
just a straightforward string concatenation.
Sorry but you want me to write the whole SQL query?
He has to use his brain.
Grouping and joining the
Hi, the GROUP_CONCAT worked. Thank you. However, I'm getting duplicates in
the "all_data" column. Is there a function like array_unique in PHP to
remove these duplicates?
I tried DISTINCT but that did not work.
Thank you.
--
View this message in context:
http://www.na
Thank you!
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171108
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi,
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
site
>> z247 schrieb:
>> Say I have the following tables;
>>
>> siteID,name
>> --
>> site1, XYZ
>> site2, RSQ
>>
>> ID,site,data
>>
>> 1, site1, M
>> 2, site2, Q
>> 3, site2, Y
>> 4, site1, P
>>
>> ... etc.
>>
>> And I want to create a view like
z247 schrieb:
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
Search the Manual for CONCAT.
SELECT
/Peter
-Original Message-
From: z247 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 04, 2006 10:02 PM
To: mysql@lists.mysql.com
Subject: Newbie - CREATE VIEW Question
Say I have the following tables;
siteID,name
, (M,P)
site2, RSQ, (Q,Y)
where all the related column data in the second table is placed in another
column. How can I do this? Is there a function that can group these values
into one variable or array?
Thank you
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW
Eko, you're not JOINing the two tables together - your database is
taking the time to produce a huge result set known as a cartesian
product, which is probably not what you want. You need to introduce an
additional WHERE clause specifying how the two tables should be JOINed, like
WHERE hiart0
I have a query statement like this
select hiart01a.cust, hiarf01.nama, hiarf01.al2, hiart01a.tgl, hiart01a.netto,
hiart01a.muka
from hiart01a, hiarf01
where hiart01a.tgl>=from_days(to_days(now()) - 180) and
hiart01a.tgl<=from_days(to_days(now()) - 30)
order by hiart01a.cust;
when I run
values of 375, 17, 3 and a bunch of 1s in the rows column, whereas
the second shows 375, 34, 6 and the same lot of 1s. All other details
are identical.
As I understand it in my naive, newbie way, as a rough rule of thumb
you can compare the speeds of queries by multiplying together the
rows va
At 16:09 +0100 11/5/06, I wrote:
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
...
That's all fine and dandy, but now I need to extend this to a
further four tables...
What I should have added is that for the moment this has to be
p
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
Finding names of people (and other info) where one or more fields
match the search string in up to five tables (abstracting somewhat):
select distinct
id, firstname, lastname,
MySQL Mailing List,
Currently I'm running MySQL 4.1.15 on my home computer where I do web
development, and MySQL 4.1.13-beta on my hosting service. Actually, I do
work on web sites that are hosted on many hosting services, but on only
one of them do I have enough access to decide for myself if
David T. Ashley wrote:
Nigel wrote:
mod_php will persist the MySQL connection holding open any lock or
syncronisation token obtained through any of the three methods :
begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
ensure that even in the event of timeouts or fatal e
1 - 100 of 1634 matches
Mail list logo
