Hi,
Is there a way of converting mySQL database to a readable text file?
What I mean is not importing the data via myODBC from another client, but by
issuing a command to the
Unix prompt (mySQL server itself) then it will generate a readable text
file.
Thanks in advance.
Alex
Look up skip grants in the manual and in future I recommend the GRANT
command.
- Original Message -
From: "harvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 03, 2001 13:56
Subject: forget password in user table and no other user has access
privilege to mysql database
Try this :
myodbc silent installation merge module
http://www.avukatpro.com/mysql.html
- Original Message -
From: Tiago Luchini <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 3:58 PM
Subject: Unattended MyODBC installation
I need to provide MyODBC with one of
hi,
i updated the password field using update statement in the command line for the root
user. other users in the table don't have any privilege to access the mysql database.
when i tried to connect the database i can't able to connect with the new password.
the passord i gave was "kannan1".
w
Hi Werner,
--
On Mon, 2 Jul 2001 15:59:19Werner Stuerenburg wrote:
>Hi noelt,
>
>
>> i mean, the value of the duration field will be transferred or
>> copied to the consumed field w/c is in a diff. table.
>
>So these are just some fields like column1 and column2 - nothing
>to do with
Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or
rather Darwin)?
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
On Tue, 3 Jul 2001 01:53, [EMAIL PROTECTED] wrote:
> I have a database of dealer bulletins. I have a web page that shows the
> results of sorting
> the info in the database in certain ways. I also want to add a field to
> the page to allow the
> user to input a search word(s) and have the results
On Tue, 3 Jul 2001 12:57, help wrote:
> I fixed the other errors, however I am still getting
> other errors. This database is tied into PHP. I want
> to be able to have an admin screen so I can make
> changes but it is not working for me. The errors I am
> getting on the Index page are :
>
> War
Also: If you are looking to build a MySQL, PHP website go to
http://phpnuke.org/ and download the 5.0RC1. Follow the Install.txt file and
you have an entire site to Play with in 1/2 an hour and there is excellent
help at http://www.nukeforums.com/forums/index.php?viewcat=5 in Spanish
English Germa
1) I left my ESP in my other pants, so I can't really debug your code.
2) Somebody will probably tell you that this isn't the appropriate group
for questions like this. You might try news://news.php.net or a site like
http://www.phpdeveloper.org or http://www.phpbuilder.com for tutorials.
R
I fixed the other errors, however I am still getting
other errors. This database is tied into PHP. I want
to be able to have an admin screen so I can make
changes but it is not working for me. The errors I am
getting on the Index page are :
Warning: Supplied argument is not a valid MySQL resul
>Hi Everyone,
>
>Does this make sense:
>select * from table_name where column_1 LIKE "%word1% OR %word2%";
That should be:
column_1 LIKE "%word1%" OR column_1 LIKE "%word2%"
>
>yeilds 1 record but...
>
>select * from table_name where column_1 LIKE "%word2% OR %word1%";
>
>yields 0 records.
>
>
Hi,
This is a start of a mini HowTo for getting Linux WebCatalog,
unixODBC, MyODBC to work with MySQL
It's a work in progress. The ODBC part worked only on 2 of 4 servers.
Q1: Do I have a config problem with unixODBC or MyODBC ?
Q2: Is there a way for force the ODBC Libraries to reload
On Tue, 3 Jul 2001 09:44, Eric Fegraus wrote:
> Hi Everyone,
>
> Does this make sense:
> select * from table_name where column_1 LIKE "%word1% OR %word2%";
>
> yeilds 1 record but...
>
> select * from table_name where column_1 LIKE "%word2% OR %word1%";
>
> yields 0 records.
>
> I'm scanning a VA
I need to create a new login for a already created
database. I have tryed to from the command prompt of
my windows 2000 adv server box.
c:\mysql\bin>Create User mark
But know luck at all what am I doing wrong??
PLease help.
Thanks
__
Do You
MySQL Error:
ERROR 1028: Sort aborted
Anybody know what this means? Ok, I can figure out what it MEANS, I'm
getting it on a rather complicated select statement with an order by clause.
Does it mean something specific like 'you need a better index' or is it just
exactly what it means?
Cal
http:
OK. Radius contains the radius, in miles, from the center of the Zipcode area.
In the following query, the latitudes and longitudes have been calculated to
yield a 20 X 20 mile square centered on the base Zipcode (in this case, 68504).
+---+-+--+---+
| zip | city
Hi Everyone,
Does this make sense:
select * from table_name where column_1 LIKE "%word1% OR %word2%";
yeilds 1 record but...
select * from table_name where column_1 LIKE "%word2% OR %word1%";
yields 0 records.
I'm scanning a VARCHAR column trying to return records that contain or
word1 and
Hi
I'm new to MySQL.
Please can anyone give me the connection sentences in Java.
Exactly:
How to charge the driver:
Class.forName("
I use windows98. And want to make experimental local connections.
Regards,
Daniel Aderhold
:-) Ya, I was thinking I would try to stay away from formatting in HTML,
and let the tool do it, quite like Crystal would (at least, I think it
does...have only read books on it in Barnes & Noble). But I could resort to
using JSP's to build the reports.
H, I will check Freshmeat too, though
Print to HTML. Pull up in browser. Print.
But seriously, have you tried looking on freshmeat?
j- k-
On Monday 02 July 2001 14:32, Mazur wrote:
> OK, what are all you guys using for a reporting tool, with MySQL as a
> backend (where you don't need Windows)?
>
> I need a reporting tool to
OK, what are all you guys using for a reporting tool, with MySQL as a
backend (where you don't need Windows)?
I need a reporting tool to generate management reports/letters out of MySQL,
which I will be using for a web-based application.
I guess I am looking for something like Crystal Reports, b
Gerald,
Check out the tutorial at the following link:
http://www.thickbook.com/extra/php_loopoption.phtml
Julie is very clear in her explanation of how to do exactly what you want to
accomplish.
Josh
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
"When" is a reserved word in ANSI SQL. See the link below for the full
list.
http://www.mysql.com/doc/R/e/Reserved_words.html
Chris Bare <[EMAIL PROTECTED]> wrote:
ERROR 1064: You have an error in your SQL syntax near
'when datetime,
who varchar(1
Title: Blank
This is what I have done
[root@MySQL Msql-Mysql-modules-1.2216]# perl Makefile.PL Which drivers
do you want to install?
1) MySQL only 2) mSQL
only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL
(either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQ
I'm trying to upgrade from 3.22 to 3.23.39 and have discovered that I can't
create a table which has a column named "when". This has worked in the past,
including on 3.23.36. Here is the output I got:
mysql> CREATE TABLE wasp_project_hist (
-> id int(11)
Actually, a new book by Paul is to be published "MySql and Perl for WWW".
Gonna be a great one. (to be published on August 13th)
--
sherzod_ruzmetov (sherzodR)
email: <[EMAIL PROTECTED]>
It really doesn't bother me if people want to use grep or map in a void
context. It didn't bother me
Paul DuBois' Book.
it is extremely well written and indexed. I've gone from a complete mysql bumbler to
somebody that can actually make it work in a short time thanks to his book.
Chris
On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen wrote:
>Does anyone have any recommendations for a
I can't seem to find any documentation on how to set this up an a
windowz box.
Can anyone help?
Pete
Gerald Clark wrote:
>
> Run your transaction log against the restored database.
>
> Pete Kuczynski wrote:
>
> > Hoping someone can point me in the right direction.
> >
> > I have Nusphere Mys
If I understand you correctly, here is my approach in php:
You look at the selected value first and store it in idSelected;
then you insert a condition and evaluate that condition in your
printf statement:
>while ($row = mysql_fetch_object ($list)) {
$selected = $row->id == $idSel
Hi John,
Try prefixing the command line with YACC='bison -y '
Here is my build script:
bash-2.05$ cat build.sh
cd mysql-4.0
YACC='bison -y ' ./BUILD/compile-pentium-debug-max
bash-2.05$
Good luck.
Ken
- Original Message -
From: "John Barton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Print the current value as the first entry of the pulldown.
It will be in the pulldown twice, but so what?
Nelson Goforth wrote:
> I have a Contact information page that draws from or writes to a table
> [contact] and displays that information in an HTML form. There is a
> field [type] that I
Run your transaction log against the restored database.
Pete Kuczynski wrote:
> Hoping someone can point me in the right direction.
>
> I have Nusphere Mysql database in production [using mysql/PHP/apache, no
> perl]. The database has 1 table, 20 columns, with 3500 entries and
> growing.
> I am
do this:
mysql -uusrename -ppassword dbname < brand.txt
mysql -uusrename -ppassword dbname < brand.sql
Tyler
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 1:59 PM
Subject: How do I restore a database backed up
Hi!
Mysqldump creates the files brand.txt & brand.sql etc.
How do i restore the database in a simple way..?
I've looked in the manual but couldn't find out...
Sincerely Victor
-
Before posting, please check:
http://www.my
I have a Contact information page that draws from or writes to a
table [contact] and displays that information in an HTML form. There
is a field [type] that I want to have populated from a pulldown list,
and that pulldown list is drawn from another table [contact_type].
I'm using PHP 3.x for
Thanks for your help, it's not that mysql does not accept my password as
root, the problem is that I'm not allowed to access mysql as root (in fact
as any user) anymore, 'cause I deleted by mistake the entry corresponding to
root in the tables in the mysql database.Can I alter the tables without
c
> > Can I just hand delete the records that I manually inserted?
> If you are brave and sure in yourslef.
I'm not really that brave, it's just that I didn't have
a choice - it appears to have worked fine - I am now
able to connect using the GUI tool.
> > What is the syntax of the grant?
Yes, but it is usually among separate applications that I use different
names. In a web app, though, I would use different users for admin stuff
versus regular stuff. You want to make use of persistent connections where
possible of course, and changing usernames a lot can get in the way of this.
>Description:
Mysql 4.0 bitkeeper fails to compile
>How-To-Repeat:
Try to compile
>Fix:
Fails with a syntax error
>Submitter-Id:
>Originator:John
>Organization:
>MySQL support: none
>Synopsis: Mysql 4.0 bitkeeper fails to compile
>Severity: non-critical
>
descriptive usernames??
Does that mean that you create a bunch of users and use their usernames to
connect to the database in differente points of your application and track
then by the names you provided for usernames???
Sio
>From: "D'Arcy Rittich" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTE
Paul Linehan writes:
>
>
> OK - fair enough - two questions though.
>
>
> Can I just hand delete the records that I manually inserted?
>
If you are brave and sure in yourslef.
>
> What is the syntax of the grant?
>
This is properly described in our fine manual.
>
> I log on as the roo
I do this by using a whole bunch of descriptive usernames. It is more work
than your idea, but you could use this method for now. I like your idea
though.
D'Arcy Rittich
- Original Message -
From: "BAUMEISTER Alexandre" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02,
Hello,
Has there been any thought about using mysql for SAP R/3 systems?
The reason I ask the question is because we work in SAP and we use mysql
as the db for our office applications. So we know them both quite well and it
would be nice if we could use the combined knowledge for our clients.
I
Hello!
I've been using MySQL version 3.22.32 and query with AND NOT phrase worked
fine. Now I have MySQL version 3.23.36 and the same query is losing records.
(the same data).
The query is quite complicated:
SELECT * FROM docs LEFT OUTER JOIN typy ON docs.nr = typy.nr LEFT
OUTER JOIN kategori
Hoping someone can point me in the right direction.
I have Nusphere Mysql database in production [using mysql/PHP/apache, no
perl]. The database has 1 table, 20 columns, with 3500 entries and
growing.
I am backing up the database to tape 2 times a day. At noon and at 5pm,
both are full backups.
At 09:50 AM 07/02/2001 , you wrote:
>Yes! Piece of cake. Simple script. Works most times.
What script would that be--please??
I want to convert an MDB database to use with MySQL on my nix box. What
about the associated ini and dat files?
>Atenciosamente,
>
>Tiago Luchini
>Diretor Técnico-Come
Yes! Piece of cake. Simple script. Works most times.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Joe Taraba <[EMAIL PROTECTED]>
To: Tiago Luchini <[EMAIL
I have a database of dealer bulletins. I have a web page that shows the
results of sorting
the info in the database in certain ways. I also want to add a field to the
page to allow the
user to input a search word(s) and have the results displayed. I can't find
the answer to this
in the docs on the
Is there any other way of using a stopword list so I can speed up and
improve the quality of my queries in a full text search without recompiling
mySQL
thanks
Chris
Dr Christopher Thorpe
Information Architect
GenomeBiology - biology for the post-genomic era
w http://www.genomebiology.com
Just curious, can you convert access database to MySQL and visa versa.
Meaning from win98 access 2000 to Linux Mysql 3.22.32?
At 04:56 AM 07/02/2001 , you wrote:
>Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com.
>
>Atenciosamente,
>
>Tiago Luchini
>Diretor Técnico-Comercial
>Galluch
Hi!
Have you specified the InnoDB startup options in
your my.cnf, in the [mysqld] section of my.cnf?
You can look at the manual at http://ww.innodb.com
where you see what kind of values you should specify.
When InnoDB starts the first time it will say:
InnoDB: The first specified data file /hom
MySQL Support:
I need some help about import data of Microsoft SQL
Server to MySql Server 3.23.39. Please, send me more information about it, thank
you for all
Bonjour,
When you have a big web site with a lot of pages, programs,
cronjobs, applications ... connecting to Mysql, it's sometimes
difficult to find from where a given query/connection comes from.
And it's sometimes urgent to find the origin of a disturbing query.
So
Hi
when i am updating the rows with prepared statement/statement( the
values may/may not be same), the count returning is different in
different cases. Why it so like this..
In my program some times the values may/may not be changed.
Irrespective of the values, the database should be update
please,
is there a way to get the size of a mysql table through
an SQL query ?
thank you
karel pitra
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I would like to know if there is a module/extension/engine which supports the storage
of spatial data in MySQL. If not, how could I store spatial data in MySQL?
Thanks a lot
-
Before posting, please check:
http://www.mysql.c
> > Is it wrong to hand edit these tables? root with the
> > password "new_password" is a valid logon for this db.
> Don't touch MySQL privilege tables, except host table.
> That way you just mess up the things, as you did.
> Use GRANT / REVOKE / SET PASSWORD ..
OK - fair enough - two q
This is in the manual - how to find out and some examples:
perror 126 127 132 134 135 136 141 144 145
126 = Index file is crashed / Wrong file format
127 = Record-file is crashed
132 = Old database file
134 = Record was already deleted (or record file crashed)
135 = No more room in record file
13
Hi Ken,
Make sure you cvsup the latest ports before building if you use
ports. THe innodb is not included (I believe) because it does yet
support all features of MySQL. You can use the ports just edit the
make file and find the line:
CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
and
Hello,
Anybody has any experiences as how to best backup the databases? It should
be a part of an automated process, and should happen in such a way as to
secure that database integrity is preserved, even upon restoring. So I
cannot just backup the files of the databases, because they might be wr
Good Morning Robert,
I use Visio, first setup an ODBC connection to the database
(MyODBC) then run the database Wizard and if fetches all the keys and
coulmns and builds a big drawing.
Good Luck,
Ken
- Original Message -
From: "Robert Goeres" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
The following Statement ("GRANT ALL ") will create
a user who will have access on mydatabase.MYTABLE only...
But My question was ... .. okay, let me describe again..
In MySQL manual I was reading the sytax of CREATE TABLE
and I found the password option there... .. My Question is 'How
Hi noelt,
> i mean, the value of the duration field will be transferred or
> copied to the consumed field w/c is in a diff. table.
So these are just some fields like column1 and column2 - nothing
to do with duration of the process itself.
The following is in php and uses class db_mysql - there
Has anyone done a bake-off among the different table types available for
mysql? Which, of the non-beta types is the fastest at Insert, update,
delete, etc?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
--
> > We want to use the Windows GUI tool to connect to a database on
> > a Linux box.
> You have to grant privileges to user@ip_address and enter ip_address
> in host table. Or grant privilege to user@"%".
I entered these records by hand from the
> ./mysql -u root -p mysql command line to
chown -R mysql /home/ecom
tpchan wrote:
> Hi all,
>
> I try the solution from David but seem it didn't work.
>
> Here is my steps:
>
> 1) Stop the mysql services.
> 2) Move the ecom database directory from '/var/lib/mysql/ecom' to
> '/home/ecom'
> 3) Make symbolic link in '/var/lib/mysql'
Hi Everybody,
We are using Mysql in Sun5.8 environment. Presently it has installed in
/usr/local/mysql. I want to change this location to /export/home/mysql. What should i
take necessary steps.
Is it work properly if move my Mysql dir to /usr/local/mysql to /export/home/mysql and
chage th
I doubt this is a MySQL problem. You are probly not indexing properly,
and you are always missing one or two entries, but only notice it with
the DESC option.
Pat Malone wrote:
> I have a problem with a bulletin board type system. When a new
> message is posted the script redirects back to t
Hi,
I need a transaction Database with Mysql.
I have compiled the sourccode 3.23.39 the following on Linux.
./configure --with-innodb
after that I have stopped and restartet mysql.
but if I make "create table .. type=InnoDB";
I create a ISAM-Table. How can I make a InnoDB-Table.
Please help.
If you shoot something with a shotgun enough times, you will kill it.
You have done so many vague things that I am not sure what your problem
is right now.
The directories and files in which the databases are stores must be
owned by mysql.
The owner of the symbolic link is not as important.
Check the source. There is an error.h file.
Lee, John wrote:
> Hi all,
>
> I am a newbie in MySQL and would like to know if there is a list of error
> codes for accessing MySQL database.
> What I am asking is something like "What is the return error code for record
> (or row) not found?" or "Wh
I need to provide MyODBC with one of my systems' installation. It would need to be as
smooth and simple as possible (completely unattended is preferred).
Does anyone know how to do this or where I could find some information?
Thanks a lot.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comerci
Once you moved the files, did you check the ownership and permissions?
I have had the same error after restoring databases from a backup, only
to find the files were owned by root and the permissions were munched.
Something that I have been known to do is to add another, larger disk
drive, or
try this :
Mysql & VB6
http://www.avukatpro.com/mysql.html
- Original Message -
From: Tiago Luchini <[EMAIL PROTECTED]>
To: Gopal Saha <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 2:56 PM
Subject: Re: How to connect Mysql with vb6 applications?
> Easy solution:
Hello,
Anybody has any experiences as how to best backup the databases? It should
be a part of an automated process, and should happen in such a way as to
secure that database integrity is preserved, even upon restoring. So I
cannot just backup the files of the databases, because they might be wr
Paul Linehan writes:
>
>
> Hi all,
>
>
>
> We want to use the Windows GUI tool to connect to a database on
> a Linux box.
>
>
> However, after trying to configure it and attempting to connect,
> we get a message along the lines of "Host 'ip_address' not allowed to
> connect
> to this MySQL
Dean Ware writes:
> Excellent!
>
> By changing the order of the tables being joined I reduced the execution
> time from 2800ms to 20ms!
>
> Very useful command.
>
> Thanks very much!
>
Keep in mind you can help MySQL a lot by setting STRAIGHT_JOIN, to
make it sure that MySQL honors the table
X Gogo writes:
> Hi,
>
> I've been using 3.23.37 source tarball compiled for Linux 2.2.19. Now I
> upgraded to 3.23.39 but still the same result... Anyway, it's not that
> important - I was just wondering why SELECT DISTINCT ... LIMIT is slower than
> the
> one without LIMIT. It's not crucial
Hi all,
We want to use the Windows GUI tool to connect to a database on
a Linux box.
However, after trying to configure it and attempting to connect,
we get a message along the lines of "Host 'ip_address' not allowed to
connect
to this MySQL server".
I'm sure that this is some silly confi
I have a simple table I created that was made from parts of other tables
that just has 2 fileds. The first field is an ID number and the second is a
score. Now each ID can have from 1 to 15 scores and what I need to do is for
each ID, get the average of the top 6 scores.
Is there a way to do this
Hi!
In .38 mysqld.exe was accidentally copied with __NT__
defined. Use mysqld-max.exe or download a new
3.23.39 from www.mysql.com.
Regards,
Heikki
http://www.innodb.com
Copied message:
hello,
I have installed mysql 3.23.38 binaries on win 98
first mysqld --version sa
Hi!
The standard MySQL -Max binary for FreeBSD (Intel) is at
www.mysql.com, look at the MySQL -Max downloads.
Max contains InnoDB, non-Max does not contain.
The downloads at www.mysql.com should always be the
best versions available.
Regards,
Heikki
http://www.innodb.com
Copied message:
.
John Griffin-Wiesner writes:
> I am trying to connect to my database with mysqlgui
> as root. I have gone into "options" and entered the
> port number and the path to the socket. I have "ask for
> password" checked on and am using the same password that
> works when I do "mysql -u root -p". I h
Easy solution: download MyODBC from mysql.com
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Gopal Saha <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PRO
Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Lok Woei Ming <[EMAIL PROTECTED]>
To: [EMAIL PROT
You can control the case-sensitivity of MySQL in my.ini (or my.cnf).
If "lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you s
Excellent!
By changing the order of the tables being joined I reduced the execution
time from 2800ms to 20ms!
Very useful command.
Thanks very much!
At 14:20 29/06/2001 -0300, you wrote:
>Are the fields been JOINed indexed? If not, they should.
>
>Have you tried an EXPLAIN command? Try it li
Hi,
are you sure, that mysql make the same sorting order??
I seems in the second query first all with 1, you cann't be sure whether
the to in not listet later on.
Try it again with "order by id" every three statements and compare then the
listings.
Gerlinde
At 12:50 02.07.01 +0200, you wrote:
>Description:
MySQL lies about what ist grater than 0.
>How-To-Repeat:
Imagine having a table...
CREATE TABLE `Customer` (
`ID` int(10) unsigned NOT NULL default '0',
`Seller` tinyint(3) default NULL,
PRIMARY KEY (`ID`));
Seller is either 0, 1 or 2. Look at the following selects:
mysql>
Hi,
I've been using 3.23.37 source tarball compiled for Linux 2.2.19. Now I
upgraded to 3.23.39 but still the same result... Anyway, it's not that
important - I was just wondering why SELECT DISTINCT ... LIMIT is slower than
the
one without LIMIT. It's not crucial for my application and
does n
I am using MySQL version 3.23.38-nt and I am writing a very simple SQL
statement to create a new schema as follows:
CREATE SCHEMA schema_name
but I got an error.
I need to use more than one schema, is not sceham supported in this release?
And if it is supported please tell me how to use it, thanx
Hello Michael,
Thursday, June 28, 2001, 11:41:57 PM, you wrote:
I'm getting this again and again with two tables which are used in
quite the same fation - some selects, often updates, rare inserts, no
deletes:
mysql> repair table counter.quickstat;
+---++--+-
Hi all,
I'm using visual basic with ODBC to update my mysql databases, and
all worked fine until now.
Now I have a new database in a different host, and when I try to
connect I receive this error message:
Can't intialize character set 7 (path: c:\mysql\\share\charsets\) (2019)
this error hap
hello,
I have installed mysql 3.23.38 binaries on win 98
first mysqld --version says "mysqld-max debug" and not mysqld without
additionnal database systems.
mysqld-max corresponds to mysqld-max ok
I have innodb_* set in my.ini file innodb_dazta_file_path=ibevolif:1M
when trying to start the
Hi,
I am a Vb programmer wants to connect with Mysql database please suggest me.
I have download Mysql for windows95 .
My mail address is [EMAIL PROTECTED]
Thanks,
Sougata
MAX() Query
Hello,
I'm trying to write 2 queries, the first to find the most recent club a
player has played for, and then the previous club they played for.
To find the most recent club i use this :
substring(max(concat(STARTDATE,TEAM)),11,100) as TEAM
which concats a players start date to th
Daniel,
This would be a 'contre-coeur' to any database...
If you want some output like this, make it so in your query:
SELECT *, (column_1 * column_2) AS column_3 FROM table;
If you actually want to store the result of the calculation, do it in your
insert query; However, a 'dynamic value' data
On Mon, 2 Jul 2001, craig riley wrote:
> Hi All,
> I have recently installed MySQL on my windows 2000 machine and
> everything is great except for the fact that it doesnt't seem to recognize
> upper case table / column names? This wouldn't be a problem if I was just
> developing locally
Hi All,
I have recently installed MySQL on my windows 2000 machine and
everything is great except for the fact that it doesnt't seem to recognize
upper case table / column names? This wouldn't be a problem if I was just
developing locally because I could just name everything lowercase. Th
1 - 100 of 101 matches
Mail list logo
