Re: Need Help Converting Character Sets

COLUMN BINARY (or BLOB); -- to forget any charset > knowledge > ALTER TABLE ... MODIFY COLUMN CHARACTER SET ...; -- coming from BINARY, > this does not check the encoding. > (sorry, don't have the link handy) > > > -Original Message- > > From: h...@tb

Need Help Converting Character Sets

I have a table, Articles, of news articles (in English) with three text columns for the intro, body, and caption. The data came from a web page, and the content was cut and pasted from other sources. I am finding that there are some non utf-8 characters in these three text columns. I would like to

OT: SQL Question

My question is not specific to MySQL, even though I am using a MySQL db for this project. I have a servlet/jsp/MySQL web site in production, and there are about 2,000 records in the flights table. One of the foreign keys is teacher_id. Up to this point, there is a one to many relationship between t

Re: Need Help Writing Simple Query

t 1) as name_2 > from test1; > > - test1 table: > col1v_idh_id > America 1 2 > > - test2 table: > id name > 2 SAM > 1 UNCLE > > - Original Message - > From: "Mark Phillips" > To: "Mysql List" >

Need Help Writing Simple Query

I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the IDs in table 2. I want to make a query so I get

Re: Questions on Database Design

donné que les email > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > aucune responsabilité pour le contenu fourni. > > > > > > > > Date: Sat, 3 Oct 2009 18:11:59 -0600 > > From: john.l.me...@gmail.com > > To: m...@phillipsmarketi

Re: Questions on Database Design

On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote: > > John, >> Thanks. The data is private to each user; there is no sharing of data. I >> am not sure what you mean by "are the actions related" Each user is >> reading/writing independently of each other. Would that argue for separate >> database

Re: Questions on Database Design

On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote: > depends on the relationship of the Data Tables and the Users that use them > > for instance if I was to setup a table of outgoing calls from 2 distinct > individuals : > Me> calls to HarvardMedicalSchool, MassGeneral, >

Re: Questions on Database Design

On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote: > Mark Phillips wrote: > >> I am new at database design, and my question relates to the trade-offs >> between putting all data in one database or several for mysql. For >> example, >> say I have an application

Questions on Database Design

I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from their mobile phones and read/write data to a database. Say there are roughly 10-15 tables in the data

Re: Need help with a query

On Monday 23 January 2006 03:33 pm, Michael Stassen wrote: > Mark Phillips wrote: > > I am running mysql 4.0.24 on Debian sarge. > > > > I have a table with two columns, "team" and "division", both varchar(255). > > There are some errors in t

Need help with a query

the parenthesis). I finally found a solution, but I do not understand it: SELECT DISTINCT division, team FROM registered WHERE (team!='' AND DIVISION!='') ORDER BY division, team Why does the ORDER BY clause require an AND in the WHERE clause to work correctly?? I do no

Re: Question regarding running 'mysql' from a bash script

On Thursday 12 January 2006 12:47 pm, Jake Peavy wrote: > On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote: > > > There is a column in my table with string values, but the strings have > > spaces > > in them. I want to read the unique column values into an array i

Re: Question regarding running 'mysql' from a bash script

quot;${TEAM_QUERY}"|sed 's/^/"/g'|sed 's/$/"/g'`) Commas are not used in the definition of an array - just spaces between quoted strings. Thanks for your help! > > > > > > -Original Message- > From: Mark Phillips [mailto:[EM

Re: Question regarding running 'mysql' from a bash script

Oops - I forgot my version of mysql - 4.0.22 running on Red Hat Linux 7.3 2.96-113 kernel 2.4.20-30.7. Mark On Thursday 12 January 2006 10:43 am, Mark Phillips wrote: > There is a column in my table with string values, but the strings have spaces > in them. I want to read the unique

Question regarding running 'mysql' from a bash script

quot;Red" "Sox" "Chicago" "Colleens" "Athletics" "Kenosha" "Comets") How do I either (1) add quotes around each row entry returned so I get the right array, or (2) fill the array in a different way? Thanks! -- Mark Phillips Phillips M

Re: Need Help Connecting

ing. Thanks for all your help, everything is now working!! Mark On Thursday 22 December 2005 06:28 am, Michael Stassen wrote: > Mark Phillips wrote: > > David, > > > > This is what I got: > > > > [EMAIL PROTECTED]:~$ aliases > > bash: aliases: comma

Re: Need Help Connecting

HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Mark Phillips [mailto:[EMAIL PROTECTED] > Sent: Thursday, 22 December 200

Re: Need Help Connecting

+61 8 8408 4259 - Fax > > > -Original Message- > From: Mark Phillips [mailto:[EMAIL PROTECTED] > Sent: Thursday, 22 December 2005 5:02 PM > To: MYSQL List > Subject: Need Help Connecting > > I have the following setup - mysql 4.0.24 running on Debian Linux > stable

Need Help Connecting

server version: 4.0.24_Debian-10sarge1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> I don't get it - why can't I use the '-u mark' option with mysql when I am logged into my own Linux user account? Thanks! --

Re: 'LIKE' for numbers

ves like "LIKE" but can act on > numbers. > > Let's say I wanted to select all rows where column x has a value of ~ y > > How should I do this? > > > With kind regards > > > Andy -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524

Re: YAQQ (Yet Another Query Question)

e page. My small contribution to science education! This list is great! Mark On Wednesday 14 December 2005 09:42 am, nigel wood wrote: > Mark Phillips wrote: > >Flights > >+---+--+--+ > > >

Re: YAQQ (Yet Another Query Question)

Nigel, Again, thanks - that is the "rule of thumb" I was looking for! Mark On Wednesday 14 December 2005 09:57 am, nigel wood wrote: > Mark Phillips wrote: > >2. Generally, what is the most "efficient" way to do this? Is is better to > >issue more queries t

Re: YAQQ (Yet Another Query Question)

Nigel, Thanks! Mark On Wednesday 14 December 2005 09:42 am, nigel wood wrote: > Mark Phillips wrote: > >Flights > >+---+--+--+ > > > >| flight_id | data1_id | data2_id | > > > >+---+--+--+ > > > >

YAQQ (Yet Another Query Question)

best practices type of answer or general rule of thumb from the sage experts on the list. Thanks for any insights you can provide! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax -- MySQL General Mailing List For list archives: http://lists.mysql.com

Fwd: Re: Need Help with a query

I forgot to copy the list as well Mark -- Forwarded Message -- Subject: Re: Need Help with a query Date: Sunday 11 December 2005 06:47 pm From: Mark Phillips <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Rhino, My apologies for leaving out t

Need Help with a query

provide! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]