is this declared in php or javascript??
depends on the syntax.
- Original Message -
From: "Caroline Jen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 9:38 AM
Subject: Select Records From the Database
> I got "null" after selecting records from a table
now() gives current date and time. use current_date() instead.
hope it helps
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 9:32 PM
Subject: Date data type issue
> Having a problem with a Date data type.
In my opinion MySql front is best and the best thing is further development
of already enriched software started again.
Nitin
- Original Message -
From: "Colleen Dick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Decem
no problems that i see.
- Original Message -
From: "p shah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 12:23 PM
Subject: Mysql Date column type
> Hi,
>
> I have one question regarding date column type in
> MYSQL.
>
> Can I use the column type for
r u getting this problem while coonecting through MySql Front or directly to
the server?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 3:23 PM
Subject: Client does not support authentication protocol requested by server
>
>
>
Look at http://www.mysql.com/downloads/mysql-4.0.html for Dynamic client libraries for
your platform.
Enjoy
Nitin
- Original Message -
From: "Franz Edler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 6:25 PM
Subject: Where to fi
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at
http://www.mysql.com/doc/en/GRANT.html
Enjoy
Nitin
--
dear buddy,
when u specify permissions on a particular database, you need to give that
database name to connect to db.
user created fine, while connecting, try this:
mysql -u abc -p abc
where last abc is ur database name.
Nitin
- Original Message -
From: "ads mysql&quo
did u do a
flush privilege
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
> O K. I have tried
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "ads mysql" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:01 PM
Subject: Re: How to create mysql user?
> did u do a
> flush privilege
>
>
>
you can optionally use MySQL Front to view and edit data in GUI mode
get it free of cost athttp://www.mysqlfront.de/
Enjoy
Nitin
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Caroline Jen" <[EMAIL PROTECTED]>
Cc: <[EMAIL P
Hi all,
There's a problem. When I try to inert into table with
insert into schedule (owner, desc, sch_for, status) values ('a', 'b', 'c', 'd')
I get error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL
server version for the right syntax to use near 'd
Solved.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>
Sent: Saturday, June 26, 2004 4:33 PM
Subject: Re: insert into text field
> look *carefully* at the insert syntax, paying attention to spaces and
> the like:
>
>
e filename from table2
union
select field-list into outfile filename from table3
It says check your version manualblah blah
Any idea, how to do it?
Thanx in advance
Nitin
union works fine but with union 'into outfile' doesn't work
anyway mysql ver is 4.0.14
thanx for ur time anyway
Nitin
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 4:
can u suggest any workaround?
anyway thanx for help
Nitin
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 8:32 PM
Subject: Re: how to export data from multiple tables
> "Ni
any idea, how to export data to a file on the remote machine?
thanx for the help anyway
Nitin
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 9:49 PM
Subject: RE: how to
these are linux machines on internet, one is web server and another db
server, with real IPs. but I may optionally want to export data to my PC,
also on internet connected through LAN to my web server and db server.
thanx for ur time
Nitin
- Original Message -
From: "Christensen,
MySQL doesn't support views as of now. It's a feature MySQL is missing for
long time. For more information have a look at
http://www.mysql.com/doc/en/ANSI_diff_Views.html
Nitin
- Original Message -
From: "Timotius" <[EMAIL PROTECTED]>
To: "MYSQL"
ly execute the
query, not the time taken to fetch the data from the database.
Enjoy
Nitin
- Original Message -
From: "Reto Baumann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 12, 2003 6:25 PM
Subject: How does LIMIT affect Query Caching
Does s
if you are using mysql on web (which is the most possible case, as MySQL is
created to be used on web), you can use your scripts to create tamporary
tables and use them as views. else you can write procedures for that
purpose, depending on your need.
Nitin
- Original Message -
From
Sorry for wrong answer, actually, that's the behavior of oracle query cache,
so I guessed it would be same for MySQL too. I sincerely apologize for any
inconvenience caused.
Nitin
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Nitin"
ginal Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 2:29 PM
Subject: Re: Views in MYSQL
> In article <[EMAIL PROTECTED]>,
> "Nitin" <[EMAIL PROTECTED]> writes:
>
> > if you are
then who said, you cant delete temporary tables
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 3:22 PM
Subject: Re: Views in MYSQL
if you can export the same from sybase, then undoubtedly you can import
those iinto mysql
Nitin
- Original Message -
From: "Prasad Budim Ram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 1:57 PM
Subject: Migration tools for sybase to
create table as select
Enjoy
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 2:49 PM
Subject: creating a new table from a SELECT
> how can i create a new table from a SELECT...WHERE.
union isnt available with 3.23 either
Nitin
- Original Message -
From: "Rory McKinley" <[EMAIL PROTECTED]>
To: "Jeff McKeon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 8:01 PM
Subject: Re: Data from two tables in one qu
mysql doesn't support anything called rollback upto 4.0
Nitin
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "debug" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 8:37 PM
Subject: Re: assorted
it could better be like
SELECT * FROM list WHERE name in ('$this1', '$this2', '$that1')
Nitin
- Original Message -
From: "Colleen Dick" <[EMAIL PROTECTED]>
To: "Mike At Spy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Randy Chrismon&qu
Dear Mr. Singh,
You need to install Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
all encryption functions are one way only
Nitin
- Original Message -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase
version, which doesn't support union and for other functions you want to
perform on some rows selected from multiple tables.
Enjoy
Nitin
- Original Message -
From: "Susan Ator" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 7:39
yntax like:
INSERT INTO host
VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
Enjoy
Nitin
- Original Message ---
i dont think there's any privilege called "ALL PRIVILEGES". You need to say
just "ALL", like:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT OPTION;
GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678'
you can either erase the previous installation and then install the newer
one or simply upgrade the previous one.
- Original Message -
From: "Manjit Patel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 8:02 PM
Subject: Changing rpm installation to binary versi
of course, the syntax is:
insert into db3.table2 (column list) select from db1.table1
for more information have a look at
http://www.mysql.com/doc/en/INSERT_SELECT.html
Enjoy
Nitin
- Original Message -
From: "ΝΙΚΟΣ ΓΑΤΣΗΣ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
u mean, in MySQLFront or other program
- Original Message -
From: "Krystan Daxner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 8:46 PM
Subject: Changing table properties
> I have a program running with MySQL as the database. I have MySQLFront
> running as
You are using the wrong syntax, try
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE
table2.id IS NULL;
The query, you are using produces cross join while you need to implement
left join for your problem.
Enjoy
Nitin
- Original Message -
From: "Larry
lationship with any other person in the tree. Though, I can design a simple
database, where everything will have to be done through queries and scripts, but I
want those queries to keep as simple as possible.
Any help will be appreciated, as I'm new to such a problem.
Thanx in advance
Nitin
Easy, use:'select * INTO OUTFILE "full path and file name"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n" from user where race='chinese' and
state='US'Nitin- Original Message -
From: "Pey Ling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October
you can use temporary tables if need to work on the resultset else use two
different queries. I think, that's the only option.
Nitin
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 2
no, it'll save it in the data directory of the database only, reason is
mysql doesn't have permission to write to any other directory.
"full path and file name" could be just file name like "data.txt" or full
path of that directory like "/var/lib/mysql/db_na
I accept, that i was wrong, but you need to have a better look too. ALL is
as good as ALL PRIVILEGES.
- Original Message -
From: "Patrik Fimml" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Victoria Reznichenko"
<[EMAIL PROTECTED]>
dont really understand it.
Any ideas?
Anyway thanx again for your great help.
Nitin
- Original Message -
From: "Brad Teale" <[EMAIL PROTECTED]>
To: "'Dan Greene'" <[EMAIL PROTECTED]>; "Nitin"
<[EMAIL PROTECTED]>; <[EMAIL PROT
that will be recognized very well, just check the file ownership after
copying directory and files. all the data directory and files should be
owned by mysql only
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wedne
yes, syntax is bit diff.
INSERT into table1(column list) select a, b, c, d from table2 where
);
Enjoy
Nitin
- Original Message -
From: "Lay Hoon Tan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 11:36 AM
Subject: Inserting values
query seems perfect, what error is this giving?
Nitin
- Original Message -
From: "Jim Bartram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 10:07 AM
Subject: Adapting a Select statement to MySQL
> I've got the foll
pe it helps
Nitin
- Original Message -
From: "fab" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 1:58 PM
Subject: minus operation
> Hi to all,
>
> My question is rather about sql langage than mysql.
>
> Here it is: i have
start.html
Enjoy
Nitin
- Original Message -
From: "Leo Huang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 6:28 PM
Subject: InnoDB Questions
> Hello,
>
> I have a few questions about InnoDB.
> I am new to InnoDB, and j
a.
For more info, have a look at:
http://www.mysql.com/doc/en/InnoDB_File_space.html
Enjoy
Nitin
- Original Message -
From: "Leo Huang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 8:00 PM
Subject: Re: InnoDB Questions
>
> ---
have data more than the size you're specifying, it'll
through error and wont do nothing.
Nitin
- Original Message -
From: "Leo Huang" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, Novembe
yea, he's right, it may be error log file
Nitin
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
To: "Leo Huang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 5:53 AM
Subject: Re: InnoDB Quest
Hi all,
I have a project in hand, where I need to accept and show data in Hindi language,
storage doesn't matter. Is that possible with MySQL, if yes, what do I need to
configure? How do I do it, any help or ideas?
Regards
Nitin
dia, it says,
Insert vol 2 and press enter
Insert vol 3 and press enter
...
Dont know, what to do. I googled on it, but no specific answer. If you have a solution
or direct me to some helpful info, I'll be very gratefull. It's really important, so
sorry again for querying at wrong place.
Regards
Nitin
Subqueries aren't supported in MySql prior to ver 4.1.
- Original Message -
From: "Becky OGrady" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 15, 2003 12:28 PM
Subject: NEWBIE!! need help with nested select query
> Hi-
>
> I have 2 queries that I know work in SQ
hi all,
I've searched a bit, but didn't find any documentation on how to use unicode in mysql
4.0.14 or 4.0.X. Any ideas or links?
Thanx in advance
Nitin
if it does (or doesn't) let me know
Regards
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Michael Stassen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 1:15 PM
Subject: Re: SQL SELECT HELP
> Hi,
>
>
ow if 2nd and 3rd rows are deleted, an autoincrement field will still assign 10, 11,
12 to the new values, while I want it to assign the values deleted from the table
first.
What will be the best way to implement it?
Thanks in advance
Nitin
First of all, thanks for replying.
but, u didnt get my point. I want to use numeric field only as the key
field, but not the normal auto increment..
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "
Is mysql the owner of the directories?
- Original Message
From: Manasi Save
To: Johan De Meersman
Cc: Waynn Lue ; mysql
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads
e SQL file which is very
handy if you need to take up PTR or just want to verify any details.
Hope that helps!
Regards,
Nitin
- Original Message
From: Angelina Paul
To: mysql@lists.mysql.com
Sent: Tue, May 4, 2010 3:49:35 AM
Subject: mysql transaction log
Please help me to under
hich I'm
not aware of?
If you have resolved these issues, please let me know.
Best Regards,
Nitin
Thanks, Prabhat! You're very right, but did you read the questions I asked?
From: Prabhat Kumar
To: Nitin Mehta
Cc: mysql@lists.mysql.com
Sent: Tue, May 11, 2010 11:54:22 AM
Subject: Re: starting multiple instances with mysqld_multi
Hi,
You ca
Hope that helps!
Regards,
Nitin
From: Machiel Richards
To: mysql@lists.mysql.com
Sent: Thu, May 20, 2010 1:07:43 PM
Subject: Innodb buffer pool size
Hi Guys
I just have a quick question.
I have done some research into how to determine the si
Manasi,
Your table structure doesn't show that the column TestID is unique. I believe
what Michael also suggested was that unless this column contains unique values,
you never know which row your procedure is reading.
I hope I'm making myself understood.
Rega
ible to achieve this within MySQL conf itself.
Thanks in advance!
Regards,
Nitin
name (of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save
To: "mysql@lists.mysql.com"
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi All,
I have 10 mysql databases all
I believe that will not be logged unless you have enabled log_warnings. Too
many
connections would normally mean that the number is going beyond the configured
limit and denying new sessions is an expected behavior and should not be an
error really.
Regards,
Nitin
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save
To: win.a
Cc: "mysql@lists.mysql.com"
Sent: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysql
Hi Jeff,
threads_connected tells you total number of connections created since server
startup and threads_cached says how many stay alive (connection pooling) even
if there are no clients connected. This means that because the value of
threads_cached was reduced on your server, it is having to
I guess, it only makes things even more simple.
You should use "replicate-do-table=db1.tb1" and so one in slave's cnf to ensure
that only this particular table gets replicated. However, all the databases on
master will get bin-logged and you may or may not want to do that.
So making it even s
log on master and use
"replicate-do-table" on slave. So in one word response to your question, no!
Hope that helps!
Also, please reply to all so the people, helping you, know about the status of
your problem.
Regards,
____
From: "Brown, Charle
u find a suitable one.
Hope that helps!
Regards,
____
From: "Brown, Charles"
To: Nitin Mehta
Cc: "mysql@lists.mysql.com"
Sent: Thursday, May 3, 2012 4:24 PM
Subject: master BIN-LOG maintenace
Hi Gurus,
I would like to set BIN-LOG main
Thanks for your kind words, Charles! It comes easily to you when you have
experienced it. I'm glad it worked for you.
From: "Brown, Charles"
To: Nitin Mehta
Cc: "mysql@lists.mysql.com"
Sent: Thursday, May 3, 2012 3:17 PM
Subje
I'm more of an hit and try guy and do good only with a data set available.
Still I think making a little change might do the trick.
SELECT DISTINCT
p.productid,
pd.name
FROM menu_product as p
INNER JOIN menu as m ON (m.menuid = p.menuid AND m.name = '')
INNER JOIN produ
Hi Aastha,
I'm not 100% sure but you could try defining the full connectstring using:
ndb-connectstring = localhost:1186
See if that helps.
Regards,
From: Aastha
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
Subject: Mysql cluster
. What can be the reason and how can i repair it ?
Regards
Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
--
Regards,
/Nitin Mehta/
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is persisting is perhaps you have data directory outside the install
directory.
How you correct the problem:
Stop the service, start the service with option '--skip-grant-tables', login
with root u
Hi,
There was sort of a bug which was fixed in MySQL 5.5 with replication
heartbeat. Before the replication heartbeat, a new relay log file would be
created after every "slave_net_timeout". It doesn't have any negative impact
though.
Hope that helps.
From: A
e for RHEL4 and MySQL 5.1 and 5.5 are supported on
RHEL4 as per this: http://www.mysql.com/support/supportedplatforms/database.html
Any ideas?
Regards,
Nitin
Friday, April 5, 2013 11:26 AM
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta wrote:
>
> We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
> installation gives error:libc.so.6(GLIBC_2.4) is needed by
> MySQL-server-community-5.1.68-1.rhel5.
, the easiest and best way is to make sure the application cleans up
after itself and closes the transactions as soon as it can.
I hope this helps!
Regards,Nitin
On Saturday, April 2, 2016 8:07 PM, geetanjali mehra
wrote:
Hi to all,
For many days, I am struggling with the problem of
move the data files to another directory (partition) and create symlinks in
original directory
- Original Message -
From: "Mike Mapsnac" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 03, 2004 7:42 PM
Subject: Delete logs: not enough space on /var/lib/mysql
> I don
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 10:53 AM
Subject: Re: Table: NULL (yes or no)
>
> >I create two tables. And when I do
> >desc table_name;
>
> >NULL value can be 'Yes' or 'No'. What the difference when NULL >val
Hi all,
as the subject of the mail says, is there any function to apply in a query, that finds
out if the value returned from the database is numeric?
thanx for help in advance
Nitin
I'm using it with PHP, but what I'm looking for is, the query syntax, not
the language feature.
Thanx anyway
- Original Message -
From: "robert_rowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 9:04 PM
Subject: Re: How to find if the value returned is nu
first download and install Dynamic client libraries
(including 3.23.x libraries) available on same page to satisfy the
dependencies
Enjoy
Nitin
- Original Message -
From: "Nikos Gatsis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004
You can just install MyODBC on the client (running MS Access) then you can
link tables stored anywhere.
have a look at:
http://forums.devshed.com/t56700/s.html
for more info
Hope that helps
Nitin
- Original Message -
From: "Matthew McNicol" <[EMAIL PROTECTED]>
To: &
You dont need Apache to run MySQL. Apache is a web server, which is required
to publish web pages. So the answer is yes.
Enjoy
Nitin
- Original Message -
From: "EP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 09, 2004 9:53 AM
Subject: Mysql
Oh, if that's the case, I'm sorry for false info.
Of course, if server is not accessible, then you cannot connect to it
anyway, directly or through Access.
Sorry again
Nitin
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Nitin Mehta
you need not write any scripts, just use MySQL Front to Import/Export dat from M$
Access
"zzapper" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Hi Ya,
>
> How to this has always been somewhat fuzzy in my head. I looked around
> for tools unsuccessfully . So I thought I'd share
i dont think that, cauz 'Password' field in 'user' table was always 16 char
long and still is. In fact, check for the no. of privs in 'user' table. if
it is 21 or 14, as in 3.23.x it was 14 and in 4.0.17 is 21.
Hope that helps
Nitin
- Original Message -
Fro
If the data is 10-char in length always, CHAR is better performance-wise.
- Original Message -
From: "Hassan Shaikh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 11, 2004 6:34 PM
Subject: Which one is better: CHAR or VARCHAR?
Hi,
I've a column of type VARCHAR(10) w
these are definitely MySQL connection identities. Each with specific
(different) privileges. You can connect to the database directly with these.
- Original Message -
From: "Matthew Stuart" <[EMAIL PROTECTED]>
To: "MySQL email support" <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 6:
it cannot b related with primary key. i do not hav any idea how u update it,
but it's supported to update any dat in any table with or without PK
- Original Message -
From: "Hans van Dalen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 6:20 PM
Subject: tabl
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
thanx for reply but not a good idea. Though i did it through PHP script
Nitin
- Original Message -
From: "Mechain Marc" <[EMAIL PROTECTED]>
To: "Nitin Mehta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 16, 2004 1:38 PM
Subject:
x27;,
signpass varchar(12) NOT NULL default '',
plancode varchar(20) NOT NULL default '',
reseller varchar(20) NOT NULL default '',
PRIMARY KEY (packno)
) TYPE=MyISAM;
I want to select distinct values of reseller column as individual columns and other
data grouped on these values.
Thanx in advance
Nitin
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: "Yves Arsenault" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 6:37 PM
Subje
1 - 100 of 123 matches
Mail list logo
