Can somebody suggest some good English magazines on MySQL ?
Rgds
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Greetings...
I thin you need to look into the enum datatype. It stores data as integer
but when queried it will return data in text.
Rgds
Insane
SQLyog - The Definitive GUI for MySQL
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
Try SQLyog - A Windows based Front End for MySQL.
http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
To: "Massimo Bandinelli" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 9:27 PM
Subject: Re:
Greetings...
Are you using Windows to connect to the MySQL. Then you can try SQLyog at
http://www.webyog.com/sqyog/download.html It will help you a lot in these
works and you dont have to write queries also.
Rgds
Insane
- Original Message -
From: "Padma kuruganti" <[EMAIL PROTECTED]>
To:
Greetings
I like SQLyog. http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: "Chris Mason" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 4:07 PM
Subject: RE: How is DBTools Software?
> I've found mysql-front
If I distribute it free or commercial then ?
Karam
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Karam Chand" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 1:10 AM
Subject: Re: Am I Violating Any Rules ?
> In the last episode (Dec 11), K
Greetings
What do you mean server part of MySQL. SQLyog allows you to perform almost
all operation which MySQLAdmin does except starting and shutting down a
MySQL server, which probably SQLyog will have in one of its future releases.
Insane
- Original Message -
From: "Stan Sebastian" <[E
Greetings
I prefer SQLyog. You can download it at
http://www.webyog.com/sqlyog/download.html
Its free, compact and has lot of features.
Insane
- Original Message -
From: "Jeff Snoxell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 20, 2002 8:54 PM
Subject: Best Windo
What type of reports you want ?
Probably you will have to develop your customized app to get the reports you
want.
Insane
- Original Message -
From: "geeta varu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 24, 2002 12:25 PM
Subject: reports
> sir,
> i would like
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been
released. It is a superfast, compact and easy to use Front End for MySQL. A
must for MySQL developers. SQLyog is FREE!
Some of the new features added in SQLyog 3.02 are -
-- ODBC Import. The simplest and the most powerful tool to
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been
released. It is a superfast, compact and easy to use Front End for MySQL. A
must for MySQL developers. SQLyog is FREE!
Some of the new features added in SQLyog 3.02 are -
-- ODBC Import. The simplest and the most powerful tool to
The best way is to import data from MS SQL Server to MySQL. SQLyog at
http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard.
Try it out and all you data will be imported.
Insane
- Original Message -
From: "Hawk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday,
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:
Hello
Can somebody tell me what are the top sites ( except ofcourse mysql.com )
for general MySQL News, Tutorials etc.
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html
It has a very good ODBC import tool which will import your Access data to
MySQL without any fuss and its FREE!!!
Insane
- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wed
Hello
There is a bug in both MySQL-Front and NaviCat where updating a field
before retrieving all the record in the data result hangs up the thread as
they use mysql_use_result() feature. Try using some other Front Ends.
Insane
- Original Message -
From: "Daniel Negron/KBE" <[EMAIL PROT
Hello
When I use the Alter table structure command to alter any field, it comes
up with an error
stating that Error number 7 - error in renaming of table "table name.myi" to
"sql-208..." and so on with (Errorcode 13). Thus I am unable to change the
structure of any table.
I am using MySQL ver 3.
I think MySQL will be more faster in Desktop environment and if you are
adverse to using the text based interface to MySQL then you can try out some
GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but
since MySQL-Front has been discontinued you can try SQLyog at
http://www.w
In also belive that MySQL is very good in a single environ ment. You can try
out some very good GUI front end clients like MySQL-Front and SQLyog. Since
MySQL-Front has been discontinued, SQLyog is a very good option.
Insane
- Original Message -
From: "Gerben Gieling" <[EMAIL PROTECTED]>
Greetings...
I believe MySQL is stable and fast enuf for your puprpose. And its pretty
easy to start up.
Insane
- Original Message -
From: "Bence Szabo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 7:52 PM
Subject: what about the stability?
> Hi,
> Thi
Greetings...
It is possible. Say for eg. If you want to copy the structure and data of
the db table in mysql table. you can use the following statement -
create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db`
If you cant to copy only the structure then you can use a query
Greetings...
I believe that ASP works well with MySQL thru ODBC. As of learning other
technologies it really depends what all you require.
Still MySQL works best with PERL and PHP.
Rgs
Insane
SQLyog ( http://www.webyog.com/sqlyog )
The Definative Front End for MySQL
- Original Message ---
Greetings...
I want to create a user which will have only Select privileges in two
columns a particular table.
For that I creates a entry in the User table in MySQL and set it as default
with N in all.
Also I entered some rows in the Columns_Priv table. Now my question is -
Do I have to enter
, III" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 30, 2002 7:00 AM
Subject: Re: Setting Permission For Column Level Only
>
> On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote:
>
> > Greetings...
> >
> > I want to cre
Greetings..
Even the MySQLGui does not work for me. It is not getting downloaded. What
should I do ?
Insane
SQLyog ( http://www.webyog.com/sqlyog )
The Definative GUI for MySQL
- Original Message -
From: "Pavel Hloušek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September
Greetings..
I am doing show keys from db.tablename but how can I know whether the key if
fulltext or not. I get to know the key is unique or not by checking
Not_Unique column in the returned resultset.
How to find a key is fulltext.
Thx
Insane
sql,query,mysql
---
://www.webyog.com )
The Definative GUI for MySQL
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Insanely Great" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 7:16 PM
Subject: Re: How to find whether a key is fulltex
Greetings...
I am developing an application on MySQL using the MySQL API's.
I have .sql file with 1 insert statement. I want to run all the queries
in one shot. mysql_real_query() allows me to execute only one query at a
time ?
So what do you think is the best approach to execute all the qu
Greetings...
I dont think that there is any SQL statement to do that.
As of changing the name, You can just go to the data directory of MySQL and
change the name of the directory of the database. MySQL stores each database
as a directoyr so changing the name of the directory will change the name
When you specify a column with primary an index of name Primary is made on
the column.
For making a column unique, you have to first make a index on it which is of
type UNIQUE. So automaticallt a index is made on it.
Rgds
Insane
- Original Message -
From: "Inbal Ovadia" <[EMAIL PROTECT
Greetings..
The MySQL Documents will be a nice place.
Maybe this will help if you want to copy all the data as well as columns
from the -
create table target_db.target_table select
Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table
(this will create the table with the exist
Greetings...
I belive MySQL is powerful enuf for the mentioned type of data. I have a
database in win2k with 100 tables and the size of the database is 8 GB. It
performs fantastic, faster the MS SQL Server which I had before.
I have MyISAM tables.
Rgds
Insane
SQLyog - The Definative Win32 GUI F
Greetings...
MySQL can handle datas hundreds times greater then that very efficiently so
dont you worry about handling 500 MB.
My database has 8GB of data and it performs best.
So dont worry.
Rgds
Insane
- Original Message -
From: "Alberto Ruiz Cristina" <[EMAIL PROTECTED]>
To: "mysql
Greetings...
Host tables are used to give privileges of a very esoteric type to user who
are connecting from differnt host with differnt permissions.
I think the MySQL documents, privilege section has a detailed working of
host table. It is the best I have seen till now.
Rgds
Insane
- Orig
Greetings..
Is iut necessary that you usee STL. Other wise MySQL C API are much more
easy to maintain and program. Even SQLyog which I am a beta tester is
written using MySQL C API and its very fast.
Rgds
Insane
- Original Message -
From: "wang tianyi" <[EMAIL PROTECTED]>
To: <[EMAIL PR
If you use mysqldump, escape the fields with proper escaping characters. You
will get a proper dump.
Rgds
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog
- Original Message -
From: "Jean-Francois nadeau" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
I have a table tbl_version_history which has a primary key and an index.
Through this query I am able to create a copy tbl_version_history_copy with
all the index.
Just replace the stuff with yours and probably it will help.
create table `tbl_version_history_copy` ( primary key ( FLD_REG_NUM )
I belive it will work in Windows
Insane
- Original Message -
From: "Terry & Cheryl Haimann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 4:24 PM
Subject: Security
> I was reading a book at B&N yesterday which left me with the impression
that in MySQL you c
If its a binary data then you have to properly escaped it with \ otherwise
it wont get inserted
Rest is same like any other insert statement.
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog
- Original Message -
From: "Mario Nicoletti" <[EMAIL PROTECTED]>
To: <[EM
I had similar problem in my case.
The solution was that maybe you are accessing the column which has data
which is greater then the specified in Max_data_allowed in my.cnf.
Change it to something more and I hope that the problem is solved ?
Insane
SQLyog - The Definative GUI For MySQL
http://www
If your users are on Windows, try out SQLyog for which I am a beta tester.
Its very simple to use and fast.
Download it at http://www.webyog.com/sqlyog
Insane
- Original Message -
From: "Rafael E. Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 3:54
Greetings...
In windows, in general the settings are done by default so that you can
start it with the default case.
To start the server go to the bin directory and just enter mysqld. I dont
think you need to enter --standalone or something like that. By default a
root user is created with 'root'
Greetings...
In the "show tables"if there is no database selected in the Server...it
will give an error that no database is selected.
In the second query...it will always return a resultsetmaybe an empty
resultset if there are no fields in the table.
hope it helps.
Insane
SQLyog - The D
Check out the tables_priv and db table in the mysql database. It has all the
permissions of the MySQL.
Insane
SQLyog - The Definitive Win32 GUI for MySQl
http://www.webyog.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 10:43 AM
S
Greetings...
I have a table in database ch whose create statement is as follows -
CREATE TABLE `chn1` (
`id` int(10) NOT NULL auto_increment,
`chn` varchar(10) NOT NULL default 'Pagal',
`name ` varchar(50) default '',
`chn3` text,
PRIMARY KEY (`id`)
TYPE=ISAM ;
Now when I giving a insert stateme
Greetings...
I used BACKUP command to backup all the tables in a database which has only
MyISAM tables ( since backup only works with MyISAM table ). Everything was
OK.
Then after some time I did the RESTORE COMMAND, but before that I deleted
all the tables in the database...in two tables,,,i got
Greetings...
Yes.
If you want to traverse two result set in the same time then use the
mysql_store_result(). If you don't have a big resultset coming then probably
mysql_store_result() in the same connection is a better option.
Otherwise you have to use two connections.
Rgds
Insane
SQLyog - The
I think you can set a max quota for a table.
Insane
- Original Message -
From: "Henry Umansky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 21, 2002 8:08 PM
Subject: mysql quota
> I want to let users on my system use MySQL, but I want them to have some
> sort of quot
Use enum.
Rgds
Insane
SQLyog - The Definitive Win32 GUI for MySQL
http://www.sqlyog.com
- Original Message -
From: "Tony Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 4:56 PM
Subject: True/False
> I am new to MySQL and I am attempting a new proje
Greetings
Can somebody point to any resource where I can get the equivalent datatype
of MySQL for SQL Server, Oracle and Access
Rgds
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Greetings
I am writing a C app wherein I have to connect to MySQL server whcih is on
SSH connection.
How can I connect to the server using mysql_real_connect ()
Any ideas ? Its urgent
Rgds
insane
-
Before posting, please chec
Greetings
I have a MySQL server with my ISP. Previously I was able to connect to the
server using any client. But now when I connect it says lost connection
during query ?
What is the reason ?
Rgds
Insane
-
Before posting, ple
No.
Just escape the fields properly.
Rgds
Insane
SQLyog
The Definitive GUI for MySQL ( http://www.sqlyog.com )
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Sunday, November 17, 2002 12:17 AM
Subject: MySQLDump & BLOB Co
Greetings
You dont have to do mysql = new mysql;
it is dont automatically.
Rgds
Insane
SQLyog - The Definitive Win32 MySQL Front End
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: "Anna Fowles-Winkler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday,
Greetings
MySQL-Front has problems with User Manager module. It does not creates
permission correctly.
Try SQLyog at http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Nove
Greetings
I think the path for the file is not correct. Try giving the complete path
with (\) in the directory name changed to (/). Also specify the escaping
characters properly.
For more information you can check out the MySQL docs on LOAD LOCAL INFILE.
Rgds
Insane
SQLyog - The Definitive Windo
56 matches
Mail list logo
