Let's say I have the following tables:
Plates table
+++-+
| id | Name | Description |
+++-+
| 1 | Paper | Blah|
| 2 | Plastic| Blah|
| 3 | China | Blah|
| 4 | Glass | Blah|
++--
Consider the folowing dataset:
+++-+-+---+
| id| Name | Location| OnOffFlag | Description |
+++-+-+---+
| 1 | Paper| Cabinet | 0 | Blah|
| 2
> I was wondering if something was possible, I have an excel file right now of
> US mailing addresses, and what I need to do is select all the odd numbered
> addresses on one road, is there an easy way I can do that from MySQL? the
> addresses could contain 3, 4 or 5 numbers per addresses such as:
> is there a function, using MySQL 5.0v, that can detect if a numerical value
> is either an Even or Odd number
MOD()
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_mod
SELECT MOD( X, 2 )
where X is your number (or column name). If 0, it's even if 1 it's odd.
thnx
>> where X is your number (or column name). If 0, it's even if
>> 1 it's odd.
> I think you mean, if it is non-zero, then it is odd.
If you're MODding using 2 as the second argument, it's always going to
be 0 or 1. 2 either divides in to the number evenly, having a
remainder of 0, or it'll have
http://www.mysql.com/products/
So the free version is going to include only MyISAM? And you won't be
able to connect using MySQL Workbench (and presumably apps like MySQL
Query Browser)? Otherwise you have to shell out $2k? Wow. I think
it might be time to start seriously looking at Postgres..
Let's say that I have the following dataset after an INNER JOIN query:
UserName | InventoryItem | InventoryAmount
| - | ---
Joe | Hammer | 2
Joe | Nails | 7
Joe | Screws | 9
Bob | Hammer | 1
Bob | H
Let's say I have the following table:
CREATE TABLE `Users` (
`id` blahblah,
`firstName` blahblah,
`lastName` blahblah,
`phone` blahblah,
`fax` blahblah,
`email` blahblah
);
If I do "SELECT id, firstName, lastName, email FROM Users, my result set is
returned as follows:
++---+
I'm running MySQL version 5.0.33.
I have the 2 following queries:
SELECT
Resource.Id,
Resource.Name,
Resource.Description,
Resource.IsVisible,
Resource.UpdatedDate,
Resource.CreatedDate
FROM
Resource
INNER JOIN
ObjectTarget ON
Resource.Id = ObjectTarget.TargetId AND ObjectTarg
> I have a slew of records that went to the wrong database. The tables
> have the same names and now I want to copy those records over to the
> correct database. Is there such a mechanism using the cli mysql
> application in Linux?
If the tables have the same schema, you should be able to jus
> > I have a slew of records that went to the wrong database. The tables
> > have the same names and now I want to copy those records over to the
> > correct database. Is there such a mechanism using the cli mysql
> > application in Linux?
> For each corresponding table:
> INSERT INTO db1.mytab
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database that way? Right now,
the o
>
> > > SSH or SFTP. The only way we can access the MySQL database on that
> server
> > > is either use phpMyAdmin (which I don't particularly care for; not to
> > > disparage the hard work of the developers, it's just a matter of
> personal
> > > preference) or use the command line.
> > Use the m
>
> There are lots of GUIs for connecting to MySQL databases. MySQL provide
> some (MySQL Query Browser and MySQL Administrator) but I prefer Toad:
> http://www.quest.com/toad-for-mysql/
I tried MySQL Administrator but couldn't get it to connect over SSH/SFTP.
I'll take a look at toad-for-mysql a
>
> Again, you can get absolutely ANY client to connect over an SSH tunnel.
> You create the tunnel with your SSH client, then use the tunnel to
> carry your traffic. So you don't need to use an unfamiliar or non-free
> program to do this. (Any program that offers a connect-over-SSH option
> is v
>
> > How do you go about creating the tunnel?
> There are lots of good tutorials online:
> http://www.google.com/search?q=create+ssh+tunnel
>
Excellent. My thanks to you and to everyone who participated in this
thread!
thnx,
Christoph
16 matches
Mail list logo
