Fwd: Re: Basic Question

Original Message Subject:Re: Basic Question Date: Mon, 17 Dec 2012 15:39:39 -0500 From: Rhino To: Reindl Harald On 2012-12-17 14:34, Reindl Harald wrote: Am 17.12.2012 19:09, schrieb Rhino: Is the version of SQL statements that I write for MySQL based

Re: Basic Question

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 vers

Re: Real Basic Question

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 cre

RE: Real Basic Question

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

Re: Real Basic Question

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: > > Mysql>show tables; > > The resu

Real Basic Question

I am a beginner, so forgive me. >From mysql if I type: Mysql>show 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.

Re: basic question about joins....

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, > pr

Re: basic question about joins....

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 = university

basic question about joins....

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;

Re: Rank beginnner - very basic question

Briefly: 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

Rank beginnner - very basic question

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 ge

RE: Help with a basic question I can't seem to find an answer.

TECTED] 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, you can acces

FW: Help with a basic question I can't seem to find an answer.

||> Subject: Help 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

Help 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 to the machine. Also, I can't create mysql use

RE: Very basic question from a total newbie! MORE INFO

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, ope

Re: Very basic question from a total newbie! MORE INFO

) [mailto:[EMAIL PROTECTED] > Sent: 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

RE: Re[2]: Very basic question from a total newbie! MORE INFO

ruary 23, 2003 12:02 PM To: Stitchin' Cc: [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 sh

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 \program files\apache group\apache2\htdocs\phpcatalog\admin C:\program files\apa

RE: Very basic question from a total newbie! MORE INFO

Sent: 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 Pa

Re: Very basic question from a total newbie! MORE INFO

> 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 >

RE: Very basic question from a total newbie! MORE INFO

age- From: Stitchin' [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

Re: Very basic question from a total newbie!

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. The

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 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 o

Need book, but have basic question ??

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

Re: basic question

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 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, plea

Re: basic question

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 TIME

Re: sorry for this "basic" question

* [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

sorry for this "basic" question

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 !

Re: mysqldump - basic question

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 scr

Re: mysqldump - basic question

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

RE: mysqldump - basic question

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

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 for one if, for instance, root is running the shell scr

Re: Another basic question - index()

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

RE: Another basic question - index()

> > 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 h

Another basic question - index()

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, Eti

Re: Very basic question from beginner

ed systems 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 tryi

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 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 toget