MySql from Command prompt

By -
To Access your MySql Database server via command prompt steps are as follows:
1.Connect to Database server.
2.Select Database
3.Run MySql Queries.

Commands for all these steps:
1.Connect to database.--

Enter the bin directory of database like -
c:\cd C:\xampp\mysql\bin

Connect to databse server:

C:\>..\bin\mysql -u username -h localhost -p [press enter]
will prmpt for password
Enter password >

now..connect to database:-
mysql> use [databasename]

now start executing quieries
>

enjoy MySql queries ....
best of luck

Comments

Post a Comment

Popular posts from this blog

Using Java Script detect if OS is 64 bit version or 32 bit.

By -
Use following html code to show OS version: <html> <script> function onload() { if (navigator.userAgent.indexOf("WOW64") != -1 || navigator.userAgent.indexOf("Win64") != -1 ) {    alert("64 bit"); } else {    alert("32 bit"); } } </script> <body> <body onload="onload()" scrolling="no"> </body> </html> Ref:  UserAgent  (http://msdn.microsoft.com/en-us/library/ms537503%28v=vs.85%29.aspx)
Read more

Get correct OS version on win 8.1 without using GetVesionEx API (deprecated )

By -
NTSTATUS (WINAPI *RtlGetVersion)(LPOSVERSIONINFOEXW); OSVERSIONINFOEXW osInfo; *(FARPROC*)&RtlGetVersion = GetProcAddress(GetModuleHandleA( "ntdll" ), "RtlGetVersion" ); if (NULL != RtlGetVersion) {    osInfo.dwOSVersionInfoSize = sizeof (osInfo);    RtlGetVersion(&osInfo); } Use above method on all  platform and it will work fine. Where GetOSVersionEx API deprecated by MS and gives wrong result on WIN 8.1.   Tested above sample on XP to 8,1 and works for me. There is another  alternative of manifest to use GetOSversionEx. Source: CodeProject  
Read more

ESENT –JET APIs to create database in Metro Style App on Windows 8

By -
ESENT –JET APIs to create database in Metro Style App on Windows 8- ESENT dll is a part of windows SDK and provides apis to create and manage database on metro style application there is two major choices that can be used to implement databse in metro style application: 1.        SqlLite v3 2.        ESENT – JET database model SQLLite3 is not officially annouced to be used as database engine on windows8. But winrt version is already available to play with database. ESENT is already the part of windows8 so winrt support is already their to link esentlib statically to use the application.  JET apis are much flexible to create indexed base database and can be used to create huge database with thousands of table and columns. JET apis introduced in different levels according to plateform like win2000, WINXP , VISTA and above. Most of structures changed due to unicode support and security enhancement. I have cre...
Read more