In storage, VARCHAR(255) is smart enough to store only the length you need on a given row, unlike CHAR(255) which would always store 255 characters. But since you tagged this question with MySQL, I’ll mention a MySQL-specific tip: as rows are copied from the storage engine layer to the SQL layer, VARCHAR fields are converted … Read more
By default after deployment MySQL has following connection restrictions: mysql> select host, user from mysql.user; +———–+—————+ | host | user | +———–+—————+ | localhost | healthchecker | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +———–+—————+ 4 rows in set (0.00 sec) Apparently, for the security purposes you … Read more
This will do what you want: INSERT INTO table2 (st_id,uid,changed,status,assign_status) SELECT st_id,from_uid,now(),’Pending’,’Assigned’ FROM table1 If you want to include all rows from table1. Otherwise you can add a WHERE statement to the end if you want to add only a subset of table1.
Just add below lines to your /etc/phpmyadmin/config.inc.php file in the bottom: $i++; $cfg[‘Servers’][$i][‘host’] = ‘HostName:port’; //provide hostname and port if other than default $cfg[‘Servers’][$i][‘user’] = ‘userName’; //user name for your remote server $cfg[‘Servers’][$i][‘password’] = ‘Password’; //password $cfg[‘Servers’][$i][‘auth_type’] = ‘config’; // keep it as config You will get Current Server: drop down with both 127.0.0.1 and … Read more
Which particular version of Ubuntu is this and is this Ubuntu Server Edition? Recent Ubuntu Server Editions (such as 10.04) ship with AppArmor and MySQL’s profile might be in enforcing mode by default. You can check this by executing sudo aa-status like so: # sudo aa-status 5 profiles are loaded. 5 profiles are in enforce … Read more
manage.py dumpdata –natural will use a more durable representation of foreign keys. In django they are called “natural keys”. For example: Permission.codename is used in favour of Permission.id User.username is used in favour of User.id Read more: natural keys section in “serializing django objects” Some other useful arguments for dumpdata: –indent=4 make it human readable. … Read more
Your MySQL binaries should be somewhere under your XAMPP folder. Look for a /bin folder, and you’ll find the mysql.exe client around. Let’s assume it is in c:\xampp\mysql\bin, then you should fireup a command prompt in this folder. That means, fire up “cmd”, and type: cd c:\xampp\mysql\bin mysql.exe -u root –password If you want to … Read more
MySQL’s maximum memory usage very much depends on hardware, your settings and the database itself. Hardware The hardware is the obvious part. The more RAM the merrier, faster disks ftw. Don’t believe those monthly or weekly news letters though. MySQL doesn’t scale linear – not even on Oracle hardware. It’s a little trickier than that. … Read more
TL;DR TEXT fixed max size of 65535 characters (you cannot limit the max size) takes 2 + c bytes of disk space, where c is the length of the stored string. cannot be (fully) part of an index. One would need to specify a prefix length. VARCHAR(M) variable max size of M characters M needs … Read more
If you want to use phpMyAdmin to set up relations, you have to do 2 things. First of all, you have to define an index on the foreign key column in the referring table (so foo_bar.foo_id, in your case). Then, go to relation view (in the referring table) and select the referred column (so in … Read more