Excuse my naivety but how do I create a Table in MySQL?
I cant find any Text/Windows based programme that allows be to create and
edit the table, fields, data types, size etc?
Im not looking for anything complex.
Many thanks,
Ed
Edward Hasted
Contact Information:
E-mail : [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Venkata Srinivasa Rao, Yerra wrote:
Dear All,
Any body know how to handle DATE related types in Java. It seems
JDBC driver fails to construct java.sql.TimeStamp object or
java.sql.Date object.
Thanks in Advance.
Best Regards,
Srinivas.
Hi
One more suggestion that does work reasonably well.
Generate a basic HTML page with a table laid out to suit the labels, in php,
with addresses in place
Write the page to your webspace as labels.htm (you will need to set
permissions to allow this)
You then need a program that will open and
Hello all
I have a problem to report. There is a SELECT query that selects data from
three tables according to certain criteria. It goes like this:
SELECT bglavna.T001, bpolja.ID AS ID2, bpotpolja.TEKST
FROM (bglavna INNER JOIN bpolja ON bglavna.ID=bpolja.FK) INNER JOIN
bpotpolja ON
David Precious [EMAIL PROTECTED] wrote:
I hope this isn't an obvious question, but I'm having a hard time figuring
this one out.
I have a cron job set up to run mysqldump regularly to dump my databases out
to a flat file, which is then compressed and passed to our backup server by
Elian Kool [EMAIL PROTECTED] wrote:
I just upgraded to 4.0.12.
I ran the mysql_fix_privilege_tables script to add the new privileges.
Unfortunately, SHOW DATABASES still shows every users all databases.
mysql show grants for [EMAIL PROTECTED];
GRANT REFERENCES, INDEX, ALTER, CREATE
Im attempting to update a table. We perform a select on the table to
determine what row to update.
update test a
set
visit_date = now()
where
a.id in (select b.id from test b where code ='Z')
Running this generates an error.
You cant specify target table 'test' for update in FROM clause.
I
Subqueries are only available in MySQL 4.1. However, you should be able
to write this as follows:
UPDATE test1 a, test2 b SET a.visit_date = NOW() WHERE a.id = b.id AND
b.code = 'Z';
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Terry Spencer [mailto:[EMAIL PROTECTED]
I would suggest myCC -- http://www.mysql.com/downloads/mysqlcc.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:45 AM
To: [EMAIL PROTECTED]
Subject: Creating a Table (wot no GUI?)
Excuse my
It worked yesterday but not today:
mysql LOAD DATA LOCAL INFILE users INTO TABLE users;
ERROR 1148: The used command is not allowed with this MySQL version
Jesse Hardy
[EMAIL PROTECTED]
704-348-8085
-
This e-mail message is intended only
Where do you change the default LIMIT value for queries. I am using
0.9.1-beta.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
snip
mysqldump: Got error: 1064: You have an error in your SQL syntax
near '404 READ /*!32311 LOCAL */' at line 1 when using LOCK TABLES
Anyone got any ideas what could be causing this to happen?
snip
Table name :) It consists only of digits. Use -Q option of mysqldump.
Aaahh! I
Where do you change the default LIMIT value for queries. I am using
0.9.1-beta.
right click on the server name and click on edit. Click on the MySQL Options tab.
Scott Pippin
[EMAIL PROTECTED]
I am about to install Red Hat Enterprise Server 2.1. I would like to put MySQL on it.
I was wondering if there were any Red Hat settings I should be aware of as I install
the OS.
Thanks,
Scott Pippin
[EMAIL PROTECTED]
How can I store procedures in mysql?
Themis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, that was what I was looking for. It has changed since earlier
versions then.
Thanks again,
Ed
On Wed, 28 May 2003, Scott Pippin wrote:
Where do you change the default LIMIT value for queries. I am using
0.9.1-beta.
right click on the server name and click on edit. Click on
By waiting or reading :
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
Jerry
- Original Message -
From: Themis Kafetzopoulos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 3:37 PM
Subject: Storing procedures
How can I store procedures in mysql?
Themis
I made the mistake of copying the MYI, MYD, and frm files of a table while the mysql
server was running. Unfortunately the table is now reporting the following error:
./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in
file: 'Table.frm'
What is the easiest
Quick, simple question for the masses I'm sure.
I've been having trouble assigning a property to a SELECT statement which
pulls an IP from a table, then redirecting the users browser to that value
stored in rstemp.
% dim rstemp %
% rstemp = MyConn.execute(SELECT group.hostip FROM test.group,
Le mer 28/05/2003 à 14:34, [EMAIL PROTECTED] a écrit :
From: Landy Atkinson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mailing Labels from MySQL database on web
Date: 27 May 2003 15:25:20 -0400
What is the best way to approach this? As a temporary measure, I
used an auxiliary
REPAIR TABLE tbl_name QUICK;
You could try that or check out myismchk (sp?)
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.
-Original Message-
From: Cassily, Ryan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28,
Hello
I would suggest SQLyog at
http://www.webyog.com/sqlyog.
Its FREE and find it more powerful and easy to use
then MyCC
Karam
--- Mike Hillyer [EMAIL PROTECTED] wrote:
I would suggest myCC --
http://www.mysql.com/downloads/mysqlcc.html
Regards,
Mike Hillyer
www.vbmysql.com
Thanks for the help, that close to what Im after. I however simplified the
problem too much in my previous question and Im still not there. :)
Im imitating a 'tree' structure. The table has rows - ID and parent_ID. The
depth of the tree is only three layers (parent - child - grandchild).
There
I have an MS excel file with 8 columns and 500 rows
I have a table called 'names' setup in mysql which i have created with 8
columns.
I now need to get my data from excel into that table.
How would u do this?.
I had a look in mysqlcc to see if there was an import option but couldn't see one
On Tue, May 27, 2003 at 03:43:14PM -0500, mos wrote:
Correct, which is why I have a means of compressing and *encrypting* the
.exe file. I can also lock it to the person's machine (or server) so it
won't fall into the wrong hands.
All such methods have been broken.
If they weren't, the
On Tue, May 27, 2003 at 05:02:47PM -0500, Cal Evans wrote:
2: BETTER
Use PHP to build a PDF on the server in the proper Avery label format and
then serve it up through the web server. If you get this working, make sure
you share how you did it.
Generating postscript from PHP is easy enough;
Export the worksheet to CSV and use the LOAD DATA command in MySQL to
import it. That is how I import all but my most complex excel
spreadsheets.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: D Crompton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 9:51 AM
To: [EMAIL
Description:
MySQL crashes out with signal 11 when replication has been set up as
a slave.
How-To-Repeat:
Follow instructions for replicated slave, then simply log out. If you
started mysqld (even if in nohup or background) it still sig11's -
options used
Alternatively, use InnoDB Hot Backup: http://www.innodb.com/hotbackup.html
This will let you take a real-time backup of your InnoDB tables without
taking the server down.
Chris
Rafal Jank wrote:
Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
Well, getting back only table one could be because you can only select *
from one table at a time, I am not sure. If so you need to either spell
out your columns specifically, or use a UNION in the query. As for the
fail when there are no children, you need a LEFT JOIN.
I have tried using myisamchk, but I do not believe it is fixing the problem because I
am still getting the same errors. Here's the output I get from it:
bash-2.05# ../../bin/myisamchk -r Table.frm
- recovering (with sort) MyISAM-table 'Table.frm'
Data records: 111
- Fixing index 1
- Fixing
Hello
Export the data in CSV from Excel and then you can try
SQLyog at http://www.webyog.com/sqlyog
It has a very good interface to import data from CSV
file.
Karam
--- D Crompton [EMAIL PROTECTED] wrote:
I have an MS excel file with 8 columns and 500 rows
I have a table called 'names'
You copied corrupted data. Shutdown the server and make a copy again, or
restore from a backup. Myisamchk will probably not work in this
situation even if you use
Myisamchk -o -f
---Original Message-
--From: Cassily, Ryan [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, May 28, 2003 10:28
mySQL does not support stored procedures your going to have to write
code to supplement the behavior or wait until mySQL 5.0.
---Original Message-
--From: rajesh_sharma [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, May 28, 2003 10:58 AM
--To: [EMAIL PROTECTED]
--Subject: How to use stored
Assuming that MySQL is on your computer (not on a remote host), run MySQL from
the command line. If you're accessing MySQL remotely, you can issue CREATE
statements from most scripting languages (PHP, for one), the same languages
you'll likely need to interact with the DB later.
Edward Dudlik
Taken from manual:
mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
- IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT ALL PRIVILEGES ON *.* TO monty@%
- IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
A full superuser who can connect to the server from anywhere,
I have a system that when I start mysqld, it works fine for a while (anywhere
from 10 minutes to 2 hours) and then stops taking connections. I get the Can't
connect to local MySQL server through socket ... however, the socket is still
there.
What's even weirder, is that any processes that
I'm having some trouble with a GROUP BY clause.
My database has a main table ('grants') with grant listings. Each
grant has one listing, including a grantid column.
A second table ('dates') holds date info about each grant. 'grants'
to 'dates' is one-to-many as a grant can have several
I am trying to do what seems like a simple Select:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
2)
I know I this select is very simple, but I need to make this one work before
I can tackle my 'real' query where the subquery is essential.
I have MySQL version
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote:
The results you wanted and the results you get were not very clear. Some examples
would have gone a long way.
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates
WHERE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
2)
I know I this select is very simple, ...
So what's the problem?
- --
jimoe at sohnen-moe dot com
pgp/gpg
On 28 May 2003 at 14:17, Peter Fleck wrote:
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants,
dates
WHERE (grants.agency = NIH-O AND grants.grantid = dates.grantid)
GROUP BY grants.grantid ORDER BY dates.yearday;
This gives me one listing per grant but they are not
Hello,
I am studying the possible
migration of a system using another database engine to MySQL for various
reasons. However, I have several instances of the following query spread
throughout my application that do not work in mysql.
The query is:
Select count(*) from
customer where
At 3:50 PM -0400 5/28/03, Keith C. Ivey wrote:
On 28 May 2003 at 14:17, Peter Fleck wrote:
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants,
dates
WHERE (grants.agency = NIH-O AND grants.grantid = dates.grantid)
GROUP BY grants.grantid ORDER BY dates.yearday;
This
MySQL only supports sub-queries as of v4.1. What version are you running now?
While I am not terribly familiar with joins, I believe that one, properly
executed, could solve your problem. In fact, a similar question was raised
earlier today. Search the archives for a post with the subject
WHERE TAB2_ID 2
is the problem.
Do you want = or or what?
Also your version of MySQL must support sub selects.
James Moe wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2
Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any
special notes I might remember when doing so?
(Mac OS X Server 10.2.6)
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote:
Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any
special notes I might remember when doing so?
(Mac OS X Server 10.2.6)
Ted
Yeah, I posted this and no reply, but you need to do this
Subject :
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.8, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
It is now available in source and binary form from the Connector/J
download pages at http://www.mysql.com/downloads/api-jdbc-stable.html
and
Greetings:
Attempting to run mysqlhotcopy on my RH 7.3 server/ MySQL 4.012 generates
the following:
install_driver(mysql) failed: Can't load
'/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for
module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No
Well noticed, Gerald. I glossed over that bcs the entire query was in caps. I
find it best to capitalize only SQL reserved words, which might be a good
suggestion to the original poster.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: gerald_clark
AHHH! I bet that is why I was having such a horrible time last night
trying to upgrade! I finally said fsck it and reverted back to
3.23.55...
I don't use a root password on localhost... Now I'll try your
suggestions and see if it works. *sigh* *crosses fingers*
-Original Message-
Where does Connector/J fit into the MySQL3.23.x versus MySQL4.x client libraries?
Someone mentioned to me today that mod_php is still compiled with the old 3.23
client even though it may be talking to a 4.x server, so I'm wondering if
Connector/J does anything different depending on whether it's
Ted,
4.1 is not in production release yet. So, for home development to test or
develop for new features specific to 4.1, then OK. If your database server
is for production use serving critical data, then use 4.0.13 which is the
current production release. Follow the instructions carefully
I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD
w/LinuxThreads, my application's query threads get hung up almost instantly,
requiring a kill -9.
When I back down to 4.0.13 (and 3.23), I don't see that particular problem anymore.
So keep an eye out for how it behaves for
Hi,
What do you call hung up ? All query appearing in opening table state
when doing a show processlist ?
If this is the case, I'm experiencing the same problem here with Linux.
Regards,
Jocelyn
- Original Message -
From: LS [EMAIL PROTECTED]
To: Ted Rogers [EMAIL PROTECTED]; [EMAIL
Bearing in mind the international nature of the internet, how do I make a
timestamp local to the user rather than local to my webserver in Canada? If
a user is adding a record to my database from England, I want the timestamp
to be GMT rather than PST, and the same for my Australian clients, and
Hi,
I'm running into an issue on MySQL 4.0.12 (not tested on other releases) using
an InnoDB table type, where an update query is getting written to the query log
but never being propogated as far as the binlog. The query is also not updating
the DB, though according to the connection layer
Hello,
I just joined the list. I was trying to rebuild the MySQL 4.0.13 source
RPM on my RedHat 9.0 machine. I get the following error messages at the
end:
make[2]: *** [isamchk] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-4.0.13/isam'
make[1]: *** [all-recursive] Error 1
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Okay, don't cut my head off. MySQL is new for me, but I'm not new to
databases.
I have a MySQL DB for development running on WinNT (3.23.51-max-nt). I'm
migrating the database for development to Mac OS X MySQL 4.0.12.
I've read both the Upgrading From v3.23 to v4.0 (Section 2.5.2) and
Upgrading
1) Are your users connected temporarely (disconnecing after a certain time) or
do you stay connected until the server crashes ;-)
2) Check your processlist and see if your max_user_connections or
max_connections (depending on your client) is reached.
Best regards
Nils Valentin
Tokyo/Japan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LS wrote:
Where does Connector/J fit into the MySQL3.23.x versus MySQL4.x client
libraries?
Someone mentioned to me today that mod_php is still compiled with the
old 3.23
client even though it may be talking to a 4.x server, so I'm wondering if
On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote:
* [EMAIL PROTECTED]
What the permissions/ownership be on my database directory?
I think is the cause of my problem of only being able to startup
mysqld as 'root'.
On my system the mysqld deamon runs as mysql and files are owned by
Hi all,
I have articles that I wish to display on a site. They are contained in long
text fields in a MySQL table.
I would like to display the first 25 words in the article, then have a
continued link to the rest of the article on another page.
I am using PHP on my pages currently.
Anyone
I might be wrong, but the first thing I always do immmediately after
installation is delete any anonymous user. There is really no need for any
extra account from security point of view.
This also means that one entry f.e [EMAIL PROTECTED] would be enough as the %
contains
any host
Thanks, I get:
(B
(B[localhost:~] ted% ps ax |grep mysql
(B 180 ?? S 0:00.04 sh /usr/bin/safe_mysqld
(B 197 ?? S 0:00.21 /usr/libexec/mysqld
(B 2054 std R+ 0:00.00 grep mysql
(B
(Bdoes this look good? safe?
(B
(BThanks again,
(BTed
(B
(B
(B
(BOn Wednesday, May
On Wednesday, May 28, 2003, at 07:40 PM, [EMAIL PROTECTED] wrote:
On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote:
* [EMAIL PROTECTED]
What the permissions/ownership be on my database directory?
I think is the cause of my problem of only being able to startup
mysqld as 'root'.
On my
On Wednesday, May 28, 2003, at 08:16 PM, otherguy wrote:
ps -U httpd
I screwed this up. It's been a long day. Of course it should be:
ps -U mysqld
sorry about that
-Cameron Wilhelm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello mysql fans ;-),
Does anybody know detailed how mysqlhotcopy works ?
Does it put a lock on the table or only on a row in case of transaction safe
tables ?
Does it work with any table type (Innodb,BDB, Merge, MyISAM) ?
Any comments much appreciated.
---
To general list Moderator: Please
i am getting people to try and break a search engine i built , when we put in the word
DB into the search query i get no results even if its there in the record , why is
this ?
WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN BOOLEAN MODE) LIMIT
0 , 10 ;
also how come this
Hi,
I try to compile MyODBC-3.51.06 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
# gmake
Making all in driver
gmake[1]: Entering directory `/tmp/MyODBC-3.51.06/driver'
gmake all-am
gmake[2]: Entering directory
Hi,
I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system
with gcc-3.2,
but for the make I got this :
# ant
Buildfile: build.xml
Overriding previous definition of reference to non.test.sources
clean:
[delete] Deleting directory /tmp/build-mysql-jdbc
init:
[copy]
Hi,
I tried to configure mysql-4.1.0 and I got these errors :
[...]
checking for OpenSSL... yes
./configure: test: =: unary operator expected
no
./configure: no: command not found
./configure: no: command not found
mkdir: cannot create directory `include/readline': File exists
checking character
i have also noticed that the boolean default is OR how can i explicitly set it to AND
like i'd like both exact matches in the search currently its exact match 1 or exact
match 2 :|
Daniel Rossi [EMAIL PROTECTED] 05/29/03 01:23pm
i am getting people to try and break a search engine i built ,
Hello,
Our company is currently redesigning its MySQL database to be more
efficient. Right now, our major concern is how to effectively do
multiple value lookups in one value table without sacrificing our
searching capability.
Basically, we are trying to link an Item from one table to
No, in my case, both queries report being in Connect state and just stay there.
Something like this:
| 14376 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14416 | unauthenticated user | 10.0.48.147 | | Connect
| | login
Googling around on this I see various people have run
I've just spent the past few days writing this backup script...
http://resume.daevid.com follow the link for it.
It will do weekly full backups on Sunday and daily diff backups. It also
does daily dumps of all databases in the mysql db directory then
combines them into a single .tgz file for
On Wed, May 28, 2003 at 03:42:24PM -0700, LS wrote:
I don't know about Mac OS X, but I can tell you that with 4.1 on
FreeBSD w/LinuxThreads, my application's query threads get hung up
almost instantly, requiring a kill -9.
When I back down to 4.0.13 (and 3.23), I don't see that particular
On Wed, May 28, 2003 at 05:05:38PM -0700, Chris Tucker wrote:
Hi,
I'm running into an issue on MySQL 4.0.12 (not tested on other
releases) using an InnoDB table type, where an update query is
getting written to the query log but never being propogated as far
as the binlog. The query is
On Wed, May 28, 2003 at 09:53:02AM -0700, Chris Tucker wrote:
Alternatively, use InnoDB Hot Backup: http://www.innodb.com/hotbackup.html
This will let you take a real-time backup of your InnoDB tables without
taking the server down.
Agreed.
Aside from shutting down MySQL and backing it up
On Wed, May 28, 2003 at 11:45:44AM +0200, Kristian Halm wrote:
Hi all
I'm going to setup a mySQL database that has to be accessed from Asia
and Europe. Due to the huge distance I plan to duplicate the database
and store one copy both in Europe and Asia. To achive data consistency
both
On Tue, May 27, 2003 at 07:50:21AM -0400, Becoming Digital wrote:
MyISAM is the default MySQL table type. This is the table type of
choice for tables whose primary activity comes from SELECT
statements. There is no need for transaction-safe tables unless
INSERT, UPDATE, and/or DELETE
On Thu, May 29, 2003 at 01:23:08PM +1000, Daniel Rossi wrote:
i am getting people to try and break a search engine i built , when
we put in the word DB into the search query i get no results even if
its there in the record , why is this ?
WHERE MATCH (sl.shotlist , sl.slug , sl.summary)
Hi Jeremy,
You are right it's not sold anymore, but that doesnt mean that it wasnt good,
right ;-).
Apart from the fact that Gemini might be outdated or not, I am really more
interested in the technical features etc.
Anyway thanks for the reply.
Best regards
Nils Valentin
2003 5 29
Has anyone ever been able to communicate between a client app and a mysql
server over stunnel ?
(stunnel listening on client; connecting to stunnel listening on mysql
server; which is redirecting traffic to the mysql port on localhost on the
server
client software connecting to localhost on
On Thu, May 29, 2003 at 12:10:09AM -0700, Daevid Vincent wrote:
Ps. And yes, I sent that as a link in my resume because I'm unemployed
and would love any offers for coding work with PHP, Linux, SQL, etc...
;-)
Well, if you're gonna pimp your resume here, I'll respond
similarly. :-)
We use
Chris,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, May 29, 2003 10:17 AM
Subject: Re: Query log/binlog inconsistency
On Wed, May 28, 2003 at 05:05:38PM -0700, Chris Tucker wrote:
Hi,
I'm running into an issue on
Hello,
can anyone tell me estimated production release for mysql 4.1?
We are now testing it in development enviroment, and it looks like we will be
utilizing its variable charsets per table, column etc. :).
--
Martin Hudec
--
:@: [EMAIL PROTECTED]
:w:
Hello List,
i know little bit about mysql. i use mysql to use
the webportal system of phpnuke. can anyone help me
to import data in mysql. for exams i have a file
nuke.sql which contains like tables design and there
records.
how to call this file when i am having sql prompt. i
use redhat
I'm trying to study some books, like Database Design for Mere Mortals.
I'm finding that I could really use a listserv to get some occasional
questions out.
Anyone know of any?
(Preferably a listserv, but forums will do as well.)
Thanks,
Ted
--
MySQL General Mailing List
For list archives:
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: D Crompton [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 2:54 AM
Subject: Re: local vs %
I might be wrong, but the first thing I always do immmediately after
installation is delete any anonymous user.
Hello List, i am new to mysql. i use php-nuke web portal. i have a database.sql file
which contains my database. it contains tables there records in .sql file which can
be opened with notepad. if i do a fresh installation of mysql how do i recover my
database using my backup file. i mean how
Hi
Newto the lists and just starting to learn about SQL. Looking forward to learning more here.
Cheers
Petra Cowled
Zawadi Rhodesian Ridgebacks
http://www.geocities.com/alekzandr1
ICQ: 20953335
To see whats happening with Rhodesian Ridgebacks in Australia
go to:
Hi all!
I have asked this before, but no replys. I'll rewrite the question
because I don't know if I got understood. ;-) Anyway, I have not found a
MySQL list best suited for this question, so here I go...
¿Anyone knows why the server (mysqld) behaves differently to clients
connecting
Hi Jose,
I believe you miss an important point. Error 1130 means that the host (ip
address) is not allowed to connect, it doesnt mean that its not physically
possible. You have to check the privileges you gave the user or host that
doesnt work.
login to mysql from a working account.
do this:
Hi Nils!
First of all, thanks for your reply.
I believe you miss an important point. Error 1130 means that the host (ip
address) is not allowed to connect, it doesnt mean that its not physically
possible. You have to check the privileges you gave the user or host that
doesnt work.
Vahri? MUHTARYAN [EMAIL PROTECTED] wrote:
I commented out because they are not working when I use set-variable =
local-infile=1 in Server and Client .. Mysql is not starting
?f I use local-infile=1 -- Mysql is starting but still same problem ...
I used --local-infile=1 at command
Rajendra Kumar [EMAIL PROTECTED] wrote:
i know little bit about mysql. i use mysql to use
the webportal system of phpnuke. can anyone help me
to import data in mysql. for exams i have a file
nuke.sql which contains like tables design and there
records.
how to call this file when i am
Gordon [EMAIL PROTECTED] wrote:
My environment is as follows
Dell Inspiron notebook with 512mb ram and 30gb disk (900mhz)
Windows 2000 sp3
MySQL 3.23.52
MySQLGUI 1.7.5-2
I created a database and connected to it ok.
Tried to create a table and nothing happens.
Tried using F9 and nothing
1 - 100 of 111 matches
Mail list logo