Re: [semi OT] mySQL question

Just as an aside, I do not bother with joins, if I can help it. If I need data from multiple tables I query each table for just the data I need, and save it in discreet arrays, 1 per table. Of course, my needs are pretty simple. I typically have one parent table (the example suggested calls them

mySQL question party

Look up Google for the party entity relationships diagram or schema. A "party" is either a "person" or a "organisation" (company, org) The party is an entity ( table) that has an id. The org or person tables have a foreign key to the party id. It is a mutual exclusive relationship. A party must ne

Re: [semi OT] mySQL question

Hello Ken, Thank you so much for your answer. Your solution confirms what I had more or less in mind. I will give it a try asap. Best, jbv Le 2023-05-11 15:33, Ken Ray a écrit : I would recommend a table for People, a table for Companies, and a table for Employment that acts as a linking ta

Re: [semi OT] mySQL question

I would recommend a table for People, a table for Companies, and a table for Employment that acts as a linking table between the first two. Something like (at its simplest): people id INT(11) first_name VARCHAR(255) last_name VARCHAR(255) companies

[semi OT] mySQL question

Hi list, This is a question for mySQL experts, which I am not. I have a table of individuals. I have another table of companies. Many individuals have worked in more than 1 company with different jobs descriptions. I need to build my DB so that, with single requests, I can get a list of either

Re: mysql question

On Mon, Oct 1, 2012 at 9:48 AM, Bob Sneidar wrote: > I may have missed the post prior, but I believe this is true only of sqLite > databases. In a >mySQL database, LC would not create a new database because of the security >built >into mySQL. I may well be mistaken; I'm hardly an expert. I tho

Re: mysql question

Yup. That would do it. On Oct 1, 2012, at 2:27 PM, Peter Haworth wrote: > Thanks Mark. I also noticed that I had a gMail Lab in place which made the > default reply button mean Reply To All so if any incoming messages were > sent to the old and new mailing lists, I think that would cause the dou

Re: mysql question

Thanks Mark. I also noticed that I had a gMail Lab in place which made the default reply button mean Reply To All so if any incoming messages were sent to the old and new mailing lists, I think that would cause the double messages. I've disabled that now. Pete lcSQL Software

Re: mysql question

Pete- Monday, October 1, 2012, 8:59:05 AM, you wrote: > Very strange. I can't find anything in my email config that would cause > this. I'll start paying more attention to the "To" and "CC" fields to try > and track down what's happening. Check to Reply-To field on incoming messages as well. T

Re: mysql question

I may have missed the post prior, but I believe this is true only of sqLite databases. In a mySQL database, LC would not create a new database because of the security built into mySQL. So far as I know, if you want to create a new mySQL database, you will have to shell in to a mySQL server. Also

Re: mysql question

Very strange. I can't find anything in my email config that would cause this. I'll start paying more attention to the "To" and "CC" fields to try and track down what's happening. Pete lcSQL Software On Sun, Sep 30, 2012 at 7:31 PM, J. Landman Gay wrote: > On 9/30/12 6:2

Re: mysql question

On 9/30/12 6:29 PM, Peter Haworth wrote: Maybe there's something weird in my gMail account - is anyone else getting my messages twice? Yes, some of them, but not all. The one Mark just referred to came to me twice. On the other hand, the one I'm replying to now only came in once. -- Jacque

Re: mysql question

Thanks Mark. Looks like some of my messages have a copy sent to the old email list for some reason. I'll check round my gmail config to see what might be causing that. Pete lcSQL Software On Sun, Sep 30, 2012 at 4:42 PM, Mark Schonewille < m.schonewi...@economy-x-talk.co

Re: mysql question

I received your last post twice. -=>JB<=- On Sep 30, 2012, at 4:29 PM, Peter Haworth wrote: > Hi Mark, > I replied before too :-) As far as I know, I don't send to both addresses, > I simply reply to the posts or send new ones to > use-livecode@lists.runrev.com. > > Maybe there's something we

Re: mysql question

Pete, I must have missed your reply, the first time. Here's a screenshot of the headers: http://qery.us/2l3 I just noticed that this doesn't happen with every e-mail from you, but it happens very regularly and only with e-mails from you. -- Best regards, Mark Schonewille Economy-x-Talk Consul

Re: mysql question

Hi Mark, I replied before too :-) As far as I know, I don't send to both addresses, I simply reply to the posts or send new ones to use-livecode@lists.runrev.com. Maybe there's something weird in my gMail account - is anyone else getting my messages twice? Pete lcSQL Software

Re: mysql question

Pete, I asked this before, but why do you still send your messages to both use-livecode@lists.runrev.com and use-livecode@lists.runrev.com? I receive all your messages twice. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.co

Re: mysql question

> You are correct, although you might be able to do this from the command > > line, e.g. using a shell script. > > > > -- > > Best regards, > > > > Mark Schonewille > > Neat suggestion Mark, thanks > > -- M > > > > -- > View this

Re: mysql question

-revolution.278305.n4.nabble.com/mysql-question-tp4655596p4655610.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and man

Re: mysql question

Hi Mark, You are correct, although you might be able to do this from the command line, e.g. using a shell script. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553

Re: mysql question

On Sun, Sep 30, 2012 at 1:39 PM, Mark Smith wrote: > Thanks Mark. I am just beginning to realize the limitations of the > implementation of SQL supported by LC. So, I presume there is no way to > create a database from LC then? ie. > > CREATE DATABASE database_name ?? revOpenDatabase() will open

Re: mysql question

.nabble.com/mysql-question-tp4655596p4655598.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

Re: mysql question

Mark, No, there is no such command. It is one of the reasons why you can't execute multiple MySQL commands from within LiveCode, while you can do this from within PHP. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twit

mysql question

Hi, is there a command in LC equivalent to connecting to a server and not necessarily to a database. The equivalent from the command line of: mysql -h localhost -u username -ppassword Thanks -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/mysql