--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> The only way to do this is via
> SHOW CREATE TABLE
I've just tried the command in question, but here's
the result:
CREATE TABLE `employees` (
`employee_id` tinyint(4) NOT NULL auto_increment,
`employee_first` varchar(20) NOT NULL default '',
Are we going to compare these dolphins to the MySQL logo? I hear they saved
us from MSSQL :-)
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Personally I would keep a table for the translations.
Some identifier for what it is, and then and id for the language.
So if something doesn't exist in one language you know about it and can
default to another language.
It also makes it easier to add new languages in my opinion.
somthing like:
Looks good to me but I'm a relative beginner. Maybe another option -
make Spanish, English, and German tables, then link those to the main
table. This however can slow you down if you are doing multiple reads
of the various tables.
Respectfully,
Ligaya Turmelle
Graham Anderson wrote:
I have a
---
On Saturday 27 November 2004 12:38, Steve Mansfield wrote:
Seem to be answering my own questions here...:-)
Looks like it's a MySQLcc problem.
Dumped tables from the live server and then, rather than running them as a sql
query via MySQLcc, I did it from the command line wit
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> There's a space beteeen the function name and the
> following
> parenthesis.
>
Yes, that and not remembering I'm still on 4.0.22 :)
Yeesh...sorry Paul.
Switched to TO_DAYS ..no diff I guess
Stuart
--
MySQL General Mailing List
For list archives
At 5:31 -0800 11/27/04, Stuart Felenstein wrote:
Does DATEDIFF only work with actual dates input i.e
('2004-12-05'
Or couldn't I do :
Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from
mytable?
(StateDate,EndDate are date columns from db)
I'm generating a syntax error on this above.
Does DATEDIFF only work with actual dates input i.e
('2004-12-05'
Or couldn't I do :
Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from
mytable?
(StateDate,EndDate are date columns from db)
I'm generating a syntax error on this above.
Stuart
--
MySQL General Mailing List
For l
Thought people might get a kick out of this...
>From the New Zealand Herald - full story on http://tinyurl.com/6m7ul
===
Dolphins saved us from shark, lifeguards say
24.11.2004
By AINSLEY THOMSON
A pod of dolphins is being credited with saving a group of lifeguards
from a circling great w
---
On Saturday 27 November 2004 12:16, Steve Mansfield wrote:
| ---
|
| On Friday 26 November 2004 17:58, Gleb Paharenko wrote:
| | Hello.
| |
| | What charset produced mysqldump with --default-character-set=latin1
| | command line option?
|
| Hmm, that still produc
---
On Friday 26 November 2004 17:58, Gleb Paharenko wrote:
| Hello.
|
| What charset produced mysqldump with --default-character-set=latin1 command
| line option?
Hmm, that still produced a file with utf-8 characters, which means they must
be stored that way in the table, no? (Al
From the lack of responses I take it that nobody disagrees that the
handling of the timestamp type is fundamentally broken in every version
of MySQL.
I'll go ahead and file several bugs, and start changing our code to
avoid the timestamp type altogther. I'm quite surprised!
Peter
Peter Valdema
Hello.
What charset produced mysqldump with --default-character-set=latin1 command
line option?
Steve Mansfield <[EMAIL PROTECTED]> wrote:
> I have a strange, irritating problem that I think is to do with MySQL. I have
> a table on a live (shared hosting) system that, when I use it on
13 matches
Mail list logo