Adam Randall <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/Which_version.html
* http://www.mysql.com/doc/en/MySQL_test_suite.html
* http://www.mysql.com/doc/en/running_mysqltest.html
* http://www.mysql.com/doc/en/exte
"Heikki Tuuri" <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/DESCRIBE.html
* http://www.mysql.com/doc/en/ALTER_TABLE.html
* http://www.mysql.com/doc/en/Group_by_functions.html
* http://www.mysql.com/doc/en/ORDER_BY_op
"Heo, Jungsu" <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/Replication_HOWTO.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replic
Hawk,
While your script is fairly straightforward in terms of SQL syntax,
Transact-SQL and MySQL's dialect of SQL are different enough that you
will have to modify some things. Here's a link to the CREATE INDEX
syntax page of the online MySQL manual:
http://www.mysql.com/doc/en/CREATE_INDEX.h
you could try the replace function of mySQL
lewell
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Original
Dear list,
I've been searching the archives before posting this request since it
is about something you've already discussed. But I didn't find the
solution, so here it comes my question.
It is about RAM consuming.
I'm running a PHP/mysql application on a redhat 8.1 - kernel 2.4-18 -
512 MB R
Hello
The latest version of SQLyog at http://www.webyog.com/sqlyog/download.html
contains a very powerful diff tool and it is free.
Try it out.
Insane
- Original Message -
From: "Daevid Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:58 AM
Subject:
SQL
Hi
Two or three days ago, the mail list appeared to stop, and now I am getting
mail two or three days old.
What has happened? Is there a delay in processing mail. The last two emails I
have received are
Re: InnoDB foreign keys bug Yesterday 12:30:56 am
BUG: InnoDB ORDER BY DESC may hang
: SYNOPSIS:
:
: Wondering if anyone knows of, or has built, or is
: interested in building
: a program that will take two .sql schema dumps (one new
: and one old) and
: create the ALTER / CREATE TABLE syntax to make the old
: one look like the
: new one. It
Does that --skip-networking switch prevent mysql from looking for a
socket?
--
Jude
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Chris Wilson <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/Packet_too_large.html
* http://www.mysql.com/doc/en/Creating_many_tables.html
* http://www.mysql.com/doc/en/REPLACE.html
* http://www.mysql.com/doc/en/String_
Does it (mysqld-shareware.exe) show up in the task managers listed
processes?
If not, it is not running (which is what I suspect). Through my
experience with it, the DOS box does not close.
Try opening a DOS box and starting it (type 'cmd' in the run box) and
see what error comes up.
If you are
"Dan Cumpian" <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/ODBC.html
* http://www.mysql.com/doc/en/Contrib.html
* http://www.mysql.com/doc/en/Windows_client_compiling.html
* http://www.mysql.com/doc/en/Windows.html
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it - maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table Two has an entry for each hotel and each day where I store info
Hi all,
I need to regularly export my Web mySQL db to a .dbf format and download
it, so I can use it with another desktop app.
Does anyone know if I can do this with PHP or Perl, or even ASP? Or any
other idea?
Thanks.
Rubens Oliveira
-
Hi MySQL ,
I have made a test database for performance testing
and my InnoDb tablespace grew from 1Gig to 8 Gig...
After I dropped that test database, the tablespace
stayed to the same size. How can I "resize" it to its
original size?
=
-
Benoit St-Jean
[EMAIL PROT
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
56 Paris 1
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
5
[EMAIL PROTECTED],
Do you think the following links may help?
* http://www.mysql.com/doc/en/Static_format.html
* http://www.mysql.com/doc/en/Miscellaneous_functions.html
* http://www.mysql.com/doc/en/Compressed_format.html
* http://www.mysql.com/doc/en/example-Maxi
I hate to reply my own emails, but the fix was adding --quote-names to the
mysqldump options.
- kevin
On Fri, 7 Feb 2003, Kevin S. Brackett wrote:
> mysqldump: Got error: 1064: You have an error in your SQL syntax near
> 'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
> /
"Prasad Budim Ram" <[EMAIL PROTECTED]>,
Do you think the following links may help?
* http://www.mysql.com/doc/en/Asking_questions.html
* http://www.mysql.com/doc/en/RESTORE_TABLE.html
* http://www.mysql.com/doc/en/Miscellaneous_functions.html
* http://www.mysql.com
In the last episode (Feb 06), Prasad Budim Ram said:
> Hi,
> Can any of you give me links about Archiving and restoring the data in
> MySQL database. Are there any utilities for the same?
http://www.mysql.com/doc/en/Backup.html
--
Dan Nelson
[EMAIL PROTECTED]
--
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Backup
mysqldump is my preferred method
[snip]
The most normal use of mysqldumpis probably for making
a backup of whole databases. See section 4.4.1
Database Backups.
mysqldump --opt database > backup-
Perhaps you can search the manual before you send a question to this (or
any other) list. You really should since several ppl spend time to
create and keep it up to date.
The manual is here:
http://www.mysql.com/doc/en/index.html
If you launch a search for the word backup you will find:
http://ww
On Thu, Feb 06, 2003 at 05:28:03PM -0800, Daevid Vincent wrote:
> I searched google, but didn't find anything.
>
> SYNOPSIS:
>
> Wondering if anyone knows of, or has built, or is interested in building
> a program that will take two .sql schema dumps (one new and one old) and
> create the ALTER
Hello
I have a performance problem when working against a large table that I
hope that I can get some help with. The table stores data that is
collected from a monitoring unit for a heating system for a larger house
complex. The table is constructed as shown below.
Transceiver INT NOT NULL, Chann
Thank you so much everyone for all of your support!
I asked a question re: a mysql post error when the text containd apostrophe and
commas. I got feedback re: delimiting and putting a / before each comma and
appostrophy. The problem is that this is not feasable for me to do this on so much
te
Prasad,
> Can any of you give me links about Archiving and restoring the data in
> MySQL database. Are there any utilities for the same?
You can use mysqldump in several ways to backup data, and mysqlimport
or mysql (the command line tool) to import data backuped with
mysqldump. There are many o
At 19:23 +1100 2/7/03, Dan Rossi wrote:
yes i am aware that sub selects are in 4.1, i'm pretty sure i have it
running @ home, there are some large traffic sites i would like to lighten
up and make a bit faster code wise with query caching and sub selects, but i
havent been told what "gamma" means
At 11:37 +1000 2/7/03, boclair wrote:
- Original Message -
From: Paul DuBois <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement
: At 14:19 +1000 2/5/03, boclair wrote:
: >I notice
At 10:55 +0100 2/7/03, Stefan Hinz wrote:
Marg,
MB> "The start up looks good: when I use the Run function
MB> C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but
MB> I'm getting this error when using the MySQL test script (See below):
I didn't know MySQL was shareware, well
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lucia Sheehan wrote:
I am creating a java application and am using tomcat. I would like to be
able to use mySQL in embedded mode, is this possible? you mentioned in
this thread that it could be made linkable in a java application, can you
tell me w
On Fri, Feb 07, 2003 at 03:20:47PM +0500, Vikram Vaswani wrote:
>
> My name is Vikram Vaswani, and I'm currently working on the outline for a
> MySQL reference book. This is supposed to be a comprehensive reference to
> MySQL 4, covering all aspects of the software, including the new
> transaction
> But what if concurrent inserts are happening to the table while the
> users page-view thru the data. The count may change.
True, in my situation that is not a big concern. In yours it may. You can
either expire the cached value every so often or run two queries on each
hit.
If you're expectin
On Wed, Jan 15, 2003 at 02:07:42AM -0800, Admin-Stress wrote:
> Hi,
>
> I am new to mySQL, so I need some help.
> I have a table, which has record structure like this:
>
> - customer
> - name
> - register_date
> - expired
>
> Every day, I add some records, new customers. The field 'expired' is
V4.0.9
How can I use the mysqld.sym file via gdb? It doesn't like the format.
Copying the stacktrace into another file where I have to edit out a
bunch of junk from gdb for resolve_stack_dump is a bit slow.
It seems that two processes have hung for a while. All the slots have
filled up even thoug
On 2/7/03 2:20 AM, "Vikram Vaswani" <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> My name is Vikram Vaswani, and I'm currently working on the outline for a
> MySQL reference book. This is supposed to be a comprehensive reference to
> MySQL 4, covering all aspects of the software, including the new
Hi all,
I think this can be done with a SQL query, but not have much luck getting it
right. Was hoping to get some suggestions on the best way to do this.
I need to extract the 'name' column in a mysql database table. split the name so
we have a "first" and "last" name value, as the name was or
Hi all,
I have a table where I have something like this:
| abc |
| abc |
| xxx |
| null |
| null |
| null |
I want to count these lines to give the result 5, meaning a distinct count
for values which are not null, and counting all the null values.
This means 1 for "abc", one for "xxx", and 3 fo
Testing - Mysql
-
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 PROTECTED]>
To unsubscribe, e-mail
Get DBI.pm from search.cpan.org.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Paul Choy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 10:53 PM
Subject: cannot locate dbi.pm while running perl scripts
Hi :
Well I actually noticed a press release a few days ago
saying that the latest version (4.0.10??) is
supporting sub-slelect... please check the website.
this following should be working:
select nome from categorias, categoriamembro
where categoriamembro.id_categoria =
categorias.categoria and
c
Assuming your server supports innodb, you can use:
Alter table table_name TYPE = InnoDB;
if it failed, simply create a table with the new type,
populate it with the data in your table (with the
"wrong" type), drop the old table and rename the new
table.
--- [EMAIL PROTECTED] wrote:
>
> Are you
here's another example from the manual...
SELECT * FROM pet WHERE name REGEXP "^b";
see: 3.3.4.7 Pattern Matching
--- Dobromir Velev <[EMAIL PROTECTED]> wrote:
> Hi,
> I use it in queries like
>
> SELECT * FROM table WHERE field REGEXP "patern";
>
> It is the same as using the LIKE operator wi
I have a problem connection from a remote host
this is the error I get
ERROR 2013: Lost connection to MySQL server during query
I am using redhat 8.0 and mysql3.23.54
please help
thank you
--
Antoine <[EMAIL PROTECTED]>
-
my 2 cents:
SQL in the "What is SQL?" phrase threw me... I thought
you were talking about MS SQL..
If I were you, I would explain relational databases
and normalization (at list to normal form III).
Usage?? well whoever goes to buy your book, must have
some ideas in head for the usage.. I don't
drop database_name;
make sure no ones is using the database_name.
--- Calvin Lam <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am a newbie with this and I need help with Mysql
>
> How can I delete a database in Mysql
>
> thanks!
>
>
--
If your going to HAVE to use windows 2000, you'll have to odbc and create
the form with vb.
I've always used web front ends and had the PDF generated on the fly, to
have to use 2000 is going to mess things up no end.
Jerry
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
Hi,
It is good for MyISAM tables.
For Innodb it puts on separate disk frm files only.
And what about Innodb tables of the specific database?
Regards,
Dmitry
> Is there any way to put different db on separate disks ?
You can move database directory to another disk and create a symlink. More
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2003 9:33 AM
Subject: Merge table limit
> Hello all.
>
> Does any one know, or can anyone point me in the direction of the limits
of
> a number of tables I can put in a union of a
Michael,
> I am using MySQL 4.0.10 on Windows. If I process SELECT @@whatever (where
> whatever is not a valid global variable name), the connection is closed.
I guess what you mean is:
Server version: 4.0.5-beta-max-nt-log
mysql> SELECT @@whatever;
ERROR 1193: Unknown system variable 'w
Pass it to a script or handeler program that does the dB work then passes
back what you need to the radius ?
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wireless
-
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
Bill,
>> record, but I need to do more processing and execute several SQL
>> statements in order to do all the usage tracking I need.
I'm not informed about Radius in any way, but I guess what you want to
do is have a middle-tier in form of an application, e.g. in PERL, PHP,
or whatever.
>> The
At 14:21 + 2/7/03, Qin Lu wrote:
Hello,
I'd like to practice my C application for using mysql.
Do you know where can I find some examples?
Look in the client directory of a MySQL source distribution. Many/most
of the standard MySQL clients are written in C.
You can also get examples at t
Hello
How can i translate MySQLCC on Bulgarian?
-
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 PROT
Hi
I am new to MYSQL. I have just installed 4.0.5 onto Win2K and I am having
problems getting the thing started. NET START MYSQL starts fine, but it
seems to fail with the following contents generated in the mysql.err file
(below).
Any ideas what I am doing wrong?
Thx
GM
InnoDB: The first sp
C,
> After some struggling, I have managed to get the problem below 99% working,
> the problem now is that I can't get them in descending order. Here is my
> select statement.
>$query = "select manager.name, position, MAX(goals) from roster join
> reference join manager where
>manager.idn=
Tool called SQLyog at
http://www.webyog.com/sqlyog/download.html does that.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Bef
On Fri, Feb 07, 2003 at 04:33:15PM -0700, [EMAIL PROTECTED] wrote:
> Hi "Doug Beyer" <[EMAIL PROTECTED]>,
>
> I'm not sure if you have checked the manual yet, but following
> links seem to be somewhat related to your query:
Please could these stop. Already I have noticed various people
reposting
At 12:32 -0500 2/7/03, Bhavin Vyas wrote:
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL
I have a problem connection from a remote host
this is the error I get
ERROR 2013: Lost connection to MySQL server during query
I am using redhat 8.0 and mysql3.23.54
please help
thank you
--
Antoine <[EMAIL PROTECTED]>
-
Dear mysql ,
ÁÕ¸¹Ò¤ÒÃáËè§Ë¹Öè§à¢éҺѪÕãËé¤Ø³·Ø¡àªéÒà»ç¹à§Ô¹ 86,400
ºÒ·äÁèÁÕ¡ÒáÂÍ´¤§àËÅ×Íä»ÇѹÃØ觢Öé¹
·Ø¡àÂ繨ÐźÂÍ´¤§àËÅ×Í·Ñé§ËÁ´·Õè¤Ø³äÁèä´éãªèÃÐËÇèÒ§Çѹ
àÇÅÒ
Åͧ¨Ô¹µ¹Ò¡ÒÃÇèÒÁÕ¸¹Ò¤ÒÃáËè§Ë¹Öè§à¢éҺѪÕãËé¤Ø³·Ø¡àªéÒà»ç¹à§Ô¹ 86,400
ºÒ·äÁèÁÕ¡ÒáÂÍ´¤§àËÅ×Íä»ÇѹÃØ觢Öé¹
·Ø¡àÂ繨ÐźÂÍ´¤§àËÅ×Í·
Did you start the server? Normally, error 1064 means the server has not been
started.
- Original Message -
From: "jsp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:49 PM
Subject: NEWBIE to mysql
Can anyone tell me why I keep getting an ERROR 1064 with th
You need to separate the fields with a comma.. Do:
name varchar(50),
message varchar(255)
See: http://www.mysql.com/doc/en/CREATE_TABLE.html
Gurhan
On Fri, 2003-02-07 at 19:52, Wileynet wrote:
> Can anyone tell me why I keep getting an ERROR 1064 with this command ?
> I just would like to create
comma after the 3rd line.
CREATE TABLE info (name varchar(50),message varchar(255));
^ comma here.
Jerry
Apps-R&D
Cable and Wireless
- Original Message -
From: "Wileyn
Bad syntax. Missing a , and type=MyISAM
Try reading the documentation:
http://www.mysql.com/doc/en/CREATE_TABLE.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Michael,
with my last reply, I was somehow wrong. It looks like a bug, indeed.
> I am using MySQL 4.0.10 on Windows. If I process SELECT @@whatever (where
> whatever is not a valid global variable name), the connection is closed.
> Is this by design? Then it should be documented. Otherwise it is
Wiley,
mysql>> CREATE TABLE info
> -> (
> -> name varchar(50)
> -> message varchar(255)
> -> )
> -> ;
It's a missing comma:
mysql>> CREATE TABLE info
> -> (
> -> name varchar(50), /* the comma goes here */
> -> message varchar(255)
> -> )
> -> ;
Regards,
Am I the only one that equates these robot replies with spam? Most of
them are as meaningful as talking to micro$oft.
Yeah, I filter them on input and they go to trash, but silence can be
taken as consent which might be construed as endorsement. Who knows
what would come next?
My $0.02,
Doug
Paul DuBois wrote:
I won't. It's silly to switch terms when the sentence has already been
reworded. The original post was based on an old version of the manual.
Gender is more correctly used for behavior or culture, not biology.
I hate to dissapoint you, but according to dictionary.com at lea
you could use the format function of vbScript
format(string, "-mm-dd")
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
Andrew Braithwaite wrote:
When I first read the phrase in question it made perfect sense in the
context in which it was written.
The fact that it made sense to you is somewhat irrelevant to whether it
made sense to the complainant(s).
mysql> UPDATE persondata SET age=age*2, age=age+1;
Remov
My question is this: I need to input data from a .sql file into an
existing and empty database I have created.
I type this into terminal at the main command line: mysql -uUser
database_name < filename.sql.
I keep getting an error message that says no such file or directory
exists.
I have trie
In the last episode (Feb 07), Kevin S. Brackett said:
> mysqldump: Got error: 1064: You have an error in your SQL syntax near
> 'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
> /*!32311 ' at line 1 when using LOCK TABLES
index is a reserved word. Not sure how you managed
: Am I the only one that equates these robot replies with
: spam? Most of
: them are as meaningful as talking to micro$oft.
:
: Yeah, I filter them on input and they go to trash, but
: silence can be
: taken as consent which might be construed as endorsement.
:
At 4:52 PM -0800 2/7/03, Wileynet wrote:
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook but I want to store the data in a mysql database.
mysql> CREATE TABLE info
-> (
->
What should be done to clear this error? This is slackware 8.0 with all
packages installed and kernel 2.2.19.
-- Jude
Script started on Sun Feb 9 19:21:04 2003
root@athame:/tmp/mysql-3.23.39# make all
make all-recursive
make[1]: Entering directory `/tmp/mysql-3.23.39'
Making all in include
>
>Hi,
>
>I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000
>machines
respectively.
>Users and host IP has been setup on mysql, and innodb has been setup with as below.
>
>innodb_data_file_path = ibdata1:10M:autoextend
>set-variable = innodb_buffer_pool_size=70M
>
No respond from remote server.
Tried using mysqladmin -h hostname version.
There was no response just hanged there. Even tried telnet hostname 3306. Same problem.
However the remote server is working cos i tried to access it from another computer. I
have also tried to install mysql 4.0.8 gamma and
Hi [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Business_Services_Support.html
* http://www.mysql.com/doc/en/Which_OS.html
* http://www.mysql.com/doc/en/MySQ
>Description:
Application that uses MyODBC 3.51.05 + MySQL 4.0.10
constantly grow memory consumption. Such behavior is not
observed if MyODBC 3.51.05 + MySQL 3.23.55 are used. I suppose
that there is memory leakage in libmysqlclient. Application
linked direct
Hello All:
Let's suppose I want to count the rows in set for a match
to a value in a column. I don't need to read the selection
set, I just need to know the number of matches.
What is the quickest, most efficient way to do this in mysql?
TIA
--
Tim Johnson <[EMAIL PROTECTED]>
http://www
With UltraDev you still have to call some javascript.
Here is a couple of examples...
function MySQLDateToday(){
var tDate = new Date();
year = tDate.getFullYear();
month = tDate.getMonth() + 1;
if (month < 10)
{ month = "0" + month; }
day = tDate.getDate(); //getDate is day of month, go fi
In the last episode (Feb 07), [EMAIL PROTECTED] said:
> Hi "Rusch (ext) Reiner" <[EMAIL PROTECTED]>,
>
> I'm not sure if you have checked the manual yet, but following
> links seem to be somewhat related to your query:
Can we maybe block [EMAIL PROTECTED] emails to the list?
--
Dan Nels
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysql>create table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created b
hi
i am using mysql version 4.0.1 alpha
my problem is that whenever i update my my.cnf to enable innodb support and
restart the system the mysql.sock file gets deleted and i cannot start
mysql. and then again i have to re install mysql
i have even tried by changing the file persission for my.cnf t
HI,
I would like to know if MM driver / Connector J for MySQL gives any
facility to archive a database. Not sure if JDBC covers this.
I have seen the mysqldump/ mysqlexport options but, i need to invoke
the Archive and Restore from a Java program.
Any bright ideas or solutions to this ?
Regards
Jeremy - the first one ;)
Any comments on the TOC?
Vikram
At 02:46 PM 2/8/03 -0800, Jeremy Zawodny wrote:
>On Fri, Feb 07, 2003 at 03:20:47PM +0500, Vikram Vaswani wrote:
>>
>> My name is Vikram Vaswani, and I'm currently working on the outline for a
>> MySQL reference book. This is supposed to
Hi Nasser,
>Usage?? well whoever goes to buy your book, must have
>some ideas in head for the usage.. I don't think you
>should waste trees on telling people things that don't
>help them.
>
>One Question: What makes this book different from the
>MySQL manual?
Well, it's not supposed to replace th
mysql I have some good news for you.
Our records show you have been entilted for a FREE membership.
Write down the information below. this offer expires in 12 hours.
Members Username: mysql
Members Password: q74Xly
http:[EMAIL PROTECTED]/apie/
Click on the above link to activate your free m
mysql> CREATE TABLE info
-> (
-> name varchar(50),
-> message varchar(255)
-> )
-> ;
[EMAIL PROTECTED] wrote:
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook bu
Store town numbers in another column.
[EMAIL PROTECTED] wrote:
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
Not sure if this will work with MySQL (office uses a different database and
I can't get to real one to test it) but this seems to work:
select t1.name, tot=(t2.col1+t2.col2+t2.col3+t2.col4)
from table1 t1, table2 t2, table3 t3
where t1.id1 = t3.id1
and t2.id2 = t3.id2
order by tot desc
name to
HI,
I would like to know if MM driver / Connector J for MySQL gives any
facility to archive a database. Not sure if JDBC covers this.
I have seen the mysqldump/ mysqlexport options but, i need to invoke
the Archive and Restore from a Java program.
Any bright ideas or solutions to this ?
Regards
I managed to sort this out.. There wasn't anything wrong with the query or the
inserts my brains was frozen!
having problems with the new query to pull the records back though if anyone
wants to give a hand?
Andrew
>-Original Message-
>From: Andrew Maynes [mailto:[EMAIL PROTECTED]]
>Sent
select table1.name, table2.id2+table2.col1+table2.col2+table2.col3 as
mysumresult from table1 left join reference using (id1) left join table2
using (id2);
[EMAIL PROTECTED] wrote:
Not sure my other email got through, so here it is again, with an updated
description of the problem.
Hi,
I have
Wiley,
there's a comma missing from the end of:
name varchar(50),
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 00:52
To:mysql
cc:
Subject:NEWBIE to mysql
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two field
We are in a critical state with our app. We would like to dump Oracle 9i
and go to MySQL. We have to do the due diligence on the port over the next
few weeks.
However, we must have full native support for UTF8. Its my understanding
this is only in MySQL 4.1.
Our dev and test platform is Win2000.
>>> Francesco Leonetti <[EMAIL PROTECTED]> Sunday, February 09, 2003
5:43:45 AM >>>
Dear list,
I've been searching the archives before posting this request since it
is about something you've already discussed. But I didn't find the
solution, so here it comes my question.
It is about RAM consu
Nicolas,
> How can I fix an order by using numbers and letters ?
> Id Town
> 56 Paris 1
> 60 Paris 10
> 7 Paris 11
> I'd like to get :
> 56 Paris 1
> 6 Paris 3
> 57 Paris 4
> A this time I'm doing this sql syntax :
> SELECT *
> FROM town
> ORDER BY town ASC
SELECT * FROM town ORDER by town ASC, d
1 - 100 of 160 matches
Mail list logo
