Folks, I am EW to the list, and MYsql. I am totally adrift, and
looking for some good reading for a raw beginner. PLEASE post some
linke for my use.
I remain,
Kirk Bailey
think
-
| THE BOX |
-
kniht
Defend
Thanks all for the advice. It seems that no-one is recommending the book I
mentioned. I've now got Paul DuBois' book (unfortunately, it's the second
edition, but hope that's still okay). Looks rather large! But it also looks
very clear.
David
--
MySQL General Mailing List
For list archives: htt
Hi,
I'm a newbie and looking for a book to help me learn mysql. I have come
across a book called "Beginning MySQL" by Robert Sheldon and Geoff Moes.
Can anyone recommend this book? Or, if not, what book can you recommend for
a newbie.
David
--
MySQL General Mailing List
For list archives: ht
I have just installed MySQL Administrator on FreeBSD 5.2.1. I am trying to use the "Connect to MySQL Server Instance"
dialog to establish a connection to a version: 4.0.22 MySQL server. I can establish a remote connection using:
mysql -h hostname -p -u username databasename
However, using MySQL A
locks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 0, Involuntary context switches 0
>How-To-Repeat:
make test
>Fix:
Unknown at this point.
>Submitter-Id:
>Originator:Charles Bailey
>Organization:
Children's Hospital of Ph
/hosts.allow, line 59:
cannot open /etc/hosts.deny: Permission denied
Brent Bailey CCNA
High Speed Data Services
MetroCast Cablevision
603-332-8629 ext:242
[EMAIL PROTECTED]
Fantastic! This was indeed the problem and has solved it. Many thanks!
On Tue, 24 Feb 2004 13:14:51 +0100, Jigal van Hemert wrote:
>> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
>> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
>> and \'$Date2\
Hello All,
I have a very strange problem which makes no sense to me whatsoever.
I am trying to find the number of queries that the people have dealt with
in a database between two dates. The dates are generated from some drop
down boxes and dropped into a variable. This is the code for the query.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I am currently getting the following error on one of the mysql servers
im looking after and wonder if anybody knows what specifically it
relates to.
Error in accept: Too many open files
Im currently running MySQL version '4.0.14' under FreeBSD
elp and time in this.
Sincerely,
Mike "Tiny" Bailey
Author of
"What Have We Done? The Dragon Chronicles"
start adding an 'export
directly to MySQL server' option want to know if it is possiable to issue the
'LOAD DATA IN FILE' or 'SOURCE' SQL commands to export the data from the
Windows machine to the FreeBSD machine.
--
Regards,
William Bailey.
Could anyone please tell me how I write an SQL statement to seperate
text from one field into multiple fields based on a aprticular character
(i.e. tab/comma/space). For example, I have a text field containing:
Text=Robyn Bailey Brisbane
I want to seperate this (per query) into 3 fields so that I
--
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTE
Hello ... my name is Brent ..and im using the latest version of mysql
on a Freebsd box with apache & php3 & php4. My problem is that ive set a
password for the root mysql user by doing:
/usr/local/bin/mysqladmin -u root password 'x'
then i installed phpMyAdmin ..and set the correct username
Hello ... my name is Brent ..and im using the latest version of mysql
on a Freebsd box with apache & php3 & php4. My problem is that ive set a
password for the root mysql user by doing:
/usr/local/bin/mysqladmin -u root password 'x'
then i installed phpMyAdmin ..and set the correct username &
.2 (0x400f1000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x4000)
Will work on building from source to see whether error is reproduced.
>How-To-Repeat:
Start mysqld-max. Connect from client.
>Fix:
Don't run mysqld-max.
>Submitter-Id:
>Originato
.
And if it is true that InnoDB tables can contain
only 1000 or fewer rows, what's the use. I could do that with a text file.
Jim Bailey
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/su
gn Key Field(s)
AGAIN?
true or false
Question V.
I suppose I should include the Constraint syntax in the SQL that creates the
Native Table and not in the SQL that creats the Foreign Table?
True or false?
Thanks for your help
Jim Bailey
_
sql,query
Following are two CREATE TABLE statements. The second one fails because of
an error in the last line.
Does anyone know why?
Jim Bailey
STATEMENT #1
CREATE TABLE IIM_InventoryItemMaster(
IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL,
IIM_ItemNm VARCHAR(64),
IIM_ItemDescCD VARCHAR
At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT.
The command returns the following error message:
Failed to open file [FileName] Error 2.
So what is this error 2. What does it mean?
Your help will be appreciated.
47 that was fixed a "long time ago" as Mr. Milivojevic
states, wouldn't I expect it to find its way into the 3.23.X series as
the production series?
I really like MySQL and don't mean this as any type of a flame, just
wondering what the versions mean. Thanks for any insight an
ws
3. ==>>Execute the query "query_failure.sql" which produces the failed output:
(Note the "IN (...)" clauses should have no effect on the output)
select * from event, status, severity
where event.status = status.status
and event.severity = severity.
I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out how
to get the query I
need against the version without the union
Seems I need a sub select but that's not supported yet. I'm trying to get a score of a
search result - the first
query works as required (but pot
y by
adding a [safe_mysqld] section with "ulimit -d 256000", as was suggested
in the MySQL manual. Neither has worked.
Could this be a problem with the mm.mysql JDBC driver itself?
Peter Bailey
(work) [EMAIL PROTECTED]
(home) [EMAIL PROTECTED]
--
as getting
frustrated and wanted to see if it would be recreated as a test if I was running the
server at all. On deleting it I was finding that it was being recreated when running
"something".
Something- I wasn&#x
nux/Apache Webserver for a friend. There's no rush but wanted to use it as a
learning experience and am getting problems with mysql- everything else seems ok.
jason bailey ([EMAIL PROTECTED]) writes:
> I'm consistently getting the error (2002)
> : Can't connect to local MySQ
HI,
I'm a new user to Linux and am interested in MySQL and PHP. I currently use
both as a developer elsewhere and am now trying to set up a test server at
home.
I've searched the MYSQL lists and notice that alot of people are getting a
similar problem as myself and I'm not sure if any have got t
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid)
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid
29 matches
Mail list logo
