assuming you have a table with two columns id and town
then here's one solution:
> Create temporary table address (ad varchar(30));
> Insert into address select concat(id, ' ', town)
from your_original_table_name;
> select * from address order by ad;
--- Nicolas JOURDEN <[EMAIL PROTECTED]>
wrote
my previous database was ORACLE8 IN WHICH THE BACKUPS ARE .DMP FILES
PLEASE HELP ME TO CONVERT THAT INTO MYSQL DATABASE
PRATHIMA RAO
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Hi,
I managed to install kafee and run a few java programs.
Now, comes the time those java program have to use MySQL database.
This is the error I get everytime I run my program:-
06-12-2002 00:43:27.302 [INFO] [main] JDBC Driver class:
com.mysql.jdbc.Driver
06-12-2002 00:43:27.304 [ERROR
I got mysql working. The thing is, as far as I can tell slackware built
it wrong. Once I downloaded source and built it with that line in the
manual I installed grant tables and ran safe_mysqld --user=mysql & and
when that came up and stayed up I tried mysql -utest and got a useful
environment.
- Original Message -
From: "yeong Tze En" <[EMAIL PROTECTED]>
> I am trying to develop an ERP system(Enterprise Resources Planning)..
> I am wondering wheater if MYSQL suitable for this system..? Any opinion or
suggestion from you all?
> Maybe Oracle or SQL server are more suitable.. at lea
Alex:
It appears you use the following mailer:
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
Use this link to unsubscribe to this list:
http://lists.mysql.com/php/unsubscribe.php
I'm so tempted to say more, but I'm restraining myself considering the mailer
you us
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.39 (So
Hi Octavian,
Try this:
select FieldName, count(*) from TableName group by FieldName
Bye,
Danny
At 16:39 2003.02.08._+0200, you wrote:
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 r
Dear all,
How do I select the very last record in a column in MySQL database?
Regards,
DT
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
On Mon, Feb 10, 2003 at 01:52:36PM +0100, Benjamin Pflugmann wrote:
> Is this bot somehow endorsed by the list admin / MySQL AB?
Hello Benjamin,
This bot is not endorsed by MySQL AB. While it was kind of Sherzod to
try to improve the utility of the list, the bot makes the list more
diffic
Dear all,
How do I select the very last record in a column in MySQL database?
Regards,
DT
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Have you looked into OpenOffice?
Won't work if you want to protect the report format from user changes though
Jerry ([EMAIL PROTECTED]) wrote*:
>
>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 gen
My email does not seem to be getting through.
This is a test to confirm whether this problem with
the mysql mailing list has been corrected.
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
On Sun, 9 Feb 2003 16:24:03 -0700, Pamela Hart wrote:
>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 mes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sherzod --
...and then [EMAIL PROTECTED] said...
%
% : Am I the only one that equates these robot replies with
% : spam? Most of
...
%
% Answers to most of the posted questions could be found online,
% so I just thought a similar autorepl
Is your Server B using the --log-slave-updates flag?
-Mike
> Hello!
>
> I have a following system.
>
> Server A : a master for server B. MySQL 4.0.9
> Server B : a slave for server A, a master for server C. MySQL 4.0.10
> Server C : a slave for server B. MySQL 4.0.10
>
> and I wanna that if
I am trying to develop an ERP system(Enterprise Resources Planning)..
I am wondering wheater if MYSQL suitable for this system..? Any opinion or suggestion
from you all?
Maybe Oracle or SQL server are more suitable.. at least the existing systems in the
market are using this 2 type of databas
: Hi :
:
: When I try running my perl scripts using DBI interface
: with mysql, I got
: this message:Can't locate DBI.pm in @INC((@INC contain :
: /usr/lib/perl5/5.6.0/i386-linux
: /usr/lib/perl5/5.6.0./usr/libperl5/site_perl/5.6.0/i386-linux
: /usr/lib/perl5/site_
HI
Does mysql support function EXIST
I got the following error
mysql> select * from arcdata d
-> WHERE year='2003' AND semester='1'
-> AND EXIST (SELECT * FROM arcdata_unitCodes u
-> WHERE u.idnum = d.idnum AND u.semester=d.semester AND u.year=d.year
-> AND unitcode LIKE '433%')
http://www.php.net/addslashes
http://www.php.net/stripslashes
--- ahimsa <[EMAIL PROTECTED]> wrote:
> 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 /
On Sat, 8 Feb 2003, Rubens Oliveira wrote:
> 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?
I've seen a couple utilities
On Fri, Feb 07, 2003 at 07:23:43PM +1100, 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 be
I've sent three request-for-unsubscribe messages from my subscribing
email address to following address since yesterday:
[EMAIL PROTECTED]
Still no responce message generated from the list. So I am writing to
the list to ask the moderator to help me sign off from the list.
Thanks!
Alex Shi
*p
Would it be possible to share with me the name and location of this Hex
editor and also the Perl script as I am having the same problem where I have
lost my SQL data. Would
appreciate it greatly.
Michael Krassos
Network Specialist
University of Miami
Department of Telecommunications
---
We used your MYSQl graphical utility, selected a few lines for
deletion and it emptied our table completely. Tried to restore, tried
using myisamchk to no avail. Can see data in the .MYD file, but
records must be marked for deletion because cannot recover the data.
Need help to get this data bac
Hi,
If you are inputting text, perhaps you should create a simple HTML form and
use PHP to insert into the database for you. You can use the PHP internal
function add_slashes($text) to automatically delimit everything for you.
If you don't know what PHP is or don't have it installed, then perhap
sql, query
Hi, group,
Do you know whether there is an upgrade patch for 3.23.47 to 3.23.55 on
SunOS 5.8 rather than a new installation?
Thank you,
Jannie
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http
I have a Red Hat 7.2 box running MySQL 3.23 on an Athlon XP 1700 with
1 GB of RAM. I have had this box for months and it has never had a problem.
Yesterday I invoked a LOAD DATA LOCAL INFILE command on a text file
with 1.5M 2-field tab-delimited varchars into an empty 2-field table and it
not only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
anupam --
...and then [EMAIL PROTECTED] said...
%
% Hi!
Hello!
% this is a beginner's question about MySQL. I have looked at the online MySQL
% documentation and have not found an answer.
I would say that this is actually a question about data
Scott,
Try using single quotes for the values in your INSERT statement.
$sSql = "INSERT INTO contacts (first_,last_ ) VALUES
('$first_','$last_')";
Quoted identifiers is a setting usually enabled for SQL Server
connections, and so it thinks you are indicating an attribute (column)
You could have PHP escape it for you. Look into the addslashes function.
It adds slashes to escape characters.
http://www.php.net/manual/en/function.addcslashes.php
If your server has magic quotes turned on it will automatically escape
characters, but it is not a good idea to rely on that.
If yo
Assuming it is 5 fixed columns, you could try:
SELECT t1.Name, SUM(t2.col1+t2.col2+t2.col3+t2.col4+t2.col5) as sum
FROM t1, t2, t3
WHERE t1.id1 = t3.id1 AND t3.id2 = t2.id2
GROUP BY t2.id2
ORDER BY sum DESC
Also, i'm assuming that all entries in t1 have a correspondent in t3 and
t2.
On Sat,
On 8 Feb 2003, at 13:21, ahimsa wrote:
> 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.
No, it's \ (backslash), not / (slash), and I don't know what your
problem with com
On 8 Feb 2003, at 12:25, Bhavin Vyas wrote:
> So, it could either be ^www.yahoo.com^(ct value) or
> .^^.(no ct value). I would like that when there is no
> ct value present in the line, the ct value in Log table should
> stay as the default NULLbut it is not. The value becomes ''
Dear mysql ,
¤Ø³ÃÙéËÃ×ÍäÁèÇèÒ
.
70% ¢Í§¼Ùé·Õèà¨çº»èÇ·ÑèÇâÅ¡
ÁÕÊÒà˵ØÁÒ¨Ò¡
âÀª¹Ò¡Ò÷Õ躡¾Ãèͧ
"¡ÒÃÃѺ»ÃзҹÍÒËÒà äÁè¶Ù¡ËÅÑ¡âÀª¹Ò¡ÒÃ
·ÓãËéÃкº à¼Ò¼ÅҢͧÃèÒ§¡ÒÂ
áÅÐÃкº´Ù´«ÖÁ ÍÒËÒ÷ӧҹäÁèÊÁ´Øšѹ
áÅÐÁÕ¼ÅãËéàÃÒä´éÃѺ
ÊÒÃÍÒËÒà äÁèà¾Õ§¾Í
µèͤÇÒÁµéͧ¡ÒâͧÃèÒ§¡ÒÂ
áÅÐà»ç¹·ÕèÁҢͧ ¡ÒÃÁÕ¹éÓ˹ѡ
Where is the text coming from ?
With languages like php, there are loads of functions to escape things and
make sure that the text is ok
Jerry
- Original Message -
From: "ahimsa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2003 9:21 PM
Subject: whats the best
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
>
> In MySQL, I need to do a multi table join in the context of a left
join. Have three
> tables: NAME, ADDRESS, and COUNTRY. Address contains a country code
(ie
> "CAN") and COUNTRY contains the translation (ie Canada). What I'd
like to
> do is get all NAMES, all datat from ADDRESS if it e
Hi all,
Please tell me how to modify the variable ft_min_word_len.
I've tried:
set ft_min_word_len=2;
set @ft_min_word_len=2;
The second creates a new variable I think and the first one tells me that
there is no such variable.
Thank you.
sql
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email
Hi all,
Please tell me what should I do to make MySQL cache all the queries that can
be cached.
Can I do this if I am not the administrator of MySQL server? (on a session
basis...).
Thanks.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
-
On Saturday 08 February 2003 18:44, Jude DaShiell wrote:
> Does that --skip-networking switch prevent mysql from looking for a
> socket?
No, if you use --skip-networking, you can connect only via Unix socket.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This em
mysql> CREATE TABLE info
-> (
-> name varchar(50) , <---comma !!!
-> message varchar(255)
-> )
-> ;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
On Saturday 08 February 2003 02:52, 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 TABL
sql, query.
Hi, group,
Greetings!
I'd like to hear your advice about "what's the best way to upgrade 3.23.47
to 3.23.55 on SunOS 5.8 with less downtime"?
Thank you,
Jannie
_
Add photos to your e-mail with MSN 8. Get 2 months
>Description:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\"
-DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I. -I.
-I.. -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c libmysql.c
-Wp,-MD,.deps/libmysql.TPlo -fPIC -DPIC -o .lib
Lars,
if I understand you correctly:
create table table1
(
hotel_number int
);
create table table2
(
hotel_number int,
free_day datetime
);
insert into table1 values(1);
insert into table1 values(2);
insert into table1 values(3);
insert into table2 values(1,"Jan 1 2003");
in
Bhavin,
the documentation says that you use \N to represent null values.
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 17:25
To:mysql
cc:
Subject:Help with default NULL
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field
same here i also received mails 12hrs+ after i posted it. what seems to be
the problem, it will take days before ppl could suggest help on mysql
problems
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 i
While exporting the data can you map empty strings to the literal null?
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject: Help with default NULL
Hi,
I have a table Log described as such:
+--+
Hi,
Yes MySQL will work on XP-HomeEd
To start it...
open a command prompt, do this by...
Start -> Run -> cmd.exe
then
cd c:\mysql\bin
mysql-nt.exe
this has started a mysql db engine.
the command prompt will not return.
to install it as a service instead do the following instead of the above
Hi,
We are pleased to announce the DBManager Professional 2.0.1. Starting in
this version it is also available in Portuguese language. Bellow a list of
the changes:
New Features
-Foreign Keys listing in MySQL/InnoDB
-Enabled Metadata View
-Enabled DAO Import for queries and relationships
-Suppor
Hello.
On Sat 2003-02-08 at 07:24:17 -0700, [EMAIL PROTECTED] wrote:
[...]
> 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
Hi.
On Sat 2003-02-08 at 16:06:03 +, [EMAIL PROTECTED] wrote:
[...]
> Re: InnoDB foreign keys bug Yesterday 12:30:56 am
> BUG: InnoDB ORDER BY DESC may hang in 4.0.10 Yesterday 12:40:40 am
>
> and they arrived 24 hours after being sent!
Yes, the list server is lagging behind now for a while
Dear Sir,
I have some problems about using Thai language in MySql.
I don't no how to make MySql for using Thai lanuage both input and query.
I can input Thai messages from web browser but I can't read the result from
query the messages from MySql to show on web brower and using MySqlAdmin
to q
- Original Message -
From: "Wileynet" <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:52 PM
Subject: NEWBIE to mysql
> Can anyone tell me why I keep getting an ERROR 1064 with this command ?
> mysql> CREATE TABLE info
> -> (
> -> name varchar(50)
> -> message varchar(2
Hi,
How can I write a MySQL query to grab single lines of the form:
ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4
From two joined tables:
Tbl1: Enquiries
--
ID
Name
Address
Etc
Tb12: Details
ID
EnquiryID
Detail
Etc
-
Note that you're ordering by "goals", not MAX(goals).
That's why you're not getting the results expected.
Try:
SELECT manager.name, position, MAX(goals) as goals
FROM roster JOIN reference JOIN manager
WHERE manager.idn=reference.idn AND reference.idp=roster.idp
AND position like 'F'
GROUP B
When using the
mysqladmin -u root -p create test
command and entering the correct password I get :-
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.soc
If your town field always uses the format "town number", you can do:
SELECT *
FROM town
ORDER BY substring(town,locate(' ',town))+0 ASC;
On Sat, 2003-02-08 at 11:40, Nicolas JOURDEN wrote:
> Hi,
>
> How can I fix an order by using numbers and letters ?
>
> Id Town
> 56 Paris 1
> 60 Paris 10
Most of mine weren't getting through either and it seem to of gone mad on
delivery too .
Jerry
Apps-R&D
Cable and Wireless
- Original Message -
From: "Simon Windsor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, Febru
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
>>> 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
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.
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
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
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
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
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
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 :
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
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
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
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,
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
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 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
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
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
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
>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
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
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,
>
>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
>
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
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
-> (
->
: 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.
:
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
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
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
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
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
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
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,
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
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/
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
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
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
Dear mysql ,
ÁÕ¸¹Ò¤ÒÃáËè§Ë¹Öè§à¢éҺѪÕãËé¤Ø³·Ø¡àªéÒà»ç¹à§Ô¹ 86,400
ºÒ·äÁèÁÕ¡ÒáÂÍ´¤§àËÅ×Íä»ÇѹÃØ觢Öé¹
·Ø¡àÂ繨ÐźÂÍ´¤§àËÅ×Í·Ñé§ËÁ´·Õè¤Ø³äÁèä´éãªèÃÐËÇèÒ§Çѹ
àÇÅÒ
Åͧ¨Ô¹µ¹Ò¡ÒÃÇèÒÁÕ¸¹Ò¤ÒÃáËè§Ë¹Öè§à¢éҺѪÕãËé¤Ø³·Ø¡àªéÒà»ç¹à§Ô¹ 86,400
ºÒ·äÁèÁÕ¡ÒáÂÍ´¤§àËÅ×Íä»ÇѹÃØ觢Öé¹
·Ø¡àÂ繨ÐźÂÍ´¤§àËÅ×Í·
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]>
-
1 - 100 of 160 matches
Mail list logo
