sql query
when I am defining a table, how do I set the default of a datetime column to
the current time? I tried setting the default to now() but it just fills
the column with 00:00 etc..
Thanks,
Eddie
-
Before posting,
great! hope it works !
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:17 AM
To: MySQL Mailing List (E-mail)
Cc: Edward Peloke
Subject: RE: Complex SQL query problem...
FYI - this query seemed to work.
select * from nodes
left join
try a left join
select count(*) from jobs
left join submissions on
jobs.standard_id=submissions.color_id
where jobs.standard_id=ID_VALUE and submissions.color_id is null
Eddie
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Friday,
: Thursday, September 12, 2002 6:43 PM
To: Edward Peloke; [EMAIL PROTECTED]
Subject: Re: laptops
At 16:21 -0400 9/12/02, Edward Peloke wrote:
Forgive me for getting off topic but I am thinking of buying a new laptop.
Which brands do you all trust? I don't have much to spend at all. I am
leaning towards
Forgive me for getting off topic but I am thinking of buying a new laptop.
Which brands do you all trust? I don't have much to spend at all. I am
leaning towards a compaq since they are offering an upgrade to xp pro for
free (which I will need) and a free wireless card. I am looking for a
Forgive me for getting off topic but I am thinking of buying a new laptop.
Which brands do you all trust? I don't have much to spend at all. I am
leaning towards a compaq since they are offering an upgrade to xp pro for
free (which I will need) and a free wireless card. I am looking for a
I am new to MySql and am trying to learn PHP in conjunction with MySql. The
webpage that I want to create will benefit from stored procedures. Are
these available with MySqlMax? If so, is it setup the same way as MySql?
Thanks,
Eddie
So is there really any benefit to using MySql Max?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Thursday, September 05, 2002 3:53 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: mysql max
Hello,
As of this writing
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default (0)
when I create the table.
Thanks,
Eddie
-
Before posting, please check:
Does anyone have any good tools for putting a trace on an MySql server. I
want to be able to see what is happening on the server.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I asked yesterday but got no responses...anyone have any ideas how I can use
one odbc connection but have access to all databases on the MSSQL server???
Thanks,
Eddie
-
Before posting, please check:
Does anyone know if there is a good profiler to use on MySql, for example,
in SQL Server, you can start the 'profiler' and it will tell you everything
that is happening on the server.
Thanks,
Eddie
-
Before posting, please
I need to have access to all the databases on my server using one ODBC
connection. Currently, I have to specify the db and only have access to
that one...is there a way around this? How about SQL Links?
Thanks,
Eddie
-
Is it possible to specify more than one owner in a mysql db? I want to
create tables with different owners.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I was thinking more along the lines of creating a db called test and
creating two tables:
test.clients and test2.clients
Like you can do in MSSQL, create many table owners in the same db.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01,
Is it possible to have global access to all databases using the new odbc
driver? For example I have an app that uses more than one table owner. In
Mysql, I had to set up a db for each owner but when I try to connect through
the odbc, I don't have access to all the databases, just one. How can
16 matches
Mail list logo