I'm doing the above migration as mentioned in the subject line. I
figured I would use the MySQL Migration Toolkit to help it along but it
won't let me connect to my 3.23.49 server. Is there any other way to
migrate all my data easily.
Thanks,
Ed
--
MySQL General Mailing List
For list archiv
I need to get some duplicate record information from a table and I
haven't found any way to do it yet. I figured there might be some type
of query I could do using a "for each" type command.
What I have is a table with names and companies. Some people have
multiple entries for different compan
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Oops, also the $this_date
>
> UPDATE this_table SET
> this_date = '$this_date',
> future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
Got it going guys, thanks again
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Please check your syntax.
> It should look like this:
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
>
> Don't forget your WHERE clause or else you populate every row.
Tried it, this is what
On Wed, 11 Oct 2006, Mark Leith wrote:
> Ed Curtis wrote:
> > I'm having some trouble setting a future date within a table. I have one
> > column 'this_date' which is a DATE field and I'm trying to add 90 days to
> > it and set a column named 'fu
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
the 'this_date' and
I'm trying to do a keyword search within a phrase saved in a table.
Here's the query:
SELECT * from closedtickets WHERE
keyphrase LIKE '%$keyword1%'
OR keyphrase LIKE '%$keyword2%'
OR keyphrase LIKE '%$keyword3%'
The problem I'm having is that the query is returning every record in th
I have a column in a table I need to replace a value of certain records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy way to do this. There are way too
many records to do it one record at a time.
Thanks,
Ed
--
MySQL General Mailin
Does anyone on the list know what REITF stands for? I'm guessing it's
some type of data format for real estate information but I can't find any
information on it anywhere.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
I could be wrong but this may have something to do with ownership and
permissions of the socket file. I recently upgraded my MySQL version and
had basically the same problem. I can't remember though if I had to change
the ownership to root.root or mysql.mysql.
HTH,
Ed
On Mon, 26 Sep 2005, San
On Wed, 22 Jun 2005 [EMAIL PROTECTED] wrote:
> You were SO close!!!
>
> SELECT
> FROM
> WHERE CHAR_LENGTH(varcharfield) >= 60;
Thanks so much. I knew I was close but couldn't remember the exact
command.
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
I've been cruising the docs for a while now and can't find what I'm
looking for. I know it has soemthing to do with value or LEN or something
easy like that but I just can't find the right command structure.
I need to list the rows in a table where the length of a field, lets say
field1 is a mini
= fake.id; it
> simply doesn't know where to get fake.id
>
>
> >From: Ed Curtis <[EMAIL PROTECTED]>
> >To: mysql@lists.mysql.com
> >Subject: SELECT ERROR
> >Date: Wed, 23 Feb 2005 08:02:21 -0500 (EST)
> >
> >
> >I'm trying to com
I'm trying to compare 2 tables and keep getting an error.
SELECT * from listings where listings.id = fake.id;
The error is "Error 1109: Unknown table 'fake' in where clause"
or "Error 1109: Unknown table 'listings' in where clause" depending on
the table order at the end of the query.
Both tabl
I know this is possible but I'm not real sure of the command to use. I
have 2 tables that are pretty much identical except for one column. What I
want to do is moved data from one table column to the other table column
based on a matching id number that is also a column in both tables called
"id".
I've been searching the docs and can't find examples how to do what I
need to do. I need to exclude some records from my SELECT statement
results but it appears I can't use (=, != or LIKE) for it.
What I have is a result set having a column name 'path'. I need to
exclude any record reulting in
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database. I'm using php and a form select list to get this value from
a pre
> I think a quick way to write this query would be
> (http://dev.mysql.com/doc/mysql/en/UNION.html):
>
> ( SELECT magazine FROM pages )
> UNION DISTINCT
> ( SELECT magazine FROM pdflog )
> ORDER BY magazine;
Thanks for all the help on this one. I just also realized that the server
I'm working wi
> What he is really missing is the WHERE clause that matches something from
> pages with something from pdflogWithout it he is requesting a
> Cartesian product of his tables (every combination of each row from both
> tables).
>
> I prefer to define my JOINS *explicitly*. It makes it harde
On Mon, 9 Aug 2004 [EMAIL PROTECTED] wrote:
> He does have a join. He has an *implied* INNER JOIN
> (http://dev.mysql.com/doc/mysql/en/JOIN.html):
>
> FROM pages, pdflog
>
> What he is really missing is the WHERE clause that matches something from
> pages with something from pdflogWithout
>
> Feel stupid again ;-)
>
> Where's your JOIN?
>
> With regards,
>
> Martijn Tonies
Thanks, that makes me feel better :)
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
God, I feel real stupid this morning and know I should know this. I have
2 tables in the same database and I'm trying to select distinct data from
a row with the same name in each table.
SELECT DISTINCT company FROM pages, pdflog ORDER BY company ASC
I'm missing something I'm sure because it doe
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
their user id for them via cookies or sessions or something though.
Ed Curtis
On Tue, 9 Mar 2004, Mulugeta Maru wrote:
> Thank you for the kind response. May be I did not clearly ask the question.
> The user table in mysql database is used to set-up a user and password. Once
> I set-up
g.orig_id = pages.mls_11 OR
> changelog.orig_id = pages.mls_12
> )
>
> John A. McCaskey
>
>
>
> -Original Message-
> From: Ed Curtis [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 10:20 AM
> To: [EMAIL PROTECTED]
> Subject: Query matching
>
mls_6
changelog.orig_id = pages.mls_7
changelog.orig_id = pages.mls_8
changelog.orig_id = pages.mls_9
changelog.orig_id = pages.mls_10
changelog.orig_id = pages.mls_11
changelog.orig_id = pages.mls_12
Would I nest these as an OR statement and how would I go about it?
Thanks,
Ed Curtis
--
MySQL Ge
I didn't know if this was possible and haven't tried yet. My boss wants
me to sort results by 3 columns (city, county, price.) He would like city
and county in alphabetical order a-z and have price from highest to
lowest. I told him I didn't think it was possible to sort two different
fields one
uarefeet >= '$squarefeet' + 0
>
> use the CAST() function, it's described more at:
> http://www.mysql.com/doc/en/Cast_Functions.html
>
>
> On Mon, 8 Dec 2003, Ed Curtis wrote:
>
> >
> > I've got an entry in a table where the value is 875. I
I've got an entry in a table where the value is 875. If I run a query on
that table with the clause AND sqaurefeet >= '$squarefeet' and $squarefeet
has a value of say 1000 the row with the squarefeer value of 875 will
appear. The column is of type varchar(10) and using the binary flag.
What am I
29 matches
Mail list logo
