Am 17.12.2012 19:09, schrieb Rhino:
Is the version of SQL statements that I write for MySQL based on the
server version or the client version?
clearly for the server
mysql is a database-SERVER
According to phpMyAdmin, the version of the MySQL Client is 4.1.22 but the
MySQL Server version
Original Message
Subject:Re: Basic Question
Date: Mon, 17 Dec 2012 15:39:39 -0500
From: Rhino rhi...@sympatico.ca
To: Reindl Harald h.rei...@thelounge.net
On 2012-12-17 14:34, Reindl Harald wrote:
Am 17.12.2012 19:09, schrieb Rhino:
Is the version of SQL
Brent,
You need to modify your BUFFER size on your CMD shell screen. Right click
the title bar then select properties and find the section that talks
about Screen Buffer Size (it's under the layout tab for me). This only
works for me if I use it in a window (not full screen).
I always create
I am a beginner, so forgive me.
From mysql if I type:
Mysqlshow tables;
The result scrolls to the last lines and then the prompt again. Is
there an argument or a variable I can set that will act like 'more' or
'less' in unix? I want it to stop scolling so I can walk through the
results.
Mysql \P less
PAGER set to less
Mysql show tables;
You can see other cool flags by typing 'help;' at the mysql prompt.
On Mon, 4 Oct 2004 14:58:29 -0700, OMalley, Brent
[EMAIL PROTECTED] wrote:
I am a beginner, so forgive me.
From mysql if I type:
Mysqlshow tables;
The result scrolls
Thanks!
-Original Message-
From: Kyle Kirkland [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 3:15 PM
To: OMalley, Brent
Cc: [EMAIL PROTECTED]
Subject: Re: Real Basic Question
Mysql \P less
PAGER set to less
Mysql show tables;
You can see other cool flags by typing 'help
On Sunday 04 July 2004 11:36 pm, bruce wrote:
hi...
i'm trying to figure out how to deal with joins
(left/right)..
i have the following test tbls...
create table universityTBL(
name varchar(50) not null default '',
ID int(10) not null auto_increment,
primary key
hi...
i'm trying to figure out how to deal with joins (left/right)..
i have the following test tbls...
create table universityTBL(
name varchar(50) not null default '',
ID int(10) not null auto_increment,
primary key (ID),
unique key (name)
)type =MyISAM;
Bruce:
The problem is that you have universityTBL listed twice in your list of
tables. Here is your statement, with numbers for each of the sources.
SELECT schoolTBL.name, universityTBL.name
FROM (1) universityTBL, (2) schoolTBL
LEFT JOIN (3) universityTBL ON schoolTBL.universityID =
I have zero experience, really, with Mysql although I compiled it on a Linux box and
it works well for a couple of sites and messageboards that I host from my house. I do
this strictly for fun and would like to let some friends and family members have
websites as well.
Here's what I don't
Briefly:
http://dev.mysql.com/doc/mysql/en/GRANT.html
GRANT ALL PRIVILEGES ON dbname.* TO user IDENTIFIED BY 'userspass';
CREATE DATABASE dbname;
\q
mysql -u user -p dbname
Password: userspass
mysql
NEVER *EVER* run ANYTHING using root. That's an administrative only user.
Some applications may
with a basic question I can't seem to find an answer.
||
|| Here is a basic question I am struggling to find an answer. I want
to run
|| mysql under solaris. Security is not a great concern to me and only
one
|| application accesses the database locally. I don't have and can't
get the
|| root access
PROTECTED]; [EMAIL PROTECTED] Mysql. Com
Subject: FW: Help with a basic question I can't seem to find an answer.
You will need root privilege in order to install and start MySQL. After
the installation, you may have to edit some confs to get MySQL to start
automatically at every boot. Thereafter
Here is a basic question I am struggling to find an answer. I want to run
mysql under solaris. Security is not a great concern to me and only one
application accesses the database locally. I don't have and can't get the
root access to the machine. Also, I can't create mysql user and groups
' [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 22, 2003 8:32 PM
To: [EMAIL PROTECTED]
Subject: Very basic question from a total newbie!
I feel so stupid right now! I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website. It'll be running on a Linux
server when I
pulled up WinMySQLadmin and everything looks like it's
working fine. What do I check next?
Thanks for your time!!!
Renee :)
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 22, 2003 8:32 PM
To: [EMAIL PROTECTED]
Subject: Very basic question from
: Sunday, February 23, 2003 11:19 AM
To: Stitchin'; [EMAIL PROTECTED]
Subject: Re: Very basic question from a total newbie! MORE INFO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Stitchin',
Sunday, February 23, 2003, 3:39:41 PM, you wrote:
I did exactly what Paul described ... I changed
Stitchin',
I don't want to be impolite, but please check some basics of your
operating system (e.g. what a path is).
Anyway, here's what you should enter (in a DOS window; C:\ is the
initial DOS prompt):
C:\ cd \program files\apache group\apache2\htdocs\phpcatalog\admin
C:\program files\apache
: [EMAIL PROTECTED]
Subject: Re[2]: Very basic question from a total newbie! MORE INFO
Stitchin',
I don't want to be impolite, but please check some basics of your
operating system (e.g. what a path is).
Anyway, here's what you should enter (in a DOS window; C:\ is the
initial DOS prompt):
C:\ cd
11:19 AM
To: Stitchin'; [EMAIL PROTECTED]
Subject: Re: Very basic question from a total newbie! MORE INFO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Stitchin',
Sunday, February 23, 2003, 3:39:41 PM, you wrote:
I did exactly what Paul described ... I changed the directory
I did exactly what Paul described ... I changed the directory at the dos
prompt to
c:\program files\apache group\apache2\htdocs\phpcatalog\admin
and typed in
mysql testcatalog createdb_mysql
my dos prompt brought up this error:
'mysql' is not recognized as an internal or external command,
I feel so stupid right now! I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website. It'll be running on a Linux
server when I get it on the web.
I've been trying to check out this catalog program called PHP Catalog.
Their website has a free version to check
At 20:31 -0500 2/22/03, Stitchin' wrote:
I feel so stupid right now! I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website. It'll be running on a Linux
server when I get it on the web.
I've been trying to check out this catalog program called PHP Catalog.
I have downloaded the ODBC driver and while I am fumbling [still
reading] about that the reference it makes if for *.MDB similar
extensions. I have cruised through the on-line manual and still
have no idea how to create one of those type extensions with a
MySql database.
I am sure it is in
Make it TIMESTAMP
But remember that this data type gets updated every time the record is
changed.
Hope this helps.
Thanks
Emery
- Original Message -
From: Edward Peloke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 11, 2002 5:50 PM
Subject: basic question
sql query
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,
At 11:50 -0400 10/11/02, Edward Peloke wrote:
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..
You don't. Default values must be constants.
The
Hello,
I like to know the sintax to do a similar select in mysql (this come from
db2):
select * from tabella where rrn(tablename) 50 limit 10
the mean is to select ten records from 50 to 60,
any equivalent with mysql ?
TNX !
* [EMAIL PROTECTED]
I like to know the sintax to do a similar select in mysql (this come from
db2):
select * from tabella where rrn(tablename) 50 limit 10
the mean is to select ten records from 50 to 60,
any equivalent with mysql ?
mysql does not have the rrn() function, but if you have
Rory,
Take a look at the shell scripts for mysqlbackup here
http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain
things quite nicely.
Cheers,
m!
ROry O'Connor wrote:
this is an absolute newbie question - but when i try to run mysqldump with a cron
(like with a shell
this is an absolute newbie question - but when i try to run mysqldump with a cron
(like with a shell script) i can't because mysqldump utility stops to ask for a
password. how can I either embed the password or set up mysqldump to not ask for one
if, for instance, root is running the shell
To: [EMAIL PROTECTED]
Subject: mysqldump - basic question
this is an absolute newbie question - but when i try to run mysqldump with a
cron (like with a shell script) i can't because mysqldump utility stops to
ask for a password. how can I either embed the password or set up mysqldump
to not ask
Am 20 Dec 2001 03:35:37 -0600 schrieb ROry O'Connor:
this is an absolute newbie question - but when i try to run mysqldump with a cron
(like with a shell script) i can't because mysqldump utility stops to ask for a
password. how can I either embed the password or set up mysqldump to not ask
What is the exact difference between
this
index(col1,col2).
that
index(col1),index(col2).
and this
index(col1),index(col2),index(col1,col2).
I read in the manual about it, but it's not really clear about the way
to should be used / created.
Any sql pseudo-teacher in here? :)
Thanks a lot,
What is the exact difference between
this
index(col1,col2).
that
index(col1),index(col2).
and this
index(col1),index(col2),index(col1,col2).
I read in the manual about it, but it's not really clear about the way
to should be used / created.
Any sql pseudo-teacher in here? :)
Etienne Marcotte wrote:
What is the exact difference between
this
index(col1,col2).
Create a single index on col1 and col2.
that
index(col1),index(col2).
Creat two indexes, one on col1, one on col2.
and this
index(col1),index(col2),index(col1,col2).
Do all three. Note that
Hi,
I'm new to mySQL and have a quick question. I'm trying to install
ShowTable-3.3. I must be downloading this incorrectly, as it never shows up
on my hard drive. Now I'm assuming that I just ftp to the site, download it,
untar (whatever that might be) it and then use perl to put it
and
will not run under Windows.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 12, 2001 22:37
Subject: Very basic question from beginner
Hi,
I'm new to mySQL and have a quick question. I'm trying to install
ShowTable-3.3. I must
38 matches
Mail list logo