Is there an ARRAY data type in mysql ???
I cdn't find it in documentation,but my java
book shows SQL has support for Arrays ..:(
Someone help???
regards
--
harsh
http://www.cse.iitb.ac.in/~harsh
---
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from localhost:3306 to server:3306.
If I u
I'm in the process of building a database server with the he following specs:
IBM x235 Server
4 x 73GB SCSI hot-swap drives
2.5GB ECC RDIMM memory
Ultrium LTO Backup Unit
ServerRAID-5i SCSI Controller.
This is being built on RedHat Linux 7.3.
My question is I've been told that this needs to be b
in process of building a data warehouse with MySQL. The primary database
holds todays data. The warehouse holds a years worth of data. In order to
pipe the data from the primary to the warehouse, was considering using an
audit program that would port changes to specific primary tables to the
wareho
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pierre wrote:
> 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
>
> cle
Rehaz Golamnobee writes:
> Hi
>
> I have just upgraded my MySQL from version 3.23 to 4.0.13.
>
> However I cannot start the server. When I type mysqld_safe & I get the following :
>
> [1] 1730
> Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql
> 030529 11:10:51 mysqld ende
Hi
I have just upgraded my MySQL from version 3.23 to 4.0.13.
However I cannot start the server. When I type mysqld_safe & I get the following :
[1] 1730
Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql
030529 11:10:51 mysqld ended
[1]+ Done mysqld_safe
When I type
hi,
i have the following query working perfectly with Dbase 4, but it crashes in
mysql :
SELECT SUM(DISTINCT A.AMOUNT) AS AMT FROM table1 A
I'd like to get that amount in only one query if possible, even though i
could do it by using a temporary table, selecting into it all the distinct
amoun
I'm using Mysql 3.23.51 on redhat.
does anyone know if there is a way of deleting records using a join.
I read somewhere that this is only supported as of version 4.x
Regards,
Steve Mansfield
[EMAIL PROTECTED]
http://www.getreal.co.uk
Real Data Services Ltd 117-119 Marlborough Road Romford Essex
"Themis Kafetzopoulos" <[EMAIL PROTECTED]> wrote:
> How can I store procedures in mysql?
Stored procedures will come only in 5.0 version of MySQL server.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Nick Stuart <[EMAIL PROTECTED]> wrote:
> Ok, seem to have an odd problem here. Using MySQL 4.0.12-max-nt-log on
> Windows 2000 server. When ever I issue a show process list all the host ids
> are of the machine that I am connecting from. So if I do 'SHOW PROCESSLIST'
> from ip ***.***.***.189 al
"Bruno Batarelo" <[EMAIL PROTECTED]> wrote:
> 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=bpolj
Daniel Rossi <[EMAIL PROTECTED]> wrote:
> 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 g
"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 F
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 w
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 c
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.
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 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 fro
Hi
New to 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: http://www.australi
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
- 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 anonymou
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: http
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 lin
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: http://www.
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
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 us
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 client;
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日 木曜日
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
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 ac
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 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 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 i
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 particu
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 stor
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
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 mul
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 bu
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
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] Copyin
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 `/tmp/MyODBC-3.51.06/driv
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 doe
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 r
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:http://lists.mysql
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
Maybe this:
SUBSTRING_INDEX(str,delim,count)
Returns the substring from string str before count occurrences of the
delimiter delim. If count is positive, everything to the left of the final
delimiter (counting from the left) is returned. If count is negative,
everything to the right of the final d
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
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 (inclu
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 kn
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
mysql
-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
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
2
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
"Upgradin
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
m
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 (P
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 s
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]
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
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 a
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 ta
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-
> Fr
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" <[
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
such
-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 m
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 : mysql_fi
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]
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
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 "Upda
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 giv
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 wher
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 ar
-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
-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
> WHER
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 4.1.
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 submissi
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 are
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 anywher
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
Bec
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 sto
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
Hi
I have used stored procedure in my application
with MS-SQL Server and I
want to use it with My SQL.
Please let me know if any way is there to use stored
procedure in MySQL. or
if any other way is there.
Thanx and regards :
Rajesh Sharma
Asst. System Engineer
Tata Consultancy Servic
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'
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 inde
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.
http://www.mysql.com/doc/e
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 następuje:
Hi
>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 w
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 P
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 enoug
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 ma
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
A
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 m
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
>
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,
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
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,
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 wa
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?
>
>
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
1 - 100 of 108 matches
Mail list logo
