necessary and press Return. Then press Up Arrow
necessary and press Return. Then press Up Arrow twice more to recall the second line. Modify it, press Return, and the query will execute. Under Windows, mysql allows statement recall only for NT-based systems. For versions such as Windows 98 or Me, you can use the special mysqlc client program instead. However, mysqlc requires an additional library file, cygwinb19.dll. If you find a copy of this library in the same directory where mysqlc is installed (the bin dir under the MySQL installation directory), you should be all set. If the library is located in the MySQL lib directory, copy it into your Windows system directory. The command looks something like this; you should modify it to reflect the actual locations of the two directories on your system: C:> copy C:mysqllibcygwinb19.dll C:WindowsSystem After you make sure the library is in a location where mysqlc can find it, invoke mysqlc and it should be capable of input-line editing. One unfortunate consequence of using mysqlc is that it’s actually a fairly old program. (For example, even in MySQL 4.x distributions, mysqlc dates back to 3.22.7.) This means it doesn’t understand newer statements such as SOURCE. 1.14 Using Auto-Completion for Database and Table Names 1.14.1 Problem You wish there was a way to type database and table names more quickly. 1.14.2 Solution There is; use mysql’s name auto-completion facility. 1.14.3 Discussion Normally when you use mysql interactively, it reads the list of database names and the names of the tables and columns in your current database when it starts up. mysql remembers this information to provide name completion capabilities that are useful for entering statements with fewer keystrokes: Type in a partial database, table, or column name and then hit the Tab key. If the partial name is unique, mysql completes it for you. Otherwise, you can hit Tab again to see the possible matches. Enter additional characters and hit Tab again once to complete it or twice to see the new set of matches. mysql’s name auto-completion capability is based on the table names in the current database, and thus is unavailable within a mysql session until a database has been selected, either on the command line or by means of a USE statement.
Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Cheap Web Hosting services