Re: mySQL question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 11:47:54 +0100

Hi Jacky

I am not sure where/how you are inserting the different records, but the
functionality you describe is probably part of the User Interface rather
than the DB engine. I am not sure if any of the following will work against
MySQL (http://www.aspfaq.com/show.asp?id=2442) and you may want to consider
TOAD http://www.toadsoft.com/. In general if you are inserting lots of
records it would be better to do this using some bulk load mechanism rather
than a GUI.

John

"Jacky Luk" <jl@knight.com> wrote in message
news:Xns952078F57B2D0GreatKnight@207.46.248.16...
> Dear all,
> I guess someone who can deal with SQL Server can also deal with mySQL. My
> question is how do you insert records (in insert mode) on the end of all
> records (the last one on the grid). In SQL Server, when you press return
on
> the last field of the record, it automatically jump to the next record, in
> mySQL, you can't do the same, you have to manually right click to get a
> menu to insert a record, I think this would be a real pain cause I've got
> many rows to insert. So the ID is not automatically sorted. How do I
> overcome all these difficulties :(
> Thanks
> Jack

Relevant Pages

  • OT: mySQL question
    ... I guess someone who can deal with SQL Server can also deal with mySQL. ... the last field of the record, it automatically jump to the next record, in ... overcome all these difficulties:( ...
    (microsoft.public.sqlserver.programming)
  • Re: The data was added to the database but the data wont be displayed
    ... replication with queued updates (SQL Server 2005), ... When inserting records into a Microsoft SQL Server database from an ... Microsoft Access tries to reselect the newly inserted record to ... subscriber) are SQL Server 2000. ...
    (microsoft.public.access.adp.sqlserver)
  • PHP, mysql, and escaping characters
    ... and the use of addcslashes. ... MySQL requires only that backslash and the quote ... In addition to the qutoes, backslashes, and nulls, real escape string ... "Inserting a large value into a BLOB column is no different than ...
    (comp.lang.php)
  • Re: Help with this code - parse insert into Mysql
    ... product information by pulling 3 fields and inserting values into my ... As hard as the devel team has tried the command-line functionality of PHP is, in my opinion, not fully finished and leaves me wanting in most cases when I use it solely as command-line script. ... if you can clarify the purpose of the script and the desired result there maybe a possibility that there is a better solution to using MySQL. ...
    (comp.lang.php)
  • Re: Help with this code - parse insert into Mysql
    ... product information by pulling 3 fields and inserting values into my ... As hard as the devel team has tried the command-line functionality of PHP is, in my opinion, not fully finished and leaves me wanting in most cases when I use it solely as command-line script. ... if you can clarify the purpose of the script and the desired result there maybe a possibility that there is a better solution to using MySQL. ...
    (comp.lang.php)